Table indices problems
Can someone who knows mysql help with the errors I am getting when I run "check" in phpmyadmin on my database? If you can point me to messages on this, that would be helpful. I've been looking for the past two hours. Any suggestions/advice sure would be nice.
1. In the table/message text area:
water.users check warning Found row where the auto_increment column has the value 0
2. And below the table/message text area, it says the following:
Problems with indexes of table `blocks`
Warning UNIQUE and INDEX keys should not both be set for column `theme`
Problems with indexes of table `filters`
Warning UNIQUE and INDEX keys should not both be set for column `format`
Problems with indexes of table `menu_links`
Warning More than one INDEX key was created for column `menu_name`
Problems with indexes of table `search_index`
Warning UNIQUE and INDEX keys should not both be set for column `word`
Problems with indexes of table `system`
Warning More than one INDEX key was created for column `type`
Problems with indexes of table `term_data`
Warning More than one INDEX key was created for column `vid`
The first one is normal. The
The first one is normal. The users table defines a user with a UID of 0 (anonymous). I'm not sure about the second one though.
Anybody have any insight on
Anybody have any insight on what to do re #2?
I have been fussing with this since May 28. No solution.
I have cleared caches (dev site). Done repair and optimize in phpmyadmn. Logged in and out. Run update. Rebooted. That's all the magic I know.
I'm a noob with mysql.
Hi again... sorry to keep
Hi again... sorry to keep bumping this but I have spent huge number of hours trying to figure out what to do about these warnings. No magic learned yet. I think I've read every post in the forum that might relate to this. I've googled. I've read and reread. I've been on IRC.
Scared to add any content if there are these problems or to move further with site out of fear that I'll be adding "stuff" on top of bad "stuff."
My dev site works perfectly, currently. I've done repair and check and optimize and analyze. I've done php update and cache clear.
****Does anybody know anyone with some phpmyadmin/mysql/drupal skills that they could refer me to? Hoping...
****When I look at the blocks table, I see:
KEYNAME FIELD
tmd UNIQUE 41 theme
module
delta
list INDEX 41 theme
status
region
weight
module
UNIQUE and INDEX keys should not both be set for column `theme`
So the field "theme" is being included in two keynames. But if I delete the list keyname, then all five fields are deleted.
Is this doubling up of settings just something that is NORMAL in Drupal tables?????