Elxis CMS Forum
Support => Database => Topic started by: rentasite on December 05, 2007, 00:42:34
-
I did a check today on one of my mysql databases, and i got these messages below. Has anyone faced similar problems?
Problems with indexes of table `elx_categories`
More than one INDEX key was created for column `section`
Problems with indexes of table `elx_core_acl_aro_groups`
More than one INDEX key was created for column `parent_id`
Problems with indexes of table `elx_core_acl_aro_sections`
More than one UNIQUE key was created for column `value`
More than one INDEX key was created for column `hidden`
Problems with indexes of table `elx_core_acl_groups_aro_map`
PRIMARY and INDEX keys should not both be set for column `group_id`
Problems with indexes of table `elx_messages_cfg`
PRIMARY and INDEX keys should not both be set for column `user_id`
Thanks in advance
-
Repair your database from your control panel.
-
I did. Check, Optimize, Repair. It still shows.
-
Open your database (using phpmyadmin) and check the problem. Check your database's structure and indexes with the Elxis default. Check if there are duplicated indexes. Perform fixes where needed.