[wp-trac] [WordPress Trac] #5193: [Category] Update Count Fails

[WordPress Trac]

#5193: [Category] Update Count Fails
-----------------------+----------------------------------------------------
 Reporter:  mattfast1  |       Owner:  anonymous
     Type:  defect     |      Status:  new      
 Priority:  normal     |   Milestone:  2.4      
Component:  General    |     Version:           
 Severity:  minor      |    Keywords:           
-----------------------+----------------------------------------------------
 When posting a new post, or updating categories on old posts, I get an
 error something like this:
 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 'SET `count` = '19' WHERE term_taxnomy_id = '22' LIMIT 1' at
 line 1]
 UPDATE SET `count` = '19' WHERE term_taxnomy_id = '22' LIMIT 1

 The category post count does not update when this error occurs.

 ---
 VERSION: Wordpress 2.4-bleeding
 UPDATED: updates from SVN automatically at ~1am Pacific time every day.
 PLUGINS: Database Manager v1.1; Hello Dolly v1.5; Mint Bird Feeder Mod
 v0.8; Mint Popular Posts v0.94; Spam Karma 2 v2.3rc1-2
 REPRODUCABLE: Occurs whenever a post is created or modified.
 --

-- 
Ticket URL: <http://trac.wordpress.org/ticket/5193>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software