Edit: opgelost door mariadb en spotweb opnieuw te installeren
Het is weer 1 dag goed gegaan en nu kan ik Spotweb niet openen.
Heeft iemand een idee wat onderstaande foutmelding inhoudt? (Ik heb install.php opnieuw succesvol gedraaid maar krijg daarna dezelfde foutmelding). Ik heb dit (/usr/syno/mysql/bin/mysqlcheck -u root -p --auto-repair --check --optimize spotweb) geprobeerd, maar dit wordt niet herkend..no such directory...
Hieronder staat disk is full, maar dat is zeker niet zo.
SpotWeb v0.67.28.31 on PHP v5.6.17 crashed object(SqlErrorException)#26 (
{ ["message":protected]=> string(50) "HY000: 14: Can't change size of file (Errcode: 28)" ["string":"CustomException":private]=> NULL ["code":protected]=> int(-1) ["file":protected]=> string(44) "/volume1/web/spotweb/lib/dbeng/dbeng_pdo.php" ["line":protected]=> int(59) ["trace":"Exception":private]=> array(5) {
- => array(6) { ["file"]=> string(44) "/volume1/web/spotweb/lib/dbeng/dbeng_pdo.php" ["line"]=> int(146) ["function"]=> string(4) "exec" ["class"]=> string(9) "dbeng_pdo" ["type"]=> string(2) "->" ["args"]=> array(2) {
- => string(1577) "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, s.editstamp AS editstamp, s.editor AS editor, 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 101 OFFSET 0" [1]=> array(0) { } } } [1]=> array(6) { ["file"]=> string(51) "/volume1/web/spotweb/lib/dao/Base/Dao_Base_Spot.php" ["line"]=> int(123) ["function"]=> string(10) "arrayQuery" ["class"]=> string(9) "dbeng_pdo" ["type"]=> string(2) "->" ["args"]=> array(1) {
- => string(1577) "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, s.editstamp AS editstamp, s.editor AS editor, 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 101 OFFSET 0" } } [2]=> array(6) { ["file"]=> string(75) "/volume1/web/spotweb/lib/services/Providers/Services_Providers_SpotList.php" ["line"]=> int(23) ["function"]=> string( "getSpots" ["class"]=> string(13) "Dao_Base_Spot" ["type"]=> string(2) "->" ["args"]=> array(4) {
- => string(1) "3" [1]=> int(0) [2]=> int(100) [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) {
- => array(4) { ["field"]=> string(7) "s.stamp" ["direction"]=> string(4) "DESC" ["autoadded"]=> bool(true) ["friendlyname"]=> NULL } } } } } [3]=> array(6) { ["file"]=> string(48) "/volume1/web/spotweb/lib/page/SpotPage_index.php" ["line"]=> int(101) ["function"]=> string(13) "fetchSpotList" ["class"]=> string(27) "Services_Providers_SpotList" ["type"]=> string(2) "->" ["args"]=> array(4) {
- => string(1) "3" [1]=> int(0) [2]=> int(100) [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) {
- => array(4) { ["field"]=> string(7) "s.stamp" ["direction"]=> string(4) "DESC" ["autoadded"]=> bool(true) ["friendlyname"]=> NULL } } } } } [4]=> array(6) { ["file"]=> string(30) "/volume1/web/spotweb/index.php" ["line"]=> int(382) ["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: 14: Can't change size of file (Errcode: 28)
