Sql-database Error

capitano
Dies ist eine vorgefertigte Schablone.
Bitte fülle soviel aus, wie dir nur Möglich ist, du kannst auch gerne noch mehr Angaben machen.


Problembeschreibung:
SQL-DATABASE ERROR


Fehlermeldung:
Database error in WoltLab Burning Board (2.3.6 pl2): Invalid SQL: SELECT DISTINCT p.userid, t.*, b.title, b.hotthread_reply, b.hotthread_view, tv.lastvisit, bv.lastvisit AS blastvisit FROM bb2_threads t LEFT JOIN bb2_boards b ON (b.boardid = t.boardid) LEFT JOIN bb2_threadvisit tv ON ((tv.threadid = t.threadid) AND (tv.userid = 1)) LEFT JOIN bb2_boardvisit bv ON ((bv.boardid = t.boardid) AND (bv.userid = 1)) LEFT JOIN bb2_posts p ON (t.threadid = p.threadid AND p.userid = '1') WHERE (t.visible <> 0) AND (b.boardid IN (3,4,6,8,9,12,14,15,16,17,19,20,21,30,31,32,33,34,36,38,39,41,43,50,51,53,6
4,65,66,68,69,70,78,80,83,86,89,90,91,92,95,96,97,99,100,102,105,107,108,10
9,113,117,119,125,128,131,132,133,134,135,136,137,138,139,140,141,150,151,1
53,154,155,156,158,160,161,162,163,164,165,166,167,168,170,171,172,173,174,
175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,194
,195,196,197,198,199,200,201,202,203,204,205,206,208,209,210,211,213,214,21
5,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,2
34,235,236,237,238,239,240,241,243,249,250,251,252,253,255,256,257,258,261,
262,263,264,266,267,269,271,272,273,278,279,280,281,282,283,286,288,289,290
,291,292,293,294,295,296,297,298,299,300,301,302,303,304,306,307,308,309,31
0,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,3
29,330,331,332,342,343,344,345,346,355,356,358,359,360,361,362,363,364,365,
366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384
,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,40
4,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,4
23,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,
442,443,444) AND NOT (b.boardid IN (12,34,135,132,133,342,6,442,141,150,402,156,257,53,343,412,408,407,264,411
,406,41,251,33,261,253,405,424,422,428,398,256,90,396,397,399,400,401,409,1
54,425,151,344,155,97,86,286,410,416,414,423,99,117,427,413,426,415,443,444
,68,263,282,283,345,137,134,431))) AND (t.closed < 3) ORDER BY t.lastposttime DESC LIMIT 48
mysql error: Table './d0020514/bb2_threadvisit' is marked as crashed and should be repaired
mysql error number: 145
mysql version: 5.0.51a-community-log
php version: 5.2.6
Date: 22.07.2008 @ 18:27
Script: /board/hmportal.php
Referer: http://www.dritteliga.net/board/wiw.php


Link zum Forum oder Screenshot:

http://www.dritteliga.net/board/


Was wurde zuletzt geändert oder eingebaut?

Ich habe die 4gewinnt Statistik gelöscht!

Ich habe jetzt mal bei phpmyadmin die Datenbank angeguckt und da steht bei der betreffenden Tabelle " in Benutzung"
Muss ich über phpmyadmin nun die Tabelle anklicken und dann auf Reparieren gehen?
jacqy
die tabelle bb2_threadvisit scheint kaputt zu sein.Im phpmyadmin mal auf reparieren gehen. Vorher Backup machen Augenzwinkern
capitano
Danke!

Hat geklappt!