Filtering by order date does not work

DNK · Post by **DNK** » 18 Jun 2025, 07:06

I'm trying to filter the list of orders by order date. But I get an error
Field Ordered at = Sun Jun 01 2025 00:00:00 GMT+0500 (GMT+05:00),Tue Jun 24 2025 23:59:59 GMT+0500 (GMT+05:00)

Error retrieving data

Undefined array key 1
#0 /releases/60/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(256): Illuminate\Foundation\Bootstrap\HandleExceptions->handleError(2, 'Undefined array...', '/home/max/sites...', 74)
#1 /releases/60/packages/aimeos/aimeos-base/src/Criteria/Expression/Compare/SQL.php(74): Illuminate\Foundation\Bootstrap\HandleExceptions->Illuminate\Foundation\Bootstrap\closure(2, 'Undefined array...', '/home/max/sites...', 74)
#2 /releases/60/packages/aimeos/aimeos-base/src/Criteria/Expression/Compare/Base.php(126): Aimeos\Base\Criteria\Expression\Compare\SQL->createTerm('mord."datepayme...', 'datetime', 'Wed Nov 30 2022...')
#3 /releases/60/packages/aimeos/aimeos-base/src/Criteria/Expression/Combine/SQL.php(71): Aimeos\Base\Criteria\Expression\Compare\Base->toSource(Array, Array, Array, Array)
#4 /releases/60/packages/aimeos/aimeos-base/src/Criteria/Expression/Combine/SQL.php(71): Aimeos\Base\Criteria\Expression\Combine\SQL->toSource(Array, Array, Array, Array)
#5 /releases/60/packages/aimeos/aimeos-base/src/Criteria/Expression/Combine/SQL.php(79): Aimeos\Base\Criteria\Expression\Combine\SQL->toSource(Array, Array, Array, Array)
#6 /releases/60/packages/aimeos/aimeos-base/src/Criteria/SQL.php(128): Aimeos\Base\Criteria\Expression\Combine\SQL->toSource(Array, Array, Array, Array)
#7 /releases/60/packages/aimeos/aimeos-core/src/MShop/Common/Manager/DB.php(864): Aimeos\Base\Criteria\SQL->getConditionSource(Array, Array, Array, Array)
#8 /releases/60/packages/aimeos/aimeos-core/src/MShop/Common/Manager/DB.php(1128): Aimeos\MShop\Common\Manager\Base->getSQLReplacements(Object(Aimeos\Base\Criteria\SQL), Array, Array, Array, Array)
#9 /releases/60/packages/aimeos/aimeos-core/src/MShop/Common/Manager/Base.php(373): Aimeos\MShop\Common\Manager\Base->searchItemsBase(Object(Aimeos\Base\DB\Connection\DBAL), Object(Aimeos\Base\Criteria\SQL), 'mshop/common/ma...', 'mshop/common/ma...', Array, 0, 3, Array)
#10 /releases/60/packages/aimeos/aimeos-core/src/MShop/Common/Manager/Decorator/Depth.php(58): Aimeos\MShop\Common\Manager\Base->search(Object(Aimeos\Base\Criteria\SQL), Array, 0)
#11 /releases/60/packages/aimeos/aimeos-core/src/MShop/Common/Manager/Decorator/Lazy.php(42): Aimeos\MShop\Common\Manager\Decorator\Depth->search(Object(Aimeos\Base\Criteria\SQL), Array, 0)
#12 /releases/60/packages/aimeos/ai-admin-jqadm/src/Admin/JQAdm/Order/Standard.php(286): Aimeos\MShop\Common\Manager\Decorator\Lazy->search(Object(Aimeos\Base\Criteria\SQL), Array, 0)
#13 /releases/60/packages/aimeos/ai-admin-jqadm/src/Admin/JQAdm/Common/Decorator/Base.php(162): Aimeos\Admin\JQAdm\Order\Standard->search()
#14 /releases/60/packages/aimeos/aimeos-laravel/src/Controller/JqadmController.php(240): Aimeos\Admin\JQAdm\Common\Decorator\Base->search()
#15 /releases/60/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): Aimeos\Shop\Controller\JqadmController->searchAction('default', 'order')
#16 /releases/60/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('searchAction', Array)
#17 /releases/60/vendor/laravel/framework/src/Illuminate/Routing/Route.php(266): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Aimeos\Shop\Controller\JqadmController), 'searchAction')
#18 /releases/60/vendor/laravel/framework/src/Illuminate/Routing/Route.php(212): Illuminate\Routing\Route->runController()
#19 /releases/60/vendor/laravel/framework/src/Illuminate/Routing/Router.php(808): Illuminate\Routing\Route->run()
#20 /releases/60/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(170): Illuminate\Routing\Router->Illuminate\Routing\closure(Object(Illuminate\Http\Request))
#21 /releases/60/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(51): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#22 /releases/60/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#23 /releases/60/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(64): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#24 /releases/60/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
#25 /releases/60/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(88): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#26 /releases/60/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#27 /releases/60/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#28 /releases/60/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#29 /releases/60/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#30 /releases/60/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest(Object(Illuminate\Http\Request), Object(Illuminate\Session\Store), Object(Closure))
#31 /releases/60/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#32 /releases/60/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#33 /releases/60/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#34 /releases/60/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(75): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#35 /releases/60/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#36 /releases/60/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(127): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#37 /releases/60/vendor/laravel/framework/src/Illuminate/Routing/Router.php(807): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#38 /releases/60/vendor/laravel/framework/src/Illuminate/Routing/Router.php(786): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#39 /releases/60/vendor/laravel/framework/src/Illuminate/Routing/Router.php(750): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route))
#40 /releases/60/vendor/laravel/framework/src/Illuminate/Routing/Router.php(739): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#41 /releases/60/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(201): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#42 /releases/60/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(170): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\closure(Object(Illuminate\Http\Request))
#43 /releases/60/app/Http/Middleware/SetLocale.php(25): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#44 /releases/60/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\Http\Middleware\SetLocale->handle(Object(Illuminate\Http\Request), Object(Closure))
#45 /releases/60/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#46 /releases/60/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#47 /releases/60/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(Object(Illuminate\Http\Request), Object(Closure))
#48 /releases/60/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#49 /releases/60/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#50 /releases/60/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\Foundation\Http\Middleware\TrimStrings->handle(Object(Illuminate\Http\Request), Object(Closure))
#51 /releases/60/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#52 /releases/60/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure))
#53 /releases/60/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(110): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#54 /releases/60/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(Object(Illuminate\Http\Request), Object(Closure))
#55 /releases/60/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#56 /releases/60/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\Http\Middleware\HandleCors->handle(Object(Illuminate\Http\Request), Object(Closure))
#57 /releases/60/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#58 /releases/60/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\Http\Middleware\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
#59 /releases/60/app/Http/Middleware/TrustHosts.php(24): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#60 /releases/60/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\Http\Middleware\TrustHosts->handle(Object(Illuminate\Http\Request), Object(Closure))
#61 /releases/60/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(127): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#62 /releases/60/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#63 /releases/60/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#64 /releases/60/public/index.php(51): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#65 main

DNK · Post by **DNK** » 18 Jun 2025, 07:17

You have this error in your demo project too!

Post by **aimeos** » 19 Jun 2025, 14:54

Thanks for the bug report!
We can confirm the issue and are working on a solution which will be part of the next release.

Post by **aimeos** » 16 Jul 2025, 07:53

This has been fixed in the release last week

DNK · Post by **DNK** » 24 Jul 2025, 07:33

And which package is responsible for this error?
ai-admin-graphql
ai-admin-jqadm
ai-admin-jsonadm

Post by **aimeos** » 24 Jul 2025, 07:43

There had been changes in the aimeos/aimeos-base and aimeos/ai-admin-jqadm package

Help for Aimeos