Elxis CMS Forum

Support => Database => Topic started by: rentasite on December 05, 2007, 00:42:34

Title: Some problems with MySQL (?)
Post 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

Title: Re: Some problems with MySQL (?)
Post by: datahell on December 05, 2007, 07:39:02

Repair your database from your control panel.

Title: Re: Some problems with MySQL (?)
Post by: rentasite on December 05, 2007, 15:32:37

I did. Check, Optimize, Repair. It still shows.

Title: Re: Some problems with MySQL (?)
Post by: datahell on December 05, 2007, 17:52:40

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.