i believe that view_view table belongs to Views module, You will get the attached error message when you "Check Table" using PhpMyAdmin

CommentFileSizeAuthor
view.JPG13.19 KBFoodster

Comments

catch’s picture

catch
he/him
Primary language English
commented

I can confirm this in my live site's database. Looks like it might be an upgrade issue.

You can safely delete the "index", leaving the "unique" intact, I think.

sun’s picture

sun
Primary language German
Location Karlsruhe
commented
Title: Problem with indexes of table » Unnecessary index 'name_2' on view_view
merlinofchaos’s picture

merlinofchaos commented
Status: Active » Closed (won't fix)

This will not be fixed in Views 1.