Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Article Timestamps and Backdating Multiple Articles
Hi All,
I just moved my local MAMP site to Dreamhost and saw that all the articles posted had a future timestamp when I imported the database on Dreamhost.
Is this because of the remote server’s date/time settings? I now have to resave all 100+ articles :( Is there a way to backdate all articles in one go?
Thanks in advance.
Cheers,
Husain
Last edited by husainhk (2008-07-08 14:18:05)
Offline
Re: Article Timestamps and Backdating Multiple Articles
Is the time-zone preference set correctly?
Are the difference between the old and the new dates the same for all articles?
Offline
Re: Article Timestamps and Backdating Multiple Articles
I just ran into this, as I’m moving my local sites up to Dreamhost. My local server was set to EST, Dreamhost is set to PST.
It appears that all my article dates are 3 hours in advance, those that were in the database prior to the import. Any new articles I create, they have the proper date, so my time settings are cool. I have my Time Zone at -5.00, DST = no. If I set the Time Zone to -8.00, then my old articles display the right time but anything new I enter assumes I’m living in California.
What to do, I can’t afford to move my family in these troubled times across the country ;)
We Love TXP . TXP Themes . TXP Tags . TXP Planet . TXP Make
Offline
Re: Article Timestamps and Backdating Multiple Articles
Reading up on this on the Dreamhost wiki, the Google and a confirmation from tech support, there is no way to change the timezone for a whole domain since PHP is run as a CGI.
PHP can’t inherit .htaccess changes like:
SetEnv TZ America/New_York
So the only thing to do is add this to your PHP script:
date_default_timezone_set(‘America/New_York’);
Where would be the best place to add this in the Textpattern core files?
We Love TXP . TXP Themes . TXP Tags . TXP Planet . TXP Make
Offline
Re: Article Timestamps and Backdating Multiple Articles
hcgtv wrote:
So the only thing to do is add this to your PHP script:
date_default_timezone_set(‘America/New_York’);Where would be the best place to add this in the Textpattern core files?
I take it the only alternative I have is to run a SQL query to change the dates in the database?
http://sam.brown.tc/entry/262/textpattern-urls-are-broken-txp-gods-help
We Love TXP . TXP Themes . TXP Tags . TXP Planet . TXP Make
Offline
Re: Article Timestamps and Backdating Multiple Articles
This worked for me
@UPDATE textpattern SET Posted = CURRENT_TIMESTAMP()@
If you’re still confused, you put that line of code in your phpMyAdmin database
(x_x)
Last edited by MR. (2009-01-09 07:04:57)
Offline
Re: Article Timestamps and Backdating Multiple Articles
^^ wouldn’t that reset all Posted dates to the current date?
Offline
Re: Article Timestamps and Backdating Multiple Articles
ruud wrote:
^^ wouldn’t that reset all Posted dates to the current date?
which would also mean that newer/older would not work?
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: Article Timestamps and Backdating Multiple Articles
ruud wrote:
^^ wouldn’t that reset all Posted dates to the current date?
which would also mean that newer/older would not work?
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: Article Timestamps and Backdating Multiple Articles
yes and yes.
Offline
Re: Article Timestamps and Backdating Multiple Articles
Backup first. Then try:
UPDATE textpattern SET Posted = DATE_SUB(Posted, INTERVAL 3 HOUR) WHERE Posted < 2008-12-10 00:00:00;This should set the Posted date back 3 hours for all articles posted before december 12th 2008.
To go in the opposite direction (setting Posted forward in time), use DATE_ADD instead of DATE_SUB.
Last edited by ruud (2008-12-17 19:58:24)
Offline
Re: Article Timestamps and Backdating Multiple Articles
ruud wrote:
This should set the Posted date back 3 hours for all articles posted before december 12th 2008.
I had just gotten down to this todo item, and I was checking the forum.
It worked just fine, I used:
UPDATE textpattern SET Posted = DATE_SUB(Posted, INTERVAL 3 HOUR)When I made the switch to the new server, I started entering dates 3 hours ahead of EST, thinking that a query would fix it all later.
Thanks Ruud.
We Love TXP . TXP Themes . TXP Tags . TXP Planet . TXP Make
Offline