[Problem]1 click upgrade failure

[compuman1112]

Hey all!

 

When i try to update my Prestashop with the 1 click upgrade module it keeps failing. Everything goes fine until the very last step.

 

The error says: 

[Ajax / Server Error for action upgradeComplete] textStatus: "error " errorThrown:"Internal Server Error " jqXHR: "
Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

"

I don't know how to fix it. 

 

Please help!

[rocky]

Try editing config/defines.inc.php and changing the value of _PS_MODE_DEV_ from false to true. You should then get a more specific error message that can be used for debugging.

[compuman1112]

 Hi! I edited the value but the error is still the same.... Any other ideas?

 

Also tried this (i found somewhere on this forum): 

 

-> Make a full backup first

-> Download the latest stable Prestashop version

-> Extract the folder

-> Open the folder and you will get 2 subfoders: Prestashop and Install_PrestaShop.html

-> Copy/Paste ONLY the Prestashop subfolder here: /admin/autoupgrade/latest/

-> Go to 1 Click Upgrade module -> On Start your Upgrade field click the button on the right named More options (Expert mode)
-> Go to Expert mode -> Channel -> select Local directory -> write the presta version you are ungradeing to (ex: 1.6.1.1) -> Save
-> On Backup Options field -> Back up my files and database -> select No -> Save
-> On Upgrade Options fiend -> Disable non-native modules -> select No -> Save
-> Check if above settings are made -> then Upgrade the version
 

Edited November 4, 2016 by compuman1112 (see edit history)

[rocky]

Did you get a more specific error message? Sorry, I can't help without knowing exactly what's wrong.

[compuman1112]

Nope i did not get any more specific error after changing those values.... So do you have any other idea?

[rocky]

Sorry, without a specific error message, there could be one of a billion different things going wrong and no way to know which one. You try checking your PHP error log in your cPanel to see if you can find a more useful error message there.

 

You could try copying the site to your localhost and upgrading it there, then transfer the files and database back to your server. That would get around the problem if it's a server issue. It wouldn't work if it's a programming issue though.

[compuman1112]

Upgrading under localhost doesn't work either. But i was able to found some of the error message;

