Syntax Error in 2.8

  • After the upgrade to 2.8 instead of categories you can read the following error message at my blog http:www.handkaas.de:

    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 ‘order ASC’ at line 1]
    SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN (‘category’) AND ( t.term_id <> 7 ) ORDER BY order ASC

    In the support forum of wordpress Germany somebode told me that the column “ORDER BY order” does not exist allready. What can I do to fix my Database now? I made the upgrade automaticly and all plugins are running well so far…

    (sorry for my very basic English…)

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter waschlabor

    (@waschlabor)

    Sorry for posting again. Right now I find out some new problems in the backend of my blog:

    All the pages are shown at my blog, but in the WP backend they will be not not found!

    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 ‘title asc’ at line 1]
    SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘page’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ OR wp_posts.post_status = ‘private’) ORDER BY menu_order,wp_posts.post_title asc

    The same happened to all posts with this error message:

    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 ‘date DESC LIMIT 0, 15’ at line 1]
    SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ OR wp_posts.post_status = ‘private’) ORDER BY wp_posts.post_date DESC LIMIT 0, 15

    What can I do now?

    have you made sure that’s not being caused by a plugin being loaded?

    for the gazillionth time —

    disable your plugins FIRST.

    doesnt work –>

    then switch to the default theme

    doesnt work –>

    reupload files.

    doesnt work –>

    post back.

    Thread Starter waschlabor

    (@waschlabor)

    Yesssssss – You’re damn right…

    After hours of work – I did everything you wrote in your reply – I found a thread in the German WP Forum whith the same kind of topic. Some guys have had problems with the plugin “My Category Order”. After a reset of the category order everthing was working well…

    So I installed and activated the plugin, press the “order”-button and the categories were shown again and everything was working well again.

    BUT: I never ever used that plugin bevore! Anyway – next time I’ll be more careful, promise ??

    Same problem and same solution after upgrading to 2.8.1.
    It was My Category Order.
    Just enter the plugin settings and update the order, that’s it.

    Thank you waschlabor for finding it out.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Syntax Error in 2.8’ is closed to new replies.