Could not execute: Unknown column 'yahoo_id' in 'field list'

Question

Hi,
I am trying to integrate vtiger crm 5.4 with vicidial server v2.4 When I go into the vicidial settings and click on "Click here to Synchronize users with Vtiger", it gives me the following error.
 

Connected successfully
GROUP- ADMIN: 5

GROUP- ADMIN: 5

GROUP- ADMIN: 5

Could not execute: Unknown column 'yahoo_id' in 'field list'

Answer 1

This issue is because there is no field 'yahoo_id' in the table 'vtiger_users' in the vtiger database.
Add the column `yahoo_id` varchar(100) DEFAULT NULL
to the table and the issue will be resolved.

Hope this helps.
- Kunal

Answer 2

 Command:

alter table vtiger_users add yahoo_id varchar(100) DEFAULT NULL;