CMS Database error in vBulletin 4.0.4 /vb/content

محروم.كوم · #1 06-25-2010, 07:20 PM

<div> PHP Code:
Database error in vBulletin 4.0.4:

Invalid SQL:
SELECT node.nodeid , (node.nodeleft = 1) AS isroot, node.contenttypeid, node.contentid, node.url, node.parentnode,

(CASE WHEN node.contenttypeid = THEN node.styleid ELSE parent.styleid end ) AS styleid, node.userid,
(CASE WHEN node.contenttypeid = THEN node.layoutid ELSE parent.layoutid end ) AS layoutid,
node.publishdate, node.setpublish, node.issection, node.permissionsfrom, node.nodeleft, node.noderight,
node.userid, node.showtitle, node.showuser, node.showpreviewonly, node.lastupdated, node.showall, node.showrating,
node.showupdated, node.showviewcount, node.showpublishdate, node.settingsforboth, node.includechildren, node.editshowchildren,
parent.permissionsfrom as parentpermissions, node.publicpreview, node.comments_enabled, node.shownav,
node.hidden, node.nosearch , info.description, info.title, info.html_title, info.viewcount, info.creationdate, info.workflowdate, info.keywords,
info.workflowstatus, info.workflowcheckedout, info.workflowlevelid, info.associatedthreadid, info.creationdate, node.showrating,
info.ratingnum, info.ratingtotal, info.rating,
user.username, thread.replycount, 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 thread AS thread ON thread.threadid = info.associatedthreadid
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.nodeid = 1;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'THEN node.styleid ELSE parent.styleid end ) AS styleid, node.userid,
(CASE ' at line 2
Error Number : 1064
Request Date : Friday, June 25th 2010 @ 06:10:59 PM
Error Date : Friday, June 25th 2010 @ 06:10:59 PM
Script : http://www.al3ial.com/vb/content/
Referrer : http://www.al3ial.com/
IP Address : 111.11.11.1
Username : admin
Classname : vB_Database
MySQL Version : 5.0.90-community-log

<div class="bbcode_container"> PHP Code:
<span style="color: #000000">Database error in vBulletin 4.0.4:

Invalid SQL:
SELECT node.nodeid, node.url, node.parentnode, node.nodeleft, node.noderight,
node.setpublish, node.publishdate, info.title, node.permissionsfrom, node.hidden, COUNT(child.nodeid) AS children,
SUM(CASE WHEN (child.setpublish > 0 AND child.publishdate <span style="color: #007700"> __DEFINE_LIKE_SHARE__