Quote Originally Posted by phastings View Post
hi. i'm running 1.3.8a with fexed mod 1.4.1. i was having the problem of fedex not showing up on the checkout page. i did the table1->table fix but now i'm getting the error below. any ideas?
thank. paul.

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 ':8156325fdbe48dbd415939aa043c72ba LIMIT 1' at line 1
in:
[SELECT products_length, products_width, products_height, products_ready_to_ship, product_is_always_free_shipping FROM zen_products WHERE products_id = 33:8156325fdbe48dbd415939aa043c72ba LIMIT 1]


phastings , did you find a resolution for this problem?
I seem to be having the same issue after adding ASA:

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 ':8cd9a94c8d0f51585a4ef83d1ea93746 LIMIT 1' at line 1
in:
[SELECT products_length, products_width, products_height, products_ready_to_ship, product_is_always_free_shipping FROM zen_products WHERE products_id = 560:8cd9a94c8d0f51585a4ef83d1ea93746 LIMIT 1]
####################


I confirmed your observation that the error occurs when adding products to the cart which have attributes.

Considering a possible add on conflict , I also have Stock by Attributes installed