[wp-hackers] Lost categories upgrading to 2.5.1

[Alan J Castonguay]

A worse problem would have been having DROP permission but not  
CREATE. If that were the case (unlikely), there would certainly have  
been data loss.

The section of the upgrade script that creates / populates wp_terms,  
and the part that drops the old tables, should be an atomic  
operation. If the data can't be imported into wp_terms, for whatever  
reason (server mis-configuration, etc), full stop, don't blindly  
attempt to drop the source tables.

Is there a trac ticket yet?

On 29-Apr-08, at 11:56 PM, Elliotte Harold wrote:

> WordPress database error: [Table 'elharo_wordpress.wp_terms'  
> doesn't exist]
> SELECT term_id, term_group FROM wp_terms WHERE slug = ‘uncategorized’
>
> ...
> WordPress database error: [DROP command denied to user  
> 'elharo_2_w'@'209.68.1.245' for table 'wp_categories']
> DROP TABLE IF EXISTS wp_categories
>
> WordPress database error: [DROP command denied to user  
> 'elharo_2_w'@'209.68.1.245' for table 'wp_link2cat']
> DROP TABLE IF EXISTS wp_link2cat
>
> WordPress database error: [DROP command denied to user  
> 'elharo_2_w'@'209.68.1.245' for table 'wp_post2cat']
> DROP TABLE IF EXISTS wp_post2cat