Jump to content
thirty bees forum
  • 0

Stats Not Working


spidawebs

Question

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?

Link to comment
Share on other sites

Recommended Posts

  • 0

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.

Link to comment
Share on other sites

  • 0

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...