Database error

Database error

由Tuan dc發表於
Number of replies: 2

Dear all,

When checking the tables by phpMyadmin, I have got errors below. I try to repair by phpMyadmin but the handers do not support this works. Please help me to correct the database. Thank you very much in advance,

Regards

------------------------------------------------

Problems with indexes of table `mdl_choice`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_choice_answers`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_choice_options`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_course_categories`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_course_display`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_course_modules`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_event`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_forum`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_forum_read`
Warning More than one INDEX key was created for column `userid`
Problems with indexes of table `mdl_forum_subscriptions`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_groups`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_groups_members`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_log`
Warning More than one INDEX key was created for column `course`
Problems with indexes of table `mdl_modules`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_resource`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_scorm`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_scorm_scoes`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_scorm_scoes_track`
Warning UNIQUE and INDEX keys should not both be set for column `userid`
Problems with indexes of table `mdl_survey_analysis`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_survey_answers`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_user`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Warning More than one INDEX key was created for column `deleted`
Warning More than one INDEX key was created for column `confirmed`
Warning More than one INDEX key was created for column `firstname`
Warning More than one INDEX key was created for column `lastname`
Warning More than one INDEX key was created for column `city`
Warning More than one INDEX key was created for column `country`
Warning More than one INDEX key was created for column `lastaccess`
Warning More than one INDEX key was created for column `email`
Problems with indexes of table `mdl_user_admins`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_user_coursecreators`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_user_preferences`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_user_students`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_user_teachers`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_wiki_entries`
Warning More than one INDEX key was created for column `groupid`
Problems with indexes of table `mdl_workshop_assessments`
Warning More than one INDEX key was created for column `submissionid`
Warning More than one INDEX key was created for column `userid`
Problems with indexes of table `mdl_workshop_submissions`
Warning More than one INDEX key was created for column `userid`

-------------------------------------------------------

評比平均分數： -
In reply to Tuan dc

Re: Database error

由Guido van der Waals發表於
It's now march, are your problems solved? I am very interested while I have the same problems with Moodle1.5.3, downloaded in december 2005.
評比平均分數： -
In reply to Guido van der Waals

Re: Database error

由Philippe Verdenal發表於
After modifying fields with warning message in the database, when checking the database, I still have the following message:

Problems with indexes of table `mdl_forum_read`
Warning More than one INDEX key was created for column `userid`
Problems with indexes of table `mdl_log`
Warning More than one INDEX key was created for column `course`
Problems with indexes of table `mdl_scorm_scoes_track`
Warning UNIQUE and INDEX keys should not both be set for column `userid`
 
Trying to solve the 1st problem, I have the following window:

Modify an index
Index name: 
Attention("PRIMARY" must be the name of and only of a primary key!)
Index type:  INDEX UNIQUE FULLTEXT Documentation
Fields : 
Field Size
-- Ignore -- id [int(10) unsigned] userid [int(10)] forumid [int(10)] discussionid [int(10)] postid [int(10)] firstread [int(10)] lastread [int(10)]
-- Ignore -- id [int(10) unsigned] userid [int(10)] forumid [int(10)] discussionid [int(10)] postid [int(10)] firstread [int(10)] lastread [int(10)]
Add to index   column(s)  

Thanks for any kind of help.
Cheers.
評比平均分數： -