Silmarillion
04.09.2006, 11:41
Seit einigen Tagen können in einem unserer Foren keine Themen mehr verfasst und keine Antworten mehr getätigt werden. Leider habe ich davon erst heute erfahren. Folgende Fehlermeldung wird angezeigt:
Datenbankfehler in vBulletin 3.5.1:
Invalid SQL:
INSERT INTO post
(showsignature, allowsmilie, username, userid, title, pagetext, iconid, visible, dateline, ipaddress, attach, threadid)
VALUES
(1, 1, 'Silmarillion', 1, 'Test', '1234...', 5, 1, 1157362525, 'xx.xxx.xxx.x', 0, 784);
MySQL-Fehler : Duplicate entry '37057' for key 1
Fehler-Nr. : 1062
Datum : Monday, September 4th 2006 @ 11:35:25 AM
Skript : http://www.deinforum.de/newthread.php
Referrer : http://www.deinforum.de/newthread.php?do=newthread&f=32
IP-Adresse : xx.xxx.xxx.x
Benutzername : Silmarillion
Klassenname : vb_database
Das betroffene Forum läuft auf einem Shared-Server.
Mit der Tabellen reparieren/optimieren Funktion bekomme ich folgende Fehlermeldungen:
cron Check Warning: 2 clients are using or haven't closed the table properly
datastore Check Warning: 5 clients are using or haven't closed the table properly
forum Check Warning: 3 clients are using or haven't closed the table properly
forumread Check Warning: 1 client is using or hasn't closed the table properly
post Check Warning: 2 clients are using or haven't closed the table properly
post Check Warning: Size of datafile is: 10510632 Should be: 10510016
post Check Error: Found 36922 keys of 36921
post Check Error: Corrupt
post_parsed Check Warning: 3 clients are using or haven't closed the table properly
post_parsed Check Warning: Found 646592 deleted space in delete link chain. Should be 646736
post_parsed Check Error: Found 2591 deleted rows in delete link chain. Should be 2593
post_parsed Check Error: record delete-link-chain corrupted
post_parsed Check Error: Corrupt
post_parsed
posthash Check Warning: 2 clients are using or haven't closed the table properly
postindex Check Warning: 2 clients are using or haven't closed the table properly
postindex Check Warning: Size of datafile is: 6003764 Should be: 6003751
postindex Check Error: Record-count is not ok; is 461828 Should be: 461827
postindex Check Warning: Found 461828 parts Should be: 461827 parts
postindex Check Error: Corrupt
thread Check Warning: 4 clients are using or haven't closed the table properly
threadread Check Warning: 2 clients are using or haven't closed the table properly
threadviews Check Warning: 7 clients are using or haven't closed the table properly
user Check Warning: 5 clients are using or haven't closed the table properly
word Check Warning: 2 clients are using or haven't closed the table properly
word Check Warning: Size of datafile is: 4422660 Should be: 4422605
word Check Error: Record-count is not ok; is 80412 Should be: 80411
word Check Warning: Found 80412 parts Should be: 80411 parts
word Check Error: Corrupt
mfg
Datenbankfehler in vBulletin 3.5.1:
Invalid SQL:
INSERT INTO post
(showsignature, allowsmilie, username, userid, title, pagetext, iconid, visible, dateline, ipaddress, attach, threadid)
VALUES
(1, 1, 'Silmarillion', 1, 'Test', '1234...', 5, 1, 1157362525, 'xx.xxx.xxx.x', 0, 784);
MySQL-Fehler : Duplicate entry '37057' for key 1
Fehler-Nr. : 1062
Datum : Monday, September 4th 2006 @ 11:35:25 AM
Skript : http://www.deinforum.de/newthread.php
Referrer : http://www.deinforum.de/newthread.php?do=newthread&f=32
IP-Adresse : xx.xxx.xxx.x
Benutzername : Silmarillion
Klassenname : vb_database
Das betroffene Forum läuft auf einem Shared-Server.
Mit der Tabellen reparieren/optimieren Funktion bekomme ich folgende Fehlermeldungen:
cron Check Warning: 2 clients are using or haven't closed the table properly
datastore Check Warning: 5 clients are using or haven't closed the table properly
forum Check Warning: 3 clients are using or haven't closed the table properly
forumread Check Warning: 1 client is using or hasn't closed the table properly
post Check Warning: 2 clients are using or haven't closed the table properly
post Check Warning: Size of datafile is: 10510632 Should be: 10510016
post Check Error: Found 36922 keys of 36921
post Check Error: Corrupt
post_parsed Check Warning: 3 clients are using or haven't closed the table properly
post_parsed Check Warning: Found 646592 deleted space in delete link chain. Should be 646736
post_parsed Check Error: Found 2591 deleted rows in delete link chain. Should be 2593
post_parsed Check Error: record delete-link-chain corrupted
post_parsed Check Error: Corrupt
post_parsed
posthash Check Warning: 2 clients are using or haven't closed the table properly
postindex Check Warning: 2 clients are using or haven't closed the table properly
postindex Check Warning: Size of datafile is: 6003764 Should be: 6003751
postindex Check Error: Record-count is not ok; is 461828 Should be: 461827
postindex Check Warning: Found 461828 parts Should be: 461827 parts
postindex Check Error: Corrupt
thread Check Warning: 4 clients are using or haven't closed the table properly
threadread Check Warning: 2 clients are using or haven't closed the table properly
threadviews Check Warning: 7 clients are using or haven't closed the table properly
user Check Warning: 5 clients are using or haven't closed the table properly
word Check Warning: 2 clients are using or haven't closed the table properly
word Check Warning: Size of datafile is: 4422660 Should be: 4422605
word Check Error: Record-count is not ok; is 80412 Should be: 80411
word Check Warning: Found 80412 parts Should be: 80411 parts
word Check Error: Corrupt
mfg