Announcement

Collapse
No announcement yet.

Unknown column 'htmlstate' in 'field list'

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Unknown column 'htmlstate' in 'field list'

    Hey guys,

    I've just got the error in our forum.

    Database error in vBulletin 4.0.2:

    Invalid SQL:
    INSERT INTO post
    (showsignature, allowsmilie, htmlstate, username, userid, title, pagetext, iconid, visible, dateline, ipaddress, attach, threadid)
    VALUES
    (1, 1, '', 'admin', 1, 'test', 'Hello guys,', 0, 1, 1271008555, 'MyIP', 0, 90991);

    MySQL Error : Unknown column 'htmlstate' in 'field list'
    Error Number : 1054
    Request Date : Sunday, April 11th 2010 @ 01:55:55 PM
    Error Date : Sunday, April 11th 2010 @ 01:55:55 PM
    Script : http://www.albrens.com/vb/newthread....ostthread&f=89
    Referrer : http://www.albrens.com/vb/newthread....newthread&f=89
    IP Address : MyIp
    Username : admin
    Classname : vB_Database
    MySQL Version : 5.0.90-community
    Is there any idea to fix it?

    Thanks!
    http://www.albrens.com

  • #2
    Did you attempt an upgrade to 4.03?
    I drank WHAT?! - Socrates

    Comment


    • #3
      I think so.
      www.hostsaller.com Hosting Service
      www.forum4phone.com Gsm Community
      http://kholamon.com Bangla Blog

      Comment


      • #4
        Biker,

        Yes I did, then I did restore backup database and files.

        Thanks!
        http://www.albrens.com

        Comment


        • #5
          I have same problem when I try to upgrade my site, any one please help

          Comment


          • #6
            That field is added when you upgrade to 4.0.3. The error in the first post is because the user is using 4.0.3 files with a 4.0.2 database. The upgrade script needs to be run.

            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 vbulletin.org
            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

            Comment


            • #7
              Originally posted by Lynne View Post
              That field is added when you upgrade to 4.0.3. The error in the first post is because the user is using 4.0.3 files with a 4.0.2 database. The upgrade script needs to be run.
              On this post he said that he did run the upgrade script Lynne.
              .......

              Comment

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