MyBB Community Forums - 1.8 phpmyadmin errors mesages

Hi,,after upgrade 1.8 ı check all tables phpmyadmin Problems with indexes of table mybb_posts

What is this error? How do I solve? means?,,

look screen pls

Upgrade it again by downloading a fresh copy of MyBB 1.8 from here:

http://www.mybb.com/download/

(2014-09-17, 05:16 AM)aroshkhan Wrote: [ -> ]Upgrade it again by downloading a fresh copy of MyBB 1.8 from here:

http://www.mybb.com/download/

That's not necessary at all.

The warning states that your mybb_posts table has a duplicate index and that may cause worse performance of that table. You can simply drop the redundant index: http://dev.mysql.com/doc/refman/5.0/en/drop-index.html

(2014-09-17, 05:28 AM)Destroy666 Wrote: [ -> ]
(2014-09-17, 05:16 AM)aroshkhan Wrote: [ -> ]Upgrade it again by downloading a fresh copy of MyBB 1.8 from here:

http://www.mybb.com/download/

That's not necessary at all.

The warning states that your mybb_posts table has a duplicate index and that may cause worse performance of that table. You can simply drop the redundant index: http://dev.mysql.com/doc/refman/5.0/en/drop-index.html

hi,destroer

what code from phpMyAdmin? little information about it. what code? should be how?

thanks.

^ at phpMyAdmin, you can select mybb_posts table at the left side column and then on right side top click on structure
scroll down for indexes and there you should see the warnings and drop links for all the indexes.
there you can click on drop link next to tid_2, tid_3 .. etc (do not drop tid index)

(2014-09-17, 02:53 PM).m. Wrote: [ -> ]^ at phpMyAdmin, you can select mybb_posts table at the left side column and then on right side top click on structure
scroll down for indexes and there you should see the warnings and drop links for all the indexes.
there you can click on drop link next to tid_2, tid_3 .. etc (do not drop tid index)

wery thanks ,ı tried.