Alternative to Time Zone Tables for shared hosting

Asked by Bo on 2016-03-15


I'm on shared hosting and the hosting company won't populate the Time Zone Tables. So is there some other way I can achieve this? Like set up an ini-file or hard code it in the source?


Question information

English Edit question
queXS Edit question
No assignee Edit question
Last query:
Last reply:
Adam Zammit (adamzammit) said : #1

Hi Bo,

One user requested this a while ago:

This method should still work (copied from the message linked above):

queXS relies on mySQL timezone support and uses the CONVERT_TZ function to produce named timezone compatible queries.

Without the timezone support enabled, all queries to CONVERT_TZ will return NULL (see: )

It is possible to get the system to work without timezone support - to do so, you will have to do the following:

1. In the queXS code, replace all occurrences of 'UTC' in the CONVERT_TZ MySQL call to something like '+0:00'

2. In all fields in the database that refer to Time_zone_name - replace a named timezone with an offset - such as '+8:00' or whatever the offset is for your timezone. If everything is in the 'System' timezone (i.e. the same as the server) I would suspect this would be '+0:00'. Therefore all database joins that use the Time_zone_name value from the database will also not be named and should succeed.

Bo (mrboboz) said : #2


Will try and get back /Bo

Can you help with this problem?

Provide an answer of your own, or ask Bo for more information if necessary.

To post a message you must log in.