Bug MySQL Error

[webi]

Hi Filip,

Since updating to the latest version, I keep getting the following error message.

Database error in vBulletin 4.2.2:

Invalid SQL:

					SELECT
						entry.*,
						user.username,
						user.usergroupid,
						user.membergroupids,
						user.infractiongroupid,
						user.displaygroupid,
						receiveduser.username AS receivedusername,
						receiveduser.usergroupid AS receivedusergroupid,
						receiveduser.membergroupids AS receivedmembergroupids,
						receiveduser.infractiongroupid AS receivedinfractiongroupid,
						receiveduser.displaygroupid AS receiveddisplaygroupid
						
					FROM (
						(
		SELECT
			download.downloadid AS postid,
			download.title AS posttitle,
			download.title AS threadtitle,
			download.userid,
			download.downloadid AS threadid,
			0 AS forumid,
			entry_vbdownloads_download.*
		FROM vbdbtech_thanks_entry AS entry_vbdownloads_download
		LEFT JOIN vbdbtech_downloads_download AS download ON (download.downloadid = entry_vbdownloads_download.contentid)
		WHERE entry_vbdownloads_download.entryid IN(22250)
	)
					) AS entry
					LEFT JOIN vbuser AS user ON(user.userid = entry.userid)
					LEFT JOIN vbuser AS receiveduser ON(receiveduser.userid = entry.receiveduserid)
					ORDER BY entryid DESC
					LIMIT 20;

MySQL Error   : Duplicate column name 'userid'
Error Number  : 1060
Request Date  : Wednesday, July 30th 2014 @ 12:30:48 PM
Error Date    : Wednesday, July 30th 2014 @ 12:30:48 PM
Script        : http://www.domain.com/members/25070-hkp-85.html
Referrer      : http://www.domain.com/
IP Address    : 127.0.0.1
Username      : hkp-85
Classname     : vB_Database_MySQLi
MySQL Version :

Best Regards

 

[Fillip H.]

I'm unable to replicate this issue. What version of MySQL are you running?

 

[webi]

On this server running version 5.5.38

Another system where the Lite version is installed and appear the "same" error messages, the version 5.1.73

 

[Fillip H.]

Does this only happen on a member's profile?

 

[webi]

Yes only on member profile

 

[Fillip H.]

I've made a potential hotfix to /dbtech/thanks/includes/sql/profileblock.php, could you please re-download the latest version and re-upload that file, and tell me if that fixes it for you?

 

[webi]

Thank you, the problem was solved by the hotfix.