More than one INDEX key was created for column `postuserid` and `lastpost`

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • RaZor Edge
    Member
    • Oct 2001
    • 73
    • 3.8.x

    More than one INDEX key was created for column `postuserid` and `lastpost`

    I have a similar problem like in this thread.

    In my case, a check on mysql forum database tell my that:

    Code:
     
    Problems with indexes of table `thread` 
     More than one INDEX key was created for column `postuserid` 
     More than one INDEX key was created for column `lastpost`
    These have probably been add by some hack or plugin.

    Can you confirm me that I can safely delete the index in red?

    Code:
    PRIMARY  PRIMARY  19788       threadid  
    forumid  INDEX  19788       forumid  visible  sticky  lastpost  
    postuserid  INDEX  638       postuserid  
    [COLOR=red]postuserid_2  INDEX  638       postuserid  
    [/COLOR]pollid  INDEX  989       pollid  
    lastpost  INDEX  19788       lastpost  
    [COLOR=red]lastpost_2  INDEX  19788       lastpost  forumid[/COLOR]  
    dateline  INDEX  19788       dateline
    Thanks!
    http://www.fnnation.com/pub/small/fnforum.gif http://www.fnnation.com/pub/small/luttemedia.gif
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Yes. You can delete: postuserid_2 and lastpost_2
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...