PDA

View Full Version : what is this erore -mysql error


milad-sasha
05-04-2011, 09:49 PM
i when loging my user name then can not see my index page of my forum and this eror of database will be appers...i just can not see my index page of my forum and i can see diffrnt link of my forum...this problem just my user when i loging...plz help me...

Database error in vBulletin 4.1.3:

Invalid SQL:

SELECT userid, usergroupid, displaygroupid, username, credits
FROM user AS user
WHERE credits > 0
ORDER BY credits DESC
LIMIT 0, 15;

MySQL Error : Unknown column 'credits' in 'field list'
Error Number : 1054
Request Date : Wednesday, May 4th 2011 @ 06:15:11 PM
Error Date : Wednesday, May 4th 2011 @ 06:15:11 PM
Script : http://www.rossoneri.ir/index.php
Referrer :
IP Address : 89.144.150.157
Username : Milad Sasha
Classname : vB_Database
MySQL Version : 5.0.92-community

http://up.iranblog.com/images/0npndoe9v82lhobz7u.jpg

merk_aus
05-04-2011, 11:18 PM
it says that you have a credits system that either isn't installed properly or has been removed and the column hasn't been removed.

milad-sasha
05-05-2011, 05:23 AM
what is the credits system?!! and i must what do to resolve this problem..plz help me

i im amature

tnx

--------------- Added 1304587319 at 1304587319 ---------------

plz somebody help me..i need help men

kh99
05-05-2011, 01:00 PM
You might go to the admin comtrol panel and click on "Plugins & Products" and then "Manage Products" and see if there is a product with "credit" in the name name, and if you find one, unintall it.

If that doesn't work, maybe the product or plugin didn't have "credit" in the name, in which case you could disable each product one at a time until the problem goes away, then uninstall that product.

milad-sasha
05-05-2011, 01:23 PM
tnx man..my problem is resolve..my problem is this mod : [AJAX]Advanced Forum Statistics