Searching the log error

juggernautsei · April 12, 2021, 12:37am

Hi, did I enter something into the search boxes above incorrectly? I was trying to search within the last hour of the log. So, I put from 2000 to 2100 for the time. Was that wrong? Oh, never mind. I get this no matter what.

version 6.0.0 (1)

I did a var_dump of the dates at line 200 of the EventAuditLogger and got this
string(33) “2021-04-11 00:00 2021-04-11 23:59”

growlingflea · April 12, 2021, 1:01am

Are you using MySQL v8 or is your version earlier?

This is what I am getting:

juggernautsei · April 12, 2021, 1:50am

ubuntu@ip-172-31-64-175:~$ sudo mysql -v
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11154
Server version: 8.0.23-0ubuntu0.20.04.1 (Ubuntu)

This is what the server is running.

mdsupport · April 12, 2021, 9:57pm

Quick guess would be that db has problem with i.date=''.

juggernautsei · April 28, 2021, 9:11pm

CONCLUSION:

@sunsetsystems posted a fix to the SQL error and now the logs load.

Thanks @sunset Rod!!