Textpattern CMS

#16 2008-01-14 17:24:55

NathanLogan

Member

From: Idaho

Registered: 2004-10-05

Posts: 24

Website

Re: Time Zone and Date problems - TxP changing dates in the actual DB

Error

SQL query: Documentation

SELECT COUNT
FROM mysql.time_zone_name

MySQL said: Documentation

1142. - SELECT command denied to user ‘myreplacedusername’@‘myreplacedhostname’ for table ‘time_zone_name’

#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.

#18 2008-01-16 16:15:10

maverick

Member

From: Southeastern Michigan, USA

Registered: 2005-01-14

Posts: 976

Website

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