There is a big problem with my DB , help please

[ForYou]

Hello ,

There is DB error when i need to view theard or profile for any member on my forums . the error looke like this ,

------------------

Database error in vBulletin 2.2.8:

Invalid SQL: SELECT SUM(views) AS personalviews FROM thread WHERE postuserid= AND open!='10'
mysql error: You have an error in your SQL syntax near 'AND open!='10'' at line 1

mysql error number: 1064


--------------------

please help me about this error how can i solve it

regards

[assassingod]

You've installed a hack incorrectly. Upload an unhacked member.php and re-install it.

Also, have you thought about upgrading? 2.2.8 has quite a few bugs

[ForYou]

Originally Posted by assassingod

You've installed a hack incorrectly. Upload an unhacked member.php and re-install it.

Also, have you thought about upgrading? 2.2.8 has quite a few bugs

Sir ,

This problem come when i move the DB to a new server but the DB was working on the old server with out any problem ..
I mean the forums was working without any problems before moving the DB to another server ,

please help
Regards

[assassingod]

You may have corrupted the DB. Try running this query:

[SQL]
REPAIR TABLE thread;
[/SQL]

Also, what vB are you using?

[ForYou]

I was do that queries but the problem still with theard ..

i'm using vb 2.2.8

please help

regards

[Velocd]

PHP Code:

postuserid= 


That shouldn't be blank. Try uninstalling that hack, and see if your profile view works.