SQL Help
Asked Modified Viewed 2,201 times
asked
When checking the tables using phpMyAdmin, I get the following:
-Problems with indexes of table 'fusion_posts'
-More than one INDEX key was created for column 'post_datestamp'
Under indexes, I see both a 'post_datestamp' and a 'post_datestamp_2'. Is this correct or has an extra index been created. Can I safely delete 'post_datestamp_2'?
-Problems with indexes of table 'fusion_posts'
-More than one INDEX key was created for column 'post_datestamp'
Under indexes, I see both a 'post_datestamp' and a 'post_datestamp_2'. Is this correct or has an extra index been created. Can I safely delete 'post_datestamp_2'?
Edited by arat on 10-07-2008 17:45,
answered
There should only be one "post_datestamp field"
The index keys should be thread_id and post_datestamp.
You can safely delete post_datestamp2.
The index keys should be thread_id and post_datestamp.
You can safely delete post_datestamp2.
answered
Thanks! I'm not sure how the extra one got there.
Category Forum
Installation Issues - 8Labels
None yet
Statistics
- Views 0 views
- Posts 2 posts
- Votes 0 votes
- Topic users 2 members
2 participants
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions