2009-08-14 17:47:25 UTC
Hi,
Is this forum alive? I'm able to create an order as a shopper but when I try to see order details, it crashes. Please see error and help. I'm trying the non-italy, english user. By the way what is this 16 digit FIN code? what are valid codes?
-----------------------------------------------------------------------------------------------------------------
Database error: Invalid SQL: SELECT l.name AS lname, p.name AS name, p.price AS curr_price, oi.product_id, oi.name AS oiname, oi.color, oi.price AS purchase_price, oi.discount AS purchase_discount, oi.discqty AS purchase_discqty, oi.iva AS purchase_iva, oi.weight AS purchase_weight, oi.qty FROM order_items oi, products_i18n l, products p WHERE oi.product_id = l.product_id AND l.lang = 'en' AND oi.product_id = p.id AND oi.order_id = '1250271196036113-99.36.15.222' UNION ALL SELECT '' AS lname, p.name AS name, p.price AS curr_price, oi.product_id, oi.name AS oiname, oi.color, oi.price AS purchase_price, oi.discount AS purchase_discount, oi.discqty AS purchase_discqty, oi.iva AS purchase_iva, oi.weight AS purchase_weight, oi.qty FROM order_items oi, products p WHERE oi.product_id = p.id AND oi.order_id = '1250271196036113-99.36.15.222' AND oi.product_id NOT IN ( SELECT l.product_id FROM products_i18n l WHERE l.lang = 'en' ) UNION ALL SELECT '' AS lname, '' AS name, '' AS curr_price, oi.product_id, oi.name AS oiname, oi.color, oi.price AS purchase_price, oi.discount AS purchase_discount, oi.discqty AS purchase_discqty, oi.iva AS purchase_iva, oi.weight AS purchase_weight, oi.qty FROM order_items oi WHERE oi.order_id = '1250271196036113-99.36.15.222' AND oi.product_id NOT IN ( SELECT p.id FROM products p )
PostgreSQL Error: 1 (ERROR: invalid input syntax for type double precision: "")
Session halted.