Board down... tabellen in pphpmyadmin corrupt! help!

Installatie lukt niet? Plotseling een foutmelding. Of weet je niet hoe iets werkt. Problemen met phpBB2 kun je in dit archief opzoeken.
Forumregels

Sinds 1 januari 2009 wordt phpBB2 niet meer ondersteund.
Onderstaande informatie is verouderd en dient uitsluitend als archief.
phpBB2.0.x
Gesloten
Ibot
Berichten: 234
Lid geworden op: 07 nov 2003, 22:07

Board down... tabellen in pphpmyadmin corrupt! help!

Bericht door Ibot » 10 aug 2004, 06:01

Help! van de ene op de andere dag was mn board niet meer te lezen, er stond 'Couldn't obtain category list.' als ik een subforum in wilde.

Met de zoekfunctie hier vond ik dat ik tabellen moest updaten, helaas kreeg ik allerlei errors, en lukte het niet.

Nu staat er dus dit in mijn phpmyadmin :(

Code: Selecteer alles


Table  Op  Msg_type  Msg_text  
Forum.php4u_bookmarks check status OK 
Forum.phpbb_auth_access check warning Table is marked as crashed and last repair failed 
Forum.phpbb_auth_access check error Keypointers and record positions doesn't match 
Forum.phpbb_auth_access check warning Found 24 deleted blocks       Should be: 0 
Forum.phpbb_auth_access check error Corrupt 
Forum.phpbb_banlist check status OK 
Forum.phpbb_categories check warning Table is marked as crashed and last repair failed 
Forum.phpbb_categories check warning Size of indexfile is: 3072      Should be: 1024 
Forum.phpbb_categories check error Can't read indexpage from filepos: -1 
Forum.phpbb_categories check error Corrupt 
Forum.phpbb_config check warning Table is marked as crashed and last repair failed 
Forum.phpbb_config check warning 1 clients is using or hasn't closed the table properly 
Forum.phpbb_config check warning Size of indexfile is: 3072      Should be: 1024 
Forum.phpbb_config check error Can't read indexpage from filepos: -1 
Forum.phpbb_config check error Corrupt 
Forum.phpbb_confirm check status OK 
Forum.phpbb_disallow check warning Table is marked as crashed and last repair failed 
Forum.phpbb_disallow check warning Size of indexfile is: 2048      Should be: 1024 
Forum.phpbb_disallow check error Can't read indexpage from filepos: -1 
Forum.phpbb_disallow check error Corrupt 
Forum.phpbb_forum_prune check status OK 
Forum.phpbb_forums check warning Table is marked as crashed and last repair failed 
Forum.phpbb_forums check warning 3 clients is using or hasn't closed the table properly 
Forum.phpbb_forums check warning Size of indexfile is: 5120      Should be: 1024 
Forum.phpbb_forums check error Can't read indexpage from filepos: -1 
Forum.phpbb_forums check error Corrupt 
Forum.phpbb_groups check warning Table is marked as crashed and last repair failed 
Forum.phpbb_groups check warning Size of indexfile is: 3072      Should be: 1024 
Forum.phpbb_groups check error Can't read indexpage from filepos: -1 
Forum.phpbb_groups check error Corrupt 
Forum.phpbb_ip check warning Table is marked as crashed and last repair failed 
Forum.phpbb_ip check warning Size of indexfile is: 167936      Should be: 10240 
Forum.phpbb_ip check error Found 1539 keys of 1538 
Forum.phpbb_ip check error Corrupt 
Forum.phpbb_posts check warning Table is marked as crashed and last repair failed 
Forum.phpbb_posts check warning 3 clients is using or hasn't closed the table properly 
Forum.phpbb_posts check warning Size of indexfile is: 143360      Should be: 13312 
Forum.phpbb_posts check error Can't read indexpage from filepos: -1 
Forum.phpbb_posts check error Corrupt 
Forum.phpbb_posts_text check warning Table is marked as crashed and last repair failed 
Forum.phpbb_posts_text check warning 2 clients is using or hasn't closed the table properly 
Forum.phpbb_posts_text check warning Size of indexfile is: 27648      Should be: 13312 
Forum.phpbb_posts_text check error Can't read indexpage from filepos: -1 
Forum.phpbb_posts_text check error Corrupt 
Forum.phpbb_privmsgs check warning Table is marked as crashed and last repair failed 
Forum.phpbb_privmsgs check warning Size of indexfile is: 4096      Should be: 1024 
Forum.phpbb_privmsgs check error Can't read indexpage from filepos: -1 
Forum.phpbb_privmsgs check error Corrupt 
Forum.phpbb_privmsgs_text check warning Table is marked as crashed and last repair failed 
Forum.phpbb_privmsgs_text check warning Size of indexfile is: 2048      Should be: 1024 
Forum.phpbb_privmsgs_text check error Can't read indexpage from filepos: -1 
Forum.phpbb_privmsgs_text check error Corrupt 
Forum.phpbb_ranks check warning Table is marked as crashed and last repair failed 
Forum.phpbb_ranks check warning Size of indexfile is: 2048      Should be: 1024 
Forum.phpbb_ranks check error Can't read indexpage from filepos: -1 
Forum.phpbb_ranks check error Corrupt 
Forum.phpbb_search_results check warning Table is marked as crashed and last repair failed 
Forum.phpbb_search_results check warning Size of indexfile is: 3072      Should be: 1024 
Forum.phpbb_search_results check error Can't read indexpage from filepos: -1 
Forum.phpbb_search_results check error Corrupt 
Forum.phpbb_search_wordlist check warning Table is marked as crashed and last repair failed 
Forum.phpbb_search_wordlist check warning 2 clients is using or hasn't closed the table properly 
Forum.phpbb_search_wordlist check warning Size of indexfile is: 169984      Should be: 46080 
Forum.phpbb_search_wordlist check error Can't read indexpage from filepos: -1 
Forum.phpbb_search_wordlist check error Corrupt 
Forum.phpbb_search_wordmatch check warning Table is marked as crashed and last repair failed 
Forum.phpbb_search_wordmatch check warning 2 clients is using or hasn't closed the table properly 
Forum.phpbb_search_wordmatch check warning Size of indexfile is: 614400      Should be: 277504 
Forum.phpbb_search_wordmatch check error Keypointers and record positions doesn't match 
Forum.phpbb_search_wordmatch check warning Found 20469 deleted blocks       Should be: 0 
Forum.phpbb_search_wordmatch check error Corrupt 
Forum.phpbb_sessions check error The handler for the table doesn't support check/repair 
Forum.phpbb_shopitems check warning Table is marked as crashed and last repair failed 
Forum.phpbb_shopitems check warning Size of indexfile is: 3072      Should be: 1024 
Forum.phpbb_shopitems check error Can't read indexpage from filepos: -1 
Forum.phpbb_shopitems check error Corrupt 
Forum.phpbb_shops check warning Table is marked as crashed and last repair failed 
Forum.phpbb_shops check status OK 
Forum.phpbb_shout check warning Table is marked as crashed and last repair failed 
Forum.phpbb_shout check warning Size of indexfile is: 4096      Should be: 1024 
Forum.phpbb_shout check error Can't read indexpage from filepos: -1 
Forum.phpbb_shout check error Corrupt 
Forum.phpbb_smilies check warning Table is marked as crashed and last repair failed 
Forum.phpbb_smilies check warning Size of indexfile is: 2048      Should be: 1024 
Forum.phpbb_smilies check error Can't read indexpage from filepos: -1 
Forum.phpbb_smilies check error Corrupt 
Forum.phpbb_themes check warning Table is marked as crashed and last repair failed 
Forum.phpbb_themes check warning Size of indexfile is: 2048      Should be: 1024 
Forum.phpbb_themes check error Can't read indexpage from filepos: -1 
Forum.phpbb_themes check error Corrupt 
Forum.phpbb_themes_name check warning Table is marked as crashed and last repair failed 
Forum.phpbb_themes_name check status OK 
Forum.phpbb_topics check warning Table is marked as crashed and last repair failed 
Forum.phpbb_topics check warning 4 clients is using or hasn't closed the table properly 
Forum.phpbb_topics check error Keypointers and record positions doesn't match 
Forum.phpbb_topics check warning Found 61 deleted blocks       Should be: 0 
Forum.phpbb_topics check error Corrupt 
Forum.phpbb_topics_watch check warning Table is marked as crashed and last repair failed 
Forum.phpbb_topics_watch check warning 3 clients is using or hasn't closed the table properly 
Forum.phpbb_topics_watch check warning Size of indexfile is: 8192      Should be: 4096 
Table  Op  Msg_type  Msg_text  
Forum.phpbb_topics_watch check error Keypointers and record positions doesn't match 
Forum.phpbb_topics_watch check warning Found 90 deleted blocks       Should be: 0 
Forum.phpbb_topics_watch check error Corrupt 
Forum.phpbb_user_group check warning Table is marked as crashed and last repair failed 
Forum.phpbb_user_group check status OK 
Forum.phpbb_users check warning Table is marked as crashed and last repair failed 
Forum.phpbb_users check warning 4 clients is using or hasn't closed the table properly 
Forum.phpbb_users check warning Size of indexfile is: 3072      Should be: 1024 
Forum.phpbb_users check error Can't read indexpage from filepos: -1 
Forum.phpbb_users check error Corrupt 
Forum.phpbb_vote_desc check warning Table is marked as crashed and last repair failed 
Forum.phpbb_vote_desc check warning Size of indexfile is: 3072      Should be: 1024 
Forum.phpbb_vote_desc check error Can't read indexpage from filepos: -1 
Forum.phpbb_vote_desc check error Corrupt 
Forum.phpbb_vote_results check warning Table is marked as crashed and last repair failed 
Forum.phpbb_vote_results check warning Size of indexfile is: 3072      Should be: 1024 
Forum.phpbb_vote_results check error Can't read indexpage from filepos: -1 
Forum.phpbb_vote_results check error Corrupt 
Forum.phpbb_vote_voters check warning Table is marked as crashed and last repair failed 
Forum.phpbb_vote_voters check error Keypointers and record positions doesn't match 
Forum.phpbb_vote_voters check warning Found 22 deleted blocks       Should be: 0 
Forum.phpbb_vote_voters check error Corrupt 
Forum.phpbb_words check warning Table is marked as crashed and last repair failed 
Forum.phpbb_words check status OK 
En dit als ik wil repareren:

Code: Selecteer alles

Table  Op  Msg_type  Msg_text  
Forum.php4u_bookmarks repair status OK 
Forum.phpbb_auth_access repair error 28 when fixing table 
Forum.phpbb_auth_access repair status Operation failed 
Forum.phpbb_banlist repair status OK 
Forum.phpbb_categories repair error 28 when fixing table 
Forum.phpbb_categories repair status Operation failed 
Forum.phpbb_config repair error 28 when fixing table 
Forum.phpbb_config repair status Operation failed 
Forum.phpbb_confirm repair status OK 
Forum.phpbb_disallow repair error 28 when fixing table 
Forum.phpbb_disallow repair status Operation failed 
Forum.phpbb_forum_prune repair status OK 
Forum.phpbb_forums repair error 28 when fixing table 
Forum.phpbb_forums repair status Operation failed 
Forum.phpbb_groups repair error 28 when fixing table 
Forum.phpbb_groups repair status Operation failed 
Forum.phpbb_ip repair error 28 when writing to datafile 
Forum.phpbb_ip repair error 28 when writing to datafile 
Forum.phpbb_ip repair status Operation failed 
Forum.phpbb_posts repair error 28 when fixing table 
Forum.phpbb_posts repair status Operation failed 
Forum.phpbb_posts_text repair error 28 when fixing table 
Forum.phpbb_posts_text repair status Operation failed 
Forum.phpbb_privmsgs repair error 28 when fixing table 
Forum.phpbb_privmsgs repair status Operation failed 
Forum.phpbb_privmsgs_text repair error 28 when fixing table 
Forum.phpbb_privmsgs_text repair status Operation failed 
Forum.phpbb_ranks repair error 28 when fixing table 
Forum.phpbb_ranks repair status Operation failed 
Forum.phpbb_search_results repair error 28 when fixing table 
Forum.phpbb_search_results repair status Operation failed 
Forum.phpbb_search_wordlist repair error 28 when fixing table 
Forum.phpbb_search_wordlist repair status Operation failed 
Forum.phpbb_search_wordmatch repair error 28 when fixing table 
Forum.phpbb_search_wordmatch repair status Operation failed 
Forum.phpbb_sessions repair error The handler for the table doesn't support check/repair 
Forum.phpbb_shopitems repair error 28 when fixing table 
Forum.phpbb_shopitems repair status Operation failed 
Forum.phpbb_shops repair error 28 when fixing table 
Forum.phpbb_shops repair status Operation failed 
Forum.phpbb_shout repair error 28 when fixing table 
Forum.phpbb_shout repair status Operation failed 
Forum.phpbb_smilies repair error 28 when fixing table 
Forum.phpbb_smilies repair status Operation failed 
Forum.phpbb_themes repair error 28 when fixing table 
Forum.phpbb_themes repair status Operation failed 
Forum.phpbb_themes_name repair error 28 when fixing table 
Forum.phpbb_themes_name repair status Operation failed 
Forum.phpbb_topics repair error 28 when fixing table 
Forum.phpbb_topics repair status Operation failed 
Forum.phpbb_topics_watch repair error 28 when fixing table 
Forum.phpbb_topics_watch repair status Operation failed 
Forum.phpbb_user_group repair error 28 when fixing table 
Forum.phpbb_user_group repair status Operation failed 
Forum.phpbb_users repair error 28 when fixing table 
Forum.phpbb_users repair status Operation failed 
Forum.phpbb_vote_desc repair error 28 when fixing table 
Forum.phpbb_vote_desc repair status Operation failed 
Forum.phpbb_vote_results repair error 28 when fixing table 
Forum.phpbb_vote_results repair status Operation failed 
Forum.phpbb_vote_voters repair error 28 when fixing table 
Forum.phpbb_vote_voters repair status Operation failed 
Forum.phpbb_words repair error 28 when fixing table 
Forum.phpbb_words repair status Operation failed 
En mijn board zelf staat nu dit:

Code: Selecteer alles

phpBB : Critical Error 

Could not query config information 

Gebruikersavatar
WebSiteNet
Berichten: 6524
Lid geworden op: 20 okt 2003, 16:56
Locatie: Wieringerwerf
Contacteer:

Bericht door WebSiteNet » 10 aug 2004, 07:58

Het is vrij duidelijk: De tabellen zijn corrupt.

Je moet aan je host vragen wat ze hier aan kunnen doen.

Ibot
Berichten: 234
Lid geworden op: 07 nov 2003, 22:07

Bericht door Ibot » 10 aug 2004, 19:33

Oke, maar hoe komt het dan??

Gebruikersavatar
WebSiteNet
Berichten: 6524
Lid geworden op: 20 okt 2003, 16:56
Locatie: Wieringerwerf
Contacteer:

Bericht door WebSiteNet » 10 aug 2004, 20:07

Dat weet ik niet.

Ik kan wel gokken, maar ik kan er lichtjaren naast zitten:

Virus
Mysql server corrupt
Hacker
Serveradmin die met bestanden klooit
etc.

Ibot
Berichten: 234
Lid geworden op: 07 nov 2003, 22:07

Bericht door Ibot » 10 aug 2004, 20:21

Gelukkig is het allemaal goed nu, nu repareerde hij wel ineens.

Erg vaag!

In ieder geval bedankt allemaal!!!

dMo-dMo
Berichten: 62
Lid geworden op: 05 jun 2004, 23:47

Bericht door dMo-dMo » 10 aug 2004, 22:16

1 tip: maak regelmatig zélf een backup van je db!

Gesloten