Update to 1.4 error: Unfortunately, 164 SQL errors have occurred.

[pichek]

Hello,

Please help me if possible.

I had multiply errors while trying to upgrade from 1.3.6 to 1.4. On the last update page of Prestashop installation it said your update is complete and 1.4 is installed yet on the same page it said the following: Unfortunately, 164 SQL errors have occurred. there is also View the Log here's the partial context of the log:

ALTER TABLE `ps_employee` ADD `bo_color` varchar(32) default NULL AFTER `stats_date_to`

(1060) Duplicate column name 'bo_color'

ALTER TABLE `ps_employee` ADD `bo_theme` varchar(32) default NULL AFTER `bo_color`

(1060) Duplicate column name 'bo_theme'

ALTER TABLE `ps_employee` ADD `bo_uimode` ENUM('hover','click') default 'click' AFTER `bo_theme`

(1060) Duplicate column name 'bo_uimode'

ALTER TABLE `ps_employee` ADD `id_lang` int(10) unsigned NOT NULL default 0 AFTER `id_profile`

(1060) Duplicate column name 'id_lang'

ALTER TABLE `ps_cms` ADD `id_cms_category` int(10) unsigned NOT NULL default '0' AFTER `id_cms`

(1060) Duplicate column name 'id_cms_category'

ALTER TABLE `ps_cms` ADD `position` int(10) unsigned NOT NULL default '0' AFTER `id_cms_category`

(1060) Duplicate column name 'position'

CREATE TABLE `ps_cms_category` ( `id_cms_category` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_parent` int(10) unsigned NOT NULL, `level_depth` tinyint(3) unsigned NOT NULL DEFAULT '0', `active` tinyint(1) unsigned NOT NULL DEFAULT '0', `date_add` datetime NOT NULL, `date_upd` datetime NOT NULL, `position` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id_cms_category`), KEY `category_parent` (`id_parent`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_cms_category' already exists


That's only a few of them. Also, I cannot load back office it says "resulted in too many redirects".

I tried to update couple of times, by returning everything to the previous state, and result is always the same.

If anyone came across such problem, your help is much appreciated.

Thanks

[zaph]

same here!
"Unfortunately, 164 SQL errors have occurred"


anything to worry before going back online with the shop????

BIG thanks for any input and to avoid any possible catastrophe!


attached the error-log as txt.file

164SQLerrors.txt