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:
And I got another database error when going to forums/credits.php
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?
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
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: