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
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
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.
