Database Strict Errors

With STRICT_TRANS_TABLES set in sql mode that is now default value get this during installation

Tue Jul  3 14:15:04 2018,709 [30508] INFO VT - PearDatabase ->ADODB error  Query Failed:UPDATE vtiger_inventoryproductrel_seq SET id=(select max(lineitem_id) from vtiger_inventoryproductrel);::->[1048]Column 'id' cannot be null

Tue Jul  3 14:15:06 2018,206 [30508] INFO VT - PearDatabase ->ADODB error  Query Failed:INSERT INTO vtiger_settings_field (fieldid, blockid, name, iconpath, description, linkto, sequence) VALUES (?,?,?,?,?,?,?)::->[1366]Incorrect integer value: '' for column 'sequence' at row 1
```

and this error saving documents

```
Tue Jul  3 12:25:31 2018,923 [11205] INFO VT - PearDatabase ->ADODB error  Query Failed:UPDATE vtiger_notes SET filename = ? ,filesize = ?, filetype = ? , filelocationtype = ? , filedownloadcount = ? WHERE notesid = ?::->[1366]Incorrect integer value: '' for column 'filesize' at row 1
```

Milestone changed to 7.2.0

Will look into more but those 2 are present during installation and last during save into documents.

mentioned in issue #1154 (closed)

mentioned in issue Fix #1154 (closed)

Milestone changed to 8.0.0

Default sql_mode set for setting in #1747 (closed)

closed

changed the description