1-Click AutoUpgrade from 1.6.0.5 to 1.6.0.6

[jprr773]

First of all, be sure to have full database and code backup before performing anything with the 1-Click AutoUpgrade module.

 

I don't recommend AT ALL upgrading from 1.6.0.5 to 1.6.0.6 using 1-Click Upgrade module,

apparently it deletes tables...

After the update process, I was stunned to see all  tables from ps_a* to ps_cms_category were gone from my database.

 

I went thru the process ,apparently the upgrade process went well, only showed some messages on the upgradeDb:

 

[OK] SQL 1.6.0.6 SET NAMES 'utf8'
[OK] SQL 1.6.0.6 ALTER TABLE `ps_order_invoice_tax` ADD INDEX (`id_tax`)
[OK] SQL 1.6.0.6 INSERT IGNORE INTO `ps_meta` (`id_meta`, `page`, `configurable`) VALUES (NULL, 'products-comparison', '1'), (NULL, 'cms', '0'), (NULL, 'category', '0'), (NULL, 'product', '0'), (NULL, 'module-bankwire-payment', '0'), (NULL, 'module-bankwire-validation', '0'), (NULL, 'module-cheque-validation', '0'), (NULL, 'module-cheque-payment', '0')
[OK] SQL 1.6.0.6 INSERT IGNORE INTO `ps_theme_meta` ( `id_theme` , `id_meta` , `left_column` , `right_column` ) SELECT `ps_theme`.`id_theme` , `ps_meta`.`id_meta` , `default_left_column` , `default_right_column` FROM `ps_theme` , `ps_meta`
[WARNING] SQL 1.6.0.6 1060 in ALTER TABLE `ps_tab` ADD `hide_host_mode` tinyint(1) NOT NULL DEFAULT '0' AFTER `active`: Duplicate column name 'hide_host_mode'
[OK] SQL 1.6.0.6 UPDATE `ps_employee` SET `bo_theme` = 'default'
[OK] SQL 1.6.0.6 DELETE FROM `ps_image_type` WHERE `name` = 'cart_default'
[OK] SQL 1.6.0.6 INSERT INTO `ps_image_type` (`id_image_type`,`name`,`width`,`height`,`products`,`categories`,`manufacturers`,`suppliers`,`scenes`,`stores`) VALUES (NULL, 'cart_default', '80', '80', '1', '0', '0', '0', '0', '0')
[WARNING] SQL 1.6.0.6 1146 in ALTER TABLE `ps_cart_rule_combination` ADD INDEX `id_cart_rule_1` (`id_cart_rule_1`): Table 'lojadada.ps_cart_rule_combination' doesn't exist
[WARNING] SQL 1.6.0.6 1146 in ALTER TABLE `ps_cart_rule_combination` ADD INDEX `id_cart_rule_2` (`id_cart_rule_2`): Table 'lojadada.ps_cart_rule_combination' doesn't exist
[OK] PHP 1.6.0.6 : /* PHP:p1606module_exceptions(); */

 

Now I just can't access the backoffice, and when I try to open it I got this screen:

 

[PrestaShopDatabaseException]

Table 'myshop.ps_access' doesn't exist
 

				SELECT *				FROM `ps_access` a				LEFT JOIN `ps_tab` t ON t.id_tab = a.id_tab				WHERE `id_profile` = 0

at line 623 in file classes/db/Db.php

617. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);618. 		}619. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))620. 		{621. 			if ($sql)622. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');623. 			throw new PrestaShopDatabaseException($this->getMsgError());624. 		}625. 	}626. 627. 	/**

• DbCore->displayError - [line 313 - classes/db/Db.php] - [1 Arguments]

  Argument [0]				SELECT *				FROM `ps_access` a				LEFT JOIN `ps_tab` t ON t.id_tab = a.id_tab				WHERE `id_profile` = 0

• DbCore->query - [line 489 - classes/db/Db.php] - [1 Arguments]

  Argument [0]				SELECT *				FROM `ps_access` a				LEFT JOIN `ps_tab` t ON t.id_tab = a.id_tab				WHERE `id_profile` = 0

• DbCore->executeS - [line 143 - classes/Profile.php] - [1 Arguments]

  Argument [0]				SELECT *				FROM `ps_access` a				LEFT JOIN `ps_tab` t ON t.id_tab = a.id_tab				WHERE `id_profile` = 0

• ProfileCore::getProfileAccesses - [line 108 - classes/Profile.php] - [1 Arguments]
• ProfileCore::getProfileAccess - [line 362 - classes/controller/AdminController.php] - [2 Arguments]
• AdminControllerCore->__construct - [line 34 - controllers/admin/AdminDashboardController.php]
• AdminDashboardControllerCore->__construct - [line 135 - classes/controller/Controller.php] - [2 Arguments]
• ControllerCore::getController - [line 366 - classes/Dispatcher.php] - [1 Arguments]
• DispatcherCore->dispatch - [line 54 - dadaboodo/index.php]

 

 

I'm only glad to have a couple of cold beers in my fridge and a full backup.....

 

[Ecom]

Hi,

 

Did you find the solution?

When I used 1-Click one on my 1.6.0.6 version I got this message Unknown column 'hide_host_mode' in 'field list'

Do you know how to fix it?