Unknown search key \"order.product:total\"

[kdim95]

Laravel framework version: 10.13.5
Aimeos Laravel version: ~2023.04
PHP Version: 8.2.7
Environment: Linux

Hello,

I updated my Aimeos today, not sure if that is the reason, but I'm getting this network error in admin dashboard now:

The GET call:
/admin/default/jsonadm/order?locale=en&aggregate=order.currencyid,order.cdate&filter[&&][0][>=][order.statuspayment]=5&filter[&&][1][>][order.ctime]=2023-05-22T00:00:00&filter[&&][2][<=][order.ctime]=2023-06-21T23:59:59&filter[&&][3][==][order.product.orderproductid]=&filter[&&][4][||][0][==][order.product.statuspayment]=-1&filter[&&][4][||][1][>=][order.product.statuspayment]=5&sort=-order.ctime&page[limit]=10000&value=order.product:total()&type=sum

The response with an error:

Code: Select all

{
"meta": {
"total": 0
, "csrf": {
"name": "_token",
"value": "<TOKEN>"
}

},

"errors": [
{
"title": "Unknown search key \"order.product:total\"",
"detail": "#0 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/aimeos\/aimeos-core\/src\/MShop\/Order\/Manager\/Standard.php(482): Aimeos\\MShop\\Common\\Manager\\Base->aggregateBase()\n#1 [internal function]: Aimeos\\MShop\\Order\\Manager\\Standard->aggregate()\n#2 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/aimeos\/aimeos-core\/src\/MShop\/Common\/Manager\/Decorator\/Base.php(51): call_user_func_array()\n#3 [internal function]: Aimeos\\MShop\\Common\\Manager\\Decorator\\Base->__call()\n#4 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/aimeos\/aimeos-core\/src\/MShop\/Common\/Manager\/Decorator\/Base.php(51): call_user_func_array()\n#5 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/aimeos\/ai-admin-jsonadm\/src\/Admin\/JsonAdm\/Order\/Standard.php(156): Aimeos\\MShop\\Common\\Manager\\Decorator\\Base->__call()\n#6 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/aimeos\/ai-admin-jsonadm\/src\/Admin\/JsonAdm\/Standard.php(117): Aimeos\\Admin\\JsonAdm\\Order\\Standard->getItems()\n#7 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/aimeos\/ai-admin-jsonadm\/src\/Admin\/JsonAdm\/Order\/Standard.php(135): Aimeos\\Admin\\JsonAdm\\Standard->get()\n#8 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/aimeos\/aimeos-laravel\/src\/Controller\/JsonadmController.php(55): Aimeos\\Admin\\JsonAdm\\Order\\Standard->get()\n#9 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php(54): Aimeos\\Shop\\Controller\\JsonadmController->getAction()\n#10 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction()\n#11 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php(259): Illuminate\\Routing\\ControllerDispatcher->dispatch()\n#12 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php(205): Illuminate\\Routing\\Route->runController()\n#13 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Router.php(799): Illuminate\\Routing\\Route->run()\n#14 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()\n#15 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Middleware\/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#16 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()\n#17 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/Middleware\/Authenticate.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#18 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php(180): Illuminate\\Auth\\Middleware\\Authenticate->handle()\n#19 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Http\/Middleware\/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#20 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()\n#21 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Middleware\/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#22 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php(180): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()\n#23 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Session\/Middleware\/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#24 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Session\/Middleware\/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest()\n#25 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php(180): Illuminate\\Session\\Middleware\\StartSession->handle()\n#26 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Cookie\/Middleware\/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#27 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()\n#28 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Cookie\/Middleware\/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#29 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()\n#30 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#31 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Router.php(798): Illuminate\\Pipeline\\Pipeline->then()\n#32 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Router.php(777): Illuminate\\Routing\\Router->runRouteWithinStack()\n#33 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Router.php(741): Illuminate\\Routing\\Router->runRoute()\n#34 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Router.php(730): Illuminate\\Routing\\Router->dispatchToRoute()\n#35 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Http\/Kernel.php(200): Illuminate\\Routing\\Router->dispatch()\n#36 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()\n#37 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Http\/Middleware\/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#38 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Http\/Middleware\/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()\n#39 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle()\n#40 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Http\/Middleware\/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#41 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Http\/Middleware\/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()\n#42 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle()\n#43 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Http\/Middleware\/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#44 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()\n#45 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Http\/Middleware\/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#46 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle()\n#47 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Http\/Middleware\/HandleCors.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#48 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle()\n#49 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Http\/Middleware\/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#50 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle()\n#51 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#52 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Http\/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then()\n#53 \/var\/www\/vhosts\/my.domain\/httpdocs\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Http\/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()\n#54 \/var\/www\/vhosts\/my.domain\/httpdocs\/public\/index.php(51): Illuminate\\Foundation\\Http\\Kernel->handle()\n#55 {main}"
}
]
}

These boxes are not loading, stuck with the spinners:
"Sales of the last 30 days"
"Sales per month"
"Sales by weekday"

[aimeos]

You have an old JS file because the key has changed to "agg:order.product:total" due to changes made to hide non-public search keys.

[kdim95]

Strange, I just compared my dashboard-sales.js with the latest one on github, for some reason the file is not up to date.
I haven't specified an older version of ai-admin-jqadm in my composer.json, trying to figure out why it hasn't updated.

I attempted to composer update aimeos/ai-admin-jqadm.
It's telling me that there are no updates.

Code: Select all

composer up aimeos/ai-admin-jqadm       
Loading composer repositories with package information
Updating dependencies
Nothing to modify in lock file
Installing dependencies from lock file (including require-dev)
Nothing to install, update or remove

I updated the file manually and the error seems to be fixed, but I don't know why the whole package can't update.

[kdim95]

I renamed the package folder and did composer up again. The problem was back after that.
The package that is being downloaded is 2023.04.6. Is that the correct package?

I specified this in my composer.json now:

Code: Select all

"aimeos/ai-admin-jqadm": "^2023.04.x-dev",

Now it seems to be working, instead of updating the .js files manually.

Do you have any idea what might be happening?

[aimeos]

Sorry, a new version of the aimeos-core package has been tagged recently while the new release of the ai-admin-jqadm with the corresponding changes was missing. This is fixed now and you will get 2023.04.7 of the ai-admin-jqadm now.

[kdim95]

Yes, it's fixed, thank you