Totally Futzed

Every single effing post in the blog excepting the three I just corrected are off by 7 hours, damn.

Warning: DON’T UPGRADE!

How in hell am I supposed to fix some 2000+ posts?

Checked, not the database which is in GMT, don’t need to repair that so I need to run a script but got errors.

Database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTERVALĘĘĘ'-7:0' HOUR_MINUTE)' at line 1]
UPDATE b2posts SET post_date = DATE_ADD(post_date, INTERVALĘĘĘ’-7:0′ HOUR_MINUTE)

No Comments so far
Leave a comment



Leave a comment
Line and paragraph breaks automatic, e-mail address never displayed, HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

(required)

(required)