Runner73

Tryed this solution, on my websites (hosted on Microsfot Azure), but plugin update failed… ??
Any other suggestion is accepted

Same problem on several sites.
Automatic process is able to dlete the old plugin directory, but can’t create the new one.
Updating manually the plug-in vi ftp, all works fine

Hi
this is a very usefull fix. With this fix I resolved the problem of pagination on different theme.
Very regards.

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

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

It’s a local problem with dp collation declare in wp-config.php
I signed plugin as correctly functioned.

If I try to deactivate and reactive plugin this is the query log response of wp:

Deactivate

UPDATE wp_options SET option_value = N’a:2:{s:29:”alo-easymail/alo-easymail.php”;i:1328031760;s:33:”alo-easymail.old/alo-easymail.php”;i:1328029282;}’ WHERE option_name = N’recently_activated’|~|i:1;|~|

Activate

[Code moderated as per the Forum Rules. Please use the pastebin]

solved it, my error on code