Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#13 2008-02-20 11:38:51
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Latest articles on 2 separate installs are returning 404's. Need help!
Remember to backup first. Off the top of my head (remove 4 hours from article posted times):
UPDATE textpattern SET Posted = DATE_SUB(Posted, INTERVAL 4 HOUR);
Last edited by Mary (2008-02-21 03:30:26)
Offline
Re: Latest articles on 2 separate installs are returning 404's. Need help!
Hi Mary,
Perfect, that works. Now I need to get my host to make the problem again (I got them to reverse it), then use this. Just a note its HOUR and not HOURS, I also need to add four hours on, not subtract them.. obviously. Silly me. -10 +4 = -6! Dur.
UPDATE textpattern SET Posted = DATE_ADD(Posted, INTERVAL 4 HOUR);
Thanks again!
-Sam
Sam Brown
sambrown.me | welovetxp.com
Offline
Re: Latest articles on 2 separate installs are returning 404's. Need help!
Ok, this appears to have worked to a varying degree of success. I am still confused as to where the URLs are generated from as this is still causing problems.
Mary said:
The clean urls are made from
Posted
.
But are they stored anywhere else in the database? Because if I update a Posted date from say 2008-02-20 to 2008-02-21 the original URL 404’s but all of the Textpattern links (previous/next article, the output on the homepage) still keep linking to the 2008-02-20. Visiting the 2008-02-21 works fine, but nothing is linking here?
Sam Brown
sambrown.me | welovetxp.com
Offline
#16 2008-02-21 09:48:37
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Latest articles on 2 separate installs are returning 404's. Need help!
Turn off and turn back on the send last mod header preference if you are using it. Manual changes to the database wouldn’t update the database value this setting depends upon.
Offline