PDA

View Full Version : what is this erore -mysql error


milad-sasha
05-04-2011, 09:21 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

https://vborg.vbsupport.ru/external/2011/05/68.jpg

Lynne
05-05-2011, 12:54 AM
That is not a default field in vbulletin - it is from a modification. You will need to disable the modification, or uninstall it, in order to get rid of the error.

milad-sasha
05-05-2011, 05:36 AM
plz tell me i must do to resolve this problem..i am very amatur

tnx

--------------- Added 1304599512 at 1304599512 ---------------

plz tell me i must do to resolve this problem..i am very amatur

Lynne
05-05-2011, 05:39 PM
Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit includes/config.php and add this line right under <?php

define('DISABLE_HOOKS', true);