WordPress.org

Ready to get started?Download WordPress

Forums

MySQL Errors (3 posts)

  1. RoS
    Member
    Posted 9 years ago #

    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?

  2. RoS
    Member
    Posted 9 years ago #

    Forget it folks - everything seems to be working fine now. It's funny, I didn't fix anything, it just started working again. I wonder why this happened...

  3. Kafkaesqui

    Posted 9 years ago #

    Explained here:

    http://wordpress.org/development/2004/12/terribly-broken/

    That it's working now means that another customer (or 500) must have stormed the support team of your host provider.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.