[DragonByte Tech]

Originally Posted by ToxXxicas

Hey! Thanks for the mod.

Since the upgrade to 1.2.0 we were getting this nasty error on members profile.

Database error in vBulletin 4.0.2:

Invalid SQL:

			SELECT 
				statuslog.dateline,
				statuslog.status,
				statuslog.moodid,
				mood.title,
				mood.imgfile,
				user.userid,
				user.username,
				user.usergroupid,
				user.infractiongroupid,
				user.displaygroupid,				
				changedby.userid AS changedbyuserid,
				changedby.username AS changedbyusername,
				changedby.usergroupid AS changedbyusergroupid,
				changedby.infractiongroupid AS changedbyinfractiongroupid,
				changedby.displaygroupid AS changedbydisplaygroupid			
			FROM vbulletin_dbtech_status_statuslog AS statuslog
			LEFT JOIN vbulletin_user AS user ON (user.userid = statuslog.userid)
			LEFT JOIN vbulletin_dbtech_status_moods AS mood USING (moodid)
			LEFT JOIN vbulletin_user AS changedby ON (changedby.userid = statuslog.changedby)
			WHERE user.userid = 2745
			ORDER BY dateline DESC, userid
			LIMIT 0, 20;

MySQL Error   : Unknown column '####_vbulletin.user.moodid' in 'on clause'
Error Number  : 1054
Request Date  : Thursday, June 17th 2010 @ 06:10:25 PM
Error Date    : Thursday, June 17th 2010 @ 06:10:25 PM
Script        : http://www.####.com/foro/member.php/####
Referrer      : http://www.####.com/foro/search.php?####
IP Address    : ####
Username      : ####
Classname     : vB_Database
MySQL Version : 4.1.22-standard

Mod disable for a while.

Hrm strange. I'll look into and hopefully have it fixed for the update tomorrow