Webgui error, database query error log

Help
1

Hello,

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.

2

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

3

Run and post ./validate.php

4

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.

Thanks.

5

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.