Announcement

Collapse
No announcement yet.

MySQL Error : Unknown column 'allowhtml' in 'field list'

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

  • MySQL Error : Unknown column 'allowhtml' in 'field list'

    Hello, I just tried to upgrade my site from 3.5.5 to 3.6.0, but started to get the following error.... Any Suggestions?

    I searched the forum before asking this question - hopfully I didn't miss the answer in another thread.

    --------------------------------------
    Database error in vBulletin 3.6.0:

    Invalid SQL:

    SELECT announcementid, startdate, title, announcement.views, forumid, enddate, pagetext, allowhtml, allowbbcode, allowsmilies,
    user.username, user.userid, user.usertitle, user.customtitle
    FROM vb_announcement AS announcement
    LEFT JOIN vb_user AS user ON(user.userid = announcement.userid)
    WHERE startdate <= 1155678431
    AND enddate >= 1155678431
    AND forumid IN (18,-1)
    ORDER BY startdate DESC
    LIMIT 3;

    MySQL Error : Unknown column 'allowhtml' in 'field list'
    Error Number : 1054
    --------------------------------------

    Thanks,
    James
    http://www.neosmut.com/vb/userbar/gr...in_Group_1.gif

  • #2
    That looks as if you were using vBulletin 3.5.4 files with vBulletin 3.6.0
    Reupload all the 3.5.5 files.
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment


    • #3
      After uploading all the 3.5.5 files again, will I need to also reupload all the 3.6.0 files and re-run the upgrade.php?

      Thanks,
      James
      http://www.neosmut.com/vb/userbar/gr...in_Group_1.gif

      Comment


      • #4
        Still getting the same error... not sure what else to do?
        http://www.neosmut.com/vb/userbar/gr...in_Group_1.gif

        Comment


        • #5
          You will need to upload the 3.6.0 files, but not run upgrade.php
          Best Regards
          Colin Frei

          Please don't contact me per PM.

          Comment


          • #6
            Okay - did that - still getting the same error...

            --------------------------------------
            Database error in vBulletin 3.6.0:

            Invalid SQL:

            SELECT announcementid, startdate, title, announcement.views, forumid, enddate, pagetext, allowhtml, allowbbcode, allowsmilies,
            user.username, user.userid, user.usertitle, user.customtitle
            FROM vb_announcement AS announcement
            LEFT JOIN vb_user AS user ON(user.userid = announcement.userid)
            WHERE startdate <= 1155689386
            AND enddate >= 1155689386
            AND forumid IN (18,-1)
            ORDER BY startdate DESC
            LIMIT 3;

            MySQL Error : Unknown column 'allowhtml' in 'field list'
            Error Number : 1054
            --------------------------------------
            http://www.neosmut.com/vb/userbar/gr...in_Group_1.gif

            Comment


            • #7
              There is no 'allowhtml' field in the 3.6.0 announcement or user tables. This has to be from a code change you've made either to the files or with a plugin.

              Reupload the original 3.6.0 files and dissable your plugins.
              Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
              Change CKEditor Colors to Match Style (for 4.1.4 and above)

              Steve Machol Photography


              Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


              Comment

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