Forum Error after upgrading to MySql 5.1

محروم.كوم · #1 03-14-2010, 08:40 PM

Here is what I am getting after upgrading to MySql 5.1 I have tried rebuilding attachments and repairing tables and still have the issue, essentially any thread with an attachment isn't working. I have also disabled all hooks in config.php and that didn't help.

Database error in vBulletin 4.0.2:
Quote:
Invalid SQL:

SELECT
fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize,
a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings,
at.contenttypes
FROM attachment AS a
INNER JOIN filedata AS fd ON (fd.filedataid = a.filedataid)
LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
WHERE
a.contentid IN (338400,338403,338406,338407,338408,338410,338412, 338417,338419,338423)
AND
a.contenttypeid =

ORDER BY a.contentid, a.attachmentid;

Additionally the CMS is also broken with this error:
Quote:
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;

Any assistance would be great. __DEFINE_LIKE_SHARE__