function defined
SQL error in comprofilerDB function failed with error number 1052
Column: 'params' in field list is ambiguous SQL=SELECT name,lastvisitDate,registerDate,username,firstname,middlename,lastname,lastupdatedate,email,hits,password,params,cb_school,cb_bigten,cb_bigeast,cb_womensbball,cb_big12,cb_acc,cb_sec,cb_pac10,cb_sunbelt,cb_patriot,cb_wac,cb_wcc,cb_a10,cb_mvc,cb_bcs,cb_ncaa,cb_d2,cb_d3,cb_italian,cb_irish,cb_jewish,cb_greek,cb_hunky,cb_spanish,cb_black,cb_military,cb_yucks,cb_politicalsatire,cb_beer,cb_football,cb_mensbball,cb_lacrosse,cb_baseball,cb_division,cb_title,usertype FROM jos_users u LEFT JOIN jos_comprofiler c on (u.id=c.user_id)
SQL =
SELECT name,lastvisitDate,registerDate,username,firstname,middlename,lastname,lastupdatedate,email,hits,password,params,cb_school,cb_bigten,cb_bigeast,cb_womensbball,cb_big12,cb_acc,cb_sec,cb_pac10,cb_sunbelt,cb_patriot,cb_wac,cb_wcc,cb_a10,cb_mvc,cb_bcs,cb_ncaa,cb_d2,cb_d3,cb_italian,cb_irish,cb_jewish,cb_greek,cb_hunky,cb_spanish,cb_black,cb_military,cb_yucks,cb_politicalsatire,cb_beer,cb_football,cb_mensbball,cb_lacrosse,cb_baseball,cb_division,cb_title,usertype FROM jos_users u LEFT JOIN jos_comprofiler c on (u.id=c.user_id)
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
Can someone please explain ASAP how I can duplicate the problem. I think the fix is obvious but I would like to test it. I did a clean xampp installtion of cb 1.2rc2 but did not get the params field. Has there been a change to the released code or what? I installed RC2 - still no second params field in comprofiler. How is it created?
Post edited by: jciconsult, at: 2008/08/22 16:02
Post edited by: jciconsult, at: 2008/08/22 16:15
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.