Shopping cart problem

[FreshP]

Hi, I have tried to find a solution for this by reading through the forums but have had very little success so far.

The problem:

When a customer adds a consecutive item to their shopping cart, the price and product of the newly added items are shown correctly, but the accompanying description is the same as the previously added item already in the cart.

Obviously, this is a problem which cannot be ignored, so if anyone has any ideas, it would be absolutely brilliant to hear from you.

Thanks very much for any help offered...

[kobra]

A url to your cart
The Zen Cart Version
mysql version
php version
The server type
and any other information you can provide

[FreshP]

URL: http://radarrecords.co.uk

The Zen Cart Version: 1.3.7

MySQL: 4.1.22 standard

PHP: 4.4.6

Server OS: Linux

Apache: 1.3.37 Unix

Thank you for looking into it. Do you have any ideas as to where I should start?

[kobra]

I do not see this issue??

here are two items added to your cart

BERLIOZ - SYMPHONIE FANTASTIQUE SOLTI/CSOFormat: VINYL LP
Country: GERMAN
Label: ELEKTRA
Cat No: (EKT57)
Condition: EX/EX
Year: 1989

11 TRACK ALBUM AND INNER SLEEVE (EKT57)

CABARET VOLTAIRE - DRINKING GASOLINE
CABARET VOLTAIRE - DRINKING GASOLINEFormat: VINYL LP
Country: GERMAN
Label: ELEKTRA
Cat No: (EKT57)
Condition: EX/EX
Year: 1989

11 TRACK ALBUM AND INNER SLEEVE (EKT57)

[FreshP]

Hi Kobra,

Thank you again for your reply.

Your attempts just made me notice something. The description on each of those you added are both the same [as below] and what's more, this description does not belong to this product. All of the descriptions being added to the products are this same one when added to the shopping cart.
----------------------------------------
Country: GERMAN
Label: ELEKTRA
Cat No: (EKT57)
Condition: EX/EX
Year: 1989

11 TRACK ALBUM AND INNER SLEEVE (EKT57)
-----------------------------------------
This description actually only applies to
http://radarrecords.co.uk/index.php?...&products_id=1

I also have a feeling this is the first entry in the product list.

I hope this all makes sense and you can see what I mean now?

[kobra]

OK I missed the additional data and only looked at the item name...

Are you using the music product type here? or the product type general?

[FreshP]

I am using the music product type.

[FreshP]

I have tried and tried and tried and just cannot find the solution to this.

What do you suggest I do in this situation? Is there any way of fixing something like this - even with paid help?

Please get in touch if you have any advice.

Thank you ...

[hem]

Sorry- way late on this but I found this thread from another...

There's a bug in function_lookup.php- lines starting at 767. They read:

    $product_lookup = $db->Execute("select " . $what_field . " as lookup_field
                              from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                              where p.products_id ='" . (int)$product_id . "'
                              and pd.language_id = '" . (int)$language . "'");

they should read:

    $product_lookup = $db->Execute("select " . $what_field . " as lookup_field
                              from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                              where p.products_id ='" . (int)$product_id . "'
                              and pd.products_id ='" . (int)$product_id . "'
                              and pd.language_id = '" . (int)$language . "'");

currently the description table is not being referenced correctly.