BV Linkedin Integration with SuiteCRM

Hello

Chrome Extension Name is BV SuiteLI which you need to search from list of Extensions.

Linkedin_Monthly is a SuiteCRM Package which you need to install in SuiteCRM via Module Loader

Please check & let me know if you are still facing any issue,

Thank You, Brainvire Team

I have installed the chrome extension and installed the module. The extension can connect to my suite instance and shows the green icon. When I click on a profile in Linkedin I can see all the fields. However, when I click save it gets stuck on loading.

I have this in my suitecrm error log MySQL error 1054: Unknown column 'leads.bv_linkedin_id' in 'where clause'

I tried a quick repair and rebuild which said the mysql was out of sync with vardefs. I ran the script and now the repaid and rebuild says everything is fine. But I still don't have that column in the db and the lead is not saving.

Please advise

Thanks

Hello

Please execute below statements in your DB

ALTER TABLE leads add COLUMN bv_linkedin_id varchar(255) NULL , add COLUMN bv_linkedin_experience text NULL , add COLUMN bv_linkedin_skills text NULL ;

ALTER TABLE contacts add COLUMN bv_linkedin_id varchar(255) NULL , add COLUMN bv_linkedin_experience text NULL , add COLUMN bv_linkedin_skills text NULL ;

Not sure,,might be some conflict.

Please check & let me know if you are still facing any issue,

Thank You, Brainvire Team

Hello

The error "Row size too large" in MariaDB typically occurs when the total size of columns in a row exceeds the maximum allowed size

Might be there are two many columns in contacts table. Due to which you are getting this error

Try changing sql as below if it can reduce the size

ALTER TABLE contacts ADD COLUMN bv_linkedin_id TEXT NULL, ADD COLUMN bv_linkedin_experience TEXT NULL, ADD COLUMN bv_linkedin_skills TEXT NULL;

If not you might need to change ROW_FORMAT to dynamic to include these fields in your DB

Thank You, Brainvire Team