I have a working schema for PostgreSQL. It installs without errors, but there are two issues I need advice on:

  • 1) When shipping is set to "Do not calculate," attempting to purchase a shippable item results in this error:


      pg_query(): Query failed: ERROR: invalid input syntax for type numeric: "" in home/darren/public_html/drupal-4.6.3/includes/database.pgsql.inc on line 45.



      query: INSERT INTO ec_transaction (shipping_cost, gross, payment_method, uid, mail, changed, shipping_firstname, shipping_lastname, shipping_street1, shipping_street2, shipping_city, shipping_state, shipping_zip, shipping_country, billing_firstname, billing_lastname, billing_street1, billing_street2, billing_city, billing_state, billing_zip, billing_country, created, payment_status, workflow, txnid) VALUES('', '1', 'cod', '1', 'darren@wans.net', '1125460800', 'Darren', 'Oh', '911 Dove Ridge Drive', '', 'Lakeland', 'FL', '33803-3707', 'us', 'Darren', 'Oh', '911 Dove Ridge Drive', '', 'Lakeland', 'FL', '33803-3707', 'us', '1125508544', '1', '1', '2') in /home/darren/public_html/drupal-4.6.3/includes/database.pgsql.inc on line 62.



    Apparently drupal is passing a '' as the shipping_cost.

  • I can view my order history in my account, but trying display transactions under the Administration menu gives no results and displays six lines of error messages:


      pg_query(): Query failed: ERROR: argument of AND must be type boolean, not type integer in /home/darren/public_html/drupal-4.6.3/includes/database.pgsql.inc on line 45.



      query: SELECT COUNT(*) FROM ec_transaction AS st WHERE 1 AND st.txnid > '0' in /home/darren/public_html/drupal-4.6.3/includes/database.pgsql.inc on line 62.



      pg_query(): Query failed: ERROR: argument of AND must be type boolean, not type integer in /home/darren/public_html/drupal-4.6.3/includes/database.pgsql.inc on line 45.



      query: SELECT COUNT(*) FROM ec_transaction AS st WHERE 1 AND st.txnid > '0' in /home/darren/public_html/drupal-4.6.3/includes/database.pgsql.inc on line 62.



      pg_query(): Query failed: ERROR: argument of AND must be type boolean, not type integer in /home/darren/public_html/drupal-4.6.3/includes/database.pgsql.inc on line 45.



      query: SELECT * FROM ec_transaction AS st WHERE 1 AND st.txnid > '0' ORDER BY st.txnid DESC LIMIT 50 OFFSET 0 in /home/darren/public_html/drupal-4.6.3/includes/database.pgsql.inc on line 62.

    • That's all the trouble I can find so far, but it's enough. The E-Commerce module really needs to work with PostgreSQL.

    CommentFileSizeAuthor
    store_1.pgsql11.41 KBdarren oh

    Comments

    darren oh’s picture

    darren oh
    Primary language English
    Location Lakeland, Florida
    commented
    Status: Needs work » Closed (duplicate)

    Duplicate of issue 16833.

    darren oh’s picture

    darren oh
    Primary language English
    Location Lakeland, Florida
    commented

    Duplicate of issue 16833.

    darren oh’s picture

    darren oh
    Primary language English
    Location Lakeland, Florida
    commented

    Duplicate of issue 16833.