Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

HeidiSQL Date Problem

phasar40's profile image phasar40 posted 1 month ago in General Permalink

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!

ansgar's profile image ansgar posted 1 month ago Permalink

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

phasar40's profile image phasar40 posted 1 month ago Permalink

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

ansgar's profile image ansgar posted 1 month ago Permalink

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)

phasar40's profile image phasar40 posted 1 month ago Permalink

It's a local host

ansgar's profile image ansgar posted 1 month ago Permalink

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

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.