SugarCRM or VoiceRD Problem?

[rightfoot]

When I try to add a new user in SugarCRM, with VoiceRD just installed, I get the following;

Query Failed:INSERT into users set id='dc73f918-6e66-f911-1ad2-48878f469c8a', user_name='kpxxxxxx', sugar_login='1', first_name='Kxxx', last_name='xxxxx', reports_to_id=null, is_admin='1', receive_notifications='1', description=null, date_entered='2008-07-23 20:05:49', date_modified='2008-07-23 20:05:49', modified_user_id='1', created_by='1', title=null, department=null, phone_home=null, phone_mobile=null, phone_work=null, phone_other=null, phone_fax=null, status='Active', address_street=null, address_city=null, address_state=null, address_country=null, address_postalcode=null, user_preferences=null, deleted='0', portal_only='0', asterisk_auto_pickup='1', asterisk_extension='6131', employee_status='Active', messenger_id=null, messenger_type=null, is_group='0'::MySQL error 1054:

Am I looking at a sugarCRM or voicerd problem?

[eNick]

MySQL 1054 is a "column doesn't exist" error. So, compare that column list with the actual Users table in MySql.

My money is that it's the asterisk_auto_pickup and asterisk_extension fields which are probably required by the voicerd component.

If you've just installed then a repair with DB rebuild might well sort you out.

Nick