Warning: The author of this contribution does not provide support for it anymore.

Top Posters on Index Cleaned contribution

I need help to fix errors - Top Posters on Index

I need help to fix errors

by badbii » Fri May 25, 2012 4:48 pm

Hello i am beginner and i need help.
I also (as many of users) got these errors :

Code: Select all

INSERT INTO phpbb_config (config_name, config_value) VALUES ('amount_top_posters', '10');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('top_posters_hours', '24');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('top_posters_excl_adm', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('top_posters_excl_mod', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('top_posters_excl_ids', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('top_posters_excl_hours', '0');

When i check my tables in phpmyadmin, these notifications shows up:

Code: Select all

Problems with indexes of table `phpbb_posts`
 More than one INDEX key was created for column `topic_id`
Problems with indexes of table `phpbb_qa_confirm`
 PRIMARY and INDEX keys should not both be set for column `confirm_id`
Problems with indexes of table `phpbb_search_wordmatch`
 UNIQUE and INDEX keys should not both be set for column `word_id`
Problems with indexes of table `phpbb_topics`
 More than one INDEX key was created for column `forum_id`


I read this tutorial:
viewtopic.php?f=70&t=588697&start=0&st=0&sk=t&sd=a
and when i try to do as written, i also got error:
error.png
error.png (7.35 KiB) Viewed 367 times



Is there anyone who know how to fix that? But don't forget that i am beginner in databases, phpmyadmin :)
badbii
Registered User
Posts: 1
Joined: Fri May 25, 2012 3:56 pm
Contact: