We can't save the invoice right now Syntax error or access violation: 1103 Incorrect table name '', query was: INSERT INTO `` () VALUES ()

Unable to generate invoice in admin order view. i saw exception log then found this error

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

anyone have an idea for that

Solutions

I got the same error and after one day research I got the solution, this error comes because of some table entries are not found in tables - sales_sequence_meta and sales_sequence_profile, after migration, and off course here sales_sequence_meta represents some tables entries such as 'sequence_order_3', 'sequence_invoice_3', 'sequence_creditmemo_3', 'sequence_shipment_3' etc so if not found create them.

here, number represents store number,

check proper tables and entries as per store number if not found create and the error will be solved.

Tags: Magento 2.x / PHP

Similar questions

Show the saved value in admin form: right now it is now showing
I have an admin form that is saving the data to database but it is not showing the values from database once it saved: How i can show the value in this form so next time if i save some other values these value that are already in DB not be lost. Show Empty value in debug mood: Edit action from controller:
Insert, Update values in existing custom table and Select values from that table. Magento2
How can i Insert, Update values in existing custom table and Select values with Magento methods not sql requests ?
What is causing SQLSTATE[42000]: Syntax error or access violation: 1064 when trying to Group Tables?
I have been trying to figure out what is causing the exception when attempting to create a join for my Collections and group them with the main_table. Here is the code from my Collection.php The line that is giving me grief is: As it throws an error that I'm can't seem to fix If anyone knows the correct syntax to use please could you kindly advise ...
CE 1.9.1 - Syntax error or access violation 1064
I'm trying to resolve this issue that only occurs when I click any link in my menu. At first after clicking, I get an error page entitled There has been an error processing your request, but refreshes the same page after that renders the page it should. After inspecting the error number in /magentoroot/var/report I see the following stack trace whi...
SQLSTATE[42000]: Syntax error or access violation: 1064 When using Magento Search
We have encountered a big problem with Magento search since this morning. When some (not all) terms are searched for we get an SQL error: I don't know if this is relevant but the error only seems to occur when a term which is from one of the products added yesterday (the SKU, part of the product name etc.). I've tried reindexing but it's made no di...
SQL Syntax error or access violation: 1142 TRIGGER command denied to user
If I want to update a configurable product I do get an error message: I already checked the grants: Does anyone has an idea how to fix it? I ran out of ideas.

Also ask

We use cookies to deliver the best possible experience on our website. By continuing to use this site, accepting or closing this box, you consent to our use of cookies. To learn more, visit our privacy policy.