WordPress Database Error

  • Hi all,

    I cannot figure out what the following error means.

    WordPress 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 ” at line 1]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2006-03-25 06:19:59’ AND (post_status = “publish” OR post_author = 1 AND post_status != ‘draft’ AND post_status != ‘static’) AND post_status != “attachment” GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0,

    Everything was working fine. I was testing the audio-player plugin and no problem. When I tried to go to the dashboard, I got the above error. Help! I don’t know what it means.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter karr

    (@karr)

    Hmm..I guess it would help if I gave further information.

    I am running WordPress 2.0.2.

    mysql version
    mysql Ver 12.22 Distrib 4.0.18

    php version
    PHP 4.4.1

    Deactivate your plugins one by one, starting with the audio one and see what happens?

    Thread Starter karr

    (@karr)

    I can’t access my wordpress dashboard as I get the same error above. So I went through my website admin panel and deleted the folder with the audio-player plugin. It did nothing. I had changed the theme so I also deleted that folder. Still nothing.

    I now go to my site and it says:
    It doesn’t look like you’ve installed WP yet. Try running install.php.

    I logged into my wordpress database through phpMyAdmin and I have the following error:

    Error

    SQL query: DocumentationEdit

    SELECT COUNT( * ) AS num
    FROM unattach_wp_1.wp_options

    MySQL said: Documentation
    #1016 – Can’t open file: ‘wp_options.MYI’. (errno: 145)

    Thread Starter karr

    (@karr)

    It was not the plug-in. I deleted the plugin as well as the last theme I used and it did not work.

    I finally ran the REPAIR TABLE command on two different tables.

    Everything seems to work now.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WordPress Database Error’ is closed to new replies.