An internal database error occurred when saving updating the profile

6854933580_2c8b688306_z

| NULL | 1 | 1 | 4294967295 | 4294966295 | 1 | ------------ --------- -------- -------- ------------- ------ ------------ --------------- ----------- 12 rows in set (0.00 sec) For each store there should be one set of tables and profiles! @Serhiy Shkolyarenko as mentioned above my store id = 2 but the strange thing is I only have 1 shop? | 11 | order | 2 | sequence_order_2 | | 12 | invoice | 2 | sequence_invoice_2| | 13 | creditmemo | 2 | sequence_creditmemo_2 | | 14 | shipment | 2 | sequence_shipment_2 | | 15 | rma_item | 2 | sequence_rma_item_2 | | 11 | order | 2 | sequence_order_2 | | 12 | invoice | 2 | sequence_invoice_2| | 13 | creditmemo | 2 | sequence_creditmemo_2 | | 14 | shipment | 2 | sequence_shipment_2 | | 15 | rma_item | 2 | sequence_rma_item_2 | ^^^^^^^^^^ YES ^^^^^^^^^^^^^^ But hwo would that be for the sales_sequence_profile than? The funny thing is that all orders are generated, Emails are send.

I noticed: the table eav_entity_store is empty, tables sequence_order_0, sequence_order_2 and sequence_order_3 (I added _2 and _3) are empty.

If you set the value to 1 in the admin panel customers with 1 address line can then checkout but with existing customers who have filled in 2 lines the problem again happens. Thanks in advance Dan @prasannanwr please provide exact steps you do and specify payment and shipment methods you use. When you go to place an order you get the error originally posted here in the last stage. I have skipped City field on checkout because we don't need city on address. I tried changing address line to 1 and it started working...

Is the problem present for Cash on Delivery payment method only or for others as well? Was it upgrade from some previous version or clear Magento install? If you change the admin value to 1 (which was a temporary fix for 2.1) the error occurs with customers who have 2 address lines filled in. not sure how many customers had addresses that are 2 lines... Maybe someone can figure out a sql query that could concatenate addresses in the database that were using 2 lines?

The shipping method is Free shipping and the payment method is Cash on delivery. I don't really know how to move forward from this...

maybe ditch magento and go with shopify, foxy.io, hell, even woocommerce would be a step up at this point with all the issues magento2 has...

I am using Filezilla to upload my work to the server. Or are there certain files that are not needed on the server ? By the way, how many web.configs do I need to have on the server ? [ web.config, web.debug.config, web.release.config ] Also now when I try loggin in, I get a different error: Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Sql Exception: Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path.

It does seem like your web.config still has reference to the attached file and is not getting the details from the database you have restored.

We upgraded to magento 2.1.1 and are facing checkout issues associated with he number of address lines a customer has. But after when I runned system upgrade and compiled, I got this error I guess but not sure. To replicate the same bug on our website and little more info please see below. I CAN say, that given the bugs in this version, there is no way I will get a license for EE. Bugs on adding items into the catalog I had to circumvent myself. Im using live transactions, Im in production mode (Just switched lastnight) Shipping&Handling is 0 (for local pickup & delivery).

If a customer has only 1 address line filled in and the default setting is 2 the error occurs. The same error as posted here is happening with us. We are also experiencing the same issues as documented here which is looks like this is repeated to: #4921 Within the admin panel set the address lines for customers to 2: Stores Name and Address Options: Number of Lines in a Street Address make it 2 Then register a new customer but only fill in one address line. This software should have been well vetted before you release a buggy version, and cause problems for people with a customer base. Not to mention the install hung, but yet the log said it finished, front end would hang forever. save Payment Information And Place Order('****', '****', Object(Magento\Quote\Model\Quote\Payment), Object(Magento\Quote\Model\Quote\Address)) #1 ****/vendor/magento/module-webapi/Controller/Rest.php(307): call_user_func_array(Array, Array) #2 ****/vendor/magento/module-webapi/Controller/Rest.php(216): Magento\Webapi\Controller\Rest- I'm running into this exact problem on magento 2.1.2 Using direct post method.

Adding a breakpoint in the catch block will allow you to see the detailed error message.

If your error is not occurring at this line, you can search the entire code base for the phrase "Please try to place the order again.".

dl=0 tables They should be similar to these, sales_sequence_profile sales_sequence_meta After I fixed these tables, it started to working. I do not know if it is important but I migrated data from older 1.9 into Magento 2 (with the ubertheme module) only products and the category. Instead the error shows up (for just a few seconds) An error occurred on the server. , the cart is empty and the customer is still on the checkout page.

You must have an account to comment. Please register or login here!