I am trying to solve a problem with a corrupted order.
A customer placed a large order (170 lines).
Whilst the customer made it through the checkout (we have all his details), and we can open the order, we get a 'Data Truncated' message on opening or printing the order.
My delving so far has led me to the OrderTracking table where the field sProductDetails is blank (as opposed to all other orders, where this field is populated).
Any database wiz that could tell me what this table does, and what the field sProductDetails relates to.
Failing this, is the database dictionary available for download, or do we need to apply for it (forgotten where I have stored my last copy!)
thanks.
A customer placed a large order (170 lines).
Whilst the customer made it through the checkout (we have all his details), and we can open the order, we get a 'Data Truncated' message on opening or printing the order.
My delving so far has led me to the OrderTracking table where the field sProductDetails is blank (as opposed to all other orders, where this field is populated).
Any database wiz that could tell me what this table does, and what the field sProductDetails relates to.
Failing this, is the database dictionary available for download, or do we need to apply for it (forgotten where I have stored my last copy!)
thanks.
Comment