HeidiSQL Date Problem

I am not a programmer and I don't know sql's or anything else. So please bear with me.

My Wordpress website is connected to a HeidiSQL database on my computer. It's an internet radio station and I noticed it occasionally freezes. So, while I was trying to figure out why I went into HeidiSQL and did Maintenance > Check > Quick. It found some errors but it also wiped out the entire song index for some reason. I mean, it's only a check, right?

So, I ran Maintenance > Extended > Repair and that rebuilt the index.

The problem now is that today is 2021-08-14 and the Wordpress plugin I use shows the last song played at 2021-09-21.

As a result the info on the website is not updating.

Is there a way to check the date in HeidiSQL and adjust it to the proper date/time so it starts showing the correct info on the website again?

You can see the problem at rfu.in.ua

TIA!

I would have a look at the logfiles in the MySQL/MariaDB folder. Most interesting is the *.err file in path/to/mysql/data/

I couldn't find that subdir

All I could find was a bunch of numbered session logs in C:\Users\xxxx\AppData\Roaming\HeidiSQL\Sessionlogs

And the last session log just shows the rebuild of the index

HeidiSQL connects to a MySQL or MariaDB server. And you need to look at the log files from MySQL, not to those from HeidiSQL.

Do you connect to a local IP address or is it a remote server? (look at the host in the HeidiSQL session manager)

It's a local host

Ok then you should find the directory where you installed MySQL/MariaDB, and look in its "data" subdirectory for that *.err file.