 
			
				02-01-2012, 06:47 PM
			
			
			
		  
	 | 
	
		
		
		
			
			| 
				
				
				
				
			 | 
			  | 
			
				
					Join Date: Sep 2010 
					
					
					
						Posts: 11
					 
					 
			Благодарил(а): 0 раз(а) 
			Поблагодарили:
				
					
						0 раз(а) в 0 сообщениях
					
				
			 
		
					
					
					
					     
				 
			 | 
		 
		 
		
	 | 
	
	
		
	
		
		
			
			
				 
				help | showgroups.php - error
			 
			 
			
		
		
		
			
			its error from showgroups.php 
	Quote: 
	
	
		
			
				Database error in vBulletin 4.1.10: 
 
Invalid SQL: 
 
		SELECT user.*, 
			usergroup.title, 
			user.options, usertextfield.buddylist, 
			userfield.field2, 
			IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid 
			,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, 
			customavatar.width AS avwidth,customavatar.height AS avheight, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb,  
			filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom 
		 
		FROM user AS user 
		LEFT JOIN usergroup AS usergroup ON(usergroup.usergroupid = user.usergroupid OR FIND_IN_SET(usergroup.usergroupid, user.membergroupids)) 
		LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid) 
		LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=user.userid) 
		LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid)  
			LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) 
		 
		WHERE (usergroup.genericoptions & 1); 
 
MySQL Error   : Unknown column 'userfield.field2' in 'field list' 
Error Number  : 1054 
Request Date  : Wednesday, February 1st 2012 @ 10:42:35 PM 
Error Date    : Wednesday, February 1st 2012 @ 10:42:35 PM 
Script        : http://www.********.co.il/showgroups.php 
Referrer      : http://www.*******.co.il/index.php 
IP Address    : ***** 
Username      : *** 
Classname     : vB_Database 
MySQL Version : 5.0.67-community 
			
		 | 
	 
	 
 its problem from mysql... 
help me pliz!!!
		  
		
		
		
		
		
		
		
		
	
	 |