WordPress › Support Topic: Syntax Error in 2.8

WordPress › Support Topic: Syntax Error in 2.8 http://wordpress.org/support/ WordPress › Support Topic: Syntax Error in 2.8 en Tue, 24 Nov 2009 11:25:36 +0000 colosimo on "Syntax Error in 2.8" http://wordpress.org/support/topic/279737#post-1132124 Thu, 09 Jul 2009 22:25:49 +0000 colosimo 1132124@http://wordpress.org/support/ 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. waschlabor on "Syntax Error in 2.8" http://wordpress.org/support/topic/279737#post-1103080 Sun, 14 Jun 2009 12:34:35 +0000 waschlabor 1103080@http://wordpress.org/support/ 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 ;-) whooami on "Syntax Error in 2.8" http://wordpress.org/support/topic/279737#post-1102526 Sat, 13 Jun 2009 22:37:16 +0000 whooami 1102526@http://wordpress.org/support/ 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. waschlabor on "Syntax Error in 2.8" http://wordpress.org/support/topic/279737#post-1102460 Sat, 13 Jun 2009 21:44:39 +0000 waschlabor 1102460@http://wordpress.org/support/ 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! <blockquote>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,<code>wp_posts.post_</code>title asc</blockquote> The same happened to all posts with this error message: <blockquote>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 <code>wp_posts.post_</code>date DESC LIMIT 0, 15</blockquote> What can I do now? waschlabor on "Syntax Error in 2.8" http://wordpress.org/support/topic/279737#post-1102446 Sat, 13 Jun 2009 21:34:25 +0000 waschlabor 1102446@http://wordpress.org/support/ After the upgrade to 2.8 instead of categories you can read the following error message at my blog http:www.handkaas.de: <blockquote>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 </blockquote> 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...)