search

OFFLINE-GmbH / oc-snipcartshop-plugin

Ecommerce solution for October CMS using snipcart.com as a backend
MIT License
11 stars 4 forks source link

SQLSTATE[42S02]: Base table or view not found #24

Closed leohner closed 5 years ago

leohner commented 6 years ago

Hello,

When I try installing the plugin, I get the following error. I've seen that not having MySQL 5.7.8 can cause the issue, but I cannot update it as my host doesn't support it.

It's odd because I've had it working in the past on a different site, although that was months ago. I really appreciate any help!

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'armuli73_axolandfriends.offline_snipcartshop_products' doesn't exist (SQL: select offline_snipcartshop_products.*, (select group_concat(name separator ', ') from offline_snipcartshop_categories inner join offline_snipcartshop_category_product on offline_snipcartshop_categories.id = offline_snipcartshop_category_product.category_id where offline_snipcartshop_products.id = offline_snipcartshop_category_product.product_id) as categories from offline_snipcartshop_products order by name asc)

tobias-kuendig commented 6 years ago

Was the installation successful? Does the table offline_snipcartshop_products exist in your database? Have you checked your system.log file after the installation?

To me it looks like there should have been an error while migrating your database. Do you have console acccess? You might want to run php artisan october:up again.

leohner commented 6 years ago

After the first installation, that table was created. But the error was the same, so I deleted the plugin files and dropped the tables to do a fresh install.

The log file confirms the lack of table:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'armuli73_axolandfriends.offline_snipcartshop_products' doesn't exist in /home/armuli73/domains/axolandfriends/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:77

I'm at work at the moment, but I'll run php artistan october:up when I get home. Hopefully that works.

I really appreciate your quick reply and the wonderful plugins you make!

leohner commented 6 years ago

So, attempting to reinstall the plugin doesn't recreate the database tables.

When I try running php artisan october:up, I get the same error.

I appreciate any insight you can give! Thank you!

tobias-kuendig commented 6 years ago

Do you have any offline_snipcartshop tables in your database? Have you tried to uninstall and reinstall the plugin via the backend settings?

leohner commented 6 years ago

The database doesn't have any offline_snipcartshop tables in the database. Uninstalling and reinstalling the plugin doesn't add them to the db either.

tobias-kuendig commented 6 years ago

What does your system.log say? It shoudn't be possible that the plugin installs without any errors. Check your system.log and if there are any errors post them here so I can see the stack trace.

leohner commented 6 years ago

