The Support Forums will be in read-only mode for a scheduled maintenance window on 01 September 2016 14:00 UTC - 20:00 UTC. More information.

[resolved] WordPress database error (4 posts)

  1. trdunsworth
    Posted 6 years ago #

    We upgraded from 2.8.5 I believe to 2.9.1 and since the upgrade, we've started receiving the following error and now Apache is not serving any of the pages for WP.

    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 for query 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 <> 1 AND t.term_id <> 7 AND t.term_id <> 10 AND t.term_id <> 13 t.term_id <> 4 AND t.term_id <> 3 AND t.term_id <> 12 AND t.term_id <> 8 AND t.term_id <> 9 AND t.term_id <> 11 AND t.term_id <> 13 ) ORDER BY order ASC made by require, require_once, include, get_sidebar, locate_template, load_template, require_once, wp_list_categories, get_categories, get_terms

    I've never seen this before. We cannot get into the site in any fashion, so it looks like we're going to have to blow it out, but I want to know what we have in case we see it again.

    Thanks much,

  2. trdunsworth
    Posted 6 years ago #

    Actually, just found out from my colleague it is 2.7 instead of a 2.8.X release.

  3. Samuel B

    Posted 6 years ago #

    1st try running a repair on the db tables with phpmyadmin

  4. trdunsworth
    Posted 6 years ago #

    Checking now. We encountered it again and that suggestion might have fixed it.

Topic Closed

This topic has been closed to new replies.

About this Topic