Quote:
Originally Posted by Hyrel
...
|
Yours is an easy fix.
Do you see where you have:
PHP Code:
Database error in vBulletin 3.6.7:
Invalid SQL:
SELECT ea.userid, ea.response, ea.signupname, ea.comment, ea.signup_date,
arm.m_name,arm.m_class,arm.m_race,arm.m_level,arm.ai_name,arm.ai_class,arm.ai_race,arm.ai_level,arm.aii_name,arm.aii_class,arm.aii_race,arm.aii_level,
userfield., userfield.
Notice it says userfield.x and the (x) is missing? That's pointing to $field5, $field9, and $field10, which are the custom userfields. You either haven't created them and pointed them to the right numbers in vboptions.., or you created them and haven't pointed them to the right numbers in vboptions.
Do you understand how to create custom userfield options? And, if so, do you know how to find the IDs of those fields?
Check my attachments for visual examples.
Remember that if you have a bunch of customfields, yours might be field22, field23, field24, etc. That's why you need to plugin the IDs correctly.