Webgui error, database query error log


It’s happening to me today, seems the auto update broke the database, the log show as:

generates invalid query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '~ "

I have checked the mysql table by using mysqlcheck -a librenms, all columns show “Ok”

Please advice how to correct the issue.
Thank you.

weird, it works with chrome, but not with firefox, brave, …

Run and post ./validate.php

it should be fine now.
I found the issue and fixed by executing this command:

php artisan key:generate --force

This could be cause of missing APP_KEY in env file.


strange, this happens again, not sure why, but after executed the command, and it can fix the issue.

Any suggestion to correct the issue permanently?
Thank you.