Add Event Error - VT7.1 on MariaDB 10.3.11

in MariaDB 10.3.11 sql_mode default value changed from "" to "NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO" so when you update mysql to newer version , because of STRICT_TRANS_TABLES , $recurid == "" cannot convert to 0 and generate this error when user add an any kind of event in calendar

---

Error in processing vtiger_table vtiger_activity_reminder Query Failed:INSERT INTO vtiger_activity_reminder VALUES (?,?,?,?)::ADODB error Error in processing vtiger_table vtiger_activity_reminder Query Failed:INSERT INTO vtiger_activity_reminder VALUES (?,?,?,?)::->Incorrect integer value: '' for column 'recurringid' at row 1

Please search the issue tracker. This has been known about - and checks should now be in place during installation to inform you you need to update your sql_modes.

http://code.vtiger.com/vtiger/vtigercrm/issues/202 (This ticket was from 3 years ago)

Status changed to closed

mentioned in issue #1154 (closed)

Milestone changed to 7.2.0