why I got errors in log table

[ahmed31916]

Hello,

I rely on Aimeos as a package, so I built my own controllers using Aimeos methods, but I noticed that the log table shows errors on every page refresh, and these are some of that errors:

Code: Select all

Time: 0.78797340393066ms
Class: Aimeos\MShop\Customer\Manager\Group\Laravel
SELECT 
mcusgr."id" AS "customer.group.id", mcusgr."siteid" AS "customer.group.siteid",
mcusgr."code" AS "customer.group.code", mcusgr."label" AS "customer.group.label",
mcusgr."mtime" AS "customer.group.mtime", mcusgr."editor" AS "customer.group.editor",
mcusgr."ctime" AS "customer.group.ctime"
FROM "mshop_customer_group" mcusgr
WHERE ( ( mcusgr."siteid" IN ('','1.') ) AND mcusgr."id" IN (NULL) )
ORDER BY mcusgr."id" ASC
LIMIT 100 OFFSET 0

Code: Select all

Missing required parameter for [Route: aimeos_shop_count] [URI: shop/{site}/count] [Missing parameter: site].
#0 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Routing\RouteUrlGenerator.php(90): Illuminate\Routing\Exceptions\UrlGenerationException::forMissingParameters(Object(Illuminate\Routing\Route), Array)
#1 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Routing\UrlGenerator.php(488): Illuminate\Routing\RouteUrlGenerator->to(Object(Illuminate\Routing\Route), Array, false)
#2 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Routing\UrlGenerator.php(463): Illuminate\Routing\UrlGenerator->toRoute(Object(Illuminate\Routing\Route), Array, false)
#3 C:\xampp\htdocs\WomenStore\vendor\aimeos\ai-laravel\src\Base\View\Helper\Url\Laravel.php(62): Illuminate\Routing\UrlGenerator->route('aimeos_shop_cou...', Array, false)
#4 [internal function]: Aimeos\Base\View\Helper\Url\Laravel->transform('aimeos_shop_cou...', 'Catalog', 'count', Array, Array, Array)
#5 C:\xampp\htdocs\WomenStore\vendor\aimeos\aimeos-base\src\View\Standard.php(87): call_user_func_array(Array, Array)
#6 C:\xampp\htdocs\WomenStore\vendor\aimeos\aimeos-base\src\View\Helper\Link\Standard.php(47): Aimeos\Base\View\Standard->__call('url', Array)
#7 [internal function]: Aimeos\Base\View\Helper\Link\Standard->transform('client/html/cat...', Array)
#8 C:\xampp\htdocs\WomenStore\vendor\aimeos\aimeos-base\src\View\Standard.php(87): call_user_func_array(Array, Array)
#9 C:\xampp\htdocs\WomenStore\vendor\aimeos\ai-client-html\src\Client\Html\Catalog\Filter\Standard.php(492): Aimeos\Base\View\Standard->__call('link', Array)
#10 C:\xampp\htdocs\WomenStore\vendor\aimeos\ai-client-html\src\Client\Html\Common\Decorator\Base.php(67): Aimeos\Client\Html\Catalog\Filter\Standard->data(Object(Aimeos\Base\View\Standard), Array, NULL)
#11 C:\xampp\htdocs\WomenStore\vendor\aimeos\ai-client-html\src\Client\Html\Common\Decorator\Context.php(48): Aimeos\Client\Html\Common\Decorator\Base->data(Object(Aimeos\Base\View\Standard), Array, NULL)
#12 C:\xampp\htdocs\WomenStore\vendor\aimeos\ai-client-html\src\Client\Html\Catalog\Filter\Standard.php(249): Aimeos\Client\Html\Common\Decorator\Context->data(Object(Aimeos\Base\View\Standard), Array, NULL)
#13 C:\xampp\htdocs\WomenStore\vendor\aimeos\ai-client-html\src\Client\Html\Common\Decorator\Exceptions.php(73): Aimeos\Client\Html\Catalog\Filter\Standard->header('')
#14 C:\xampp\htdocs\WomenStore\vendor\aimeos\ai-client-html\src\Client\Html\Common\Decorator\Base.php(92): Aimeos\Client\Html\Common\Decorator\Exceptions->header('')
#15 C:\xampp\htdocs\WomenStore\vendor\aimeos\aimeos-laravel\src\Aimeos\Shop\Controller\PageController.php(38): Aimeos\Client\Html\Common\Decorator\Base->header()
#16 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Routing\Controller.php(54): Aimeos\Shop\Controller\PageController->indexAction('js/plugins/font...')
#17 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction('indexAction', Array)
#18 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Routing\Route.php(261): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Aimeos\Shop\Controller\PageController), 'indexAction')
#19 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Routing\Route.php(204): Illuminate\Routing\Route->runController()
#20 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Routing\Router.php(725): Illuminate\Routing\Route->run()
#21 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(141): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#22 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Routing\Middleware\SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#23 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#24 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#25 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#26 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\View\Middleware\ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#27 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#28 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#29 C:\xampp\htdocs\WomenStore\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))
#30 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#31 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#32 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#33 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#34 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#35 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#36 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Routing\Router.php(726): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#37 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Routing\Router.php(703): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#38 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Routing\Router.php(667): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route))
#39 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Routing\Router.php(656): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#40 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(167): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#41 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(141): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#42 C:\xampp\htdocs\WomenStore\app\Http\Middleware\SetLocale.php(25): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#43 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): App\Http\Middleware\SetLocale->handle(Object(Illuminate\Http\Request), Object(Closure))
#44 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#45 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#46 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(Object(Illuminate\Http\Request), Object(Closure))
#47 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#48 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#49 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Foundation\Http\Middleware\TrimStrings->handle(Object(Illuminate\Http\Request), Object(Closure))
#50 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#51 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure))
#52 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance.php(86): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#53 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(Object(Illuminate\Http\Request), Object(Closure))
#54 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Http\Middleware\HandleCors.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#55 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Http\Middleware\HandleCors->handle(Object(Illuminate\Http\Request), Object(Closure))
#56 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Http\Middleware\TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#57 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Http\Middleware\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
#58 C:\xampp\htdocs\WomenStore\app\Http\Middleware\TrustHosts.php(24): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#59 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): App\Http\Middleware\TrustHosts->handle(Object(Illuminate\Http\Request), Object(Closure))
#60 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#61 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(142): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#62 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(111): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#63 C:\xampp\htdocs\WomenStore\public\index.php(52): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#64 C:\xampp\htdocs\WomenStore\vendor\laravel\framework\src\Illuminate\Foundation\resources\server.php(16): require_once('C:\\xampp\\htdocs...')
#65 {main}

