WordPress.org

Ready to get started?Download WordPress

Forums

WordPress database error (9 posts)

  1. PARoss
    Member
    Posted 8 years ago #

    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

  2. MichaelH
    Member
    Posted 8 years ago #

    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)!

  3. Mark (podz)
    Support Maven
    Posted 8 years ago #

    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.

  4. PARoss
    Member
    Posted 8 years ago #

    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

  5. PARoss
    Member
    Posted 8 years ago #

    So...

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

    Phil

  6. Mark (podz)
    Support Maven
    Posted 8 years ago #

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

  7. PARoss
    Member
    Posted 8 years ago #

    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

  8. Mark (podz)
    Support Maven
    Posted 8 years ago #

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

    (and hosts always say that :) )

  9. PARoss
    Member
    Posted 8 years ago #

    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'

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags