Support » Fixing WordPress » MySQL Errors

  • I am running WP 1.2 and have been able to successfully post and receive comments without a problem. After not posting or receiving any comments for the past two days or so, I visited my site (main page, index.php) to find the following errors displayed:

    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 4]
    SELECT DISTINCT ID, category_id, cat_name, category_nicename, category_description, category_parent FROM wp_categories, wp_post2cat, wp_posts WHERE category_id = cat_ID AND post_id = ID AND post_id IN (,,,,,,,,,,,,,)

    Warning: Invalid argument supplied for foreach() in /home/resistor/public_html/wp-blog-header.php on line 478

    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 ‘,,,,,,,,,,,,) GROUP BY ID’ at line 4]
    SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = ‘1’) WHERE post_status = ‘publish’ AND ID IN (,,,,,,,,,,,,,) GROUP BY ID

    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 ‘,,,,,,,,,,,,) ORDER BY post_id,meta_key’ at line 3]
    SELECT post_id,meta_key,meta_value FROM wp_postmeta WHERE post_id IN(,,,,,,,,,,,,,) ORDER BY post_id,meta_key

    Fatal error: Call to undefined function: array() in /home/resistor/public_html/wp-includes/functions.php on line 1129

    All of my posts are in a catagory, and there are no catagories not containing any posts. I have the following plug-ins installed and I have yet to have any trouble with them: WP Blacklist 2.61 and WP Recent Links 1.31.

    I am unsure if this is related or not, but the menu on my WP admin pages says “array” for almost every item, except for “logout” and “view site”.

    I’ve gone into my cPanel and “checked” my database (everything was “OK”) and “repaired” my database, but that didn’t do anything.

    My site address is: resistorserve.net. Does anyone have any insight?

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘MySQL Errors’ is closed to new replies.