Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: Time Zone and Date problems - TxP changing dates in the actual DB
Mary
Is this what you are looking for? I ran it from the phpAdmin SQL tab.
CONVERT_TZ(‘2007-03-11 2:00:00’,‘US/Eastern’,‘US/Central’)
2007-03-11 01:00:00
CONVERT_TZ(‘2007-03-11 3:00:00’,‘US/Eastern’,‘US/Central’)
2007-03-11 01:00:00
I’m not conversant in MySQL, so I don’t know if returning the same result is good, bad, or in-different.
- The queries return the same for both a dev. 4.0.x install and for my crockery test site (Textpattern version: 4.1.0 (r2767). Both are hosted on Dreamhost.
- With the 4.0.x version there is not “Daylight” savings check box.
- With the crockery install the “Daylight Savings” is checked. When I uncheck it and save, it reloads checked.
- To work around I have set both to GMT – 6:00.
Thanks
Mike
Last edited by maverick (2008-01-12 19:28:23)
Offline
Re: Time Zone and Date problems - TxP changing dates in the actual DB
The query returned NULL.
Offline
#15 2008-01-14 08:10:33
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Time Zone and Date problems - TxP changing dates in the actual DB
See MySQL Server Time Zone Support
Mike, your result appears to mean that it is indeed a MySQL problem (see above).
Nathan, if you run this:
SELECT COUNT(*) FROM mysql.time_zone_name;what do you get?
Offline
Re: Time Zone and Date problems - TxP changing dates in the actual DB
Error
SQL query: Documentation
SELECT COUNT
FROM mysql.time_zone_name
- - SELECT command denied to user ‘myreplacedusername’@‘myreplacedhostname’ for table ‘time_zone_name’
Offline
#17 2008-01-16 12:16:20
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Time Zone and Date problems - TxP changing dates in the actual DB
We can’t really tell whether you have the same problem as Mike, since your host is protecting that table from view. If I were you, I would contact my host, describe to them the problem, refer them to that MySQL manual entry (see above) and ask if that might be the cause.
Offline
Re: Time Zone and Date problems - TxP changing dates in the actual DB
Thanks Mary. I just returned to work after vacation, so I’m playing catch-up, but will follow up on your feedback as soon as I can.
Thanks again
Mike
Offline