1

After migrating our Magento 1 site to Magento 2 we're getting this error when we try place an order

Order saving error: SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name '', query was: INSERT INTO `` () VALUES ()

We've looked around but there seems to be no clear solution to this.

  • Which magento version are u using? – Navin Bhudiya Jan 19 '18 at 7:50
  • It seems table missing form databaase – Navin Bhudiya Jan 19 '18 at 7:50
3

Please check below tables in the database (number of tables depends as per stores/websites) :

sequence_invoice_1, sales_sequence_meta, sales_sequence_profile

May be this will fix the issue when placing order.

| improve this answer | |
1

Finally resolved the issue.

Had to open and save each store view as there were missing tables for the storeview(s). This generated the missing tables and I was able to place an order.

| improve this answer | |
1

There is two Method :

1) Firstly check the store id of your website then check the table in databases sales_sequence_profile, sales_sequence_meta
If table have missing or table not save the data with current store id.

You can use the below link :

https://minhducnho.wordpress.com/2017/10/24/magento-2-fixed-error-when-place-order-sqlstate42000-syntax-error-or-access-violation-1103-incorrect-table-name/

2) Direct download the module and install it

https://github.com/joeshelton-wagento/fixsalessequence

bin/magento wagento:fixsalessequence --all

| improve this answer | |
0

You can edit your entire store and without any change save it. Then flush your cache. After that, you can see the entire entry of the store in sales_sequence_meta table. Issue resolved now you can place an order. Thanks :)

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.