RangerPretzel

I’m on the 4.1.6 version of SlimStat, btw.

I found a setting called “Reset Timezone”. Is that the one you were talking about?

I tried it with both YES and NO.

The YES setting seems to produce broken results (lots of 0 pageview days), but YES also shows in the default view for Overview that today is the 30th (and has 5 unique visitors.)

The NO setting seems the most correct (0 pageview days only appear when I filter by one of the “Top Pages”.) On the down side, using the NO setting reveals that in the default view for Overview that it doesn’t show the data for the 30th (it’s currently 12:15am on the 30th where I am.)

Not sure what to make of that.

MySQL: 5.5.40
PHP: 5.4.34

I’ll take a shot at the 8-step debugging session tomorrow and post back. ??

Cheers.

Review added. Thanks again for all your good work. ??

I spoke too soon… I just tested the custom date range function again. For example, I picked the 90 day range preset and then selected a filter by choosing a single post.

It’s a lot better than it was, but I still have 1 day in a selected range of days with 0 page views. (Which just isn’t possible because it gets between 20 and 40 hits per day every day.)

Looks like you must have nailed down a bunch of edge cases with 3.9.1, but you’re missing that last corner case. ??

Don’t worry, I’m patient. I’m sure you’ll find that last bug. ??

Hi Camu,
It wasn’t fully fixed in 3.9.0, but I just installed 3.9.1 and I think everything is in order again. Nice work! Thanks again!

Hi Camu,

1) I downloaded 3.8.6 and manually unzippped/unpacked it into the appropriate plugin folder. The “Reset Filters” button appears to be back which is good!

2) Here’s an example of the “Last 60 Days” problem:
https://pretzellogix.net/zero-pageview-days.gif

And yet when I select just a date range of that 1 day, I get:
https://pretzellogix.net/single-day-pageviews.gif

Which tells me that the data is there.

3) Here’s an example of the “off-by-one” error:
https://pretzellogix.net/date-range-off-by-one.gif

As you can see in the screenshot, I selected Dec 13th and -7 days. The scale on the bottom shows Dec 12th as the last day as well as when I mouse over. I think your code must by using 00:00 as an end point when counting negatively (rather than 23:59:59).

Common sense logic would suggest that when going back 7 days from Dec 13th that the date range should be Dec 7th 00:00 to Dec 13th 23:59. But this code does not appear to do that. It seems to select Dec 6th 00:00 thru Dec 13th 00:00.

So that’s what I’ve got. Let me know if you need any more info from me.

Btw, I wanted to let you know that I really like SlimStat as a plugin for WP and that I purchased the “Labels for IP Addresses” add-on a month or so ago because it seemed very useful and I wanted to support your continued development of this great plugin.

Thanks for your hard work. ??

I can reproduce the first bug better now.

If I select a date range preset, like “Last 60 Days” and then select my most popular page in the “Top Pages” section as a filter, there are days when it shows 0 pageviews.

I know this isn’t true because I check my website every day and on those days, the page views are registered properly. The data is clearly still in the DB because if I select that exact date with 0 pageviews and only give it a range of 1 day, then the pageviews appear.

You also appear to have an off-by-one error when doing custom date ranges as the date shown on the right side is correct data for Today, but is labeled Yesterdays date.

I just reloaded this morning and everything seems to be fine now. I hate intermittent bugs. They’re the worst to trackdown/reproduce. If I can find a consistent way to reproduce it, I’ll let you know.

Regarding the 2nd problem, that one still exists for me.

If I select the “Today” preset (button) or the “This Year So Far” preset button in the Date Range drop down, after the page loads with the chart, when I click the Date Range drop down again, there is no longer a “Reset Filters” button like there is for all other date ranges.

yeah, sorry about that. I’ve looked into writing a Mac version, but the learning curve seems kinda steep/time-consuming for something I give away for free.

Anyone try this new version yet? Just checking.

Mods: If this is the wrong forum for this, please let me know and I’ll take it elsewhere.

dlawton is right (and I forgot to mention this), if the smaller WXR files fail or hang during import, you usually can just hit “reload” on your browser and then the “resend” button and it should pick-up from where it left off.

Also, for users of the 1and1.com service, I found this advice on .htaccess very helpful. It made Imports work better and allowed auto-upgrades to work as well. (previously they wouldn’t work without this one line in the .htaccess file.)

Mark’s explanation is a good one. So good that I wrote a free program based on this concept to do the hard work for you.

It’s a WordPress WXR (XML) file splitter and it not only helped my friend, but a bunch of other people have downloaded it too and left comments on my website about how easy this was. Give it a shot!

(requires Windows and .NET 2.0 framework)

I’ve found that this sometimes happens because the WordPress WXR file is too big and needs to be split up into smaller chunks.

So I wrote a simple tool to do all the heavy lifting for you. I call it the WXR file splitter.

After splitting up the files, you should also note that sometimes mid-import, the import will fail or hang. I find that just hitting the “Reload” button on your browser and clicking “resend” will allow it to pick-up where it left off.

Good luck!

Ok guys. I wanted to thank everyone for their support…

And also, I’ve come up with a solution of my own. I wrote my own WXR file splitter. It requires a Windows PC and the .NET 2.0 framework (which I think pretty much everyone has installed by now…)

My file splitter takes any size WXR file (I tested with a 32MB file) and loads it into memory, and then splits it up into many smaller files which are perfect for uploading in small batches.

You can download it for free from my website: Split WordPress XML RSS (WXR) files

Cheers!

I wrote a WXR (WordPress XML RSS) file splitter for Windows. And the best part is that it’s free.

WXR File Splitter

Cheers!