Dashboard Sales Panels empty

stiller · Post by **stiller** » 13 Feb 2024, 23:44

hi.

Dashboard sales panels like "Sales of the last 30 days" remain empty whereas order panels like "Orders by hour" do show figures as expected. no hint in the log. The legend is shown. just the values are missing.
any idea?
cheers, V

aimeos/ai-admin-jqadm 2022.10.14

stiller · Post by **stiller** » 14 Feb 2024, 09:51

I could single out the problem.
the change in commit
https://github.com/aimeos/ai-admin-jqad ... be87f4d682
is breaking the output.

Post by **aimeos** » 14 Feb 2024, 10:04

If you are using 2022.10 LTS, the relevant change is:
https://github.com/aimeos/ai-admin-jqad ... es.js#L161

Can you check what are the values in your mshop_order_base_product.orderproductid column? Are they NULL or an empty string?

stiller · Post by **stiller** » 14 Feb 2024, 11:04

values are "NULL" but the column is named "ordprodid"

Post by **aimeos** » 14 Feb 2024, 11:09

If it's NULL it should work. Can you check why it doesn't?
The keys are not always named like the short column names and the key for that column is OK:
https://github.com/aimeos/aimeos-core/b ... hp#L59-L66

Help for Aimeos