Bug Database Error

[Madhatterr]

Using the latest Beta version, site is down so I can't check exact version number. I put in the vBCredits II point information and changed the points per to 0 as instructed in another thread and now my site is showing the database error page when trying to load any page. Here is the information on the error. Currently my entire site is down because of this error.

Database error in vBulletin 4.1.11:

Invalid SQL:

               SELECT  administrator.*,
                       userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
                       IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
                       language.phrasegroup_global AS phrasegroup_global,
                       language.phrasegroup_timezone AS phrasegroup_timezone,
                       language.phrasegroup_user AS phrasegroup_user,
                       language.phrasegroup_cpuser AS phrasegroup_cpuser,
                       language.phrasegroup_holiday AS phrasegroup_holiday,
                       language.phrasegroup_cppermission AS phrasegroup_cppermission,
                       language.phrasegroup_cpoption AS phrasegroup_cpoption,
                       language.phrasegroup_cprofilefield AS phrasegroup_cprofilefield,
                       language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
                       language.phrasegroupinfo AS lang_phrasegroupinfo,
                       language.options AS lang_options,
                       language.languagecode AS lang_code,
                       language.charset AS lang_charset,
                       language.locale AS lang_locale,
                       language.imagesoverride AS lang_imagesoverride,
                       language.dateoverride AS lang_dateoverride,
                       language.timeoverride AS lang_timeoverride,
                       language.registereddateoverride AS lang_registereddateoverride,
                       language.calformat1override AS lang_calformat1override,
                       language.calformat2override AS lang_calformat2override,
                       language.logdateoverride AS lang_logdateoverride,
                       language.decimalsep AS lang_decimalsep,
                       language.thousandsep AS lang_thousandsep
                       , (user.credits) AS vbcredits_1, user.credits AS vbcreditsb_1, (user.activity_points) AS vbcredits_3, user.activity_points AS vbcreditsb_3 , avatars_pointstable.activity_points AS dbtech_avatars_points
               FROM user AS user
               LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
               LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN administrator AS administrator ON (administrator.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
                LEFT JOIN userid AS avatars_pointstable ON(avatars_pointstable.userid = user.userid)
               WHERE user.userid = 43;

MySQL Error   : Table 'hortonst_vbulletin384.userid' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, March 28th 2012 @ 10:38:23 AM
Error Date    : Wednesday, March 28th 2012 @ 10:38:23 AM
Script        : http://playvampire.com/admincp/options.php?do=validate&varname=
Referrer      : http://playvampire.com/admincp/avatars.php?do=options&dogroup=dbtech_avatars_general
IP Address    : 70.244.237.77

---------- Post added at 10:50 ---------- Previous post was at 10:46 ----------

I've disable addons via the config file and turned off my board until this issue can be fixed.

 

[Fillip H.]

You accidentally put userid in the "Points Table" field

Please enter vBulletin Options and change the "Points Table" setting for vBAvatars to whatever you use in vBCredits

 

[Madhatterr]

Yep, thanks!

Anyway you could make it so it checks that before saving? The setting under vBCredits actually does say userid in the column even though it's wrong.

Nevermind I was looking at the column instead of the table.

 

[Fillip H.]

I'll look into whether it's possible to validate the setting