Weirdest SQL bug ever: REVERSE (6 posts)

  1. telavivian
    Posted 8 years ago #

    Dear WordPress community, I had the worst night with the weirdest bug ever: My SQL db got reversed. Not by content, but by order.

    The WP Loop now display my oldest posts first, and my newest posts last. I did not make any changes, and the bug is NOT in the WP Theme. I ran PHPMyAdmin, and there I saw the oldest posts (still numbered with their original post numbers) first, and so forth.

    I have absolutely *no* idea how this happened, and even less ideas as to resolving this.


    -- t.

  2. Dunworking
    Posted 8 years ago #

    Me too ! All of a sudden it swapped things round....what is going on ?

  3. A lot of people have been reporting this. I do not understand the cause of it yet, but a lot of people have also reported that upgrading to the latest WordPress fixed it.

    Search me, I can't understand why it would suddenly happen on older versions either.

  4. tianodesign
    Posted 8 years ago #

    Okay, so where are really simple, non-techie, step-by-step instrux for upgrading WordPress and ending this nightmare where all the entries reversed to FIFO?

    Feel free to cc me via email to: steve@tianodesign.com.

    Thank you.

    Steve Tiano

  5. D-Girl
    Posted 8 years ago #

    download the newest version and read the readme.html file. I upgraded by following the instructions in the file.

  6. MichaelH
    Posted 8 years ago #

    To follow up on this, there was a report that this problem is caused when hosts upgrade to MySQL version 5.0.51. The problem, a MySQL bug, is fixed in MySQL 5.0.52.

    For more info see Peter Westwood's post on wp-hackers:

Topic Closed

This topic has been closed to new replies.

About this Topic