[harmor19]

This is odd. It's throwing this error

PHP Code:

SELECT 
            userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
            IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
            language.phrasegroup_search AS phrasegroup_search,
            language.phrasegroup_error AS phrasegroup_error,
            language.phrasegroup_global AS phrasegroup_global,
            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
            
        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 language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 
        
        WHERE user.userid = 1;

MySQL Error  : Unknown column 'language.phrasegroup_error' in 'field list' 


I can see that it's selecting the column but why is it throwing the error?


I'm using

PHP Code:

$phrasegroups = array('error');