Mryntu

Magento 2 when place order from newly created store,
after click on place order button below error is dispaly,

Syntax error or access violation: 1103 Incorrect table name '', query was: INSERT INTO `` () VALUES ()

And stop place order functionality.

if you have created your store programmatically you have to dispatch an event add_store with your store model in parameter.

$this->eventManager->dispatch('store_add', ['store' => $storeModel]);

If you look MagentoSalesSequenceObserverSequenceCreatorObserver , this observer is called for the add_storeevent

It will insert some data related to your store in sales_sequence_meta table

this issues you got when you try insert new row to a table relation ship to sequence auto generate .
to resolve this issues , please see in table "sales_sequence_meta" with "entity_type" = "order" , check and make sure this entity_type = "order" exist on all your stores . Insert new one if you check it missed for any store id .

meta_id | entity_type | store_id | sequence_table

1 | order | 0 | sequence_order_0

I think Magento 2 not installed properly. So if possible try to reinstall latest updated version and after that first of all clear cache & do indexing. Its working properly from my setup.

In various circumstances, Magento does not create sales sequence tables for a store. These are tables where order increment IDs, shipment increment IDs, etc are created. So, checkout fails when trying to assign an increment ID to a new order. Example tables:

sequence_creditmemo_1
sequence_invoice_1
sequence_order_1
sequence_rma_1
sequence_shipment_1

Here is a module for a Magento CLI command that will create missing sales sequence tables for a given store:
https://github.com/joeshelton-wagento/fixsalessequence

Blockquote
Here is a module for a Magento CLI command that will create missing sales sequence tables for a given store: https://github.com/joeshelton-wagento/fixsalessequence
Blockquote

Just curious how does one install the module you created, I tried to pull it down via composer (no go), I also tried to copy all files over to Magento2 with exception to composer.json.

I ran the command bin/magento wagento:fixsalessequence --all
It came back with There are no commands defined in the "wagento" namespace.

Looks like I'm having the same issue, I moved a site over today and while testing I'm hitting the same error.

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

Thanks for posting this module!