Stats Not Working

[spidawebs]

On the Dashboard, it shows the number of orders under Activity Overview, but under Dashboard it shows zero for everything.

If you go to Stats > Stats, everything is zero, including number of visitors, orders placed, revenue etc.

Does something need to be enabled somewhere?

[twistcapmedia]

I am assuming you turned "demo data" off or whatever in the top right corner of dashboard?

[spidawebs]

@twistcapmedia Yes, now everything is showing zero, even after an order is placed

[Norwegian_Rat]

This might be a PHP issue. Stats acted kinda funny when we upgraded our PHP-version to 7.1. You got spinning icons?

[spidawebs]

@Norwegian_Rat No, no spinning icons. Everything is super fast in TB!

[Norwegian_Rat]

It wasn't a speed issue I had in mind. I know there were some issues with the PHP (7.1) and stats in the upgrade from PS 1.6.1.10 to 1.6.1.11. Most likely it it fixed in TB, and maybe this is another issue, but you can double check it just to rule out it's not the PHP causing it.

[spidawebs]

@Norwegian_Rat I'm still on PHP 5.5.34 so I guess it must be another issue

[JamesBlond008]

Sorry to bump this Thread up, but i have this issue sind 1. of January 2018. Everything was fine in 2017 with the Stats but now it shows Zero.

My Shop is running on PHP 7.0

[dosbiner]

@jamesblond008 try new all in one stats module from here https://store.thirtybees.com/statistics

[JamesBlond008]

Im on 1.0.3 TBS i cant use that

[SLiCK_303]

Do you have the modules, graphnvd3 and gridhtml installed?

[SLiCK_303]

@jamesblond008 said in Stats Not Working:

Everything was fine in 2017 with the Stats but now it shows Zero.

everything in the stats shows zero, or just your dashboard forecast. or...?

[JamesBlond008]

[JamesBlond008]

Can someone help me by this Problem?

[SLiCK_303]

Hit the config button on the top right, next to the refresh button. Do you have any numbers set in there, or are they empty/all zeros?

[JamesBlond008]

Its still 0

[SLiCK_303]

that didnt anwser my question.... ;)

[JamesBlond008]

[SLiCK_303]

hmm..ok. Do you have any info in your database, in the tborder* tables?

[SLiCK_303]

Assuming you have data in the db, and all related modules installed,(like graphnvd3, gridhtml, statscatalog, and statscheckup) I dont know what to tell ya, maybe someone else has ideas.

[JamesBlond008]

There are Datas inside them. As you can see in the following Picture, it shows me the Stats from 2017 but noch all of it. I dont know why is that? We had Orders in each Month.

[SLiCK_303]

open the setting on that page for last year, then compare to this year, thats all I can think it could be.....

[JamesBlond008]

Both are exact the same hm....

[SLiCK_303]

I'm outta ideas, hopefully someone else has some....sorry

[Rhapsody]

Reading this I had a similar problem.  I ended up resetting the four dashboard modules and the problem was fixed.

BO - Modules -> Dashboard (on left menu) shows the 4 dashboard modules.  Click the dropdown on each and select Reset

[varadipeter]

There is a fundamental logic fault in the design of stats modules' queries.

The (original?) programmer presumed that each order will have an associated invoice but for many it's not the case (I am one of those many). The queries use 'invoice_date' where they should use 'date_add'.

The solution is simple: search and replace the first with the latter and number will appear. Use the quotes too, there is at least one function name containing invoice_date in one of the stats*.php files, you don't want to mess it up.