please help me fast

C

cinneke

New Member
get this error anyone help me ?
get this error if i hit the memberlist link


Code: 
Database error in vBulletin 3.7.2:

Invalid SQL:

		SELECT user.*,usertextfield.*,userfield.*, user.userid, options,
			IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
		
		,avatar.avatarpath,NOT ISNULL(customavatar.userid) AS hascustomavatar,customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight
		
		 , lastactivity AS lastvisittime 
		, IF(YEAR(user.birthday_search) > 0 AND user.showbirthday IN (1,2) AND YEAR(user.birthday_search) < YEAR(CURDATE()), user.birthday_search, '0000-00-00') AS agesort
		
		, user.xperience, user.xperience_level 
		FROM user AS user
		LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
		LEFT JOIN userfield AS userfield ON(userfield.userid=user.userid)
		
		LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
		
		
		
		WHERE 1=1
			AND (user.usergroupid IN (-1,6,7,2,5,1))
			
		ORDER BY user.username asc 
		LIMIT 0, 30;

MySQL Error   : Unknown column 'user.xperience' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, July 9th 2008 @ 03:58:18 PM
Error Date    : Wednesday, July 9th 2008 @ 03:58:18 PM
Script        : http://www.xxx/forum/memberlist.php
Referrer      : http://www.xxx/forum/
IP Address    : xx.xx.x.xx
Username      : xxx
Classname     : vb_database
MySQL Version : 4.1.21-standard-log
 
if i reinstall the app then its good but i uninstall this kill_xperience.php then i get the error :

Unknown column 'user.xperience' in 'field list'



i realy want to remove this app thx
 
sounds like vbexperience hack. Just out of curiosity, after uninstalling the hack in AdminCP did you also remove the XML files that came with it ?

An error like this is usually triggered by left over XMLs
 
lordsyntax said:
sounds like vbexperience hack. Just out of curiosity, after uninstalling the hack in AdminCP did you also remove the XML files that came with it ?

An error like this is usually triggered by left over XMLs
Click to expand...

yes all removed ):
 
Can you tell me which XMLs you removed ? I just tried .15 on a heavily modded 3.7.2, install and uninstall went just fine without any problems.

Did you install the latest version over your existing one and then uninstalled again ? Might help :)

// Edit
You might also have to rebuild bitfields after removing those XML files, that could be another definite cause of the error
 
lordsyntax said:
Can you tell me which XMLs you removed ? I just tried .15 on a heavily modded 3.7.2, install and uninstall went just fine without any problems.

Did you install the latest version over your existing one and then uninstalled again ? Might help :)

// Edit
You might also have to rebuild bitfields after removing those XML files, that could be another definite cause of the error
Click to expand...


Did you install the latest version over your existing one and then uninstalled again ? Might help :) yes i did !!
 
did you check Plugin Manager if any hooks/plugins remained after uninstall ?

See if the error goes away when disabling all hooks by inserting this code in your config.php
PHP: 
define ( 'DISABLE_HOOKS', true);
 
lordsyntax said:
did you check Plugin Manager if any hooks/plugins remained after uninstall ?
Click to expand...


yes all removed think a have to keep this hack only now then to remove the name vBExperience 3.7.15
 
try that disable hook thing to see whether it´s caused by the hack or an actual problem with the DB (which is unlikely)
 
You must log in or register to reply here.
Back
Top