Statistik missing old Orders

[rvhelp]

Hello, after the update (22.10.1) the entries in the statistics are missing. Only new orders are displayed.

What determines which orders are displayed here? Have I possibly deleted references or what could be the reason for that?

[aimeos]

There's a check for if orders contain products from the same site or from the site subtree (important for marketplaces):
https://github.com/aimeos/aimeos-core/b ... #L447-L463

You should check if the site IDs are migrated property in all tables (from "1" to "1." for example if you only have one site).

[rvhelp]

The Site IDs are all migrated to "1."

I tried again to go through the update process.

When updating from 22.4.4 to 22.7.1 / 22.7.2 / 22.10.1, the statistics from previous months are no longer displayed in the backend statistics.

[aimeos]

You only have one site with "1." as value allover?

[rvhelp]

Yes only one site and "1." in every mshop_order table.

[aimeos]

No clue why the old orders are not loaded.
Can you enable debug mode (madmin/log/manager/loglevel = 7) and check the SQL statements, why the old orders are not returned or used for aggregation?

[rvhelp]

I tried, but there are only new entries when I open the frontend and not when I go to the Aimeos Dashboard.

But I did find out something: An older order is displayed as soon as I delete a newer one - only the last 25 orders are displayed.

[aimeos]

In the latest order section, only the last 25 orders are listed.
The order heatmap should show the number of orders from the last months per day.

[rvhelp2]

In my case latest orders sections at the top contains 10 orders. The heatmap and everything else are somehow limited to the last 25 orders:

[aimeos]

The only way to find out why only these orders are shown is to enable debug logs:

Code: Select all

madmin/log/manager/loglevel = 7

Then, open the dashboard and afterwards the Log panel to see the executed queries and check the order related queries which use SQL aggregation functions like COUNT() or SUM().