1.6.1.0 -> 1.6.1.1 File update sucessful but database failure

[szben]

I have upgraded my prestashop from 1.6.1.0 to 1.6.1.1. The file update was successful but database upgrade failed. The upgraded 1.6.1.1 store is working fine with the old 1.6.1.0 database. But I think it would be better to upgrade the database too.

 

How can I upgrade the database only? One-click update and manual update doesn't work because the files are already updated.

Edited August 22, 2015 by szben (see edit history)

[szben]

Anyone can help me? Is it so hard to just upgrade the database?

[SLiCK_303]

ALTER TABLE `ps_customer_message` CHANGE `message` `message` MEDIUMTEXT NOT NULL;
UPDATE `ps_tax_rules_group` SET `date_add` = NOW(), `date_upd` = NOW() WHERE `date_add` = '0000-00-00 00:00:00';

ALTER TABLE  `ps_order_detail` ADD  `original_wholesale_price` DECIMAL( 20, 6 ) NOT NULL DEFAULT  '0.000000';

ALTER TABLE `ps_specific_price` DROP KEY `id_product_2`;

ALTER IGNORE TABLE `ps_specific_price` ADD UNIQUE KEY `id_product_2` (`id_cart`, `id_product`,`id_shop`,`id_shop_group`,`id_currency`,`id_country`,`id_group`,`id_customer`,`id_product_attribute`,`from_quantity`,`id_specific_price_rule`,`from`,`to`);
 

 

assuming that your prefix for your db is 'ps'......and assuming you are coming from 1.6.1.0 to 1.6.1.1

Edited August 24, 2015 by SLiCK_303 (see edit history)

[szben]

Thank you!