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

[Christophe Humbert]

Thanks Lucia for the info!

Christophe Humbert
*IT Program Manager*
+352 691 391 974
+33 6 50 09 48 88
Skype: chris.e.humbert


On Wed, Mar 30, 2016 at 2:17 PM, lucia digirolamo <
l.digirolamo at websonica.net> wrote:

> 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/
>>
>>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20160330/a469e7b0/attachment.html>