Status
Not open for further replies.

hornstar

Customer
I just went into user manager and put in a 1 in event tokens are greater than or equal to: and searched and it came back with a database error:

Code:
Database error in vBulletin 3.8.5:

Invalid SQL:

		SELECT
		user.*, (options & 8) AS coppauser, userfield.*
		, (vbcreditst_2.tokens) AS vbcredits_2, (user.credits) AS vbcredits_1
		FROM vb3_user AS user
		LEFT JOIN vb3_userfield AS userfield ON(userfield.userid = user.userid)
		LEFT JOIN vb3_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
		 LEFT JOIN inferno_user AS vbcreditst_2 ON (user.userid = vbcreditst_2.user_id) 
		WHERE 1=1 AND vbcreditst_2.tokens >= 1
		ORDER BY username ASC
		LIMIT 0, 50;

MySQL Error   : Column 'options' in field list is ambiguous
Error Number  : 1052

And I got another database error when going to forums/credits.php
Code:
Database error in vBulletin 3.8.5:

Invalid SQL:
SELECT userfield.*, usertextfield.*, user.*, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, (vbcreditst_2.tokens) AS vbcredits_2, (user.credits) AS vbcredits_1 FROM vb3_user AS user LEFT JOIN vb3_userfield AS userfield ON (user.userid = userfield.userid)
				LEFT JOIN vb3_usertextfield AS usertextfield ON (usertextfield.userid = user.userid)  LEFT JOIN inferno_user AS vbcreditst_2 ON (user.userid = vbcreditst_2.user_id) 
				ORDER BY vbcredits_2 DESC LIMIT 10;

MySQL Error   : Incorrect key file for table '/tmp/#sql_72e4_0.MYI'; try to repair it
Error Number  : 126
Repairing Database and Tables does not solve it.

Edit:
I installed it fresh on my test vb install. forums/credits.php worked, but then I added a new currency called Event Tokens and colomn: tokens and then I get the database error again. Deleting Currency fixes the database error. Any ideas what is going wrong?
 
Last edited:
Status
Not open for further replies.

Legacy vBCredits II Deluxe

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
846
Customer rating
0.00 star(s) 0 ratings
Back
Top