Getting Database Error after Ugrading to 3.7.0 B6

[roja1]

Hello.

I am getting database error , please guys help me to fix this erro.

I am getting this error after upgrading at vb 3.7.0 Beta 6.

Invalid SQL:
SELECT
picturecount
FROM album
WHERE userid=1;

MySQL Error : Unknown column 'picturecount' in 'field list'
Error Number : 1054
Date : Tuesday, March 11th 2008 @ 04:13:38 PM
Script : http://www.mysite.com/Forums/cron.php?rand=906391
Referrer : http://www.mysite.com/Forums/forumdisplay.php?f=30
IP Address : xyz
Username : Unregistered
Classname : vb_database
MySQL Version :

Thanks

[Steve Machol]

There is no 'picturecount' field in Beta 6.

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. Make sure you change to the new style and view your forums with it. Do you have the same problem?

[roja1]

thanks for the reply.

i got 3000 db error emails in 2 days and always it says ,

IP Address : xyz
Username : Unregistered
Classname : vb_database

there is no database error with any registered user name and ReferrerURl,s always diffirent.
will let u know once i finish as u told.
Thanks

[roja1]

Hello.

Looks like this problem is solved after doing as u told.

Now getting another database error and if i am not worng than its becoz of shoutbox, just wanna be sure that its because of shoutbox so i can delete shoutbox.

here is the error.

nvalid SQL:
select count(*) as `ts` from shout;

MySQL Error : Table 'DB_Name.shout' doesn't exist
Error Number : 1146
Date : Wednesday, March 12th 2008 @ 11:12:05 AM
Script : http://www.forum.com/Forums/vbshout.php?do=archive&page=63
Referrer :
IP Address :... IP
Username : ID
Classname : vb_database
MySQL Version : 4.1.22-standard

NOTE:- The shoutbox was disabled when i got this error.

Thanks

[Zachery]

It wont matter if its disabled when theyt're going to the file, to stop these errors uninstall the modification and undo any changes it had you do.

[roja1]

HI.

OK i uninstalled MGC Chatbox Evo .
Will let u know if any thing wrong .

Thanks