Welcome,
Guest
.
Please
login
or
register
.
Did you miss your
activation email
?
News:
Did you know that
Elxis 5.x
uses HTML5, CSS3 and pure javascript without external libraries such as jQuery?
Home
Help
Login
Register
Elxis CMS Forum
»
Support
»
Database
»
Some problems with MySQL (?)
« previous
next »
Print
Pages: [
1
]
Author
Topic: Some problems with MySQL (?) (Read 7906 times)
rentasite
Elxis Community
Hero Member
Posts: 3282
Web Services
Some problems with MySQL (?)
«
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
Logged
Rent a Site
|
Lelevose
datahell
Elxis Team
Hero Member
Posts: 10356
Re: Some problems with MySQL (?)
«
Reply #1 on:
December 05, 2007, 07:39:02 »
Repair your database from your control panel.
Logged
Elxis Team
|
Is Open Source
|
IOS Rentals | IOS AERO
rentasite
Elxis Community
Hero Member
Posts: 3282
Web Services
Re: Some problems with MySQL (?)
«
Reply #2 on:
December 05, 2007, 15:32:37 »
I did. Check, Optimize, Repair. It still shows.
Logged
Rent a Site
|
Lelevose
datahell
Elxis Team
Hero Member
Posts: 10356
Re: Some problems with MySQL (?)
«
Reply #3 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.
Logged
Elxis Team
|
Is Open Source
|
IOS Rentals | IOS AERO
Print
Pages: [
1
]
« previous
next »
Elxis CMS Forum
»
Support
»
Database
»
Some problems with MySQL (?)