SQL 1.6.0.10 1286 in CREATE TABLE `prstshp_smarty_cache` ( `id_smarty_cache` char(40) NOT NULL, `name` char(40), `cache_id` varchar(254) DEFAULT NULL, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `content` longtext NOT NULL, PRIMARY KEY (`id_smarty_cache`), KEY `name` (`name`), KEY `cache_id` (`cache_id`), KEY `modified` (`modified`) ) ENGINE=MariaDB DEFAULT CHARSET=utf8: Unknown storage engine 'MariaDB'
SQL 1.6.0.10 1286 in CREATE TABLE IF NOT EXISTS `prstshp_order_slip_detail_tax` ( `id_order_slip_detail` int(11) unsigned NOT NULL, `id_tax` int(11) unsigned NOT NULL, `unit_amount` decimal(16,6) NOT NULL DEFAULT '0.000000', `total_amount` decimal(16,6) NOT NULL DEFAULT '0.000000', KEY (`id_order_slip_detail`), KEY `id_tax` (`id_tax`) ) ENGINE=MariaDB DEFAULT CHARSET=utf8: Unknown storage engine 'MariaDB'
SQL 1.6.0.10 1286 in CREATE TABLE IF NOT EXISTS `prstshp_mail` ( `id_mail` int(11) unsigned NOT NULL AUTO_INCREMENT, `recipient` varchar(126) NOT NULL, `template` varchar(62) NOT NULL, `subject` varchar(254) NOT NULL, `id_lang` int(11) unsigned NOT NULL, `date_add` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id_mail`), KEY `recipient` (`recipient`(10)) ) ENGINE=MariaDB DEFAULT CHARSET=utf8: Unknown storage engine 'MariaDB'
SQL 1.6.0.12 1286 in CREATE TABLE `prstshp_cms_category_shop` ( `id_cms_category` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_shop` INT(11) UNSIGNED NOT NULL , PRIMARY KEY (`id_cms_category`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=MariaDB DEFAULT CHARSET=utf8: Unknown storage engine 'MariaDB'
SQL 1.6.1.0 1286 in CREATE TABLE `prstshp_tag_count` ( `id_group` int(10) unsigned NOT NULL DEFAULT 0, `id_tag` int(10) unsigned NOT NULL DEFAULT 0, `id_lang` int(10) unsigned NOT NULL DEFAULT 0, `id_shop` int(11) unsigned NOT NULL DEFAULT 0, `counter` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id_group`, `id_tag`), KEY (`id_group`, `id_lang`, `id_shop`, `counter`) ) ENGINE=MariaDB DEFAULT CHARSET=utf8: Unknown storage engine 'MariaDB'
SQL 1.6.1.0 1146 in REPLACE INTO `prstshp_tag_count` (id_group, id_tag, id_lang, id_shop, counter) SELECT cg.id_group, t.id_tag, t.id_lang, ps.id_shop, COUNT(pt.id_tag) AS times FROM `prstshp_product_tag` pt LEFT JOIN `prstshp_tag` t ON (t.id_tag = pt.id_tag) LEFT JOIN `prstshp_product` p ON (p.id_product = pt.id_product) INNER JOIN `prstshp_product_shop` product_shop ON (product_shop.id_product = p.id_product) JOIN (SELECT DISTINCT id_group FROM `prstshp_category_group`) cg JOIN (SELECT DISTINCT id_shop FROM `prstshp_shop`) ps WHERE pt.`id_lang` = 1 AND product_shop.`active` = 1 AND EXISTS(SELECT 1 FROM `prstshp_category_product` cp LEFT JOIN `prstshp_category_group` cgo ON (cp.`id_category` = cgo.`id_category`) WHERE cgo.`id_group` = cg.id_group AND p.`id_product` = cp.`id_product`) AND product_shop.id_shop = ps.id_shop GROUP BY pt.id_tag, cg.id_group: Table 'prestashop.prstshp_tag_count' doesn't exist
SQL 1.6.1.0 1146 in REPLACE INTO `prstshp_tag_count` (id_group, id_tag, id_lang, id_shop, counter) SELECT 0, t.id_tag, t.id_lang, ps.id_shop, COUNT(pt.id_tag) AS times FROM `prstshp_product_tag` pt LEFT JOIN `prstshp_tag` t ON (t.id_tag = pt.id_tag) LEFT JOIN `prstshp_product` p ON (p.id_product = pt.id_product) INNER JOIN `prstshp_product_shop` product_shop ON (product_shop.id_product = p.id_product) JOIN (SELECT DISTINCT id_shop FROM `prstshp_shop`) ps WHERE pt.`id_lang` = 1 AND product_shop.`active` = 1 AND product_shop.id_shop = ps.id_shop GROUP BY pt.id_tag: Table 'prestashop.prstshp_tag_count' doesn't exist
SQL 1.6.1.0 1286 in CREATE TABLE `prstshp_smarty_lazy_cache` ( `template_hash` varchar(32) NOT NULL DEFAULT '', `cache_id` varchar(255) NOT NULL DEFAULT '', `compile_id` varchar(32) NOT NULL DEFAULT '', `filepath` varchar(255) NOT NULL DEFAULT '', `last_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`template_hash`, `cache_id`, `compile_id`) ) ENGINE=MariaDB DEFAULT CHARSET=utf8: Unknown storage engine 'MariaDB'
SQL 1.6.1.0 1286 in CREATE TABLE `prstshp_smarty_last_flush` ( `type` ENUM('compile', 'template'), `last_flush` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`type`) ) ENGINE=MariaDB DEFAULT CHARSET=utf8: Unknown storage engine 'MariaDB'
SQL 1.6.1.0 1286 in CREATE TABLE `prstshp_modules_perfs` ( `id_modules_perfs` int(11) unsigned NOT NULL AUTO_INCREMENT, `session` int(11) unsigned NOT NULL, `module` varchar(62) NOT NULL, `method` varchar(126) NOT NULL, `time_start` double unsigned NOT NULL, `time_end` double unsigned NOT NULL, `memory_start` int unsigned NOT NULL, `memory_end` int unsigned NOT NULL, PRIMARY KEY (`id_modules_perfs`), KEY (`session`) ) ENGINE=MariaDB DEFAULT CHARSET=utf8: Unknown storage engine 'MariaDB'
SQL 1.6.1.0 1146 in ALTER TABLE `prstshp_smarty_lazy_cache` CHANGE `cache_id` `cache_id` varchar(255) NOT NULL DEFAULT '': Table 'prestashop.prstshp_smarty_lazy_cache' doesn't exist
SQL 1.6.1.0 1146 in TRUNCATE TABLE `prstshp_smarty_lazy_cache`: Table 'prestashop.prstshp_smarty_lazy_cache' doesn't exist
SQL 1.6.1.0 1286 in /* Advanced EU Compliance tables */ CREATE TABLE IF NOT EXISTS `prstshp_cms_role` ( `id_cms_role` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `id_cms` int(11) unsigned NOT NULL, PRIMARY KEY (`id_cms_role`, `id_cms`), UNIQUE KEY `name` (`name`) ) ENGINE=MariaDB DEFAULT CHARSET=utf8: Unknown storage engine 'MariaDB'
SQL 1.6.1.0 1286 in CREATE TABLE IF NOT EXISTS `prstshp_cms_role_lang` ( `id_cms_role` int(11) unsigned NOT NULL, `id_lang` int(11) unsigned NOT NULL, `id_shop` int(11) unsigned NOT NULL, `name` varchar(128) DEFAULT NULL, PRIMARY KEY (`id_cms_role`,`id_lang`, `id_shop`) ) ENGINE=MariaDB DEFAULT CHARSET=utf8: Unknown storage engine 'MariaDB'
SQL 1.6.1.2 1146 in REPLACE INTO `prstshp_tag_count` (id_group, id_tag, id_lang, id_shop, counter) SELECT cg.id_group, pt.id_tag, pt.id_lang, id_shop, COUNT(pt.id_tag) AS times FROM `prstshp_product_tag` pt INNER JOIN `prstshp_product_shop` product_shop USING (id_product) JOIN (SELECT DISTINCT id_group FROM `prstshp_category_group`) cg WHERE product_shop.`active` = 1 AND EXISTS(SELECT 1 FROM `prstshp_category_product` cp LEFT JOIN `prstshp_category_group` cgo ON (cp.`id_category` = cgo.`id_category`) WHERE cgo.`id_group` = cg.id_group AND product_shop.`id_product` = cp.`id_product`) GROUP BY pt.id_tag, pt.id_lang, cg.id_group, id_shop ORDER BY NULL: Table 'prestashop.prstshp_tag_count' doesn't exist
SQL 1.6.1.2 1146 in REPLACE INTO `prstshp_tag_count` (id_group, id_tag, id_lang, id_shop, counter) SELECT 0, pt.id_tag, pt.id_lang, id_shop, COUNT(pt.id_tag) AS times FROM `prstshp_product_tag` pt INNER JOIN `prstshp_product_shop` product_shop USING (id_product) WHERE product_shop.`active` = 1 GROUP BY pt.id_tag, pt.id_lang, id_shop ORDER BY NULL: Table 'prestashop.prstshp_tag_count' doesn't exist
SQL 1.6.1.2 1146 in TRUNCATE TABLE `prstshp_smarty_last_flush`: Table 'prestashop.prstshp_smarty_last_flush' doesn't exist

[bellini13]

Those are not errors, they are just messages from upgrading your database

 

What version of Prestashop are you currently on, and what version are you trying to upgrade to?

[compuman1112]

Version now: 1.6.0.9 i'm trying to upgrade to the newest version availible. In some lines it tells "doesnt exist", can that be the problem?

Edited November 18, 2016 by compuman1112 (see edit history)

[bellini13]

what version is "the newest version available"?