Hi there,
In the checkout during step 2: Review and payements I have an error.
I checked the logs ad it says :
SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ”, query was: INSERT INTO “ () VALUES () {“exception”:”[object] (Zend_Db_Statement_Exception(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ”, query was: INSERT INTO “ () VALUES () at /var/www/vhosts/dev.swissisgood.ch/httpdocs/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:235, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ” at /var/www/vhosts/dev.swissisgood.ch/httpdocs/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:228)”} []
Do you know if it’s related to the migration or not?
Thanks in advance for your help
Best Regards
2 answers
Hi there,
INSERT INTO “ () VALUES () {“exception”:”[object] (Zend_Db_Statement_Exception(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ”, query was: INSERT INTO “ () VALUES () at
That because the sales meta data tables was missing on migrated Store views. To solve that issue, for each store view migrated, let’s open it and click to save button in back-end.
Regards,
Mall.
Hi Mall,
Worked perfectly! Thanks a lot.
Best Regards
This question is now closed