WordPress.org

Ready to get started?Download WordPress

Forums

WP eCommerce
[Plugin: WP e-Commerce] Installation problem (4 posts)

  1. runner973@hotmail.com
    Member
    Posted 2 years ago #

    The result of installation is ok, but defaul page (Products Page - Checkout Page - Transaction Results - Your Account) aren't created.

    Into the admin panel of plug in:
    Country and money symbols are blank and the box is empty

    http://wordpress.org/extend/plugins/wp-e-commerce/

  2. analogrithems
    Member
    Posted 2 years ago #

    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

  3. runner973@hotmail.com
    Member
    Posted 2 years ago #

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

  4. runner973@hotmail.com
    Member
    Posted 2 years ago #

    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.";}
    .
    .
    .

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic