Database error on profile page

[Paradigm]

I just upgraded to RC4 from Beta5. After doing this I get an error on everyones profile page. Any help would be GREATLY appreciated. THANKS!

Database error in vBulletin 3.7.0 Release Candidate 4:

Invalid SQL:

                SELECT COUNT(*) AS albumcount, SUM(album.picturecount) AS picturecount
                FROM vbalbum AS album
                WHERE album.userid = 307
                    AND album.state IN ('public', 'private', 'public');

MySQL Error   : Unknown column 'album.picturecount' in 'field list'
Error Number  : 1054
Date          : Tuesday, April 29th 2008 @ 09:23:36 AM
Script        : http://www.bigonline.org/member.php?u=307
Referrer      : http://www.bigonline.org/private.php?do=newpm&u=9
IP Address    : 162.39.31.66
Username      : Paradigm
Classname     : vB_Database
MySQL Version : 5.0.45-community

This is the error that is displayed on a profile page without photo albums

Database error in vBulletin 3.7.0 Release Candidate 4:

Invalid SQL:

            SELECT album.*,
                picture.pictureid, picture.extension, picture.idhash,
                picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height
                
            FROM vbalbum AS album
            LEFT JOIN vbpicture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)
            
            WHERE album.userid = 13
                AND album.state IN ('public', 'private', 'profile')
                AND album.picturecount > 0
                
            ORDER BY album.lastpicturedate DESC
            LIMIT 2;

MySQL Error   : Unknown column 'album.picturecount' in 'where clause'
Error Number  : 1054
Date          : Tuesday, April 29th 2008 @ 09:29:41 AM
Script        : http://www.bigonline.org/member.php?u=13
Referrer      : http://www.bigonline.org/index.php
IP Address    : 162.39.31.66
Username      : Paradigm
Classname     : vB_Database
MySQL Version : 5.0.45-community

[Paradigm]

I ran a suspect versions and it's saying this for all the files:

File version mismatch: found 3.7.0 Release Candidate 4, expected 3.7.0 Beta 5

[Wayne Luke]

Please run install/upgrade.php. As 3.7.0 final is released you should download those files and upload them and run the upgrade script.

[Paradigm]

I did run upgrade.php per the install instructions. I will be installing 3.7 gold later today.

[Paradigm]

I uploaded all of the 3.7 Gold files to their appropriate locations. When I run install.php after in tries to upgrade it tells me this:


Your vBulletin (3.7.0) does not appear to be running the version that was downloaded (3.7.0 Beta 5).
This generally means your upgrade was not successful. Please ensure that you have uploaded the latest files and click here to try again.
If you are sure you wish to continue with this part of the upgrade, click here

I proceeded anyways and afterwards I checked the file versions and its still giving me this:


File version mismatch: found 3.7.0, expected 3.7.0 Beta 5

[Wayne Luke]

You have missed upgrade steps somewhere along the way. Either you are not uploading all the files as everything in the upload folder needs to be uploaded between every version, you restored a backup after a previous upgrade, or you received an error message on a previous upgrade and continued to the next step without resolving it.

The last step in each upgrade version is to upgrade the template version and yours is currently stuck at 3.7.0 beta 5 for some reason. The only way to resolve your incomplete upgrades is to open a support ticket for official support.

[Paradigm]

I have done that. Thanks for your help Wayne.

[Paradigm]

I have figured out what the problem was. Well, actually I didn't but I fixed the problem I was having. I tried using a different FTP software to up the files. I ran the upgrade script and it installed normally. I checked the file versions and everything looks fine and all of our profile pages are working fine.