Thanks for the recent update and all your hard work.

After updating from 5.x-2.4 to 5.x-2.5, when I visit admin/settings/date-time, the Default Time Zone settings do not list time zones, i.e.: "Saturday, March 7, 2009 - 11:15 -0500", they list geographic locations, i.e.: "America/Los Angeles". When I set the time zone for Los Angeles, I get the following error:

user warning: Table 'play7com_Drupal5.event_timezones' doesn't exist query: SELECT * FROM event_timezones WHERE name = 'America/Los Angeles' in /home/play7com/public_html/includes/database.mysql.inc on line 174.

Is there some way I can repair this?

Comments

jonathanwinn’s picture

jonathanwinn commented

bump....

hackwater’s picture

hackwater commented

Do you have the Event module installed? Have you had it installed at some point?

jonathanwinn’s picture

jonathanwinn commented

Thanks for the response. Yes, I do have event installed. Is there a conflict you know of?

hackwater’s picture

hackwater commented

Ok, this appears to be fixed in the dev branch of 5.x-2.x; from what I can tell, the code in 5.x-2.5 is trying to use Event 2's timezone table without checking to see if the table is there. If you're running Event 1, you don't have this table, hence the error.

So you have a few options. You can go to the dev version of the Date module until a stable version is released with the patch, or you can go to the Event 2 module (which is dev only at this point in time), or you can keep your current versions of everything and edit the Date module by adding a quick check for the Event 2 table in the date_timezone.module, in the date_event_zonelist_by_name function.

jonathanwinn’s picture

jonathanwinn commented

jhereg69--

Thanks so much for your advice. Seeing as I have event installed, but I really don't use it, is there any downside to upgrading to Event 2 (dev)? It seems like the safest of the available options--would you agree?

hackwater’s picture

hackwater commented

That's what I ended up doing. But if you do currently use Event views, make sure you also get the Event 2 Views module, as part of the Event 2 re-write involved moving those two pieces into separate modules. If you don't use Event at all, you could disable and uninstall it, and that should also eliminate your problem.

jonathanwinn’s picture

jonathanwinn commented

An update for anyone else who might have had this problem:

Per jhreg9, I disabled and uninstalled the event module, and the error alert went away.

I would add that the timezone remains a geographic area rather than a time zone, as pointed out in the original post. That works for me--I was merely concerned about the error nag.

arlinsandbulte’s picture

arlinsandbulte commented
Status: Active » Fixed

Looks like the issue has been resolved... cleaning up.

Concerning the time zones see this issue:
#401920: Clarify that we're not really selecting time zone

SeanA’s picture

SeanA commented

In case anyone else encounters this problem, there's a fix here: #353327: Error about event.module timezones.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.