Support » Plugin: WP eCommerce » [Plugin: WP e-Commerce] Installation problem

Viewing 3 replies - 1 through 3 (of 3 total)
  • Of course they are blank you can’t have a store without configuring it. You need to set you location, tax settings etc. That is done so you don’t try to run a store without configuring it first.

    -Analog

    Runner73

    (@runner973hotmailcom)

    I can’t set my location because the relative box i empty.

    Runner73

    (@runner973hotmailcom)

    This is extract of query.log error during activation

    Line 175: SHOW TABLE STATUS LIKE ‘wp_wpsc_also_bought’|~|a:0:{}|~|a:3:{i:0;s:5:”42000″;i:1;i:156;i:2;s:96:”[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword ‘TABLE’.”;}
    Line 176: ALTER TABLE wp_wpsc_also_bought COLLATE utf8_general_ci|~|i:1;|~|a:3:{i:0;s:5:”42000″;i:1;i:156;i:2;s:98:”[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword ‘COLLATE’.”;}
    Line 177: SHOW FULL COLUMNS FROM wp_wpsc_also_bought|~|a:0:{}|~|a:3:{i:0;s:5:”42000″;i:1;i:156;i:2;s:95:”[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword ‘FULL’.”;}
    Line 178: ALTER TABLE wp_wpsc_also_bought ADD id bigint NOT NULL IDENTITY(1,1) ;|~|i:1;|~|a:3:{i:0;s:5:”42S21″;i:1;i:2705;i:2;s:173:”[Microsoft][SQL Server Native Client 10.0][SQL Server]Column names in each table must be unique. Column name ‘id’ in table ‘wp_wpsc_also_bought’ is specified more than once.”;}
    Line 179: ALTER TABLE wp_wpsc_also_bought ADD selected_product bigint NOT NULL DEFAULT ‘0’ |~|i:1;|~|a:3:{i:0;s:5:”42S21″;i:1;i:2705;i:2;s:187:”[Microsoft][SQL Server Native Client 10.0][SQL Server]Column names in each table must be unique. Column name ‘selected_product’ in table ‘wp_wpsc_also_bought’ is specified more than once.”;}
    Line 180: ALTER TABLE wp_wpsc_also_bought ADD associated_product bigint NOT NULL DEFAULT ‘0’ |~|i:1;|~|a:3:{i:0;s:5:”42S21″;i:1;i:2705;i:2;s:189:”[Microsoft][SQL Server Native Client 10.0][SQL Server]Column names in each table must be unique. Column name ‘associated_product’ in table ‘wp_wpsc_also_bought’ is specified more than once.”;}
    Line 181: ALTER TABLE wp_wpsc_also_bought ADD quantity int NOT NULL DEFAULT ‘0’ |~|i:1;|~|a:3:{i:0;s:5:”42S21″;i:1;i:2705;i:2;s:179:”[Microsoft][SQL Server Native Client 10.0][SQL Server]Column names in each table must be unique. Column name ‘quantity’ in table ‘wp_wpsc_also_bought’ is specified more than once.”;}
    Line 185: SHOW TABLE STATUS LIKE ‘wp_wpsc_cart_contents’|~|a:0:{}|~|a:3:{i:0;s:5:”42000″;i:1;i:156;i:2;s:96:”[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword ‘TABLE’.”;}
    Line 186: ALTER TABLE wp_wpsc_cart_contents COLLATE utf8_general_ci|~|i:1;|~|a:3:{i:0;s:5:”42000″;i:1;i:156;i:2;s:98:”[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword ‘COLLATE’.”;}
    Line 187: SHOW FULL COLUMNS FROM wp_wpsc_cart_contents|~|a:0:{}|~|a:3:{i:0;s:5:”42000″;i:1;i:156;i:2;s:95:”[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword ‘FULL’.”;}
    Line 188: ALTER TABLE wp_wpsc_cart_contents ADD id bigint NOT NULL IDENTITY(1,1) ;|~|i:1;|~|a:3:{i:0;s:5:”42S21″;i:1;i:2705;i:2;s:175:”[Microsoft][SQL Server Native Client 10.0][SQL Server]Column names in each table must be unique. Column name ‘id’ in table ‘wp_wpsc_cart_contents’ is specified more than once.”;}
    Line 189: ALTER TABLE wp_wpsc_cart_contents ADD prodid bigint NOT NULL DEFAULT ‘0’ |~|i:1;|~|a:3:{i:0;s:5:”42S21″;i:1;i:2705;i:2;s:179:”[Microsoft][SQL Server Native Client 10.0][SQL Server]Column names in each table must be unique. Column name ‘prodid’ in table ‘wp_wpsc_cart_contents’ is specified more than once.”;}
    Line 190: ALTER TABLE wp_wpsc_cart_contents ADD name NVARCHAR(255) COLLATE database_default NOT NULL DEFAULT ” |~|i:1;|~|a:3:{i:0;s:5:”42S21″;i:1;i:2705;i:2;s:177:”[Microsoft][SQL Server Native Client 10.0][SQL Server]Column names in each table must be unique. Column name ‘name’ in table ‘wp_wpsc_cart_contents’ is specified more than once.”;}
    Line 191: ALTER TABLE wp_wpsc_cart_contents ADD purchaseid bigint NOT NULL DEFAULT ‘0’ |~|i:1;|~|a:3:{i:0;s:5:”42S21″;i:1;i:2705;i:2;s:183:”[Microsoft][SQL Server Native Client 10.0][SQL Server]Column names in each table must be unique. Column name ‘purchaseid’ in table ‘wp_wpsc_cart_contents’ is specified more than once.”;}
    Line 192: ALTER TABLE wp_wpsc_cart_contents ADD price decimal(11,2) NOT NULL DEFAULT ‘0’ |~|i:1;|~|a:3:{i:0;s:5:”42S21″;i:1;i:2705;i:2;s:178:”[Microsoft][SQL Server Native Client 10.0][SQL Server]Column names in each table must be unique. Column name ‘price’ in table ‘wp_wpsc_cart_contents’ is specified more than once.”;}
    Line 193: ALTER TABLE wp_wpsc_cart_contents ADD pnp decimal(11,2) NOT NULL DEFAULT ‘0’ |~|i:1;|~|a:3:{i:0;s:5:”42S21″;i:1;i:2705;i:2;s:176:”[Microsoft][SQL Server Native Client 10.0][SQL Server]Column names in each table must be unique. Column name ‘pnp’ in table ‘wp_wpsc_cart_contents’ is specified more than once.”;}
    Line 194: ALTER TABLE wp_wpsc_cart_contents ADD tax_charged decimal(11,2) NOT NULL DEFAULT ‘0’ |~|i:1;|~|a:3:{i:0;s:5:”42S21″;i:1;i:2705;i:2;s:184:”[Microsoft][SQL Server Native Client 10.0][SQL Server]Column names in each table must be unique. Column name ‘tax_charged’ in table ‘wp_wpsc_cart_contents’ is specified more than once.”;}
    Line 195: ALTER TABLE wp_wpsc_cart_contents ADD gst decimal(11,2) NOT NULL DEFAULT ‘0’ |~|i:1;|~|a:3:{i:0;s:5:”42S21″;i:1;i:2705;i:2;s:176:”[Microsoft][SQL Server Native Client 10.0][SQL Server]Column names in each table must be unique. Column name ‘gst’ in table ‘wp_wpsc_cart_contents’ is specified more than once.”;}
    Line 196: ALTER TABLE wp_wpsc_cart_contents ADD quantity int NOT NULL DEFAULT ‘0’ |~|i:1;|~|a:3:{i:0;s:5:”42S21″;i:1;i:2705;i:2;s:181:”[Microsoft][SQL Server Native Client 10.0][SQL Server]Column names in each table must be unique. Column name ‘quantity’ in table ‘wp_wpsc_cart_contents’ is specified more than once.”;}
    Line 197: ALTER TABLE wp_wpsc_cart_contents ADD donation NVARCHAR(1) COLLATE database_default NOT NULL DEFAULT ‘0’ |~|i:1;|~|a:3:{i:0;s:5:”42S21″;i:1;i:2705;i:2;s:181:”[Microsoft][SQL Server Native Client 10.0][SQL Server]Column names in each table must be unique. Column name ‘donation’ in table ‘wp_wpsc_cart_contents’ is specified more than once.”;}
    .
    .
    .

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘[Plugin: WP e-Commerce] Installation problem’ is closed to new replies.