Error after upgrading to MySql 5.1

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ericgtr
    Senior Member
    • Oct 2003
    • 115

    [Forum] Error after upgrading to MySql 5.1

    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:
    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:
    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.
  • ericgtr
    Senior Member
    • Oct 2003
    • 115

    #2
    Okay, figured it out. For anyone else who may find this thread there are two things that I had to do after upgrading to MySql 5.1 on vBulletin 4.0.2. Both of these must be done, one will not work without the other.

    1) Repair/Optimize tables (through your adminCP is fine)
    2) Upgrade vBulletin again - I went to my http://mysite.com/install/upgrade.php and ran it, even though I was already upgraded it was necessary to do it again.

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...