Code: Select all

Plugin::register: Aimeos\MShop\Plugin\Provider\Order\AddressesAvailable

Code: Select all

Time: 1.431941986084ms
Class: Aimeos\MShop\Locale\Manager\Standard
SELECT mloc."pos", 
mloc."id" AS "locale.id", mloc."siteid" AS "locale.siteid", mloc."site_id",
mloc."langid" AS "locale.languageid", mloc."currencyid" AS "locale.currencyid",
mloc."pos" AS "locale.position", mloc."status" AS "locale.status",
mloc."mtime" AS "locale.mtime", mloc."editor" AS "locale.editor",
mloc."ctime" AS "locale.ctime"
FROM "mshop_locale" mloc
LEFT JOIN "mshop_locale_site" mlocsi ON (mloc."site_id" = mlocsi."id")
LEFT JOIN "mshop_locale_language" mlocla ON (mloc."langid" = mlocla."id")
LEFT JOIN "mshop_locale_currency" mloccu ON (mloc."currencyid" = mloccu."id")
WHERE ( mloc."siteid" = '1.' AND mloc."langid" IN ('en') AND ( ( mloc."status" = 1 ) AND 1 = 1 ) AND mloccu."status" > 0 AND mlocla."status" > 0 AND mlocsi."status" > 0 )
GROUP BY mloc."pos",  mloc."id"
ORDER BY mloc."pos" ASC
LIMIT 100 OFFSET 0

[aimeos]

The 1.), 3.) and 4.) output is debug output because you've set the loglevel to 7 in your ./config/shop.php.
The 2.) is an error due to a missing value for the mandatory {site} parameter because you configured Aimeos as a multi-site setup but somewhere the value for the site parameter got lost

[ahmed31916]

thank you very much