problem plz help upgraded to 3.7.2

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mystic
    New Member
    • Sep 2007
    • 16

    problem plz help upgraded to 3.7.2

    i just upgraded from 3.6.8 to 3.7.2

    in my admincp i get this error

    what does it mean and how i fix it kindly help

    Database error in vBulletin 3.7.2:

    Invalid SQL:

    SELECT COUNT(*) AS count
    FROM moderation AS moderation
    INNER JOIN post AS post USING (postid)
    WHERE moderation.type='reply';

    MySQL Error : Unknown column 'postid' in 'from clause'
    Error Number : 1054
    Request Date : Tuesday, August 12th 2008 @ 09:23:20 PM
    Error Date : Tuesday, August 12th 2008 @ 09:23:20 PM
    Script : http://www.yah00-city.com/kinga/index.php?do=home
    Referrer : http://www.yah00-city.com/kinga/index.php
    IP Address :
    Username : !My$Ticc!
    Classname : vB_Database
    MySQL Version : 5.0.51a-community

    ----------------------
    when i got to options and click on all settings i get this error

    Database error in vBulletin 3.7.2:

    Invalid SQL:

    INSERT INTO regimage
    (regimagehash, imagestamp, dateline)
    VALUES
    ('9fe8cca1bd87573f0747c49bbb036101', 'WBBJ8t', 1218577480);

    MySQL Error : Table 'yahoocit_vbulletin.regimage' doesn't exist
    Error Number : 1146
    Request Date : Tuesday, August 12th 2008 @ 09:44:40 PM
    Error Date : Tuesday, August 12th 2008 @ 09:44:40 PM
    Script : http://www.yah00-city.com/kinga/opti...roup=%5Ball%5D
    Referrer : http://www.yah00-city.com/kinga/options.php?null=0
    IP Address :
    Username : !My$Ticc!
    Classname : vB_Database
    MySQL Version : 5.0.51a-community
    Last edited by mystic; Tue 12 Aug '08, 2:33pm.
  • mystic
    New Member
    • Sep 2007
    • 16

    #2
    Nevermind i fixed it thanks...i didnt upload correctly

    Comment

    • mystic
      New Member
      • Sep 2007
      • 16

      #3
      k i fixed the above one but i got another problem..after i corrected the issue i got this

      i dont know what i am doing wrong

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        Invalid SQL errors are almost always related to modified code. To troubleshoot this, the first thing you need to do is remove any third-party hacks or plugins, then see if you still have this problem.

        If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

        Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?
        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

        • mystic
          New Member
          • Sep 2007
          • 16

          #5
          thanks so much u are absouletly right thanks once again

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          😀
          😂
          🥰
          😘
          🤢
          😎
          😞
          😡
          👍
          👎