Date: 2020-10-12 17:17
Posted By: Deleted User (deleteduser_11200)

This is caused by the STRICT_TRANS_TABLES SQL mode set in mysql.conf

[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_strict_trans_tables

I have changed my mysql.conf file that solved the problem. 
If you want to fix it in the php script be sure that value_index is not NULL
when inserting a record to cms_module_lisemodulename_fieldval on
framework/action_togglefielddefvalue.php

mysql> desc cms_module_lisemodulename_fieldval;
+-------------+---------+------+-----+---------+-------+
| Field       | Type    | Null | Key | Default | Extra |
+-------------+---------+------+-----+---------+-------+
| item_id     | int(11) | NO   | PRI | NULL    |       |
| fielddef_id | int(11) | NO   | PRI | NULL    |       |
| value_index | int(11) | NO   | PRI | NULL    |       |
| value       | text    | YES  |     | NULL    |       |
| data        | text    | YES  |     | NULL    |       |
+-------------+---------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> select * from cms_module_lisemodulename_fieldval where item_id=101;
+---------+-------------+-------------+---------------------------------------------+------+
| item_id | fielddef_id | value_index | value                                   
| data |
+---------+-------------+-------------+---------------------------------------------+------+
|     101 |           4 |           0 | 1                                       
| NULL |
+---------+-------------+-------------+---------------------------------------------+------+
2 rows in set (0.00 sec)


(root)/trunk/framework/action.admin_togglefielddefvalue.php - Rev 210
http://viewsvn.cmsmadesimple.org/filedetails.php?repname=lise&path=%2Ftrunk%2Fframework%2Faction.admin_togglefielddefvalue.php

$query  = 'DELETE FROM ' . cms_db_prefix() . 'module_' .
$this->_GetModuleAlias() . '_fieldval WHERE item_id = ? AND fielddef_id = ?';
$result = $db->Execute($query, array($item_id, $fid));

----> $query  = 'INSERT INTO ' . cms_db_prefix() . 'module_' .
$this->_GetModuleAlias() . '_fieldval (item_id, fielddef_id, value) VALUES (?,
?, ?)';
$result = $db->Execute($query, array($item_id, $fid, $value));