-RanZ- Posted January 21, 2021 Share Posted January 21, 2021 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? Link to comment Share on other sites More sharing options...
-RanZ- Posted January 21, 2021 Author Share Posted January 21, 2021 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 Link to comment Share on other sites More sharing options...
-RanZ- Posted January 21, 2021 Author Share Posted January 21, 2021 So I recreated the same order using my test account, I get this error when checking out - Link to comment Share on other sites More sharing options...
-RanZ- Posted January 21, 2021 Author Share Posted January 21, 2021 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. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.