Welcome, Guest. Please login or register.

Author Topic: Incorrect integer value error  (Read 1550 times)

lrosa

  • Newbie
  • *
  • Posts: 2
    • View Profile
Incorrect integer value error
« on: March 27, 2022, 05:56:20 pm »
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

  • Administrator
  • Hero Member
  • *****
  • Posts: 2893
    • View Profile
    • NeDi
Re: Incorrect integer value error
« Reply #1 on: May 09, 2022, 10:35:23 am »
Thanks for posting this fix, appreciated :-)
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo