Hello there. I've been trying to upgrade for about 3 days.
I have version 1.6.0.9.
First I upgraded from 1.6.0.9 to 1.6.1.24 (minor). After that I tried to increase it to 1.7.6.8 (major). But while upgrading the database, it keeps giving 500 internal server error during the upgrade.
For this:
ini_set ('default_charset', 'utf-8');
ini_set ('magic_quotes_runtime', 0);
ini_set ('magic_quotes_sybase', 0);
ini_set ('upload_max_filesize', '512M');
ini_set ('max_execution_time', 30000);
ini_set ('memory_limit', '512M');
ini_set ('max_input_time', 6000);
ini_set ('max_input_vars', 3000);
ini_set ('post_max_size', '512M');
ini_set ('max_input_vars', 20000);
I made the necessary adjustments. But it still gives the same error and is interrupted.
When this failed, I started upgrading one by one from the local directory.
I can successfully upgrade to 1.6.0.9-> 1.6.0.14-> 1.6.1.9-> 1.6.1.12-> 1.6.1.14-> 1.6.1.19-> 1.6.1.24 one by one successfully. But when I try to switch from 1.6.1.24 to 1.7.0.1 or 1.7.0.0 I get an error.
Log:
[OK] SQL 1.6.2.0 SET NAMES 'utf8' [OK] SQL 1.6.2.0 INSERT INTO `psn_configuration` (`name` , `value` , `date_add` , `date_upd`) VALUES ('PS_SMARTY_LOCAL', '0', NOW(), NOW()) [OK] SQL 1.7.0.0 SET NAMES 'utf8' [OK] SQL 1.7.0.0 INSERT INTO `psn_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_SMARTY_LOCAL', '0', NOW(), NOW()), ('PS_PASSWD_RESET_VALIDITY', '1440', NOW(), NOW()), ('PS_CUSTOMER_BIRTHDATE', '1', NOW(), NOW()), ('PS_ACTIVE_CRONJOB_EXCHANGE_RATE', '0', NOW(), NOW()), ('PS_ORDER_RECALCULATE_SHIPPING', '1', NOW(), NOW()), ('PS_MAINTENANCE_TEXT', 'We are currently updating our shop and will be back really soon.<br>Thanks for your patience.', NOW(), NOW()) [OK] SQL 1.7.0.0 INSERT INTO `psn_configuration_lang` (`id_configuration`, `id_lang`, `value`, `date_upd`) SELECT c.`id_configuration`, l.`id_lang`, c.`value`, NOW() FROM `psn_configuration` c, `psn_lang` l WHERE c.`name` = 'PS_MAINTENANCE_TEXT' [OK] SQL 1.7.0.0 INSERT INTO `psn_hook_alias` (`name`, `alias`) VALUES ('actionCartUpdateQuantityBefore', 'actionBeforeCartUpdateQty'), ('actionAjaxDieBefore', 'actionBeforeAjaxDie'), ('actionAuthenticationBefore', 'actionBeforeAuthentication'), ('actionSubmitAccountBefore', 'actionBeforeSubmitAccount'), ('actionDeleteProductInCartAfter', 'actionAfterDeleteProductInCart') [OK] SQL 1.7.0.0 ALTER TABLE `psn_currency` DROP `iso_code_num` ,DROP `sign` ,DROP `blank` ,DROP `format` ,DROP `decimals` [OK] SQL 1.7.0.0 /* Password reset token for new "Forgot my password screen */ ALTER TABLE `psn_customer` ADD `reset_password_token` varchar(40) DEFAULT NULL [OK] SQL 1.7.0.0 ALTER TABLE `psn_customer` ADD `reset_password_validity` datetime DEFAULT NULL [OK] SQL 1.7.0.0 ALTER TABLE `psn_employee` CHANGE `last_connection_date` `last_connection_date` DATE NULL DEFAULT NULL [OK] SQL 1.7.0.0 ALTER TABLE `psn_employee` ADD `reset_password_token` varchar(40) DEFAULT NULL [OK] SQL 1.7.0.0 ALTER TABLE `psn_employee` ADD `reset_password_validity` datetime DEFAULT NULL [OK] SQL 1.7.0.0 /* Need to set the date to null before manipulate the table if the strict mode is enabled on MySQL */ UPDATE `psn_customer` SET `newsletter_date_add` = NULL WHERE YEAR(newsletter_date_add) = "0000" [OK] SQL 1.7.0.0 ALTER TABLE `psn_customer` CHANGE COLUMN `passwd` `passwd` varchar(60) NOT NULL [OK] SQL 1.7.0.0 ALTER TABLE `psn_employee` CHANGE COLUMN `passwd` `passwd` varchar(60) NOT NULL [OK] SQL 1.7.0.0 ALTER TABLE `psn_customer` CHANGE COLUMN `firstname` `firstname` varchar(255) NOT NULL [OK] SQL 1.7.0.0 ALTER TABLE `psn_customer` CHANGE COLUMN `lastname` `lastname` varchar(255) NOT NULL [OK] SQL 1.7.0.0 /* Changes regarding modules */ ALTER TABLE `psn_module` ADD UNIQUE INDEX `name_UNIQUE` (`name` ASC) [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `psn_modules_perfs` [DROP] SQL `psn_module_carrier` table has been dropped. [OK] SQL 1.7.0.0 CREATE TABLE `psn_module_carrier` ( `id_module`INT(10) unsigned NOT NULL, `id_shop`INT(11) unsigned NOT NULL DEFAULT '1', `id_reference` INT(11) NOT NULL, PRIMARY KEY (`id_module`,`id_shop`, `id_reference`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 [OK] PHP 1.7.0.0 : /* PHP:select_current_payment_modules(); */ [OK] PHP 1.7.0.0 : /* Add Payment Preferences tab. SuperAdmin profile is the only one to access it. */ /* PHP:ps_1700_add_payment_preferences_tab(); */ [OK] SQL 1.7.0.0 UPDATE `psn_access` SET `view` = '0', `add` = '0', `edit` = '0', `delete` = '0' WHERE `id_tab` = (SELECT `id_tab` FROM `psn_tab` t WHERE t.`class_name` = 'AdminPaymentPreferences' LIMIT 1) AND `id_profile` > 1 [OK] SQL 1.7.0.0 UPDATE `psn_quick_access` SET `link` = "index.php/product/new" WHERE `link` = "index.php?controller=AdminProducts&addproduct" [OK] SQL 1.7.0.0 ALTER TABLE `psn_product` CHANGE `available_date` `available_date` DATE NULL DEFAULT NULL [OK] SQL 1.7.0.0 ALTER TABLE `psn_product` ADD `show_condition` TINYINT(1) NOT NULL DEFAULT '0' AFTER `available_date` [OK] SQL 1.7.0.0 ALTER TABLE `psn_product` ADD `isbn` VARCHAR( 13 ) NULL DEFAULT NULL [OK] SQL 1.7.0.0 ALTER TABLE `psn_product_shop` CHANGE `available_date` `available_date` DATE NULL DEFAULT NULL [OK] SQL 1.7.0.0 ALTER TABLE `psn_product_shop` ADD `show_condition` TINYINT(1) NOT NULL DEFAULT '0' AFTER `available_date` [OK] SQL 1.7.0.0 ALTER TABLE `psn_order_detail` ADD `product_isbn` VARCHAR( 13 ) NULL DEFAULT NULL [OK] SQL 1.7.0.0 ALTER TABLE `psn_product_attribute` CHANGE `available_date` `available_date` DATE NULL DEFAULT NULL [OK] SQL 1.7.0.0 ALTER TABLE `psn_product_attribute` ADD `isbn` VARCHAR( 13 ) NULL DEFAULT NULL [OK] SQL 1.7.0.0 ALTER TABLE `psn_product_attribute_shop` CHANGE `available_date` `available_date` DATE NULL DEFAULT NULL [OK] SQL 1.7.0.0 ALTER TABLE `psn_stock` ADD `isbn` VARCHAR( 13 ) NULL DEFAULT NULL [OK] SQL 1.7.0.0 ALTER TABLE `psn_supply_order_detail` ADD `isbn` VARCHAR( 13 ) NULL DEFAULT NULL [OK] SQL 1.7.0.0 ALTER TABLE `psn_order_invoice` DROP COLUMN `invoice_address`, DROP COLUMN `delivery_address` [OK] SQL 1.7.0.0 ALTER TABLE `psn_cart_product` CHANGE `id_product_attribute` `id_product_attribute` int(10) unsigned DEFAULT '0' [OK] SQL 1.7.0.0 ALTER TABLE `psn_product_lang` ADD `social_sharing_title` VARCHAR( 255 ) NOT NULL [OK] SQL 1.7.0.0 ALTER TABLE `psn_product_lang` ADD `social_sharing_description` VARCHAR( 255 ) NOT NULL [OK] PHP 1.7.0.0 : /* PHP:ps1700_stores(); */ [OK] SQL 1.7.0.0 ALTER TABLE `psn_hook` DROP `live_edit` [OK] SQL 1.7.0.0 /* Remove comparator feature */ DELETE FROM `psn_hook_alias` WHERE `name` = 'displayProductComparison' [OK] SQL 1.7.0.0 DELETE FROM `psn_hook` WHERE `name` = 'displayProductComparison' [OK] SQL 1.7.0.0 DELETE FROM `psn_meta` WHERE `page` = 'products-comparison' [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `psn_compare` [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `psn_compare_product` [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `psn_theme` [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `psn_theme_meta` [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `psn_theme_specific` [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `psn_scene` [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `psn_scene_category` [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `psn_scene_lang` [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `psn_scene_products` [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `psn_scene_shop` [OK] SQL 1.7.0.0 ALTER TABLE `psn_shop` ADD COLUMN `theme_name` VARCHAR(255) AFTER `id_category` [OK] SQL 1.7.0.0 UPDATE `psn_shop` SET `theme_name` = 'classic' [OK] SQL 1.7.0.0 UPDATE `psn_configuration` SET value=0 WHERE name='PS_TAX_DISPLAY' [OK] SQL 1.7.0.0 ALTER TABLE `psn_image_type` DROP `scenes` [OK] SQL 1.7.0.0 ALTER TABLE `psn_cart` ADD `checkout_session_data` MEDIUMTEXT NULL [OK] SQL 1.7.0.0 ALTER TABLE `psn_shop` DROP COLUMN `id_theme` [OK] SQL 1.7.0.0 ALTER TABLE `psn_cart_product` ADD `id_customization` INT(10) NOT NULL DEFAULT '0' AFTER `id_product_attribute` [OK] SQL 1.7.0.0 ALTER TABLE `psn_cart_product` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_cart`, `id_product`, `id_product_attribute`, `id_customization`, `id_address_delivery`) [OK] SQL 1.7.0.0 ALTER TABLE `psn_order_detail` ADD `id_customization` INT(10) NULL DEFAULT '0' AFTER `product_attribute_id` [OK] SQL 1.7.0.0 ALTER TABLE `psn_customized_data` ADD `id_module` INT(10) NOT NULL DEFAULT '0', ADD `price` DECIMAL(20,6) NOT NULL DEFAULT '0', ADD `weight` DECIMAL(20,6) NOT NULL DEFAULT '0' [OK] SQL 1.7.0.0 ALTER TABLE `psn_customization_field` ADD `is_module` TINYINT(1) NOT NULL DEFAULT '0' [OK] SQL 1.7.0.0 ALTER TABLE `psn_cart_rule` ADD `reduction_exclude_special` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `reduction_percent` [OK] SQL 1.7.0.0 ALTER TABLE `psn_product` ADD `state` INT UNSIGNED NOT NULL DEFAULT '1' [OK] SQL 1.7.0.0 ALTER TABLE `psn_product` ADD KEY `state` (`state`, `date_upd`) [OK] SQL 1.7.0.0 ALTER TABLE `psn_lang` ADD `locale` varchar(5) COLLATE utf8_unicode_ci NOT NULL [OK] PHP 1.7.0.0 : /* PHP:ps_1700_add_locale(); */ [DROP] SQL `psn_authorization_role` table has been dropped. [OK] SQL 1.7.0.0 /* Right management */ CREATE TABLE `psn_authorization_role` ( `id_authorization_role` int(10) unsigned NOT NULL auto_increment, `slug` VARCHAR(255) NOT NULL, PRIMARY KEY (`id_authorization_role`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 [OK] SQL 1.7.0.0 RENAME TABLE `psn_access` TO `psn_access_old` [OK] SQL 1.7.0.0 RENAME TABLE `psn_module_access` TO `psn_module_access_old` [DROP] SQL `psn_access` table has been dropped. [OK] SQL 1.7.0.0 CREATE TABLE `psn_access` ( `id_profile` int(10) unsigned NOT NULL, `id_authorization_role` int(10) unsigned NOT NULL, PRIMARY KEY (`id_profile`,`id_authorization_role`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 [DROP] SQL `psn_module_access` table has been dropped. [OK] SQL 1.7.0.0 CREATE TABLE `psn_module_access` ( `id_profile` int(10) unsigned NOT NULL, `id_authorization_role` int(10) unsigned NOT NULL, PRIMARY KEY (`id_profile`,`id_authorization_role`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 [OK] PHP 1.7.0.0 : /* Add Payment Preferences tab. SuperAdmin profile is the only one to access it. */ /* PHP:ps_1700_right_management(); */ [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `psn_access_old` [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `psn_module_access_old`
Errors:
[INTERNAL] /home/testpc/public_html/vendor/icanboogie/cldr/lib/WebProvider.php line 77 - ICanBoogie\CLDR\ResourceNotFound: Path not defined: supplemental/codeMappings.
#0 /home/testpc/public_html/vendor/icanboogie/cldr/lib/ProviderChainTrait.php(43): ICanBoogie\CLDR\WebProvider->provide('supplemental/co...')
#1 /home/testpc/public_html/vendor/icanboogie/cldr/lib/ProviderChainTrait.php(43): ICanBoogie\CLDR\FileProvider->provide('supplemental/co...')
#2 /home/testpc/public_html/vendor/icanboogie/cldr/lib/Repository.php(124): ICanBoogie\CLDR\RunTimeProvider->provide('supplemental/co...')
#3 /home/testpc/public_html/vendor/icanboogie/cldr/lib/Supplemental.php(95): ICanBoogie\CLDR\Repository->fetch('supplemental/co...')
#4 /home/testpc/public_html/src/Core/Cldr/Repository.php(296): ICanBoogie\CLDR\Supplemental->offsetGet('codeMappings')
#5 /home/testpc/public_html/src/Core/Cldr/Repository.php(221): PrestaShop\PrestaShop\Core\Cldr\Repository->isCurrencyValid('EUR')
#6 /home/testpc/public_html/classes/Currency.php(105): PrestaShop\PrestaShop\Core\Cldr\Repository->getCurrency('EUR')
#7 /home/testpc/public_html/classes/controller/AdminController.php(499): CurrencyCore->__construct('1')
#8 /home/testpc/public_html/src/Adapter/LegacyContext.php(55): AdminControllerCore->__construct()
#9 /home/testpc/public_html/src/Adapter/LegacyContext.php(178): PrestaShop\PrestaShop\Adapter\LegacyContext->getContext()
#10 /home/testpc/public_html/app/cache/prod/appProdProjectContainer.php(2647): PrestaShop\PrestaShop\Adapter\LegacyContext->getEmployeeLanguageIso()
#11 /home/testpc/public_html/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Container.php(314): appProdProjectContainer->getPrestashop_Core_Admin_DataProvider_ModuleInterfaceService()
#12 /home/testpc/public_html/app/cache/prod/appProdProjectContainer.php(2899): Symfony\Component\DependencyInjection\Container->get('prestashop.core...')
#13 /home/testpc/public_html/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Container.php(314): appProdProjectContainer->getPrestashop_Module_ManagerService()
#14 /home/testpc/public_html/src/Core/Addon/Module/ModuleManagerBuilder.php(86): Symfony\Component\DependencyInjection\Container->get('prestashop.modu...')
#15 /home/testpc/public_html/src/Core/Addon/Theme/ThemeManager.php(254): PrestaShop\PrestaShop\Core\Addon\Module\ModuleManagerBuilder->build()
#16 /home/testpc/public_html/src/Core/Addon/Theme/ThemeManager.php(167): PrestaShop\PrestaShop\Core\Addon\Theme\ThemeManager->doDisableModules(Array)
#17 /home/testpc/public_html/src/Core/Addon/Theme/ThemeManager.php(203): PrestaShop\PrestaShop\Core\Addon\Theme\ThemeManager->enable('classic')
#18 /home/testpc/public_html/admin9398/autoupgrade/latest/install/upgrade/php/ps_1700_reset_theme.php(32): PrestaShop\PrestaShop\Core\Addon\Theme\ThemeManager->reset('classic')
#19 [internal function]: ps_1700_reset_theme()
#20 /home/testpc/public_html/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader.php(395): call_user_func_array('ps_1700_reset_t...', Array)
#21 /home/testpc/public_html/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader.php(360): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader->runPhpQuery('1.7.0.0', '/* PHP:ps_1700_...')
#22 /home/testpc/public_html/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader.php(284): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader->runQuery('1.7.0.0', '/* PHP:ps_1700_...')
#23 /home/testpc/public_html/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader17.php(55): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader->upgradeDb('1.6.1.24')
#24 /home/testpc/public_html/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader.php(101): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader17->upgradeDb('1.6.1.24')
#25 /home/testpc/public_html/modules/autoupgrade/classes/TaskRunner/Upgrade/UpgradeDb.php(41): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader->doUpgrade()
#26 /home/testpc/public_html/admin9398/autoupgrade/ajax-upgradetab.php(53): PrestaShop\Module\AutoUpgrade\TaskRunner\Upgrade\UpgradeDb->run() #27 {main}
How can I solve this problem? Or how can I upgrade the version from 1.6.0.9 to 1.7 without losing my data.
Thanks in advance.