No announcement yet.

Upgrade from 4.02 to 4.03 Problem, please help

  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Upgrade from 4.02 to 4.03 Problem, please help

    Database error in vBulletin 4.0.2:
    Invalid SQL:
    SELECT node.nodeid, node.showrating, node.setpublish,
    node.contenttypeid, node.contentid, node.url, node.parentnode, node.styleid, node.userid, node.nodeleft, node.noderight,
    node.layoutid, node.publishdate, node.publicpreview, node.issection, node.permissionsfrom, node.showtitle, node.showuser, node.showpreviewonly,
    node.showupdated, node.showviewcount, node.showpublishdate, node.settingsforboth, node.includechildren, node.showall, node.editshowchildren,
    node.shownav, node.hidden, node.nosearch, node.comments_enabled,
    info.description, info.html_title, info.title, info.viewcount, info.creationdate, info.workflowdate, info.associatedthreadid,
    info.workflowstatus, info.workflowcheckedout, info.viewcount, info.workflowlevelid, info.keywords, info.ratingnum, info.ratingtotal, info.rating,
    user.username, article.pagetext, article.threadid, article.blogid,
    article.posttitle, article.postauthor, thread.replycount, article.poststarter,
    article.previewtext, article.previewimage, article.imagewidth, article.imageheight, article.previewvideo,
    article.postid, article.blogpostid, article.post_started, article.post_posted, article.htmlstate

    FROM vb_cms_node AS node
    INNER JOIN vb_cms_article AS article ON article.contentid = node.contentid
    INNER JOIN vb_cms_nodeinfo AS info ON info.nodeid = node.nodeid
    LEFT JOIN vb_user AS user ON user.userid = node.userid
    LEFT JOIN vb_thread AS thread ON thread.threadid = info.associatedthreadid

    WHERE node.nodeid = 3602;
    MySQL Error : Unknown column 'article.htmlstate' in 'field list'
    Error Number : 1054
    Request Date : Monday, April 12th 2010 @ 06:42:42 AM
    Error Date : Monday, April 12th 2010 @ 06:42:42 AM
    Script :
    Referrer :
    IP Address : xxxxx
    Username : xxxxx
    Classname : vB_Database
    MySQL Version : 5.0.89-community

  • #2
    After I transfer these new files to my server. I got this message. I could not access to . I did turn off my site before I upload new files. Please help


    • #3
      please help, I don't have a back up, I am still waiting for your help. I could not run upgrade.php because this error message.


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