jeremyers1

r3df,
I would love those patches, if you want to make them available. I think the rolling 24 hour option would be great.

Sure. I wouldn’t mind using a rolling 24 hours. The plugin doesn’t seem to have this option. Is there a plugin that does?

Just live sites. I’m probably just going to ignore it for now.

You were right again. It did not permanently change the timezone. Oh well.

How does WordPress put the right time in for the posts and comments? These also are saved in the Database. Couldn’t the plugin call that time (in the settings) rather than the one in the Database?

Oh, and for any not in the Eastern Timezone, I think that if you don’t know your named timezone, you can use a UTC offset, such as this:

SET time_zone = '-5:00';

if you don’t know your UTC offset, just search Google for it.

And now that you have discovered the problem, I was able to set the proper time.

I used this in the SQL box:

SET time_zone = 'America/New_York';

Ok, I tested it at 6:58PM Eastern (18:58)

It came back 22:58:19, which is 10:58. So this is definitely the issue, since my daily stats reset at 8 PM Eastern.

yes, I checked the times in Settings->general. Those are correct.

Yes, I do have access to my databse phpmyadmin.

r3df,

You are probably right. It seems there should be a way to connect the plugin to the Blog Timezone settings instead, or even to the Blog’s Site Stats. I just don’t know enough php to figure it out.

I am hoping they dump this into the JetPack soon also. This is a much needed tool.

Come on WordPress!

Could this bit of code be tweaked to fix this?

This code is found in: wordpress-popular-posts/wordpress-popular-posts.php

[Code moderated as per the Forum Rules. Please use the pastebin]

r3df,

Yep. You are right. I emptied my cache last night at 11:59 pm, and it started counting again, but the day reset 10 minutes ago, at 8:00 PM EDT.

So, where can I change the setting in the plugin to reset at midnight EDT?

I am thinking that it must start counting the second it is installed.

I am going to test it tonight, and empty the cache and historical data at 11:59 pm, and see if that fixes it.

Brenda,

No, I did not lose all my data. Plugins shouldn’t affect blog data.

No, the wp-cron.php is not through the Dashboard. You have to use an FTP client to find and edit the file. I use FileZilla.

I eventually found a solution.

My host has some extra server-side security. In my Host CPanel, I had to create a “cron job” for wp-cron.php from my WP root directory.

However, this cron job was timing out.

So, I also had to go increase the “timeout” length in wp-cron.php (inside /wp-includes) from 0.01 to 1.00.