After migrate successfully from magento 1.8 to magento 2.0, i’m unable to place order from other store(i have multiple store and for default checkout is working fine).
Everytime i got the below error in my log.
[2016-01-15 08:49:03] main.CRITICAL: exception ‘Zend_Db_Statement_Exception’ with message ‘Report ID: webapi-5698b27f9bb41; Message: SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ”, query was: INSERT INTO “ () VALUES ()’ in /var/www/html/magento20new/lib/internal/Magento/Framework/Webapi/ErrorProcessor.php:194
Stack trace:
#0 /var/www/html/magento20new/lib/internal/Magento/Framework/Webapi/ErrorProcessor.php(139): Magento\Framework\Webapi\ErrorProcessor->_critical(Object(Zend_Db_Statement_Exception))
#1 /var/www/html/magento20new/app/code/Magento/Webapi/Controller/Rest.php(163): Magento\Framework\Webapi\ErrorProcessor->maskException(Object(Zend_Db_Statement_Exception))
#2 /var/www/html/magento20new/var/generation/Magento/Webapi/Controller/Rest/Interceptor.php(24): Magento\Webapi\Controller\Rest->dispatch(Object(Magento\Framework\App\Request\Http))
#3 /var/www/html/magento20new/lib/internal/Magento/Framework/App/Http.php(115): Magento\Webapi\Controller\Rest\Interceptor->dispatch(Object(Magento\Framework\App\Request\Http))
#4 /var/www/html/magento20new/lib/internal/Magento/Framework/App/Bootstrap.php(258): Magento\Framework\App\Http->launch()
#5 /var/www/html/magento20new/index.php(39): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http))
#6 {main} [] []
Please help me asap. As i have to delivered the project to the client. So plz help me soon, so that i can resolve the issue.
Thanks
-
Adam Due ⋅10.00 $tone March 29, 2016
i'm so sorry about your problem, but you may take the help from technical team of #Litextension at http://litextension.com/contacts/ hope that your problems will be deal soon!
Adam Due ⋅10.00 $tone
March 29, 2016
34 answers
Hi Manish Singh
Please find the solution at here: https://github.com/ubertheme/module-ubdatamigration/issues/7#issuecomment-202425765
In case you want to use our service, let’s submit at: http://www.ubertheme.com/magento-custom-services/
Regards,
Mall.
Hello
Is this issue comes after migration or default magento 2.0 have this issue ??
Thanks
Hi Manish Singh,
This issue come after migration. This because has some new rules and work flow in sales module of Magento 2.
and in your case, you have multiple stores in database and it missing some needed tables exclude default store. This tables wasn’t exists in Magento 1 database and we have have to create this by tool or manual.
See more this: http://i.imgur.com/rkFvbC8.png
Let’s provide me the SSH credentials of your Magento 2. I will check further current your database migrated and tell you solution to solve this issue.
Best Regards,
Mall.
Hi Mall,
so can i create all table corresponding to store manually i.e. sequence_
Is we also need to do entry in ‘sales_sequence_meta’.??
Please let me know the step please.
Thanks for your help.
Hi Manish Singh,
Let’s provide me the SSH credentials of your Magento 2 in a ‘private reply’. I will check further and tell you solution by code.
Regards,
Mall.
Hi Manish Singh,
I have create a backup and edit the xml file at path: vendor/magento/module-sales/etc/events.xml
To solve the issues let’s do more some steps as below:
Step 1: delete all tables you have created manual.
Step 2: In Back-end of your site (Stores/All stores), view and make edit all Stores in your site (only click open and press ‘Save Store’ button). This task will auto generate some missing tables of sales module by ‘SequenceCreatorObserver’ plugin.
Step 3:
+ Flush the Magento 2 cache by command: bin/magento cache:flush
+ Reindex the Magento 2 database by command: bin/magento indexer:reindex
Do it and let’s me know how it goes.
Regards,
Mall.
Hi Manish Singh,
Did you do Step 2 as suggest with all Store Views in your Magento2?
Regards,
Mall.
Hi Manish Singh,
Yes I did it, but it not created any tables.
=> Let’s delete all folders at var/* and pub/static/* (exclude file .htaccess)
Right now it’s start with 000000001.
I’m sorry this working rules of Magento 2. See more this at: http://devdocs.magento.com/guides/v2.0/migration/migration-migrate-additional.html
Regards,
Mall.
Hey Mall,
Now I manually create all the table and do manual entry in table ‘sales_sequence_meta‘ and ‘sales_sequence_profile‘.
Now i’m able to place order successfully.
If it’s create problem in future then can i delete again all the table and then follow the step you told me or leave this as now it’s working fine.
Also regarding Order Increment ID, module-sales-sequence is responsible. I’m finding the way to change the increment id.
Thank you very much for your support.
Hi Manish Singh,
Yes, let’s contact me if you need further assistance!
Regards,
Mall.
I have the same problem after conversion. Can you tell me which tables to delete or make?
I have the same problem after conversion. Can you tell me which tables to delete or make?
To sole that issue, for each your Store Views migrated let’s open it and click to save button in back-end of your site.
Regards,
Mall.
Hi, I have similar problem with checkout , after successful migration with UBDataMigrationPro checkout doesn’t work, below log erro, please can you help us too?
Hi robinmaster,
below log erro,
I don’t see the log error as you mentioned. But let’s try open and re-save for each Store View migrated in back-end of your site.
Once done, let’s re-check the checkout function in front-end of your site. And tell me know how it goes.
Regards,
Mall.
Hello, Well our problem was similar and when processing the checkout with payment via paypal, after the recommended procedure the store returned to work the checkout in paypal. Well I thank for the quick support and help. I made the right choice, not only by the tool itself which did not give any error, but by the help and support that was very fast and functional.
Hi robinmaster,
Yeah, Let’s contact me if you need further assistance.
Regards,
Mall.
I have a little bit problem with checkout. After Migration New costumers are ok to make new orders, however older customers(thats represents about 55% of sales), has problem with this error: Failed to load resource: the server responded with a status of 400 ()
My checkout store are with 1 lines in configuration checkout, that solve new clients problems, but for old Clientes, remain with problem.
jquery.js:10254 POST https://magento2.eagletechz.com.br/rest/default_migrated/V1/carts/mine/payment-information 400 ()
Can you help us with any tips?
Hi robinmaster,
My checkout store are with 1 lines in configuration checkout, that solve new clients problems, but for old Clientes, remain with problem.
jquery.js:10254 POST https://magento2.eagletechz.com.br/rest/default_migrated/V1/carts/mine/payment-information 400 ()
So, kindly provide me the ssh credentials, web root path of your Magento2 and phpmyadmin credentials of your Magento2 database.
And provide me once customer credentials with that issue. I will check further and help you out.
Regards,
Mall.
Hi there,
Kindly provide me more once Customer credentials with issue as you mentioned.
Regards,
Mall.
Hi robinmaster,
Warning: include(HTMLPurifier_Printer.php): failed to open stream: No such file or directory in /var/www/clients/client0/web5/web/app/code/Ubert
heme/Ubdatamigration/lib/yii/YiiBase.php on line 432
That seem you have issue with folders and files permission during install upgrade of our tool. Let’s provide me the ssh credentials of your working now. I will check further and help you out.
Regards,
Mall.
Hi there,
in addition to the problem found in the checkout,….but about the tool and non-migration of new customers, for which I request help.
I am sorry for not catching your question in your last reply. Please help to confirm if the check out issue is still in place at your end? If there’s another issue, kindly advice me as well.
Regards,
Mall.
I am having this same issue , what’s the solution ? I have 3 different store view in my Magento 2 store but I only need 1
“Magento Order was not created. Reason: SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ”, query was: INSERT INTO “ () VALUES ()”
Hi fka200,
To solve the issue as you mentioned. For each Store View migrated, let’s open it and then click to save button in back-end of your site.
Regards,
Mall.
