WordPress database error

  • embisiz

    (@embisiz)


    18 years, 5 months ago

    I am using WP 2.0 with mysql 4.0.27-standard and php 4.4.7. Since a couple hours I am getting error messages related with mysql and wordpress database when I try to open the root page of the blog, or any of the categories and pages. However, with the admin panel and with the posts, there is no problem at all. The error is:

    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 ” at line 1]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2007-12-26 21:43:59’ AND (post_status = “publish” OR post_author = 1 AND post_status != ‘draft’ AND post_status != ‘static’) AND post_status != “attachment” GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0,

    even above header. How can I solve this problem? As far as I know, I haven’t changed anything…

    Regards,
    buyruk

Viewing 4 replies - 1 through 4 (of 4 total)
  • moshu

    (@moshu)

    18 years, 5 months ago

    If it used to work and you really didn’t do anything to it… what was the answer of your host when you asked them?

    Thread Starter embisiz

    (@embisiz)

    18 years, 5 months ago

    They were updating my b/w and disk space limits, but told me that has nothing to do with wordpress or mysql. And I am also not sure that two things are related. Do you have any idea, why did the problem occur? The link to my blog is here, you can also have a look: my blog

    Andrew Ozz

    (@azaozz)

    18 years, 5 months ago

    Looking at the db query, it’s missing the number of posts that are to be displayed. Here:
    ORDER BY post_date DESC LIMIT 0,
    There should be another number after that, like “LIMIT 0, 5” or similar.

    Try to enter the number of posts for the home page again (WP 2.0 had this option, right). Also try asking your host to fix and optimize the tables, but make a backup first.

    Thread Starter embisiz

    (@embisiz)

    18 years, 5 months ago

    I was also sceptical about that part, but I was just not sure whether there is a limit of number of characters to be shown within an error.

    I checked the reading properties from the admin panel and set the “post per page” variable one more time. Now it works just fine. Thanks for the support!

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘WordPress database error’ is closed to new replies.