16
I just fixed mine in about 5 minutes.
CBB tables are not the only ones affected either.
Basically I just dropped the ones that combined values already set, and removed fields from the ones that were combined.
I have not ran into a problem yet.
Example: _bb_topics
le="color: #000000"><?php PRIMARY PRIMARY 27 Edit Drop topic_id forum_id INDEX None Edit Drop forum_id topic_last_post_id INDEX None Edit Drop topic_last_post_id topic_poster INDEX None Edit Drop topic_poster topic_forum INDEX None Edit Drop topic_id forum_id topic_sticky INDEX None Edit Drop topic_sticky topic_digest INDEX None Edit Drop topic_digest digest_time INDEX None Edit Drop digest_time PRIMARY and INDEX keys should not both be set for column `topic_id`
Changed to
le="color: #000000"><?php PRIMARY PRIMARY 30 Edit Drop topic_id forum_id INDEX None Edit Drop forum_id topic_last_post_id INDEX None Edit Drop topic_last_post_id topic_poster INDEX None Edit Drop topic_poster topic_sticky INDEX None Edit Drop topic_sticky topic_digest INDEX None Edit Drop topic_digest digest_time INDEX None Edit Drop digest_time
0 errors after doing this to all tables
For god sakes back it up first.
My old topics didn't come back, but I think by dumping that table and reinjecting the data it should repopulate.
