WordPress.org

1. harpshot
   Member
   Posted 8 years ago #

   That has me venturing into the unknown, which hasn't stopped me yet. Is this how to handle it: first back up db then (1) copy and paste the script into the query window in phpmyadmin and hit "go", OR (2) copy and paste the script into a php file (i.e. script.php) and open in browser?

2. Cena
   Member
   Posted 8 years ago #

   I did the latter with no problems.

3. Ryan Boren
   WordPress Dev
   Posted 8 years ago #

   Michel, can the post_modified stuff simply be added to upgrade_110()? It seems to be safe to call multiple times since it checks for '0000-00-00 00:00:00'. Also, your fix-CVS-dates.php script works nicely. That would be more convenient than cutting and pasting.

4. Matt Mullenweg
   Troublemaker
   Posted 8 years ago #

   The plugin has a trick for that:
   http://wiki.wordpress.org/index.php/PhpHighlightPlugin

5. Nick Momrik
   Member
   Posted 8 years ago #

   Why more changes with the dates anyways? Are they not being stored GMT anymore? And if not, why is there still an offset from GMT?
   I know...don't use CVS on a "production site"... :-P
   I thought the previous change to using GMT was great for several reasons...
   If someone moves to a new timezone, all they need to do is change the offset and they are good to go. No need to update all of the times in the database.
   If someone's hosting server changes timezones (which a friends just did this week) nothing needs to be done. He is using the latest full release (which uses server time) so he had to change his offset.

6. Ryan Boren
   WordPress Dev
   Posted 8 years ago #

   This explains the problem well. The date/time of old posts should not change when timezones adjust or when offsets are changed. This could result in a post moving from one day to another, thus breaking the post's permalink.

7. Nick Momrik
   Member
   Posted 8 years ago #

   Ahhh....I can see the point in that.
   But why then, did all of my post time change when I ran the upgrade and the fix? Should I still be using the same offset, just all of my times will change for old posts and comments?

8. Nick Momrik
   Member
   Posted 8 years ago #

   I did it all again and the times seemed to work now (even on a new post)....hmmm.

9. harpshot
   Member
   Posted 8 years ago #

   Heh, the ugrading and scripting changed my gmt offset and after I re-set it to -6 I can't post comments on account of the 10 second warning. Thought I could beat it by deleting all the wp cookies, but I either missed one or the effect is tied into the db. Guess I'll have to wait 6 hours and 10 seconds. :-)
   Meanwhile I'm pondering why, in the context of global communications, it's necessary or even desirable to have anything stamped, logged or displayed in anything other than GMT (or UT). When I see a post that says March 22, 2004 at 03:45 PM that'd be, where? Without specifying the time zone it doesn't tell me anything particularly useful. As usual, though, I've probably missed some important point.

10. Lilandra
    Member
    Posted 8 years ago #

    hello! how do you run the script? i've tried but well i don't know..

11. Cena
    Member
    Posted 8 years ago #

    Lily, you've got to take the function and put into a php file (inserted between <?php and ?>. Save it as something, like script.php. Upload it to (well...I uploaded it to wp-admin), then simply point your browser at it. (i.e..../wp-admin/script.php).

12. Lilandra
    Member
    Posted 8 years ago #

    i think i managed to do that but then when i tried to post a comment it gave me alot of mysql errors
    and now i think i've restored the older version but still not positive i got everything back to that..

Topic Closed

This topic has been closed to new replies.