Problem while placing order

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} [] []

  1. I had found someone had asked same question here, https://github.com/magento/magento2/issues/12318

3 answers

Profile photo of Mall Staff 184060.00 $tone December 5, 2017
Public

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.
 

#1
Profile photo of ubdev Staff 98150.00 $tone December 5, 2017
Public

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

#3

Please login or Register to Submit Answer

Written By

Comments