Announcement

Collapse
No announcement yet.

Database error in vBulletin 3.7.0 Release Candidate 1

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

  • Database error in vBulletin 3.7.0 Release Candidate 1

    i was try to update my vb to the last Version i found this message error
    -----------------------------------------------------
    Database error in vBulletin 3.7.0 Release Candidate 1:
    Invalid SQL:
    SELECT COUNT(*) AS albumcount, SUM(album.picturecount) AS picturecount
    FROM album AS album
    WHERE album.userid = 1
    AND album.state IN ('public', 'private', 'public');
    MySQL Error : Unknown column 'album.picturecount' in 'field list'
    Error Number : 1054
    ----------------------------------------------


    thanks

  • #2
    You are still running old code. To troubleshoot this, first 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. Also be sure to upload the admincp files to whichever directory you have set in your config.php file. Then run 'Suspect File Versions' in Diagnostics to make sure you have all the original files for your version and that none show 'File does not contain expected contents':

    Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

    [Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

    Next, disable all plugins.

    Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

    define('DISABLE_HOOKS', true);

    Then if you still have this problem, 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. That will fix his.
    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


    • #3
      sir all things ok but still same message are there

      Comment


      • #4
        Error Number : 1054

        i got the same error number. but i got it when i go to my userCP or PM...

        Comment


        • #5
          up please

          Comment


          • #6
            Nothing has changed. You cannot get this error if you follow the instructions in post #2.
            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


            • #7
              We did not found the solutions until now

              Comment


              • #8
                WHat ended up being the solution? I dont have many plugins installed but I really hate to remove all of them trying to track this down.

                Ive verified all my file versions are correct.

                Thanks

                Comment


                • #9
                  Nevermind.. I believe I found the problem.... an old hack was calling that field which is amazing considering I only have like 3 hacks installed.

                  Comment

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