XOOPS 2.0.14
Cloned Template: Yes
templates generated: Yes

General Server Information:

OS: Linux
Apache: 1.3.36 (UNIX)
PHP: 4.4.2
MySQL: 4.1.20 (std.log)
Register_globals: ON

PC Browser

Widnows XP Home Edition
--------------------------------------------------------
--------------------------------------------------------

When running a check on MySQL from Phpadmin I get Status OK for all tables but down at the bottom I have these Warnings/Problems indicated. I have no idea what to do about them. Anyone got an ideas or recommendations?

Problems with indexes of table `xoops1_banner`
PRIMARY and INDEX keys should not both be set for column `bid`

Problems with indexes of table `xoops1_newblocks`
More than one INDEX key was created for column `mid`

Problems with indexes of table `xoops1_priv_msgs`
PRIMARY and INDEX keys should not both be set for column `msg_id`
More than one INDEX key was created for column `to_userid`

Problems with indexes of table `xoops1_ranks`
More than one INDEX key was created for column `rank_min`

Problems with indexes of table `xoops1_smartfaq_answers`
PRIMARY and INDEX keys should not both be set for column `answerid`
Problems with indexes of table `xoops1_smartfaq_categories`
PRIMARY and INDEX keys should not both be set for column `categoryid`
Problems with indexes of table `xoops1_smartfaq_faq`
PRIMARY and INDEX keys should not both be set for column `faqid`

Problems with indexes of table `xoops1_users`
PRIMARY and INDEX keys should not both be set for column `uid`
More than one INDEX key was created for column `uname`

Bump

What to do about them? Ignore them.

1. I think there's a bug with phpMyAdmin. Extra columns aren't recognised when the index begins with the same field as the primary key. In other words, 'banner', 'prv_msgs', 'users' (same primary key/index) are correct despite what phpMyAdmin says.

2. Some indexes aren't needed, so if you want you can safely delete them. Not much point though in my opinion, as the indexes don't even seem to be used.

Anyway, if you want to cleanup your database indexes:

'new_blocks' doesn't need the 'mid' index.
'prv_msgs' doesn't need the 'to_user' index.
'ranks' doesn't need the 'rank_min' index.
'users' doesn't need the 'uname' index.

I don't have smartfaq so can't give any comment on that.

Personally, I'd ignore the 'warnings' - unless I had a very large database, in which case I'd be optimising the queries first, forcing them to use a particular index. As it is, the extra indexes do no harm so I wouldn't bother about them.