Textpattern URLs are broken, TXP Gods help?
I woke up today to one problem on two of my sites running Textpattern. Interestingly I have never had any problems of this nature before and I could really do with some help, fast. The problem is that the latest articles on both Peppermint Tea & We Love TXP are returning 404’s on their permalink pages, all of the other articles are fine.
I am using the same URL scheme
/year/month/day/title on both, they are also both hosted on the same server as this site which I can’t replicate the problem on, perhaps because I am using a different URL scheme? Using messy urls doesn’t cause the pages to 404. No idea what the problem is, if anybody can help please drop me a comment or email, thanks!
Update: Turns out changing the server time negative 4 hours caused the problem, still looking for a solution.
Update 2: A solution at last, Mary one of the Textpattern developers helped out with this simple SQL query that will fix the time difference created by updating the servers internal clock. Thanks Mary!
UPDATE textpattern SET Posted = DATE_ADD(Posted, INTERVAL 4 HOUR);