Dashboard Sales Panels empty

Questions around the TYPO3 integration and plugins
Forum rules
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
stiller
Posts: 88
Joined: 05 Mar 2016, 15:59

Dashboard Sales Panels empty

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
Posts: 88
Joined: 05 Mar 2016, 15:59

Re: Dashboard Sales Panels empty

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.

User avatar
aimeos
Administrator
Posts: 8027
Joined: 01 Jan 1970, 00:00

Re: Dashboard Sales Panels empty

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?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

stiller
Posts: 88
Joined: 05 Mar 2016, 15:59

Re: Dashboard Sales Panels empty

Post by stiller » 14 Feb 2024, 11:04

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

User avatar
aimeos
Administrator
Posts: 8027
Joined: 01 Jan 1970, 00:00

Re: Dashboard Sales Panels empty

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
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply