Greetings,

I installed the ecommerce live subproducts module and received some errors in relation to my postgresql database.

query: SELECT * FROM ec_ls_pproduct WHERE nid = 5 in /includes/database.pgsql.inc on line 144.

pg_query() [function.pg-query]: Query failed: ERROR: relation "ec_ls_pproduct" does not exist in /includes/database.pgsql.inc on line 125.

Illegal choice ec_live_subproducts_attribute in Types element.

query: ALTER TABLE ec_ls_pproduct ADD FOREIGN KEY (nid) REFERENCES node(nid); in /includes/database.pgsql.inc on line 144.

pg_query() [function.pg-query]: Query failed: ERROR: relation "ec_ls_pproduct" does not exist in /includes/database.pgsql.inc on line 125.

query: ALTER TABLE ec_ls_pattribute ADD FOREIGN KEY (pnid) REFERENCES node(nid); in /includes/database.pgsql.inc on line 144.

pg_query() [function.pg-query]: Query failed: ERROR: there is no unique constraint matching given keys for referenced table "node" in /includes/database.pgsql.inc on line 125.

query: ALTER TABLE ec_ls_bpattribute ADD FOREIGN KEY (pnid) REFERENCES node(nid); in /includes/database.pgsql.inc on line 144.

pg_query() [function.pg-query]: Query failed: ERROR: there is no unique constraint matching given keys for referenced table "node" in /includes/database.pgsql.inc on line 125.

query: CREATE TABLE ec_ls_pproduct ( nid INTEGER NOT NULL, sku_title BOOLEAN DEFAULT 0, children_creation VARCHAR(50), default_selection VARCHAR(50) ); in /includes/database.pgsql.inc on line 144.

pg_query() [function.pg-query]: Query failed: ERROR: column "sku_title" is of type boolean but default expression is of type integer HINT: You will need to rewrite or cast the expression. in /includes/database.pgsql.inc on line 125.

Regards,
Jason

Comments

brmassa’s picture

brmassa commented
Assigned: Unassigned » brmassa
Status: Active » Fixed

Jason,

the databases were not being created because an error i did. im gonna commit the fix soon. If you want to fix it for yourself do:

* On ec_li_subproducts.install, replace the line "case "pgsql":" to "default:" and delete the lines

    case "default":
      drupal_set_message(t("Your database is not supported"));

Uninstall the moduel and reinstall it.

regards,

massa

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)