Hoi,
Ik heb een vaag probleem sinds een paar dagen. Elke keer naar ongeveer een dag of twee krijg ik dit soort meldingen in spotweb.
object(Exception)#13 (6) { ["message:protected"]=> string(91) "Error executing query: Incorrect key file for table '/tmp/#sql_e0b_0.MYI'; try to repair it" ["string:private"]=> string(0) "" ["code:protected"]=> int(0) ["file:protected"]=> string(63) "/share/HDA_DATA/.qpkg/SpotWeb/spotweb/lib/dbeng/dbeng_mysql.php" ["line:protected"]=> int(102) ["trace:private"]=> array(6) { [0]=> array(6) { ["file"]=> string(61) "/share/HDA_DATA/.qpkg/SpotWeb/spotweb/lib/dbeng/dbeng_abs.php" ["line"]=> int(83) ["function"]=> string(7) "rawExec" ["class"]=> string(11) "dbeng_mysql" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(995) "SELECT s.id AS id, s.messageid AS messageid, s.category AS category, s.poster AS poster, l.download as downloadstamp, l.watch as watchstamp, l.seen AS seenstamp, s.subcata AS subcata, s.subcatb AS subcatb, s.subcatc AS subcatc, s.subcatd AS subcatd, s.subcatz AS subcatz, s.title AS title, s.tag AS tag, s.stamp AS stamp, s.moderated AS moderated, s.filesize AS filesize, s.spotrating AS rating, s.commentcount AS commentcount, f.userid AS userid, f.verified AS verified FROM spots AS s LEFT JOIN spotstatelist AS l on ((s.messageid = l.messageid) AND (l.ouruserid = 2)) LEFT JOIN spotsfull AS f ON (s.messageid = f.messageid) ORDER BY s.reversestamp ASC LIMIT 26 OFFSET 0" } } [1]=> array(6) { ["file"]=> string(63) "/share/HDA_DATA/.qpkg/SpotWeb/spotweb/lib/dbeng/dbeng_mysql.php" ["line"]=> int(140) ["function"]=> string(4) "exec" ["class"]=> string(9) "dbeng_abs" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> string(995) "SELECT s.id AS id, s.messageid AS messageid, s.category AS category, s.poster AS poster, l.download as downloadstamp, l.watch as watchstamp, l.seen AS seenstamp, s.subcata AS subcata, s.subcatb AS subcatb, s.subcatc AS subcatc, s.subcatd AS subcatd, s.subcatz AS subcatz, s.title AS title, s.tag AS tag, s.stamp AS stamp, s.moderated AS moderated, s.filesize AS filesize, s.spotrating AS rating, s.commentcount AS commentcount, f.userid AS userid, f.verified AS verified FROM spots AS s LEFT JOIN spotstatelist AS l on ((s.messageid = l.messageid) AND (l.ouruserid = 2)) LEFT JOIN spotsfull AS f ON (s.messageid = f.messageid) ORDER BY s.reversestamp ASC LIMIT 26 OFFSET 0" [1]=> array(0) { } } } [2]=> array(6) { ["file"]=> string(52) "/share/HDA_DATA/.qpkg/SpotWeb/spotweb/lib/SpotDb.php" ["line"]=> int(755) ["function"]=> string(10) "arrayQuery" ["class"]=> string(11) "dbeng_mysql" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(995) "SELECT s.id AS id, s.messageid AS messageid, s.category AS category, s.poster AS poster, l.download as downloadstamp, l.watch as watchstamp, l.seen AS seenstamp, s.subcata AS subcata, s.subcatb AS subcatb, s.subcatc AS subcatc, s.subcatd AS subcatd, s.subcatz AS subcatz, s.title AS title, s.tag AS tag, s.stamp AS stamp, s.moderated AS moderated, s.filesize AS filesize, s.spotrating AS rating, s.commentcount AS commentcount, f.userid AS userid, f.verified AS verified FROM spots AS s LEFT JOIN spotstatelist AS l on ((s.messageid = l.messageid) AND (l.ouruserid = 2)) LEFT JOIN spotsfull AS f ON (s.messageid = f.messageid) ORDER BY s.reversestamp ASC LIMIT 26 OFFSET 0" } } [3]=> array(6) { ["file"]=> string(59) "/share/HDA_DATA/.qpkg/SpotWeb/spotweb/lib/SpotsOverview.php" ["line"]=> int(174) ["function"]=> string(

"getSpots" ["class"]=> string(6) "SpotDb" ["type"]=> string(2) "->" ["args"]=> array(6) { [0]=> string(1) "2" [1]=> int(0) [2]=> string(2) "25" [3]=> array(4) { ["filter"]=> string(0) "" ["search"]=> array(4) { ["tree"]=> string(0) "" ["unfiltered"]=> string(4) "true" ["value"]=> array(0) { } ["filterValues"]=> array(0) { } } ["additionalFields"]=> array(0) { } ["sortFields"]=> array(1) { [0]=> array(2) { ["field"]=> string(5) "stamp" ["direction"]=> string(4) "DESC" } } } [4]=> array(0) { } [5]=> bool(false) } } [4]=> array(6) { ["file"]=> string(65) "/share/HDA_DATA/.qpkg/SpotWeb/spotweb/lib/page/SpotPage_index.php" ["line"]=> int(64) ["function"]=> string(9) "loadSpots" ["class"]=> string(13) "SpotsOverview" ["type"]=> string(2) "->" ["args"]=> array(5) { [0]=> string(1) "2" [1]=> int(0) [2]=> string(2) "25" [3]=> array(4) { ["filter"]=> string(0) "" ["search"]=> array(4) { ["tree"]=> string(0) "" ["unfiltered"]=> string(4) "true" ["value"]=> array(0) { } ["filterValues"]=> array(0) { } } ["additionalFields"]=> array(0) { } ["sortFields"]=> array(1) { [0]=> array(2) { ["field"]=> string(5) "stamp" ["direction"]=> string(4) "DESC" } } } [4]=> array(2) { ["field"]=> string(0) "" ["direction"]=> string(0) "" } } } [5]=> array(6) { ["file"]=> string(47) "/share/HDA_DATA/.qpkg/SpotWeb/spotweb/index.php" ["line"]=> int(267) ["function"]=> string(6) "render" ["class"]=> string(14) "SpotPage_index" ["type"]=> string(2) "->" ["args"]=> array(0) { } } } } Error executing query: Incorrect key file for table '/tmp/#sql_e0b_0.MYI'; try to repair it
Ik probeer dan via mysql de tabellen te repareren, echter kan dit alleen op de tabellen van het type MyISAM, de anderen geeft hij de melding dat het niet werkt. Zijn er meer mensen met dit probleem? Of weet iemand wat ik hier aan kan doen?