Thank you for all of your help! Here's the stack trace: 

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'json null, `shipping_address` json null, `credit_card_last4_digits` varchar(4) n' at line 1 in /home/armuli73/domains/axolandfriends/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:77
Stack trace:
#0 /home/armuli73/domains/axolandfriends/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(77): PDO->prepare('create table `o...', Array)
#1 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Connection.php(452): Doctrine\DBAL\Driver\PDOConnection->prepare('create table `o...')
#2 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Connection.php(657): Illuminate\Database\Connection->Illuminate\Database\{closure}('create table `o...', Array)
#3 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('create table `o...', Array, Object(Closure))
#4 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Connection.php(459): Illuminate\Database\Connection->run('create table `o...', Array, Object(Closure))
#5 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(86): Illuminate\Database\Connection->statement('create table `o...')
#6 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(252): Illuminate\Database\Schema\Blueprint->build(Object(October\Rain\Database\Connections\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#7 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(165): Illuminate\Database\Schema\Builder->build(Object(October\Rain\Database\Schema\Blueprint))
#8 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\Database\Schema\Builder->create('offline_snipcar...', Object(Closure))
#9 /home/armuli73/domains/axolandfriends/plugins/offline/snipcartshop/updates/builder_table_create_offline_snipcartshop_orders.php(56): Illuminate\Support\Facades\Facade::__callStatic('create', Array)
#10 /home/armuli73/domains/axolandfriends/vendor/october/rain/src/Database/Updater.php(35): OFFLINE\SnipcartShop\Updates\BuilderTableCreateOfflineSnipcartshopOrders->up()
#11 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(29): October\Rain\Database\Updater->October\Rain\Database\{closure}(Object(October\Rain\Database\Connections\MySqlConnection))
#12 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(327): Illuminate\Database\Connection->transaction(Object(Closure))
#13 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\Database\DatabaseManager->__call('transaction', Array)
#14 /home/armuli73/domains/axolandfriends/vendor/october/rain/src/Database/Updater.php(40): Illuminate\Support\Facades\Facade::__callStatic('transaction', Array)
#15 /home/armuli73/domains/axolandfriends/modules/system/classes/VersionManager.php(397): October\Rain\Database\Updater->setUp('/home/armuli73/...')
#16 /home/armuli73/domains/axolandfriends/modules/system/classes/VersionManager.php(146): System\Classes\VersionManager->applyDatabaseScript('OFFLINE.Snipcar...', '1.0.1', 'builder_table_c...')
#17 /home/armuli73/domains/axolandfriends/modules/system/classes/VersionManager.php(99): System\Classes\VersionManager->applyPluginUpdate('OFFLINE.Snipcar...', '1.0.1', Array)
#18 /home/armuli73/domains/axolandfriends/modules/system/classes/UpdateManager.php(519): System\Classes\VersionManager->updatePlugin(Object(OFFLINE\SnipcartShop\Plugin))
#19 /home/armuli73/domains/axolandfriends/modules/system/classes/UpdateManager.php(155): System\Classes\UpdateManager->updatePlugin('OFFLINE.Snipcar...')
#20 /home/armuli73/domains/axolandfriends/modules/system/controllers/Updates.php(305): System\Classes\UpdateManager->update()
#21 [internal function]: System\Controllers\Updates->onExecuteStep()
#22 /home/armuli73/domains/axolandfriends/modules/backend/classes/Controller.php(536): call_user_func_array(Array, Array)
#23 /home/armuli73/domains/axolandfriends/modules/backend/classes/Controller.php(419): Backend\Classes\Controller->runAjaxHandler('onExecuteStep')
#24 /home/armuli73/domains/axolandfriends/modules/backend/classes/Controller.php(229): Backend\Classes\Controller->execAjaxHandlers()
#25 /home/armuli73/domains/axolandfriends/modules/backend/classes/BackendController.php(95): Backend\Classes\Controller->run('install', Array)
#26 [internal function]: Backend\Classes\BackendController->run('system/updates/...')
#27 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array)
#28 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction('run', Array)
#29 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Route.php(212): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Backend\Classes\BackendController), 'run')
#30 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Route.php(169): Illuminate\Routing\Route->runController()
#31 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\Routing\Route->run()
#32 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#33 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#34 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#35 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#36 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#37 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#38 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#39 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#40 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#41 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#42 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#43 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#44 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#45 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#46 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#47 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#48 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#49 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Router.php(660): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#50 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Router.php(635): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#51 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Router.php(601): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route))
#52 /home/armuli73/domains/axolandfriends/vendor/october/rain/src/Router/CoreRouter.php(20): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#53 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): October\Rain\Router\CoreRouter->dispatch(Object(Illuminate\Http\Request))
#54 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#55 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#56 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#57 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#58 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#59 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#60 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#61 /home/armuli73/domains/axolandfriends/index.php(43): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#62 {main}
Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'json null, `shipping_address` json null, `credit_card_last4_digits` varchar(4) n' at line 1 in /home/armuli73/domains/axolandfriends/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:79
Stack trace:
#0 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Connection.php(452): Doctrine\DBAL\Driver\PDOConnection->prepare('create table `o...')
#1 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Connection.php(657): Illuminate\Database\Connection->Illuminate\Database\{closure}('create table `o...', Array)
#2 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('create table `o...', Array, Object(Closure))
#3 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Connection.php(459): Illuminate\Database\Connection->run('create table `o...', Array, Object(Closure))
#4 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(86): Illuminate\Database\Connection->statement('create table `o...')
#5 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(252): Illuminate\Database\Schema\Blueprint->build(Object(October\Rain\Database\Connections\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#6 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(165): Illuminate\Database\Schema\Builder->build(Object(October\Rain\Database\Schema\Blueprint))
#7 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\Database\Schema\Builder->create('offline_snipcar...', Object(Closure))
#8 /home/armuli73/domains/axolandfriends/plugins/offline/snipcartshop/updates/builder_table_create_offline_snipcartshop_orders.php(56): Illuminate\Support\Facades\Facade::__callStatic('create', Array)
#9 /home/armuli73/domains/axolandfriends/vendor/october/rain/src/Database/Updater.php(35): OFFLINE\SnipcartShop\Updates\BuilderTableCreateOfflineSnipcartshopOrders->up()
#10 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(29): October\Rain\Database\Updater->October\Rain\Database\{closure}(Object(October\Rain\Database\Connections\MySqlConnection))
#11 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(327): Illuminate\Database\Connection->transaction(Object(Closure))
#12 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\Database\DatabaseManager->__call('transaction', Array)
#13 /home/armuli73/domains/axolandfriends/vendor/october/rain/src/Database/Updater.php(40): Illuminate\Support\Facades\Facade::__callStatic('transaction', Array)
#14 /home/armuli73/domains/axolandfriends/modules/system/classes/VersionManager.php(397): October\Rain\Database\Updater->setUp('/home/armuli73/...')
#15 /home/armuli73/domains/axolandfriends/modules/system/classes/VersionManager.php(146): System\Classes\VersionManager->applyDatabaseScript('OFFLINE.Snipcar...', '1.0.1', 'builder_table_c...')
#16 /home/armuli73/domains/axolandfriends/modules/system/classes/VersionManager.php(99): System\Classes\VersionManager->applyPluginUpdate('OFFLINE.Snipcar...', '1.0.1', Array)
#17 /home/armuli73/domains/axolandfriends/modules/system/classes/UpdateManager.php(519): System\Classes\VersionManager->updatePlugin(Object(OFFLINE\SnipcartShop\Plugin))
#18 /home/armuli73/domains/axolandfriends/modules/system/classes/UpdateManager.php(155): System\Classes\UpdateManager->updatePlugin('OFFLINE.Snipcar...')
#19 /home/armuli73/domains/axolandfriends/modules/system/controllers/Updates.php(305): System\Classes\UpdateManager->update()
#20 [internal function]: System\Controllers\Updates->onExecuteStep()
#21 /home/armuli73/domains/axolandfriends/modules/backend/classes/Controller.php(536): call_user_func_array(Array, Array)
#22 /home/armuli73/domains/axolandfriends/modules/backend/classes/Controller.php(419): Backend\Classes\Controller->runAjaxHandler('onExecuteStep')
#23 /home/armuli73/domains/axolandfriends/modules/backend/classes/Controller.php(229): Backend\Classes\Controller->execAjaxHandlers()
#24 /home/armuli73/domains/axolandfriends/modules/backend/classes/BackendController.php(95): Backend\Classes\Controller->run('install', Array)
#25 [internal function]: Backend\Classes\BackendController->run('system/updates/...')
#26 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array)
#27 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction('run', Array)
#28 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Route.php(212): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Backend\Classes\BackendController), 'run')
#29 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Route.php(169): Illuminate\Routing\Route->runController()
#30 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\Routing\Route->run()
#31 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#32 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#33 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#34 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#35 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#36 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#37 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#38 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#39 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#40 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#41 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#42 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#43 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#44 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#45 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#46 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#47 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#48 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Router.php(660): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#49 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Router.php(635): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#50 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Router.php(601): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route))
#51 /home/armuli73/domains/axolandfriends/vendor/october/rain/src/Router/CoreRouter.php(20): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#52 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): October\Rain\Router\CoreRouter->dispatch(Object(Illuminate\Http\Request))
#53 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#54 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#55 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#56 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#57 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#58 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#59 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#60 /home/armuli73/domains/axolandfriends/index.php(43): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#61 {main}
Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'json null, `shipping_address` json null, `credit_card_last4_digits` varchar(4) n' at line 1 (SQL: create table `offline_snipcartshop_orders` (`id` int unsigned not null auto_increment primary key, `token` char(36) not null, `invoice_number` varchar(255) null, `currency` varchar(255) null, `creation_date` timestamp null, `modification_date` timestamp null, `completion_date` timestamp null, `status` varchar(255) null, `payment_status` varchar(255) null, `email` varchar(255) null, `will_be_paid_later` tinyint(1) null, `shipping_address_same_as_billing` tinyint(1) null, `billing_address` json null, `shipping_address` json null, `credit_card_last4_digits` varchar(4) null, `tracking_number` varchar(255) null, `tracking_url` varchar(255) null, `shipping_fees` varchar(255) null, `shipping_provider` varchar(255) null, `shipping_method` varchar(255) null, `card_holder_name` varchar(255) null, `card_type` varchar(255) null, `payment_method` varchar(255) null, `payment_gateway_used` varchar(255) null, `tax_provider` varchar(255) null, `lang` varchar(255) not null, `refunds_amount` double(8, 2) null, `adjusted_amount` double(8, 2) null, `rebate_amount` double(8, 2) null, `taxes` json null, `items_total` double(8, 2) null, `subtotal` double(8, 2) null, `taxable_total` double(8, 2) null, `grand_total` double(8, 2) null, `total_weight` int null, `total_rebate_rate` int null, `notes` text null, `custom_fields` json null, `shipping_enabled` tinyint(1) null, `payment_transaction_id` varchar(255) null, `metadata` json null, `ip_address` varchar(255) null, `user_id` char(36) null) default character set utf8 collate utf8_unicode_ci engine = InnoDB) in /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
Stack trace:
#0 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('create table `o...', Array, Object(Closure))
#1 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Connection.php(459): Illuminate\Database\Connection->run('create table `o...', Array, Object(Closure))
#2 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(86): Illuminate\Database\Connection->statement('create table `o...')
#3 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(252): Illuminate\Database\Schema\Blueprint->build(Object(October\Rain\Database\Connections\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#4 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(165): Illuminate\Database\Schema\Builder->build(Object(October\Rain\Database\Schema\Blueprint))
#5 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\Database\Schema\Builder->create('offline_snipcar...', Object(Closure))
#6 /home/armuli73/domains/axolandfriends/plugins/offline/snipcartshop/updates/builder_table_create_offline_snipcartshop_orders.php(56): Illuminate\Support\Facades\Facade::__callStatic('create', Array)
#7 /home/armuli73/domains/axolandfriends/vendor/october/rain/src/Database/Updater.php(35): OFFLINE\SnipcartShop\Updates\BuilderTableCreateOfflineSnipcartshopOrders->up()
#8 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(29): October\Rain\Database\Updater->October\Rain\Database\{closure}(Object(October\Rain\Database\Connections\MySqlConnection))
#9 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(327): Illuminate\Database\Connection->transaction(Object(Closure))
#10 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\Database\DatabaseManager->__call('transaction', Array)
#11 /home/armuli73/domains/axolandfriends/vendor/october/rain/src/Database/Updater.php(40): Illuminate\Support\Facades\Facade::__callStatic('transaction', Array)
#12 /home/armuli73/domains/axolandfriends/modules/system/classes/VersionManager.php(397): October\Rain\Database\Updater->setUp('/home/armuli73/...')
#13 /home/armuli73/domains/axolandfriends/modules/system/classes/VersionManager.php(146): System\Classes\VersionManager->applyDatabaseScript('OFFLINE.Snipcar...', '1.0.1', 'builder_table_c...')
#14 /home/armuli73/domains/axolandfriends/modules/system/classes/VersionManager.php(99): System\Classes\VersionManager->applyPluginUpdate('OFFLINE.Snipcar...', '1.0.1', Array)
#15 /home/armuli73/domains/axolandfriends/modules/system/classes/UpdateManager.php(519): System\Classes\VersionManager->updatePlugin(Object(OFFLINE\SnipcartShop\Plugin))
#16 /home/armuli73/domains/axolandfriends/modules/system/classes/UpdateManager.php(155): System\Classes\UpdateManager->updatePlugin('OFFLINE.Snipcar...')
#17 /home/armuli73/domains/axolandfriends/modules/system/controllers/Updates.php(305): System\Classes\UpdateManager->update()
#18 [internal function]: System\Controllers\Updates->onExecuteStep()
#19 /home/armuli73/domains/axolandfriends/modules/backend/classes/Controller.php(536): call_user_func_array(Array, Array)
#20 /home/armuli73/domains/axolandfriends/modules/backend/classes/Controller.php(419): Backend\Classes\Controller->runAjaxHandler('onExecuteStep')
#21 /home/armuli73/domains/axolandfriends/modules/backend/classes/Controller.php(229): Backend\Classes\Controller->execAjaxHandlers()
#22 /home/armuli73/domains/axolandfriends/modules/backend/classes/BackendController.php(95): Backend\Classes\Controller->run('install', Array)
#23 [internal function]: Backend\Classes\BackendController->run('system/updates/...')
#24 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array)
#25 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction('run', Array)
#26 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Route.php(212): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Backend\Classes\BackendController), 'run')
#27 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Route.php(169): Illuminate\Routing\Route->runController()
#28 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\Routing\Route->run()
#29 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#30 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#31 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#32 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#33 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#34 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#35 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#36 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#37 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#38 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#39 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#40 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#41 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#42 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#43 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#44 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#45 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#46 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Router.php(660): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#47 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Router.php(635): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#48 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Router.php(601): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route))
#49 /home/armuli73/domains/axolandfriends/vendor/october/rain/src/Router/CoreRouter.php(20): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#50 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): October\Rain\Router\CoreRouter->dispatch(Object(Illuminate\Http\Request))
#51 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#52 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#53 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#54 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#55 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#56 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#57 /home/armuli73/domains/axolandfriends/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#58 /home/armuli73/domains/axolandfriends/index.php(43): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#59 {main}
tobias-kuendig commented 6 years ago

The problem is that your MySQL version doesn not support JSON column types. Sinces this feature is causing more harm than good I changed the column types to TEXT for all new installations in version 1.0.39.

Try to properly remove the SnipcartShop plugin and reinstall the latest version. It should work now.

tobias-kuendig commented 5 years ago

Closed due to inactivity.