Support » Fixing WordPress » WordPress database error

  • I just made my first post with WP 1.52 and got this error code:

    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 ‘) AND posts.post_parent = 0’ at line 7]
    SELECT posts.* FROM wp_posts as posts WHERE posts.post_status = ‘static’ AND posts.post_name IN ( ) AND posts.post_parent = 0

    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 ‘) AND categories.category_parent = 0 AND posts.post_status = ‘publish” at line 12]
    SELECT categories.* FROM wp_categories as categories INNER JOIN wp_post2cat as post2cat ON post2cat.category_id = categories.cat_ID INNER JOIN wp_posts as posts ON posts.ID = post2cat.post_id WHERE categories.category_nicename IN ( ) AND categories.category_parent = 0 AND posts.post_status = ‘publish’ AND posts.post_date_gmt <= ‘2005-11-26 12:46:00’

    Warning: Cannot modify header information – headers already sent by (output started at /home/phil/public_html/wp/wp-includes/wp-db.php:98) in /home/phil/public_html/wp/wp-admin/admin.php on line 10

    Warning: Cannot modify header information – headers already sent by (output started at /home/phil/public_html/wp/wp-includes/wp-db.php:98) in /home/phil/public_html/wp/wp-admin/admin.php on line 11

    Warning: Cannot modify header information – headers already sent by (output started at /home/phil/public_html/wp/wp-includes/wp-db.php:98) in /home/phil/public_html/wp/wp-admin/admin.php on line 12

    Warning: Cannot modify header information – headers already sent by (output started at /home/phil/public_html/wp/wp-includes/wp-db.php:98) in /home/phil/public_html/wp/wp-admin/admin.php on line 13

    I’m not a php guy, don’t know what it means. The blog is located at http://www.paross.com/wp.

    Phil

Viewing 8 replies - 1 through 8 (of 8 total)
  • Here’s some help with the Header already sent problem.

    ——-
    Welcome to the WordPress Support Forums!

    Please help keep the Forums successful by reading:
    http://wordpress.org/support/topic/39501

    And, thank you, for letting us know if this information proves useful (or not)!

    Mark (podz)

    (@podz)

    Support Maven

    I see you are using the semiologic cms theme – have you checked for possible solutions at Denis’ site ?

    And unless you have altered the file wp-db.php, the error lies elsewhere so don’t edit either file mentioned in the error messages above.

    Okay, I’ve reinstalled everything except the mysql database, and I switched to the default theme. I still get this when I access the Dashboard/Options/Nav Menus:

    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 ‘) AND posts.post_parent = 0’ at line 7]
    SELECT posts.* FROM wp_posts as posts WHERE posts.post_status = ‘static’ AND posts.post_name IN ( ) AND posts.post_parent = 0

    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 ‘) AND categories.category_parent = 0 AND posts.post_status = ‘publish” at line 12]
    SELECT categories.* FROM wp_categories as categories INNER JOIN wp_post2cat as post2cat ON post2cat.category_id = categories.cat_ID INNER JOIN wp_posts as posts ON posts.ID = post2cat.post_id WHERE categories.category_nicename IN ( ) AND categories.category_parent = 0 AND posts.post_status = ‘publish’ AND posts.post_date_gmt <= ‘2005-11-30 17:49:00’

    I’m out of ideas on how to fix it.

    Phil

    So…

    Do you think this is a WP problem or a hosting problem?

    Phil

    Mark (podz)

    (@podz)

    Support Maven

    I’d say Hosting if for no other reason that I don’t recall this being posted before. That said, who is your host ?

    My host is http://www.jatol.com

    I show php is 4.4.1 and zend Optimizer is 2.5.10a.
    Also mysql is 4.1.13

    They don’t think it is their problem.

    Phil

    Mark (podz)

    (@podz)

    Support Maven

    This is a default install in every way ?
    You have at least one post ?
    No plugins ?

    (and hosts always say that 🙂 )

    No, I was running several plugins. So, I deactivated them. When I got to the basic WordPress program, the error code could not be found. The culprit seems to be Semilogic/Options/Nav Menus. That gives me:

    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 ‘) AND posts.post_parent = 0’ at line 7]
    SELECT posts.* FROM wp_posts as posts WHERE posts.post_status = ‘static’ AND posts.post_name IN ( ) AND posts.post_parent = 0

    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 ‘) AND categories.category_parent = 0 AND posts.post_status = ‘publish” at line 12]
    SELECT categories.* FROM wp_categories as categories INNER JOIN wp_post2cat as post2cat ON post2cat.category_id = categories.cat_ID INNER JOIN wp_posts as posts ON posts.ID = post2cat.post_id WHERE categories.category_nicename IN ( ) AND categories.category_parent = 0 AND posts.post_status = ‘publish’ AND posts.post_date_gmt <= ‘2005-12-05 04:14:00’

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘WordPress database error’ is closed to new replies.