No announcement yet.

SQL erro after upgrading

  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL erro after upgrading

    veru simple

    Database error in vBulletin 3.6.0 Beta 1:
    Invalid SQL:
    UPDATE session SET newposts = newposts+1 WHERE NOT ISNULL(newposts);
    MySQL Error : Unknown column 'newposts' in 'where clause'
    Error Number : 1054
    Date : Saturday, June 10th 2006 @ 10:11:21 AM
    Script :
    Referrer :
    IP Address :
    Username : nbento
    Classname : vb_database
    I can PM, I can preview threads but I cant post.
    That error happens when trying to create new threads or replying to posts.
    I have photopost on top of the foruns, and GARS... NOT a single hack installed.

  • #2
    I just found that even trowing that error while submitting a new thread, the sam thread was posted (submitted) now thats weird.
    Im going to test a few more times


    • #3
      Some help here would be much appreciated


      • #4
        There is no 'newposts' column in the default 3.6 session table. This is from a hack or plugin you've installed.
        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.


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