[#2941] CB Connect SQL error and connection error

this is the error i get when signing up with twitter:

moscomprofiler::storeNew failed: Unknown column 'formatname' in 'field list' SQL=INSERT INTO `jos_comprofiler` (`id`,`user_id`,`firstname`,`middlename`,`lastname`,`avatar`,`approved`,`confirmed`,`registeripaddr`,`twitter_userid`,`formatname`,`location`,`interests`) VALUES ('72','72','You','Are The','Judge',' a3.twimg.com/profile_images/1592811867/youarethejudgetwitter_normal.jpg','1','1','65.112.145.53','392754829','','','discuss cases based on testimony, evidence, and attorney performance')

the name goes into the user management but it is unconfirmed

even after confirming it then next time i log in i ger
"user name in use" it appears that it is trying to create a new user.


1) what is the sql error when signing up with twitter and how can i fix it
2) how can I have it automatically confirmed
3) how can I let the application know i'm trying to sign in not sign up

Please remove the formatname field from your Twitter field mapping as it doesn't actually exist in the database as a column. Have added the below ticket to try and remove fields that don't exist as database columns.

forge.joomlapolis.com/issues/2941

SOLVED. Thank you.