Jump to the post that solved this thread.
Solved: 10 Years, 4 Months, 2 Weeks ago 1.8 phpmyadmin errors mesages
#1
Solved: 10 Years, 4 Months, 2 Weeks ago
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 


Attached Files Thumbnail(s)
   
_______________________________________________

It is not disgraceful to ask, it is disgraceful no to ask.


sory for my english .
Reply
#2
Solved: 10 Years, 4 Months, 2 Weeks ago
This user has been denied support. This user has been denied support.
Upgrade it again by downloading a fresh copy of MyBB 1.8 from here:

http://www.mybb.com/download/
Reply
#3
Solved: 10 Years, 4 Months, 2 Weeks ago
(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
Reply
#4
Solved: 10 Years, 4 Months, 2 Weeks ago
(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.
_______________________________________________

It is not disgraceful to ask, it is disgraceful no to ask.


sory for my english .
Reply
#5
Solved: 10 Years, 4 Months, 2 Weeks ago
^ 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)
Reply
#6
Solved: 10 Years, 4 Months, 2 Weeks ago
(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.
_______________________________________________

It is not disgraceful to ask, it is disgraceful no to ask.


sory for my english .
Reply
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: