Hey, so this warning shows up on the admin pages and I'm not to sure what to do about it because the schema hook has the fix that I found at http://drupal.org/node/159605#comment-4321368. Here is the text of the error messages:

    Field field_data_field_date.field_date_value: no Schema type for mysql type datetime.
    Field field_data_field_date.field_date_value2: no Schema type for mysql type datetime.
    Field field_revision_field_date.field_date_value: no Schema type for mysql type datetime.
    Field field_revision_field_date.field_date_value2: no Schema type for mysql type datetime.
    field_data_field_date.field_date_value: no type for Schema type datetime:normal.
    Field field_data_field_date.field_date_value: no Schema type for type datetime.
    field_data_field_date.field_date_value2: no type for Schema type datetime:normal.
    Field field_data_field_date.field_date_value2: no Schema type for type datetime.
    field_revision_field_date.field_date_value: no type for Schema type datetime:normal.
    Field field_revision_field_date.field_date_value: no Schema type for type datetime.
    field_revision_field_date.field_date_value2: no type for Schema type datetime:normal.
    Field field_revision_field_date.field_date_value2: no Schema type for type datetime.

Comments

arlinsandbulte’s picture

arlinsandbulte commented

Try the dev version of Date.

From the Date project home page:
"The best combination of modules is to use the -dev versions of Views, CTools, Date, & Calendar. Please don't report issues unless you have tried the latest current -dev versions of all these modules."

jthermane24’s picture

jthermane24 commented
Version: 7.x-2.0-alpha3 » 7.x-2.x-dev

Issue still persistent after upgrading all modules to -dev versions.

karens’s picture

karens commented
Status: Active » Postponed (maintainer needs more info)

If you have altered the schema with some patch, I am not surprised you are having trouble. I have no idea what "the schema hook has the fix that I found at ..." means. Does this mean you altered the code of Date module? Does this mean you have created a custom module that is trying to use this schema? Either one will fail. Date already has the schema correctly configured and if you change it you will break it. And if you try to do something with it in custom code you will collide with what Date is doing.

jthermane24’s picture

jthermane24 commented
Status: Postponed (maintainer needs more info) » Closed (works as designed)

I'm not sure what happened but an update of the module got rid of this error.

I'm sorry that sentence made no sense at all. The only explanation that I can give was that it was in the middle of one of my like 10 hour development sessions and my brain was no longer working. So sorry, thanks for the help.

nzxt’s picture

nzxt commented

I am also having the exact problem of "No Schema Type for Mysql Datetime". I created a new content type called event with 3 fields a title, body and start date. Also tried using debut event module which produces same erros. The warning showing on the configuration pages are as follows:

• Field field_data_field_event_date.field_event_date_value: no Schema type for mysql type datetime.
• Field field_data_field_event_date.field_event_date_value2: no Schema type for mysql type datetime.
• Field field_data_field_start_date.field_start_date_value: no Schema type for mysql type datetime.
• Field field_data_field_start_date.field_start_date_value2: no Schema type for mysql type datetime.
• Field field_revision_field_event_date.field_event_date_value: no Schema type for mysql type datetime.
• Field field_revision_field_event_date.field_event_date_value2: no Schema type for mysql type datetime.
• Field field_revision_field_start_date.field_start_date_value: no Schema type for mysql type datetime.
• Field field_revision_field_start_date.field_start_date_value2: no Schema type for mysql type datetime.
• field_data_field_event_date.field_event_date_value: no type for Schema type datetime:normal.
• Field field_data_field_event_date.field_event_date_value: no Schema type for type datetime.
• field_data_field_event_date.field_event_date_value2: no type for Schema type datetime:normal.
• Field field_data_field_event_date.field_event_date_value2: no Schema type for type datetime.
• field_revision_field_event_date.field_event_date_value: no type for Schema type datetime:normal.
• Field field_revision_field_event_date.field_event_date_value: no Schema type for type datetime.
• field_revision_field_event_date.field_event_date_value2: no type for Schema type datetime:normal.
• Field field_revision_field_event_date.field_event_date_value2: no Schema type for type datetime.
• field_data_field_start_date.field_start_date_value: no type for Schema type datetime:normal.
• Field field_data_field_start_date.field_start_date_value: no Schema type for type datetime.
• field_data_field_start_date.field_start_date_value2: no type for Schema type datetime:normal.
• Field field_data_field_start_date.field_start_date_value2: no Schema type for type datetime.
• field_revision_field_start_date.field_start_date_value: no type for Schema type datetime:normal.
• Field field_revision_field_start_date.field_start_date_value: no Schema type for type datetime.
• field_revision_field_start_date.field_start_date_value2: no type for Schema type datetime:normal.
• Field field_revision_field_start_date.field_start_date_value2: no Schema type for type datetime.

The schema module says there are 4 fields in the field_sql_storage table where the schema and database are different. Here is the schema information:

field_data_field_event_date

•column field_event_date_value - difference on: type
declared: array('description' => 'TODO: please describe this field!', 'type' => 'DATETIME', 'not null' => FALSE)
actual: array('description' => 'TODO: please describe this field!', 'type' => 'datetime', 'not null' => FALSE)
•column field_event_date_value2 - difference on: type
declared: array('description' => 'TODO: please describe this field!', 'type' => 'DATETIME', 'not null' => FALSE)
actual: array('description' => 'TODO: please describe this field!', 'type' => 'datetime', 'not null' => FALSE)

field_revision_field_event_date

•column field_event_date_value - difference on: type
declared: array('description' => 'TODO: please describe this field!', 'type' => 'DATETIME', 'not null' => FALSE)
actual: array('description' => 'TODO: please describe this field!', 'type' => 'datetime', 'not null' => FALSE)
•column field_event_date_value2 - difference on: type
declared: array('description' => 'TODO: please describe this field!', 'type' => 'DATETIME', 'not null' => FALSE)
actual: array('description' => 'TODO: please describe this field!', 'type' => 'datetime', 'not null' => FALSE)

field_data_field_start_date

•column field_start_date_value - difference on: type
declared: array('description' => 'TODO: please describe this field!', 'type' => 'DATETIME', 'not null' => FALSE)
actual: array('description' => 'TODO: please describe this field!', 'type' => 'datetime', 'not null' => FALSE)
•column field_start_date_value2 - difference on: type
declared: array('description' => 'TODO: please describe this field!', 'type' => 'DATETIME', 'not null' => FALSE)
actual: array('description' => 'TODO: please describe this field!', 'type' => 'datetime', 'not null' => FALSE)

field_revision_field_start_date

•column field_start_date_value - difference on: type
declared: array('description' => 'TODO: please describe this field!', 'type' => 'DATETIME', 'not null' => FALSE)
actual: array('description' => 'TODO: please describe this field!', 'type' => 'datetime', 'not null' => FALSE)
•column field_start_date_value2 - difference on: type
declared: array('description' => 'TODO: please describe this field!', 'type' => 'DATETIME', 'not null' => FALSE)
actual: array('description' => 'TODO: please describe this field!', 'type' => 'datetime', 'not null' => FALSE)

This is a fresh install of D7.7 with all the latest dev versions, I am now installing modules and testing as I enable modules. I don't see any possible way the schema could have been changed. I will test on another fresh install of D7.7 with all of the latest dev modules but make the date module the first module to install and test. Any other help would be appreciated.

karens’s picture

karens commented

This is a bug in schema module, which has not been updated since the datetime type was removed from core. See #1237974: Schema module reporting some Date discrepancies where I bumped the issue to them.

Anonymous’s picture

Anonymous (not verified) commented
Title: No Schema type for mysql type datetime » Field qrl_webform_views_#_15.submitted: no Schema type for mysql type datetime.
Component: Date CCK Field » Code
Priority: Normal » Critical
Status: Closed (works as designed) » Active

Field qrl_webform_views_#_15.submitted: no Schema type for mysql type datetime.

Good day

i keep getting the error above, can some one help me without editing code. i removed my Date/Time module.

thanks

karens’s picture

karens commented
Priority: Critical » Normal
Status: Active » Closed (works as designed)

I have no control over the Schema module. I can't do anything about this. The fix has to happen there. Also it appears you are using webform, which does NOT use the date module, so maybe webform has the same issue.

WhiplashInfo’s picture

WhiplashInfo commented

nzxt - have you found any solution to the problem yet?
I have the same problem, and it occur dispite what version of schema I use.
//Tomas

kamran-dg’s picture

kamran-dg commented
Issue summary: View changes

install data module and open the data module and go to data.module file.
and find the 'sql_type' and set the DATE_DATETIME. on line no: 470 in data.module
This works for me in Drupal 7.56

'sql_type' => DATE_UNIX, 'sql_type' => DATE_DATETIME,