1c upgrade to 1.4.9 : error upgradedb

[zizoo]

When doing the one click upgrade from 1.4.8.2 to 1.4.9 i get following error [technical error - Javascript] error detected for action "upgradedb". Starting restoration.

 

I want to do the manual upgrade but in the docs it says after copying the new files to the server you have to run the /install/upgrade/upgrade.php but this file is not present in the 1.4.9 distribution zip.

 

Please help me get this upgrade working...

[MEG Venture]

Same error here... Any solution?

[MEG Venture]

My mistake...

Edited August 26, 2012 by Caglar (see edit history)

[Trip]

Hi Caglar,

can you tell us what you did wrong? I have the same error so maybe you can shed some light?

Thx, trip

[MEG Venture]

I tried on a different server and it worked. So it shows that this error is because of the server configuration. If I can find the reson, I'll let you know.

[zizoo]

My SQL server allows remote connections, so this isn't the problem. It would be great if we could find some more logging to see what causes this error.

[rturner]

I used the latest autoupgrade module and got the same error at the end of the install on two stores. But everything still worked. I haven't found anything broken yet.

[MEG Venture]

I used the latest autoupgrade module and got the same error at the end of the install on two stores. But everything still worked. I haven't found anything broken yet.

 

Cool Mine was upgraded, too. The only thing I noticed that my third-party modules were still deactivated.

 

Thanks for the tip, though!!!

[zizoo]

I seriously doubt you have upgraded by the full. 1.4.9 had a lot of database improvements. Probably nothing is broken but you are also probably missing out on the improvements.

 

I whish we had some more information on the possible cause of this problem and solution to be sure we can do a full upgrade.

[Trip]

The database update can be done manually. The code is in prestashop/install/sql/upgrade/1.4.9.0.sql

SET NAMES 'utf8';
ALTER TABLE `PREFIX_image` ADD UNIQUE KEY `idx_product_image` (`id_image` , `id_product` , `cover`);
ALTER TABLE `PREFIX_category_product` DROP INDEX `category_product_index`, ADD PRIMARY KEY (`id_category`, `id_product`);
ALTER TABLE `PREFIX_cms_category_lang` DROP INDEX `category_lang_index`, ADD PRIMARY KEY (`id_cms_category`, `id_lang`);
ALTER TABLE `PREFIX_order_tax` ADD `id_order_tax` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
ALTER TABLE `PREFIX_feature_lang` ADD INDEX feature_name (`id_lang`, `name`);
ALTER TABLE `PREFIX_state` ADD INDEX statename (`name`);
ALTER TABLE `PREFIX_category` ADD INDEX nleftrightactive (`nleft`, `nright`, `active`);
ALTER TABLE `PREFIX_category` ADD INDEX level_depth (`level_depth`);
ALTER TABLE `PREFIX_category` ADD INDEX nright (`nright`);
ALTER TABLE `PREFIX_category` ADD INDEX nleft (`nleft`);
ALTER TABLE `PREFIX_specific_price` ADD INDEX from_quantity (`from_quantity`);
ALTER TABLE `PREFIX_product` ADD INDEX indexed (`indexed`);
UPDATE `PREFIX_country` SET `zip_code_format` = 'NNNNN' WHERE `iso_code` = 'MC' LIMIT 1;
UPDATE `PREFIX_county_zip_code` SET `to_zip_code` = `from_zip_code` WHERE `to_zip_code` = 0;
UPDATE `PREFIX_configuration` SET `value` = 0 WHERE `name` = 'PS_HIGH_HTML_THEME_COMPRESSION' LIMIT 1;
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`)(SELECT 'PS_TAX_DISPLAY_ALL', `value`, NOW(), NOW() FROM `PREFIX_configuration` WHERE name = 'PS_TAX_DISPLAY' LIMIT 1);
DELETE FROM `PREFIX_referrer_cache` WHERE id_referrer NOT IN (SELECT id_referrer FROM `PREFIX_referrer`);
/* PHP:update_module_mailalerts(); */;
/* PHP:update_module_blocklayered(); */;

 

I can do the upgrade the old fashioned way by download the 1.4.9 package copy the old setting.inc.php to the config and then

do the upgrade via the installer. But than I have to copy the modules, images etc. back to the new installation but maybe it is the time to clean up a little

Regards, trip

[zizoo]

That's great, but this is not really a 'one click upgrade'..

 

Too bad we don't see a reply from a prestashop representative on possible cause of this error...

[mg2812]

Same error ... also wait some solution!

[zizoo]

Check this :

 

http://forge.prestashop.com/browse/PSCFI-6470

 

I'm going to try this and let you know...

[zizoo]

I can confirm this fix works... succesfully upgraded to 1.4.9

 

http://forge.prestas...owse/PSCFI-6470