MariaDB error when trying to correct schema


#1

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


#2

A post was merged into an existing topic: Report database schema issues here


#3