how to completely solve database error?

[=:Jack:=]

my favorite site has a database error !

and this is what it says !

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT blockid, requirement
FROM profileblockprivacy
WHERE userid = 859143;

MySQL Error : Table 'dotsis_dotsis.profileblockprivacy' doesn't exist
Error Number : 1146
Request Date : Friday, June 19th 2009 @ 06:26:50 AM
Error Date : Friday, June 19th 2009 @ 06:26:51 AM
Script : http://www.dotsis.com/mobile_phone/member.php?u=859143
Referrer : Mobile Games, Ringtones, Wallpapers, Themes & PC Suite Programs | Symbian Java Mobiles Applications | Cell Phone Softwares
IP Address : 86.96.229.89
Username : =:Jack:=
Classname : vb_database
MySQL Version : 4.1.22-standard

 

[saram1805]

Like it says, the table doesn't exist.

Are you using a 3.8 mod with your 3.7 vbulletin?

 

[bluescorpion]

The error message says they are running 3.7.2. That table did not exist in that release. It looks like they copied files to do an upgrade and didn't run the upgrade script or they did run the script and it failed. Rerun the upgrade script and make sure it completes. Unfortunately, you have an unknown state so I am just guessing at a fix ... meaning that the files that are running appear to be a different version than the installed database.

 

[=:Jack:=]

so what can be the solution?
what should be done?
i need technical suggestions !
thx for all who replied !

 

[saram1805]

Like said above, you're running 3.7.2 but you have a page requesting something that doesn't exist until 3.8.

You've either installed a 3.8.x mod on your incompatible forum, you've attempted an upgrade that didn't complete fully, or you've contaminated your files in some other way with mismatched versions.

 

[=:Jack:=]

guys is there a solution
coz me and the admin are trying to saught it