We have uninstalled this mod, until its out of BETA.
We now have numerous MySql errors and need to fix this.
All template edits have been reverted, product succesfully uninstalled.
The error we get ( but cannot locate ) .. so help needed is:
Code:
nvalid SQL:
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_itrader AS phrasegroup_itrader,
language.phrasegroup_posting AS phrasegroup_posting,
language.phrasegroup_prefix AS phrasegroup_prefix,
language.phrasegroup_adv_gallery_int AS phrasegroup_adv_gallery_int,
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
,mgcugp.mgc_cb_evo_default_color, ppgal_user.*
FROM yobromofuser AS user
LEFT JOIN yobromofuserfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN yobromofusertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN yobromoflanguage AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
LEFT JOIN yobromofusergroup AS mgcugp ON (user.usergroupid=mgcugp.usergroupid)
LEFT JOIN yobromofppgal_user AS ppgal_user ON (ppgal_user.userid = user.userid)
WHERE user.userid = 2;
MySQL Error : Unknown column 'language.phrasegroup_itrader' in 'field list'
Error Number : 1054
Request Date : Thursday, July 31st 2008 @ 09:37:38 AM
Error Date : Thursday, July 31st 2008 @ 09:37:38 AM
Script : http://www.xxxxxxxx.com/forum/itrader_feedback.php?u=34
Referrer :
IP Address : xxx.xxx.xxx.xxx
Username :
Classname : vB_Database
MySQL Version :