Hello Team,
After data migration, i have noticed that new orders are not placed for some reason. I checked logs and found one strange behaviour. Have a look at error log, also let me know if you can guide me to fix it?
main.CRITICAL: Exception message: SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ”, query was: INSERT INTO “ () VALUES ()
Trace: #0 /home/tbsdev8/public_html/error/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(93): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/tbsdev8/public_html/error/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
#2 /home/tbsdev8/public_html/error/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/tbsdev8/public_html/error/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘INSERT INTO “ …’, Array)
#4 /home/tbsdev8/public_html/error/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(517): Zend_Db_Adapter_Pdo_Abstract->query(‘INSERT INTO “ …’, Array)
#5 /home/tbsdev8/public_html/error/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(580): Magento\Framework\DB\Adapter\Pdo\Mysql->_query(‘INSERT INTO “ …’, Array)
#6 /home/tbsdev8/public_html/error/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(576): Magento\Framework\DB\Adapter\Pdo\Mysql->query(‘INSERT INTO “ …’, Array)
#7 /home/tbsdev8/public_html/error/vendor/magento/module-sales-sequence/Model/Sequence.php(85): Zend_Db_Adapter_Abstract->insert(NULL, Array)
#8 /home/tbsdev8/public_html/error/vendor/magento/module-quote/Model/ResourceModel/Quote.php(172): Magento\SalesSequence\Model\Sequence->getNextValue()
#9 /home/tbsdev8/public_html/error/vendor/magento/module-quote/Model/Quote.php(2194): Magento\Quote\Model\ResourceModel\Quote->getReservedOrderId(Object(Magento\Quote\Model\Quote))
#10 /home/tbsdev8/public_html/error/vendor/magento/module-paypal/Model/Express/Checkout.php(495): Magento\Quote\Model\Quote->reserveOrderId()
#11 /home/tbsdev8/public_html/error/vendor/magento/module-paypal/Controller/Express/GetToken.php(183): Magento\Paypal\Model\Express\Checkout->start(‘http://www.tbs-…’, ‘http://www.tbs-…’, false)
#12 /home/tbsdev8/public_html/error/vendor/magento/module-paypal/Controller/Express/GetToken.php(93): Magento\Paypal\Controller\Express\GetToken->getToken()
#13 /home/tbsdev8/public_html/error/vendor/magento/framework/App/Action/Action.php(107): Magento\Paypal\Controller\Express\GetToken->execute()
#14 /home/tbsdev8/public_html/error/vendor/magento/framework/Interception/Interceptor.php(58): Magento\Framework\App\Action\Action->dispatch(Object(Magento\Framework\App\Request\Http))
#15 /home/tbsdev8/public_html/error/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Paypal\Controller\Express\GetToken\Interceptor->___callParent(‘dispatch’, Array)
#16 /home/tbsdev8/public_html/error/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Paypal\Controller\Express\GetToken\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Request\Http))
#17 /home/tbsdev8/public_html/error/generated/code/Magento/Paypal/Controller/Express/GetToken/Interceptor.php(26): Magento\Paypal\Controller\Express\GetToken\Interceptor->___callPlugins(‘dispatch’, Array, Array)
#18 /home/tbsdev8/public_html/error/vendor/magento/framework/App/FrontController.php(55): Magento\Paypal\Controller\Express\GetToken\Interceptor->dispatch(Object(Magento\Framework\App\Request\Http))
#19 /home/tbsdev8/public_html/error/vendor/magento/framework/Interception/Interceptor.php(58): Magento\Framework\App\FrontController->dispatch(Object(Magento\Framework\App\Request\Http))
#20 /home/tbsdev8/public_html/error/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Framework\App\FrontController\Interceptor->___callParent(‘dispatch’, Array)
#21 /home/tbsdev8/public_html/error/vendor/magento/module-store/App/FrontController/Plugin/RequestPreprocessor.php(94): Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Request\Http))
#22 /home/tbsdev8/public_html/error/vendor/magento/framework/Interception/Interceptor.php(135): Magento\Store\App\FrontController\Plugin\RequestPreprocessor->aroundDispatch(Object(Magento\Framework\App\FrontController\Interceptor), Object(Closure), Object(Magento\Framework\App\Request\Http))
#23 /home/tbsdev8/public_html/error/app/code/Amasty/GeoipRedirect/Plugin/Action.php(127): Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Request\Http))
#24 /home/tbsdev8/public_html/error/vendor/magento/framework/Interception/Interceptor.php(135): Amasty\GeoipRedirect\Plugin\Action->aroundDispatch(Object(Magento\Framework\App\FrontController\Interceptor), Object(Closure), Object(Magento\Framework\App\Request\Http))
#25 /home/tbsdev8/public_html/error/vendor/magento/module-page-cache/Model/App/FrontController/BuiltinPlugin.php(73): Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Request\Http))
#26 /home/tbsdev8/public_html/error/vendor/magento/framework/Interception/Interceptor.php(135): Magento\PageCache\Model\App\FrontController\BuiltinPlugin->aroundDispatch(Object(Magento\Framework\App\FrontController\Interceptor), Object(Closure), Object(Magento\Framework\App\Request\Http))
#27 /home/tbsdev8/public_html/error/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Request\Http))
#28 /home/tbsdev8/public_html/error/generated/code/Magento/Framework/App/FrontController/Interceptor.php(26): Magento\Framework\App\FrontController\Interceptor->___callPlugins(‘dispatch’, Array, NULL)
#29 /home/tbsdev8/public_html/error/vendor/magento/framework/App/Http.php(135): Magento\Framework\App\FrontController\Interceptor->dispatch(Object(Magento\Framework\App\Request\Http))
#30 /home/tbsdev8/public_html/error/vendor/magento/framework/App/Bootstrap.php(256): Magento\Framework\App\Http->launch()
#31 /home/tbsdev8/public_html/error/index.php(39): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http))
#32 {main} [] []
-
I had found someone had asked same question here, https://github.com/magento/magento2/issues/12318
3 answers
Hi there,
main.CRITICAL: Exception message: SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ”, query was: INSERT INTO “ () VALUES ()
Trace: #0
To solve that issue, for each Store views migrated, let’s open it and click to save button in back-end of your site.
Pls: For migrated data ready to use, please do full steps as indicated in the guide of our tool in Readme.html
Regards,
Mall.
Thanks.. it worked…
Hi Mayur Upasani,
Glad that it helps. We have the ticket closed for now. For additional question, please submit a new ticket, we will get back to you then.
Regards,
Ubertheme team