A Delightful Alternative to 404 – Not Found :: Serving you since 1996

Pontifications and Other Mindless Banter

<< previous post: Main Screen Turn On::Main::next post: Czar Putin >>

December 22, 2004

Database Error

Filed under: Administrivia,Geek-Fu @ 6:10:09 PM
From the "For-all-you-other-Word-Press-Geeks-out-there" Department

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

I found this on the WordPress Blog

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.

Well, at least my web provider is upgrading something!

It only took them a day to get this right. I’m impressed.

4 Comments »

  1. You’re impressed?
    I’m embarrassed for them. There obviously wasn’t a checkout or test prior to cutover. I would believe that a number of people are in the dog house as a result.
    You gave a good heads up but something so basic probably won’t happen elsewhere.

    Comment by Dad — December 22, 2004 @ 9:13:49 PM


  2. It sounds like this is a widespread problem amoung webhosts providing PHP to their users.
    (I’m also betting that another user complained about the problem and their sysadmins had to figure this whole Zend Optimizer issue out.)

    And from what I know about php, this would have only affected how PHP interfaces with a mySQL database. This would not have been a huge impact, in my opinion, as most simple php use doesn’t use an external database structure, but rather hacks their own inside their own code.

    Comment by Jeremy — December 22, 2004 @ 9:23:31 PM


  3. I understand that you pay for this service.
    Do they state in their agreement that they don’t support external dbs?
    Do they state that they don’t support all SQLs?
    As their customer, you should ask them for their test and cutover plans to ensure that other problems you don’t know about yet didn’t go untested.
    They should refund 1/30th of the monthly fee to everyone that experienced the problem and deduct it from the bonuses of those responsible.

    Do I sound like I’m in the Christmas spirit? I’ve been having too many Generation “Y”s hitting me with “WHATEVER” or “TALK-TO-THE-HAND”. Then they ask why their jobs are going to India and “IT’S-NOT-FAIR”.

    Comment by Dad — December 22, 2004 @ 9:52:48 PM


  4. To be fair to the hosting providers; if they have scripts to update their back-end software—which is a good thing—they’re not going to catch this until there are problems.

    Library incompatibilities happen, unfortunately.

    Comment by Geof F. Morris — December 23, 2004 @ 10:34:08 AM


RSS feed for comments on this post. TrackBack URI

Leave a comment

Powered by WordPress 3.8.3