Unknown column 'link_count'

[Denis-de-Bernardy]

I got a few reports with this error:

> "WordPress database error: [Unknown column 'link_count' in 
> 'where clause'] SELECT * FROM wp_categories WHERE cat_ID > 0 
> AND link_count > 0 ORDER BY cat_name ASC"

wp-includes/category.php seems to be only place with an occurence of link_count > 0.

D.

[markjaquith]

Sounds like the 2.1 upgrade didn't go as planned. You might try manually decrementing the database version number (stored in the database). This will allow an upgrade, which should fix the database. Or, perhaps the user lacks ALTER privs in MySQL.

[foolswisdom]

Closing as INVALID for now.

Denis-de-Bernardy,please:

• Include WordPress version and other environmental information
• "Frequent issue?" is not a useful Summary
• Do not set the Milestone
• Please search the forums before posting bugs.

ADDITIONAL DETAILS
The cause of this issue is likely that database is not upgraded from pre-2.1, that in turn is likely a result of not all of the WordPress files being uploaded/replaced successfully which not triggering the database upgrade. Or the user does not have priv to alter the mysql.