[Vtigercrm-developers] MySQL 5.7 Defaults causing issues?

[Alan Lord]

FYI:

If I remove the STRICT_TRANS_TABLES from the MySQL defaults then I can 
save an Opportunity.

Al


On 11/08/16 09:47, Alan Lord wrote:
>
> So then I tried to create and save a new Opportunity...
>
> On the new Ubuntu 16.04 server I see the two following db errors reported:
>
>> Thu Aug 11 07:41:52 2016,347 [14395] DEBUG VT - Prepared sql query
>> being executed : insert into
>> vtiger_potential(potentialid,potentialname,potential_no,amount,related_to,closingdate,potentialtype,nextstep,sales_stage,probability,campaignid,forecast_amount,contact_id)
>> values(?,?,?,?,?,?,?,?,?,?,?,?,?)
>> Thu Aug 11 07:41:52 2016,347 [14395] DEBUG VT - Prepared sql query
>> parameters : [30531,My Test
>> Opportunity,POT1637,0,,2016-08-21,,,2-Labwork Started,0,0,0,]
>> Thu Aug 11 07:41:52 2016,347 [14395] INFO VT - PearDatabase ->ADODB
>> error  Query Failed:insert into
>> vtiger_potential(potentialid,potentialname,potential_no,amount,related_to,closingdate,potentialtype,nextstep,sales_stage,probability,campaignid,forecast_amount,contact_id)
>> values(?,?,?,?,?,?,?,?,?,?,?,?,?)::->[1366]Incorrect integer value: ''
>> for column 'related_to' at row 1
>> Thu Aug 11 07:41:52 2016,347 [14395] INFO VT - function
>> insertIntoEntityTable Potentials vtiger_table name vtiger_potentialscf