Elitefredy
05-20-2012, 06:21 AM
Hey
I'm using mary's classifieds since it came out all was fine until now. Today out of no-where i got this error:
Database error in vBulletin 4.1.10:
Invalid SQL:
SELECT SQL_CALC_FOUND_ROWS node.nodeid AS itemid ,(node.nodeleft = 1) AS isroot, node.nodeid, node.contenttypeid, node.contentid, node.url, node.parentnode, node.styleid, node.userid,
node.layoutid, node.publishdate, node.setpublish, node.issection, parent.permissionsfrom as parentpermissions,
node.showrating,
node.permissionsfrom, node.publicpreview, node.shownav, node.hidden, node.nosearch , info.description, info.title, info.viewcount, info.creationdate, info.workflowdate,
info.workflowstatus, info.workflowcheckedout, info.workflowlevelid, info.associatedthreadid,
user.username, sectionorder.displayorder
FROM cms_node AS node
INNER JOIN cms_nodeinfo AS info ON info.nodeid = node.nodeid
LEFT JOIN user AS user ON user.userid = node.userid
LEFT JOIN cms_sectionorder AS sectionorder ON sectionorder.sectionid = node.parentnode
AND sectionorder.nodeid = node.nodeid
LEFT JOIN cms_node AS parent ON parent.nodeid = node.parentnode
WHERE node.new != 1 AND node.nodeid IN (1,45,11,2,3) AND ( (node.permissionsfrom IN (1)) OR (node.userid =1) OR ( node.permissionsfrom in (1) AND (node.parentnode IN (1) OR node.nodeid = 1) AND
node.setpublish > 0 AND node.publishdate < 1337498336 ))AND node.new != 1
ORDER BY CASE WHEN sectionorder.displayorder > 0 THEN sectionorder.displayorder ELSE 9999999 END ASC,
node.publishdate DESC;
MySQL Error : Fehler 28 (Speicher-Engine)
Error Number : 1030
Request Date : Sunday, May 20th 2012 @ 09:18:56 AM
Error Date : Sunday, May 20th 2012 @ 09:18:56 AM
Script : http://snowpath.de/
Referrer :
IP Address : 84.72.25.227
Username : Fredy
Classname : vB_Database
MySQL Version : 5.0.51a-24+lenny5-log
--------------- Added 1337499087 at 1337499087 ---------------
hm fixed ;)
I'm using mary's classifieds since it came out all was fine until now. Today out of no-where i got this error:
Database error in vBulletin 4.1.10:
Invalid SQL:
SELECT SQL_CALC_FOUND_ROWS node.nodeid AS itemid ,(node.nodeleft = 1) AS isroot, node.nodeid, node.contenttypeid, node.contentid, node.url, node.parentnode, node.styleid, node.userid,
node.layoutid, node.publishdate, node.setpublish, node.issection, parent.permissionsfrom as parentpermissions,
node.showrating,
node.permissionsfrom, node.publicpreview, node.shownav, node.hidden, node.nosearch , info.description, info.title, info.viewcount, info.creationdate, info.workflowdate,
info.workflowstatus, info.workflowcheckedout, info.workflowlevelid, info.associatedthreadid,
user.username, sectionorder.displayorder
FROM cms_node AS node
INNER JOIN cms_nodeinfo AS info ON info.nodeid = node.nodeid
LEFT JOIN user AS user ON user.userid = node.userid
LEFT JOIN cms_sectionorder AS sectionorder ON sectionorder.sectionid = node.parentnode
AND sectionorder.nodeid = node.nodeid
LEFT JOIN cms_node AS parent ON parent.nodeid = node.parentnode
WHERE node.new != 1 AND node.nodeid IN (1,45,11,2,3) AND ( (node.permissionsfrom IN (1)) OR (node.userid =1) OR ( node.permissionsfrom in (1) AND (node.parentnode IN (1) OR node.nodeid = 1) AND
node.setpublish > 0 AND node.publishdate < 1337498336 ))AND node.new != 1
ORDER BY CASE WHEN sectionorder.displayorder > 0 THEN sectionorder.displayorder ELSE 9999999 END ASC,
node.publishdate DESC;
MySQL Error : Fehler 28 (Speicher-Engine)
Error Number : 1030
Request Date : Sunday, May 20th 2012 @ 09:18:56 AM
Error Date : Sunday, May 20th 2012 @ 09:18:56 AM
Script : http://snowpath.de/
Referrer :
IP Address : 84.72.25.227
Username : Fredy
Classname : vB_Database
MySQL Version : 5.0.51a-24+lenny5-log
--------------- Added 1337499087 at 1337499087 ---------------
hm fixed ;)