SQL error in comprofilerDB function failed with error number 1054
Unknown column 'c.cb_doorcolor' in 'field list' SQL=SELECT u.name,u.lastvisitDate,u.registerDate,c.avatar,c.avatarapproved,u.username,c.firstname,c.middlename,c.lastname,c.lastupdatedate,u.email,c.hits,u.params,c.website,c.location,c.occupation,c.interests,c.company,c.city,c.state,c.zipcode,c.address,c.cb_preferredtelephone,c.cb_vehiclemake1,c.cb_vehiclemake2,c.cb_vehiclemake3,c.cb_vehiclemodel1,c.cb_vehiclemodel2,c.cb_vehiclemodel3,c.cb_vehiclecolor1,c.cb_vehiclecolor2,c.cb_vehiclecolor3,c.cb_vehicleyear1,c.cb_vehicleyear2,c.cb_vehicleyear3,c.cb_vehicleregistration2,c.cb_vehicleregistration1,c.cb_vehicleregistration3,c.cb_address2,c.cb_unit,c.cb_agaddress,c.cb_stow,c.cb_ma,c.cb_zipcode,c.cb_2ndemailaddress,c.cb_2ndtelephone,c.cb_emergname1,c.cb_emergnumb1,c.cb_emergemail1,c.cb_emergname2,c.cb_emergnumb2,c.cb_emergemail2,c.cb_skills,c.cb_doorcolor,c.cb_bldg,c.cb_primaryfrontcolor,c.cb_primaryrearcolor,c.cb_shake,c.cb_shutters,c.cb_bkflw,u.usertype,u.block FROM jos_users u LEFT JOIN jos_comprofiler c on (u.id=c.user_id)
SQL =

SELECT u.name,u.lastvisitDate,u.registerDate,c.avatar,c.avatarapproved,u.username,c.firstname,c.middlename,c.lastname,c.lastupdatedate,u.email,c.hits,u.params,c.website,c.location,c.occupation,c.interests,c.company,c.city,c.state,c.zipcode,c.address,c.cb_preferredtelephone,c.cb_vehiclemake1,c.cb_vehiclemake2,c.cb_vehiclemake3,c.cb_vehiclemodel1,c.cb_vehiclemodel2,c.cb_vehiclemodel3,c.cb_vehiclecolor1,c.cb_vehiclecolor2,c.cb_vehiclecolor3,c.cb_vehicleyear1,c.cb_vehicleyear2,c.cb_vehicleyear3,c.cb_vehicleregistration2,c.cb_vehicleregistration1,c.cb_vehicleregistration3,c.cb_address2,c.cb_unit,c.cb_agaddress,c.cb_stow,c.cb_ma,c.cb_zipcode,c.cb_2ndemailaddress,c.cb_2ndtelephone,c.cb_emergname1,c.cb_emergnumb1,c.cb_emergemail1,c.cb_emergname2,c.cb_emergnumb2,c.cb_emergemail2,c.cb_skills,c.cb_doorcolor,c.cb_bldg,c.cb_primaryfrontcolor,c.cb_primaryrearcolor,c.cb_shake,c.cb_shutters,c.cb_bkflw,u.usertype,u.block FROM jos_users u  LEFT JOIN jos_comprofiler c on (u.id=c.user_id)