Share

PgMarket

The forum address has changed, you have been automatically redirected. Please update any bookmarks to use the new URL.

Subscribe

sql error on php 5.2 pgsql 8.3.5

You are viewing a single message from this topic. View all messages.

  1. 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.
< Previous | 1 | Next >

Add a Reply

This forum does not allow anonymous participation.

Log in to add a reply. Not registered? Create an account to participate and receive email updates when replies are posted to this topic.