Forum Question about upgrade_400a1_indexes.php
 

When running this script, I get the following and I'm not sure how to proceed. Can anyone help me out?

ne or more of the indexes being added is already defined If this query has already been run successfully, then this error can be safely ignored. If in doubt, check the indexes in mysql and ensure that they are correct

ALTER TABLE post
ADD INDEX threadid_visible_dateline (threadid, visible, dateline, userid, postid),
ADD INDEX ipaddress (ipaddress),
ADD INDEX dateline (dateline)

Duplicate key name 'dateline'


Adding thread indexes
One or more of the indexes being added is already defined If this query has already been run successfully, then this error can be safely ignored. If in doubt, check the indexes in mysql and ensure that they are correct

ALTER TABLE thread
DROP INDEX lastpost,
ADD INDEX lastpost(lastpost),
ADD INDEX forumid_lastpost(forumid, lastpost)

Duplicate key name 'forumid_lastpost'