Incorrect integer value error

[lrosa]

Hi,
in case you got an error like this with NeDi 2.1.071

DBD::mysql::st execute failed: Incorrect integer value: '' for column `nedi`.`modules`.`modidx` at row 1 at ./inc/libdb.pm line 1679.

The solution for me on Ubuntu 20.04.4 LTS was to add this line under [mysqld] section of MariaDB configuration file:

sql_mode = ""


Refer to MariDB documentation https://mariadb.com/kb/en/sql-mode/ for details.




Luigi

[rickli]

Thanks for posting this fix, appreciated :-)