[Vtigercrm-developers] creating potentials through webservice gives database error

[lucia digirolamo]

I found it! I'll share my solution in case it can be useful to somebody 
else.

During migration the field 'forecast_amount' got doubled. As a result I 
had two forecast_amount fields in vtiger_field table. I deleted one of 
them and now doCreate works.




On 30/03/2016 11:52, Alan Lord wrote:
> On 30/03/16 10:46, lucia digirolamo wrote:
>
>> $recorddata = array(
>>          'potentialname' => 'test',
>>          'related_to' => '3x95460', // (moduleId x recordId) such as
>> 3x95460
>>          'closingdate' => date('Y-m-d'),
>>          'sales_stage' => 'Closed Lost',
>>          'amount' => '2000',
>>          'contact_id'=>'4x97106',
>>      );
>
>
> Are your wsids correct? "3" in some of my systems is for the FAQ 
> module and "4" is for Quotes. Check your table vtiger_ws_entity - 
> these are *not* the same as the tabid.
>
>
> Also you have no assigned_user_id field - which is _always_ mandatory.
>
> Al
>
>
> _______________________________________________
> http://www.vtiger.com/
>