When user tries selects a timezone in account, date_timezone.module tries to update timezone information of event.module.
event-5.x-1.x does not have a event_timezones table so, date_timezone.module triggers following error:
"Table 'db.event_timezones' doesn't exist query: SELECT * FROM event_timezones WHERE name = 'America/New York'".
It was previously reported at forums.

CommentFileSizeAuthor
#1 event_timezone.patch850 bytesdevelcuy

Comments

develcuy’s picture

develcuy commented
StatusFileSize
new event_timezone.patch850 bytes

date_api.module already cares about event_timezone table, so I have rolled a patch with similar logic.

Blessings!

Gentoo7’s picture

Gentoo7 commented

Thank a lot develCuy! how can i add the patch?

thanks

MartysMind’s picture

MartysMind commented

Applied to release version 5.x-2.5, seams to fix the problem.

To install:

1. Navigate to your site 'sites/all/modules/data/date_timezone/'
2. Copy of FTP the patch to that location
3. patch -p0 < event_timezone_0.patch

That should do it, did for me.

Gentoo7’s picture

Gentoo7 commented

sorry im not getting step 2 and 3

MartysMind’s picture

MartysMind commented

To fix this you need to be logged into your website through a telnet or ssh terminal connection.

You will also need to upload the patch to the website where you can copy it into the modules directory for the site.

From the command prompt (telnet/ssh connection) on your site you will have to do the following:

1. Navigated to the module directory (e.g. cd sites/all/modules/formfilter)
2. Copy the patch to that location from wherever you uploaded it (e.g. cp /tmp/event_timezone_0.patch . )
3. patch the file (e.g patch -p0 < event_timezone_0.patch )

If any of that is vague try looking up each linux command (telnet, ssh, cd, cp, patch) on google.

Hope that helps.

karens’s picture

karens commented
Status: Active » Fixed

Took me a while to get to this, sorry! Thanks for the patch.

Status: Fixed » Closed (fixed)

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

Screenack’s picture

Screenack commented

FYI: helped stopped the same thing I was seeing -- thanks