Wrong order total, missing attributes

[-RanZ-]

I am having a major issue w/ OsCommerce 2.3.4.

Issue 1 - look at the order below, subtotal is completely wrong.

Issue 2 - item number 2 is completely missing 3 attributes that are selected when adding to the card.

The only thing I have changed recently is I deleted 2 categories of products. Any ideas?

 

[-RanZ-]

Looking at the orders_id field in orders_products_attributes it looks like the attributes for that second product are not getting written to the database

The product does get added to the orders_products table though, see below

 

It looks like deleting whole categories has totally hosed something on my site

[-RanZ-]

So I recreated the same order using my test account, I get this error when checking out -

 

[-RanZ-]

I changed the type for products_options_values to varchar(64) instead of varchar(32) and that seemed to fix at least the options not showing in the admin panel for orders. The thing I dont understand is I have a test copy of this website on another web host with products_options_values set at varchar(32) and it works fine.

 

I am still stumped on the order total, I just did a test order and it all added up right.