Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SpotWeb v0.58.25.29 on PHP v5.5.16 crashed object(SqlErrorException)#34 (8) { ["message":protected]=> string(87) "HY000: Table './spotweb/spots' is marked as crashed and last (automatic?) repair failed" ["string":"CustomException":private]=> NULL ["code":protected]=> int(-1) ["file":protected]=> string(44) "/volume1/web/spotweb/lib/dbeng/dbeng_pdo.php" ["line":protected]=> int(94) ["trace":"Exception":private]=> array(6) { [0]=> array(6) { ["file"]=> string(44) "/volume1/web/spotweb/lib/dbeng/dbeng_pdo.php" ["line"]=> int(181) ["function"]=> string(4) "exec" ["class"]=> string(9) "dbeng_pdo" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> string(1506) "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, s.reportcount AS reportcount, s.spotterid AS spotterid, f.verified AS verified, COALESCE(bl.idtype, wl.idtype, gwl.idtype) AS idtype FROM spots AS s LEFT JOIN spotstatelist AS l on ((s.messageid = l.messageid) AND (l.ouruserid = 3)) LEFT JOIN spotsfull AS f ON (s.messageid = f.messageid) LEFT JOIN spotteridblacklist as bl ON ((bl.spotterid = s.spotterid) AND ((bl.ouruserid = 3) OR (bl.ouruserid = -1)) AND (bl.idtype = 1)) LEFT JOIN spotteridblacklist as wl on ((wl.spotterid = s.spotterid) AND ((wl.ouruserid = 3)) AND (wl.idtype = 2)) LEFT JOIN spotteridblacklist as gwl on ((gwl.spotterid = s.spotterid) AND ((gwl.ouruserid = -1)) AND (gwl.idtype = 2)) WHERE (bl.spotterid IS NULL) ORDER BY s.reversestamp ASC LIMIT 51 OFFSET 0" [1]=> array(0) { } } } [1]=> array(6) { ["file"]=> string(51) "/volume1/web/spotweb/lib/dao/Base/Dao_Base_Spot.php" ["line"]=> int(122) ["function"]=> string(10) "arrayQuery" ["class"]=> string(9) "dbeng_pdo" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(1506) "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, s.reportcount AS reportcount, s.spotterid AS spotterid, f.verified AS verified, COALESCE(bl.idtype, wl.idtype, gwl.idtype) AS idtype FROM spots AS s LEFT JOIN spotstatelist AS l on ((s.messageid = l.messageid) AND (l.ouruserid = 3)) LEFT JOIN spotsfull AS f ON (s.messageid = f.messageid) LEFT JOIN spotteridblacklist as bl ON ((bl.spotterid = s.spotterid) AND ((bl.ouruserid = 3) OR (bl.ouruserid = -1)) AND (bl.idtype = 1)) LEFT JOIN spotteridblacklist as wl on ((wl.spotterid = s.spotterid) AND ((wl.ouruserid = 3)) AND (wl.idtype = 2)) LEFT JOIN spotteridblacklist as gwl on ((gwl.spotterid = s.spotterid) AND ((gwl.ouruserid = -1)) AND (gwl.idtype = 2)) WHERE (bl.spotterid IS NULL) ORDER BY s.reversestamp ASC LIMIT 51 OFFSET 0" } } [2]=> array(6) { ["file"]=> string(35) "/volume1/web/spotweb/lib/SpotDb.php" ["line"]=> int(373) ["function"]=> string(8) "getSpots" ["class"]=> string(13) "Dao_Base_Spot" ["type"]=> string(2) "->" ["args"]=> array(4) { [0]=> string(1) "3" [1]=> int(0) [2]=> int(50) [3]=> array(9) { ["filter"]=> string(0) "" ["categoryList"]=> array(0) { } ["unfiltered"]=> bool(false) ["strongNotList"]=> array(0) { } ["filterValueList"]=> array(0) { } ["additionalFields"]=> array(0) { } ["additionalTables"]=> array(0) { } ["additionalJoins"]=> array(0) { } ["sortFields"]=> array(1) { [0]=> array(4) { ["field"]=> string(7) "s.stamp" ["direction"]=> string(4) "DESC" ["autoadded"]=> bool(true) ["friendlyname"]=> NULL } } } } } [3]=> array(6) { ["file"]=> string(42) "/volume1/web/spotweb/lib/SpotsOverview.php" ["line"]=> int(503) ["function"]=> string(8) "getSpots" ["class"]=> string(6) "SpotDb" ["type"]=> string(2) "->" ["args"]=> array(5) { [0]=> string(1) "3" [1]=> int(0) [2]=> int(50) [3]=> array(9) { ["filter"]=> string(0) "" ["categoryList"]=> array(0) { } ["unfiltered"]=> bool(false) ["strongNotList"]=> array(0) { } ["filterValueList"]=> array(0) { } ["additionalFields"]=> array(0) { } ["additionalTables"]=> array(0) { } ["additionalJoins"]=> array(0) { } ["sortFields"]=> array(1) { [0]=> array(4) { ["field"]=> string(7) "s.stamp" ["direction"]=> string(4) "DESC" ["autoadded"]=> bool(true) ["friendlyname"]=> NULL } } } [4]=> bool(false) } } [4]=> array(6) { ["file"]=> string(48) "/volume1/web/spotweb/lib/page/SpotPage_index.php" ["line"]=> int(73) ["function"]=> string(9) "loadSpots" ["class"]=> string(13) "SpotsOverview" ["type"]=> string(2) "->" ["args"]=> array(4) { [0]=> string(1) "3" [1]=> int(0) [2]=> int(50) [3]=> array(9) { ["filter"]=> string(0) "" ["categoryList"]=> array(0) { } ["unfiltered"]=> bool(false) ["strongNotList"]=> array(0) { } ["filterValueList"]=> array(0) { } ["additionalFields"]=> array(0) { } ["additionalTables"]=> array(0) { } ["additionalJoins"]=> array(0) { } ["sortFields"]=> array(1) { [0]=> array(4) { ["field"]=> string(7) "s.stamp" ["direction"]=> string(4) "DESC" ["autoadded"]=> bool(true) ["friendlyname"]=> NULL } } } } } [5]=> array(6) { ["file"]=> string(30) "/volume1/web/spotweb/index.php" ["line"]=> int(403) ["function"]=> string(6) "render" ["class"]=> string(14) "SpotPage_index" ["type"]=> string(2) "->" ["args"]=> array(0) { } } } ["previous":"Exception":private]=> NULL ["string":"Exception":private]=> string(0) "" } HY000: Table './spotweb/spots' is marked as crashed and last (automatic?) repair failed
Advertisement
Add Comment
Please, Sign In to add comment