Strange Problem with Order Data Missing

[stehodges]

Done a thorough search of the forum and whilst others have experienced similar in the past no-one seems to have had this same issue.

The problem is this: every now and then we receive an order confirmation email with details missing. It is always missing the billing address but sometimes even misses out the delivery address, shipping information or products from the order. The data that is missing is not present in the database so it is not an email issue.

We use a custom made payment module which authorises a card before submitting the final order in Zen. This could be the issue but hasn't changed and has never caused a problem.

The payment we take is always correct though - so even if a product ends up being missed off the order in Zen we have taken the money for it - this shows me that Zen has totalled it up correctly as we use the Zen total to take the money.

The annoying thing is we can't replicate this error and we know it is not browser/OS specific. Customers have said the process seems fine (though I guess we can't 100% guarantee everything shows correctly at the confirmation stage) until they receive their email! It's easy to point the blame at our payment module but that seems to be doing its job (taking an amount, authorising it, then continuing the Zen process.

It looks to me like a db issue - i.e. when it comes to inserting the order it can't/won't insert all the information. As we've done some customisations I appreciate this is probably not a core Zen bug but I was hoping for some pointers from those that know the code - maybe someone has an idea as to why this info wouldnt be saving?

[stehodges]

I have added some debugging to log to file the following:

$this at the top of the create method in /includes/classes/order.php

$sql_data_array right before it's used to insert into the orders table (just in case anything goes wrong in between the two!)

Now just have to wait for it to happen again. I'm almost certain we'll see the info missing in the order object