Question Duplicate entry at jos_kunena_messages - Upgrade from 1.5.12

A command like that maybe:

ALTER TABLE `table_name`
CHANGE `column_name` `column_name`
INT(key_length) NOT NULL AUTO_INCREMENT

to all Primary Keys will do the job?

checked DB and all messages are fine before the upgrade, forum is still locked of course..

You can do it in phpmyadmin easiest. Just delete the old one and create new primary key with the same parameters selected.

Yes I did that through phpmyadmin. But I think not all kunena tables need auto_incremement primary keys.
Here is what I did (with "-" I mark the tables that did not make any changes to them):

jos_kunena_announcement ==> id ==> auto increment
jos_kunena_attachments ==> mesid ==> auto increment
jos_kunena_attachments_bak ==> mesid ==> auto increment
jos_kunena_categories ==> id ==> auto increment
jos_kunena_config -
jos_kunena_config_backup -
jos_kunena_discussbot -
jos_kunena_favorites -
jos_kunena_groups ==> id ==> auto increment
jos_kunena_messages ==> id ==> auto increment
jos_kunena_messages_text ==> id ==> auto increment
jos_kunena_moderation -
jos_kunena_polls ==> id ==> auto increment
jos_kunena_polls_options ==> id ==> auto increment
jos_kunena_polls_users -
jos_kunena_ranks ==> id ==> auto increment
jos_kunena_sessions -
jos_kunena_smileys ==> id ==> auto increment
jos_kunena_subscriptions -
jos_kunena_subscriptions_categories -
jos_kunena_thankyou -
jos_kunena_users -
jos_kunena_users_banned -
jos_kunena_version -
jos_kunena_whoisonline -

Yup, that did the trick. I posted some messages and all works fine.

Thank you very much for all the help.

Please mark this thread as solved.

Yes, you're right. Not all of them even have primary key -- some of them have just unique keys.

Glad that we got this one shorted out! The problem was the broken J1.0 -> J1.5 migration, which somehow affects only latest versions. No idea why..

I believe that you have the same issue in jos_fb tables..?