Jump to content

1-Click Upgrade 1.6.1.24 to 1.7.0.1

Albatrosss
 Share

Recommended Posts

Albatrosss Newbie

Albatrosss

Posted
Posted (edited)

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.
 

Edited by Albatrosss (see edit history)
Link to comment
Share on other sites
Albatrosss Newbie

Albatrosss

Posted
  • Author
Posted
On 9/27/2020 at 8:18 PM, Crezzur said:

You can try to start a manual upgrade to 1.7 more information can be found here: https://www.sunnytoo.com/6996/manually-upgrade-prestashop

I tried this too but it didn't work. 

 

Solved. I was using php5.6. 1-Click-Upgrade module was failing during upgrade. I upgraded the php version to 7.2. I fixed the errors that came up. Finally, the upgrade was successful.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...