UBB.Developers Forums UBB.threads 7 Development How Do I? SQL errors- Change in Groups

I removed a couple of Maderators and an Admin yesterday and since then their PM system is broke. Here is the SQL error I see


Problems with indexes of table `w3t_Boards`
Warning PRIMARY and INDEX keys should not both be set for column `Bo_Number`
Problems with indexes of table `w3t_Moderators`
Warning More than one INDEX key was created for column `Mod_Uid`
Problems with indexes of table `w3t_Posts`
Warning More than one INDEX key was created for column `B_Board`
Problems with indexes of table `w3t_Users`
Warning PRIMARY and INDEX keys should not both be set for column `U_Number`


Before I run a repair table I wanted to ask advice on this. I can't let go of the memory of a repair table killing my database one year

anyone?

either try a repair or look at the indexes in phpMyAdmin and if in fact those four fields have indexes set and shouldn;t.. well you have bigger fish...

thanks Scroungr, I ran the repair and it looks like its fixed

yeah sounded like somehow something created an index on a primary field and well thats what caused that error

I sorta got a question to bounce off of Chaos's question.

I recently added a new user group in the Admin panel...but decided not to go further with it.

Is there a SQL query to delete this group now. I'm looking in the panel and my version only has Create, Rename, Mass move for options for Groups.

If there's a query to delete this recently added new one, I'd appreciate it.

Thanks!