FIX FOR ./validate incorrect column (notifications/datetime) (users/created_at) FIX

Hope this saves someone else some time in combing the answers on the interwebs.

when running ./validate you may receive the error

[FAIL] Database: incorrect column (notifications/datetime)
[FAIL] Database: incorrect column (users/created_at)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on Discord (https://t.libren.ms/discord) or the community site (https://t.libren.ms/5gscd):
[FIX]:
Run the following SQL statements to fix.
SQL Statements:
ALTER TABLE notifications CHANGE datetime datetime timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:00’ ;
ALTER TABLE users CHANGE created_at created_at timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:01’ ;

TO solve this you need to log into the mysql database with -u root -p

root needs to be replaced with the database username you selected in the mysql setup and then you’ll be prompted for the mysql password selected in the setup

Once logged into mysql cli you need to connect to the database with the command below

connect librennms

"librenms" and “root” is the default login name and database name in the setup defaults if you copy and pasted from the how to

Once connected to the database you can run the commands from ./validate

ALTER TABLE notifications CHANGE datetime datetime timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:00’ ;
ALTER TABLE users CHANGE created_at created_at timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:01’ ;