I received the following error when running validate.php
[FAIL] Database: incorrect column (state_translations/state_value)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on IRC or the community site (https://t.libren.ms/5gscd):
ALTER TABLE state_translations CHANGE state_value state_value smallint(5) unsigned NOT NULL DEFAULT ‘NULL’;
When I connect to the DB and issue the ALTER command, I receive the following error:
MariaDB [librenms]> ALTER TABLE state_translations CHANGE state_value state_value smallint(5) unsigned NOT NULL DEFAULT ‘NULL’;
ERROR 1067 (42000): Invalid default value for ‘state_value’
Has anyone else seen this error…?? If so, what was your fix…??
Thank you.
-Patrick