By nikitas on

# user warning: Table 'plasisgr_web.date_format_types' doesn't exist query: SELECT dft.type, dft.title, dft.locked FROM date_format_types dft ORDER BY dft.title in /home/plasisgroup/plasisgroup.com/sites/all/modules/date/date_api.module on line 1925.
# user warning: Table 'plasisgr_web.date_format_types' doesn't exist query: SELECT dft.type, dft.title, dft.locked FROM date_format_types dft ORDER BY dft.title in /home/plasisgroup/plasisgroup.com/sites/all/modules/date/date_api.module on line 1925.
# user warning: Table 'plasisgr_web.date_format_types' doesn't exist query: SELECT dft.type, dft.title, dft.locked FROM date_format_types dft ORDER BY dft.title in /home/plasisgroup/plasisgroup.com/sites/all/modules/date/date_api.module on line 1925.
# user warning: Table 'plasisgr_web.date_format_types' doesn't exist query: SELECT dft.type, dft.title, dft.locked FROM date_format_types dft ORDER BY dft.title in /home/plasisgroup/plasisgroup.com/sites/all/modules/date/date_api.module on line 1925.
# user warning: Table 'plasisgr_web.date_format_types' doesn't exist query: SELECT dft.type, dft.title, dft.locked FROM date_format_types dft ORDER BY dft.title in /home/plasisgroup/plasisgroup.com/sites/all/modules/date/date_api.module on line 1925.

. . .
What do i do ?
Unistall and reInstall ?
and what will happen with the CCK fields?

⋅ Categories: Drupal 6.x

Comments

cog.rusty’s picture

cog.rusty commented

What exactly did you do? Did you install a new version of the date module?

nikitas’s picture

nikitas commented

i just saw a security risk and a message showing me that 'i have to update to 6.10' . . .
i downloaded localization module and was going to install it (that's how it started) . . .
but then i saw this error inside the modules and stopped everything . . .
Now i m downloading the complete site from ftp and made a bkp up db file . . . to test it locally . . .
i found this but it did nt help me . .. http://drupal.org/node/388128
I m going to test it locally unistall-reinstall update to 6.10 etc . . .
p.s : could it be from update.php?

cog.rusty’s picture

cog.rusty commented

No, it is from a bad or half-finished installation or update of the date module, maybe because of insufficient php memory. Check the admin/reports/status page to see what your php memory limit is.

tentonjim’s picture

tentonjim commented

I just went through this same routine. Got notified to update, did so and foobar... uninstalled reinstalled no luck.

Here is what worked for me...

  1. Delete your current date module folder from sites/all/modules/
  2. Install the date-6.x-2.0.tar.gz updated module.
  3. Enable the following in the Date Time Fieldgroup:
  4. DateAPI
  5. Date
  6. DateTimeZone
  7. run update.php

You have to have all 3 in order for the Date one to be enabled. The SQL is apparently looking specifically for the Date module. (took me 3 tries)

Enable those 3 and then immediately run update.php - that's it.

When you run update.php when you get to all the module dropdowns it will ask that needs updating, make sure the date one says 60005. Mine defaulted to that.

Good luck!

-- JimS aka tentonjim
http://tentonweb.com/