MariaDB 10.2.27 syntax error

How to configure and adapt Aimeos based shops as developer
Forum rules
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
User avatar
QuốcTrungNguyễnHoàng
Posts: 14
Joined: 06 Aug 2019, 03:22

MariaDB 10.2.27 syntax error

Post by QuốcTrungNguyễnHoàng » 21 Sep 2019, 04:28

I got some error when deploy aimeos project to hosting.

Code: Select all

Aimeos\MW\DB\Exception thrown with message "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"id" AS "locale.site.id", mlocsi."code" AS "locale.site.code",
                            mlocsi."la' at line 1"

Stacktrace:
#62 Aimeos\MW\DB\Exception in /home/osst5638/public_html/aloaladdin.vn/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/DB/Statement/DBAL/Simple.php:91
#61 Aimeos\MW\DB\Statement\DBAL\Simple:execute in /home/osst5638/public_html/aloaladdin.vn/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Locale/Manager/Site/Standard.php:902
#60 Aimeos\MShop\Locale\Manager\Site\Standard:getSearchResults in /home/osst5638/public_html/aloaladdin.vn/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Locale/Manager/Site/Standard.php:630
#59 Aimeos\MShop\Locale\Manager\Site\Standard:searchItems in /home/osst5638/public_html/aloaladdin.vn/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Base.php:475
#58 Aimeos\MShop\Common\Manager\Base:findItemBase in /home/osst5638/public_html/aloaladdin.vn/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Locale/Manager/Site/Standard.php:348
#57 Aimeos\MShop\Locale\Manager\Site\Standard:findItem in /home/osst5638/public_html/aloaladdin.vn/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Decorator/Base.php:126
#56 Aimeos\MShop\Common\Manager\Decorator\Base:findItem in /home/osst5638/public_html/aloaladdin.vn/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Locale/Manager/Standard.php:124
#55 Aimeos\MShop\Locale\Manager\Standard:bootstrap in /home/osst5638/public_html/aloaladdin.vn/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Decorator/Base.php:51
#54 call_user_func_array in /home/osst5638/public_html/aloaladdin.vn/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Decorator/Base.php:51
#53 Aimeos\MShop\Common\Manager\Decorator\Base:__call in /home/osst5638/public_html/aloaladdin.vn/vendor/aimeos/aimeos-laravel/src/Aimeos/Shop/Base/Locale.php:71
#52 Aimeos\Shop\Base\Locale:get in /home/osst5638/public_html/aloaladdin.vn/vendor/aimeos/aimeos-laravel/src/Aimeos/Shop/Base/Context.php:101
#51 Aimeos\Shop\Base\Context:get in /home/osst5638/public_html/aloaladdin.vn/app/Http/Controllers/HomeController.php:251
#50 App\Http\Controllers\HomeController:listAction in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
#49 call_user_func_array in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
#48 Illuminate\Routing\Controller:callAction in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
#47 Illuminate\Routing\ControllerDispatcher:dispatch in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
#46 Illuminate\Routing\Route:runController in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Route.php:169
#45 Illuminate\Routing\Route:run in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
#44 Illuminate\Routing\Router:Illuminate\Routing\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
#43 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:41
#42 Illuminate\Routing\Middleware\SubstituteBindings:handle in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
#41 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#40 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:68
#39 Illuminate\Foundation\Http\Middleware\VerifyCsrfToken:handle in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
#38 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#37 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
#36 Illuminate\View\Middleware\ShareErrorsFromSession:handle in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
#35 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#34 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63
#33 Illuminate\Session\Middleware\StartSession:handle in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
#32 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#31 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
#30 Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse:handle in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
#29 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#28 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
#27 Illuminate\Cookie\Middleware\EncryptCookies:handle in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
#26 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#25 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:102
#24 Illuminate\Pipeline\Pipeline:then in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Router.php:660
#23 Illuminate\Routing\Router:runRouteWithinStack in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Router.php:635
#22 Illuminate\Routing\Router:runRoute in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Router.php:601
#21 Illuminate\Routing\Router:dispatchToRoute in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Router.php:590
#20 Illuminate\Routing\Router:dispatch in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176
#19 Illuminate\Foundation\Http\Kernel:Illuminate\Foundation\Http\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
#18 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/fideloper/proxy/src/TrustProxies.php:56
#17 Fideloper\Proxy\TrustProxies:handle in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
#16 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#15 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:30
#14 Illuminate\Foundation\Http\Middleware\TransformsRequest:handle in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
#13 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#12 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:30
#11 Illuminate\Foundation\Http\Middleware\TransformsRequest:handle in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
#10 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#9 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
#8 Illuminate\Foundation\Http\Middleware\ValidatePostSize:handle in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
#7 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#6 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:46
#5 Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode:handle in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
#4 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#3 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:102
#2 Illuminate\Pipeline\Pipeline:then in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:151
#1 Illuminate\Foundation\Http\Kernel:sendRequestThroughRouter in /home/osst5638/public_html/aloaladdin.vn/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:116
#0 Illuminate\Foundation\Http\Kernel:handle in /home/osst5638/public_html/aloaladdin.vn/public/index.php:55
Please help me.
I'm use: aimeos/aimeos-laravel": "2018.10.* package and
Database Server version: 10.2.27-MariaDB-cll-lve - MariaDB Server

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

Re: MariaDB 10.2.27 syntax error

Post by aimeos » 21 Sep 2019, 07:54

Please make sure that your Aimeos database resource definition contains the "stmt" part with "SET SESSION sql_mode='ansi'; ..."
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply