There is a big problem with my DB , help please
 

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

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

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

[SQL]
REPAIR TABLE thread;
[/SQL]

Also, what vB are you using?

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

i'm using vb 2.2.8

please help

regards

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