Rick Radko

If the times are right for WordPress then it is probably using php times to create strings/data to save in the database and not SQL. This plugin is using both php time functions and sql time functions, CURDATE() is an sql one, to mange time strings.

To get it fixed, you either need to get it changed on the server, which may not be possible, or add it to the plugin as above with a php call to the DB that fixes it every time a page loads.

Thinking a bit more, where is your server? If it’s not local then you probably won’t be able to get them to change the time.

The best solution would be to ask your hosting provider to fix it on the server.

Did the set work? Try select now() again afterwards, it should be back at it’s old time. The set does not stick for me, which as as per the docs as I understand it. The SET time_zone is a per session setting, and unfortunately in php/web, an sql session is usually per page load.

You’ll need to put something like:
$wpdb->query(“SET time_zone = ‘America/New_York'”);
in either this plugin, or your functions.php to set it every time a page loads. (depending on where you put it, you may need: global $wpdb; before it too.)

Ok, lets see what time mysql thinks it is. Try entering: SELECT NOW() in the SQL box in myphpadmin and see what time you get.

@jeremyers1, have you checked the times displayed beside the timezone setting in your dashboard under settings->general? Are they correct?

Do you have access to your database cpanel/phpmyadmin?

Yes! I’d like to see the patch.

@jeremyers1, I’ve not really had a chance to dig, (I’ve only just started using this plugin myself) but I don’t think the plugin is the issue. I’d suspect it’s the server time, probably is not set for eastern.

It’s more likely a time coversion issue. It’s probably resetting at midnight GMT, which right now would be 8pm EDT.