Searching the log error

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”

Are you using MySQL v8 or is your version earlier?

This is what I am getting:

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.

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

CONCLUSION:

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

Thanks @sunset Rod!!

1 Like