WordPress.org

Ready to get started?Download WordPress

My Blog Is Terribly Broken

Posted December 23, 2004 by Matt Mullenweg. Filed under Documentation.

If you load up your blog and see something like this:

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 ',,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,]
SELECT DISTINCT ID, category_id, cat_name, category_nicename, category_description, category_parent FROM blog_categories, blog_post2cat, blog_posts WHERE category_id = cat_ID AND post_id = ID AND post_id IN (,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,)
Warning: Invalid argument supplied for foreach() in /path/to/wordpress/wp-blog-header.php on line 478

Don’t worry, nothing happened to your data or WordPress. Your host probably just upgraded PHP to version 4.3.10 and forgot to upgrade the Zend Optimizer. We already have a support thread about it. The PHP download page says:

Note: Due to an incompatibility between earlier versions of Zend Optimizer and PHP 4.3.10, it’s recommended to upgrade to the latest version.

So contact your host and let them know what’s happening, and they should be able to fix everything.

No Pings

RSS feed for comments on this post.

  1. Database Error

    Hey, remember when my website decided to have a stroke? Well I finally found the answer.

    Trackback from Jeremy-Gilby-dot-com on December 23, 2004

  2. Common WordPress Error after PHP v4.3.10

    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 ',,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,]
    SELECT DISTINCT ID, category_id, cat_name, category_nicena…

    Trackback from MacManX.com on December 23, 2004

  3. Une mise jour php/debian qui tourne mal

    a doit faire deux heures que mon blog est kaput et je viens seulement de m’en rendre compte. J’ai trouv un indice sur le blog de WordPress qui mentionnait de mettre jour le Zend Optimizer, mais je ne l’utilise pas… Finalement, j’ai trouv la …

    Trackback from IM2 | OQP on December 23, 2004

  4. turck mmcache, eaccelerator, php and licences

    Following up on my messy upgrade post, this part is in english. It just came out like this (probably from reading the english bug reports). Oh well, I don’t feel like translating it…
    The turck mmcache bug was already reported for Debian. This will …

    Trackback from IM2 | OQP on December 23, 2004

  5. Otra vez me cargo el Payaso

    Por segunda vez a Moiblog lo cargo el payaso.En esta ocacion el problema es que se hizo una actualizacion de PHP (la cual era sumamente recomendable por cuestiones de seguridad) sin embargo no actualizaron el Zend Optimizer lo cual causo una incompat…

    Trackback from Moiblog on January 4, 2005

See Also:

For more WordPress news, check out the WordPress Planet.

There’s also a development P2 blog.

To see how active the project is check out our Trac timeline, it often has 20–30 updates per day.

Categories

%d bloggers like this: