No announcement yet.

Upgrade from 4.02 to 4.03 Problem - 1 step

  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Upgrade from 4.02 to 4.03 Problem - 1 step

    I already shutdown my site, I upload new files to my server. Then I run . Then I got this error message. I try many times but it does not work.

    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

    I am using vbulletin software for more than 10 years. This is first time I got error message when I try to upgrade. Something wrong with your software, please check.
    Please tell me how to upgrade to new version

  • #2
    Put in a support ticket with the necessary information to your database/site and let us take a look at this.

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help


    • #3
      is there any more info on this issue, it is identical to what i am experiencing when i uploaded files and tried to upgrade


      • #4
        In phpMyAdmin, run the following query and this will add the column in there:

        ALTER TABLE *PREFIX*cms_article ADD htmlstate enum('off', 'on', 'on_nl2br') NOT NULL DEFAULT 'on_nl2br'

        If you're database uses a prefix, replace *PREFIX* with this otherwise remove that before running this.
        Vote for:

        - *Admin Settable Paid Subscription Reminder Timeframe*
        *PM - Add ability to reply to originator only*
        - Add Admin ability to auto-subscribe users to specific channel(s)
        - "Quick Route" Interface...


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