Title: [Plugin: WP e-Commerce] Installation problem
Last modified: August 20, 2016

---

# [Plugin: WP e-Commerce] Installation problem

 *  [Runner73](https://wordpress.org/support/users/runner973hotmailcom/)
 * (@runner973hotmailcom)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-wp-e-commerce-installation-problem-1/)
 * 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/](http://wordpress.org/extend/plugins/wp-e-commerce/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [analogrithems](https://wordpress.org/support/users/analogrithems/)
 * (@analogrithems)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-wp-e-commerce-installation-problem-1/#post-2539221)
 * 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
 *  Thread Starter [Runner73](https://wordpress.org/support/users/runner973hotmailcom/)
 * (@runner973hotmailcom)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-wp-e-commerce-installation-problem-1/#post-2539224)
 * I can’t set my location because the relative box i empty.
 *  Thread Starter [Runner73](https://wordpress.org/support/users/runner973hotmailcom/)
 * (@runner973hotmailcom)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-wp-e-commerce-installation-problem-1/#post-2539232)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/wp-e-commerce_ebebeb.svg)
 * [WP eCommerce](https://wordpress.org/plugins/wp-e-commerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-e-commerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-e-commerce/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-e-commerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-e-commerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-e-commerce/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Runner73](https://wordpress.org/support/users/runner973hotmailcom/)
 * Last activity: [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-wp-e-commerce-installation-problem-1/#post-2539232)
 * Status: not resolved