attrib stock - 32 character string getting appended to each item in shopping cart

[johnnybravoh]

Hello there,

I have a very odd problem that seems to have popped up out of nowhere.

A 32 character string is being appended to each product ID for only one category in my store. This only shows up in the shopping cart. Nowhere else. Here is an example of a URL in the shopping cart.

http://www.some_random_URL.com/shop/index.php?main_page=product_info&products_id=180:b46420006b9a8139c243e890f2e8bed5

See that :b46420006b9a8139c243e890f2e8bed5?

I get a different 32 character string for each product, but it's persistent across sessions - i.e. I get the same 32 character string for products_id 180 no matter which computer I view this on.

Where's that coming from? It's breaking queries! When I click on a link in the shopping cart, I get a message like:

"1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':b46420006b9a8139c243e890f2e8bed5 and stock_attributes=1150' at line 1
in:
[select quantity from shop_products_with_attributes_stock where products_id=180:b46420006b9a8139c243e890f2e8bed5 and stock_attributes=1150]"

I don't really know where to find what is causing this behavior and appreciate any help you can provide.

Thank you in advance,

Jon

[Ajeh]

That is shown when Attributes are added to the Product and inserted in the Cart ...

If you go to the product from the shopping_cart and there are Attributes, you will see it so that the settings are set as in the shopping_cart ...

If you go to the Product from anywhere else you will only see the =180 ...

[DrByte]

Your products-with-attribute-stock module appears to need to be treating your products_id value as a string with quotes around it, but isn't.

[johnnybravoh]

It sounds then like this is expected behavior but if that's the case then why are the links broken in the shopping cart?

Every time I click on a link I get the error as stated in the original post. This can't be right.

[Ajeh]

Have you an URL where we can see this happening, perhaps?

[johnnybravoh]

Yes - it's password protected to keep anyone from purchasing while the shop is in development.

url:http://www.akianestour.com/shop
userid: tmp
pass: tmp123

Add any painting to your shopping cart. When you're viewing the shopping cart contents you'll see the 32 character appended products_id I'm speaking of.

Jon

[DrByte]

Add any painting to your shopping cart. When you're viewing the shopping cart contents you'll see the 32 character appended products_id I'm speaking of.

Yes, that is entirely normal for products that have attributes associated with them.

Your problem has nothing to do with those necessary characters.
The problem is that your SQL Query should be enclosing the product id in quotes because if it's not in quotes, it treats the : character as a divider instead of part of the product id.

[johnnybravoh]

Yes, that is entirely normal for products that have attributes associated with them.

Your problem has nothing to do with those necessary characters.
The problem is that your SQL Query should be enclosing the product id in quotes because if it's not in quotes, it treats the : character as a divider instead of part of the product id.

Oh that's great news. Means an easy fix. Would you happen to know the file I need to alter to insert the quotes?

Thanks again!

[johnnybravoh]

Oh that's great news. Means an easy fix. Would you happen to know the file I need to alter to insert the quotes?

Thanks again!

Alright - I found it. It was code that I inserted in the file includes/modules/attributes.php to display attribute quantities in the attribute list so you can see that there are 500 24x30 paintings and 475 30x46 paintings for instance...

I really appreciate your assistance in pointing me in the right direction.