Jump to content
Sign in to follow this  
-RanZ-

Wrong order total, missing attributes

Recommended Posts

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?

 

osissue.jpg.d6602832cefd9add328f8865430d9b28.jpgosissue.jpg.d6602832cefd9add328f8865430d9b28.jpg

Share this post


Link to post
Share on other sites

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

image.thumb.png.c939445c8bc01dba47902f0a921eecfc.png

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

image.thumb.png.d2988a44a59586df99594f53f63001b2.png

 

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

Edited by -RanZ-

Share this post


Link to post
Share on other sites

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

 

image.thumb.png.16b3b9af1681e09469e2aff07ebaec81.png

Share this post


Link to post
Share on other sites

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.

image.png.a05f9ef9238495de56d121355c2805c2.png

 

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×