kjtocool Posted December 13, 2007 Share Posted December 13, 2007 I am getting a problem with my database: More than one INDEX key was created for column `topic_id` More than one FULLTEXT key was created for column `post_subject` I ran a table repair, and the error still exists. Any ideas? Here are the indexes listed: Keyname Type Cardinality Action Field PRIMARY PRIMARY 1037398 Edit Drop post_id forum_id INDEX 25 Edit Drop forum_id topic_id INDEX 33464 Edit Drop topic_id poster_ip INDEX 47154 Edit Drop poster_ip poster_id INDEX 1657 Edit Drop poster_id post_approved INDEX 1 Edit Drop post_approved tid_post_time INDEX 1037398 Edit Drop topic_id, post_time post_subject FULLTEXT 1 Edit Drop post_subject post_text FULLTEXT 1 Edit Drop post_text post_content FULLTEXT 1 Edit Drop post_subject, post_text Quote Link to comment Share on other sites More sharing options...
fenway Posted December 14, 2007 Share Posted December 14, 2007 Yes, you don't need the individual indexes if you already included them as the first key for a multi-column index -- which you have. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.