Why was Magento unable to save the client after creating the identifier?

Question

I'm trying to track down the cause of a rare error (love these intermittent errors) when a customer chooses to register during the checkout, but when the order is completed, Magento will somehow not be able to save the customer record. This leads to an orphaned order without an email address, to a difficult situation with customer service.

Here are the results of my research:

• Viewing the customer order in adminhtml reports that the customer is a Guest and the email address is empty. Billing and delivery addresses are visible.
• customer_is_guest false in sales_flat_order
• The sales_flat_order refers to a valid entry in sales_flat_order_address .
• The sales_flat_order_address record contains values ​​for customer_id and customer_address_id , however these related records do not exist.
• There is no noticeable template in the information about customers, ordered products, payment methods.
• There are no corresponding entries in the system.log, exception.log, apache, var / reports and other log files.

Thoughts:

• customer retention goes far enough to create an identifier.
• is there an observer on customer_save_after that causes a save rollback?
• a low level database error results in a save failure.

Does anyone have any suggestions on how to track this?

The version is Enterprise 1.9.

Answer 1

I would add many additional protocols, try to write them well enough to capture the error - and save these logs if the error can be detected.

Once you have the logs that show the error, you can more easily isolate the problematic code.

To do this, you may need to register database queries, which, unfortunately, can be complex if the amount of data is high and / or subject to privacy problems.