By nbluto on

I have a drupal site running 6.6 and I installed the Date module and got the following error:

* user warning: Table 'bethany_drpl1.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/bethany/public_html/sites/all/modules/date/date_api.module on line 1925.
* user warning: Table 'bethany_drpl1.date_format' doesn't exist query: SELECT df.dfid, df.format, df.type, df.locked, dfl.language FROM date_format df LEFT JOIN date_format_types dft ON df.type = dft.type LEFT JOIN date_format_locale dfl ON df.format = dfl.format AND df.type = dfl.type ORDER BY df.type, df.format in /home/bethany/public_html/sites/all/modules/date/date_api.module on line 1992.
* user warning: Table 'bethany_drpl1.date_format_locale' doesn't exist query: SELECT format, type, language FROM date_format_locale in /home/bethany/public_html/sites/all/modules/date/date_api.module on line 2050.
* user warning: Table 'bethany_drpl1.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/bethany/public_html/sites/all/modules/date/date_api.module on line 1925.
* user warning: Table 'bethany_drpl1.date_format' doesn't exist query: SELECT df.dfid, df.format, df.type, df.locked, dfl.language FROM date_format df LEFT JOIN date_format_types dft ON df.type = dft.type LEFT JOIN date_format_locale dfl ON df.format = dfl.format AND df.type = dfl.type ORDER BY df.type, df.format in /home/bethany/public_html/sites/all/modules/date/date_api.module on line 1992.

Can anyone tell me what it means, and how to fix it? This module has worked fine for me on other 6.10 sites.

Thank you.

Nicole Bluto

⋅ Categories: Drupal 6.x

Comments

mattyoung’s picture

mattyoung commented

Try uninstall and re-install the module.

First, disable the module, then uninstall. Then reinstall the module.

I think this also delete any date cck field data so keep this in mind.

nikitas’s picture

nikitas commented

. . . a solution . . .? cause i m having the same problem . . .
how did it started ?

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/

mattyoung’s picture

mattyoung commented

>uninstalled reinstalled no luck.

You should report this to the date module issue. The date_format_types schema is defined in date_api.install. If you totally *uninstall*, when you enable the modules again, it does a fresh install. There is no need to run update.php. In fact, there shouldn't be any update for you to run.

This loos like some bug. Something is wrong with the uninstall.

atxsigns’s picture

atxsigns commented

I have the same issue. Updated> broken. Deselected all date modules. Deleted folder. Installed 2007 version from the date module page. Enabled module. Still broken.

mattyoung’s picture

mattyoung commented

>Deselected all date modules. Deleted folder

Don't just deselect and delete folder. You need to go uninstall before you delete folder.

ggevalt’s picture

ggevalt commented

FYI, here's another thread on this issue that was automatically closed but not resolved. I have reopened it in hopes we can get some resolution. http://drupal.org/node/395156

I tried out the uninstall and reinstall and it worked UNTIL I ran the update on another module. So clearly there IS an issue with the date module with respect to the update.php function. Not good. Can anyone find a solution?

thanks

geoff gevalt

geoff gevalt
http://www.youngwritersproject.org
http://www.ywpschools.net
http://geoffreygevalt.com

hansrossel’s picture

hansrossel commented

clear cache and run update.php twice in a row, use latest code of core and date module, use php 5.

Make sure you don't have any files left in the date folder that are from a previous version.

KOBA - Drupal Webdesign & Webdevelopment