Question 0 post counts 1.5.8

Actually userid IS primary key, which is unique.

This means that your installation is flawed: you have lost indexes from your database. Did you migrate your tables from Joomla 1.0 or very old version of FireBoard/JoomlaBoard?

Yes, this was a migration from Joomla 1.0 and Fireboard.

Mine was originally a migration from joomlaboard and then onto fireboard. All was working well until the 1.5.8 patch came along.

I am confused about how to fix this, not sure wbout what primary key / unique means, I can see it in phpmyadmin but means nothing to me

Would someone mind explaining step by step what I need to do to fix this or is there some code I can run in phpmyadmin to help fix this ?

Appreciate any help

Delete all keys from every jos_fb_ table and run these:

ALTER TABLE `jos_fb_announcement` ADD PRIMARY KEY ( `id` ) ;
ALTER TABLE `jos_fb_attachments` ADD INDEX `mesid` ( `mesid` ) ;
ALTER TABLE `jos_fb_categories` ADD PRIMARY KEY ( `id` ) ;
ALTER TABLE `jos_fb_categories` ADD INDEX `parent` ( `parent` ) ;
ALTER TABLE `jos_fb_categories` ADD INDEX `published_pubaccess_id` ( `published` , `pub_access` , `id` ) ;
ALTER TABLE `jos_fb_categories` ADD INDEX `msg_id` ( `id_last_msg` ) ;
ALTER TABLE `jos_fb_favorites` ADD UNIQUE `thread` ( `thread` , `userid` ) ;
ALTER TABLE `jos_fb_favorites` ADD INDEX `userid` ( `userid` ) ;
ALTER TABLE `jos_fb_messages` ADD PRIMARY KEY ( `id` ) ;
ALTER TABLE `jos_fb_messages` ADD INDEX `thread` ( `thread` ) ;
ALTER TABLE `jos_fb_messages` ADD INDEX `parent` ( `parent` ) ;
ALTER TABLE `jos_fb_messages` ADD INDEX `catid` ( `catid` ) ;
ALTER TABLE `jos_fb_messages` ADD INDEX `ip` ( `ip` ) ;
ALTER TABLE `jos_fb_messages` ADD INDEX `ip` ( `userid` ) ;
ALTER TABLE `jos_fb_messages` ADD INDEX `ip` ( `time` ) ;
ALTER TABLE `jos_fb_messages` ADD INDEX `ip` ( `locked` ) ;
ALTER TABLE `jos_fb_messages` ADD INDEX `hold_time` ( `hold` , `time` ) ;
ALTER TABLE `jos_fb_messages` ADD INDEX `parent_hits` ( `parent` , `hits` ) ;
ALTER TABLE `jos_fb_messages_text` ADD PRIMARY KEY ( `mesid` ) ;
ALTER TABLE `jos_fb_moderation` ADD PRIMARY KEY ( `catid` , `userid` ) ;
ALTER TABLE `jos_fb_ranks` ADD PRIMARY KEY ( `rank_id` ) ;
ALTER TABLE `jos_fb_sessions` ADD PRIMARY KEY ( `userid` ) ;
ALTER TABLE `jos_fb_smileys` ADD PRIMARY KEY ( `id` ) ;
ALTER TABLE `jos_fb_subscriptions` ADD UNIQUE `thread` ( `thread` , `userid` ) ;
ALTER TABLE `jos_fb_subscriptions` ADD INDEX `userid` ( `userid` ) ;
ALTER TABLE `jos_fb_users` ADD PRIMARY KEY ( `userid` ) ;
ALTER TABLE `jos_fb_users` ADD INDEX `group_id` ( `group_id` ) ;
ALTER TABLE `jos_fb_users` ADD INDEX `posts` ( `posts` ) ;
ALTER TABLE `jos_fb_users` ADD INDEX `uhits` ( `uhits` ) ;
ALTER TABLE `jos_fb_version` ADD PRIMARY KEY ( `id` ) ;
ALTER TABLE `jos_fb_whoisonline` ADD PRIMARY KEY ( `id` ) ;
ALTER TABLE `jos_fb_whoisonline` ADD INDEX `userid` ( `userid` ) ;

Hi,

Sorry this is going over my head a little, how do I delete the keys ?

Appreciate the help

Please bear in mind that if you run SQL queries by hand you are running the risk of irreparably damaging your site. Before making any changes, always make sure you take a backup and that you know how to restore from it. Please, before making any changes by hand, read the note written by fxstein: How To Destroy your forum data... .

Having said these things, and being aware of the risks you are about to take, the general syntax to delete a key for a MySQL table is: