More than one INDEX key was created for column `dateline`

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Darat
    Senior Member
    • Sep 2004
    • 121
    • 3.7.x

    More than one INDEX key was created for column `dateline`

    Hi

    We're experiencing some problems with MySQL and it's been suggested that we may have some corrupted indexes so I used phpMyAdmin to check all the vBulletin tables.

    Everything came up fine apart from this comment:

    phpMyadmin output

    Problems with indexes of table `post`
    More than one INDEX key was created for column `dateline`
    Is this an actual problem or something that vBulletin normally does?

    Thanks in advance
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    This is not a normal vB error. Someone or something (hack or plugin) created an extra index on this table that is causing this problem.
    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

    • Darat
      Senior Member
      • Sep 2004
      • 121
      • 3.7.x

      #3
      Thanks for the answer Steve. I'll remove all my hacks but in case something is left behind can you tell me which of these are not the standard vb indexes?

      Keyname Type Cardinality Action Field
      PRIMARY PRIMARY 1214202 postid
      userid INDEX 3299 userid
      threadid INDEX 404734 threadid
      userid
      importpost_index INDEX 1214202 importpostid
      dateline INDEX 1214202 dateline
      dateline_2 INDEX 1214202 dateline
      dateline_3 INDEX 1214202 dateline

      I'm assuming dateline_2 and _3 are the non-vb indexes?

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        Yes, removce the dateline_2 and dateline_3 indexes.
        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...