Orders not showing products sold

Trying to find a solution for our orders not showing the products sold. It does it on some products, but not all. I have looked at the good ones and see no difference in the settings with the ones that aren't working. Any thoughts?

Hi there,

Maybe the product not displayed are options and you enabled the "Group options with product" option in the main configuration (System>Configuration>Main).

Thanks for the thought, but it was disabled. Any other ideas?

This looks like a mysql error when inserting the products in the order_product table at the end of the checkout.
So you that that it only happens for some products right ? Is it always the same products which have the issue ?
If so, if you try to checkout with the "debug mode" option of the configuration of joomla turned on, do you get an error at the end of the checkout ? If so, what is it ?