Unfortunately, 13 SQL errors have occurred. disaster again upgrade from 1.4.01 to 1.4.02

[prestachina]

Congratulations!
Update is finished!
Unfortunately, 13 SQL errors have occurred.

View the log

SET NAMES 'utf8'


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


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


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


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


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


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


CREATE TABLE `sz_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


CREATE TABLE `sz_cms_category_lang` ( `id_cms_category` int(10) unsigned NOT NULL, `id_lang` int(10) unsigned NOT NULL, `name` varchar(128) NOT NULL, `description` text, `link_rewrite` varchar(128) NOT NULL, `meta_title` varchar(128) DEFAULT NULL, `meta_keywords` varchar(255) DEFAULT NULL, `meta_description` varchar(255) DEFAULT NULL, UNIQUE KEY `category_lang_index` (`id_cms_category`,`id_lang`), KEY `category_name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8


INSERT INTO `sz_cms_category_lang` VALUES(1, 1, 'Home', '', 'home', NULL, NULL, NULL)


INSERT INTO `sz_cms_category_lang` VALUES(1, 2, 'Accueil', '', 'home', NULL, NULL, NULL)


INSERT INTO `sz_cms_category_lang` VALUES(1, 3, 'Inicio', '', 'home', NULL, NULL, NULL)


INSERT INTO `sz_cms_category` VALUES(1, 0, 0, 1, NOW(), NOW(),0)


UPDATE `sz_cms_category` SET `position` = 0


UPDATE `sz_cms` SET `position` = 0


UPDATE `sz_cms` SET `id_cms_category` = 0


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


UPDATE `sz_employee` SET `id_lang` = (SELECT `value` FROM `sz_configuration` WHERE `name` LIKE "PS_LANG_DEFAULT")


ALTER TABLE `sz_customer` ADD `note` text AFTER `secure_key`


ALTER TABLE `sz_contact` ADD `customer_service` tinyint(1) NOT NULL DEFAULT 0 AFTER `email`


CREATE TABLE `sz_customer_thread` ( `id_customer_thread` int(11) unsigned NOT NULL auto_increment, `id_lang` int(10) unsigned NOT NULL, `id_contact` int(10) unsigned NOT NULL, `id_customer` int(10) unsigned default NULL, `id_order` int(10) unsigned default NULL, `id_product` int(10) unsigned default NULL, `status` enum('open','closed','pending1','pending2') NOT NULL default 'open', `email` varchar(128) NOT NULL, `token` varchar(12) default NULL, `date_add` datetime NOT NULL, `date_upd` datetime NOT NULL, PRIMARY KEY (`id_customer_thread`), KEY `id_customer_thread` (`id_customer_thread`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8


CREATE TABLE `sz_customer_message` ( `id_customer_message` int(10) unsigned NOT NULL auto_increment, `id_customer_thread` int(11) default NULL, `id_employee` int(10) unsigned default NULL, `message` text NOT NULL, `file_name` varchar(18) DEFAULT NULL, `ip_address` int(11) default NULL, `user_agent` varchar(128) default NULL, `date_add` datetime NOT NULL, PRIMARY KEY (`id_customer_message`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8


CREATE TABLE `sz_payment_cc` ( `id_payment_cc` INT NOT NULL auto_increment, `id_order` INT UNSIGNED NULL, `id_currency` INT UNSIGNED NOT NULL, `amount` DECIMAL(10,2) NOT NULL, `transaction_id` VARCHAR(254) NULL, `card_number` VARCHAR(254) NULL, `card_brand` VARCHAR(254) NULL, `card_expiration` CHAR(7) NULL, `card_holder` VARCHAR(254) NULL, `date_add` DATETIME NOT NULL, PRIMARY KEY (`id_payment_cc`), KEY `id_order` (`id_order`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8


CREATE TABLE `sz_specific_price` ( `id_specific_price` INT UNSIGNED NOT NULL AUTO_INCREMENT, `id_product` INT UNSIGNED NOT NULL, `id_shop` TINYINT UNSIGNED NOT NULL, `id_currency` INT UNSIGNED NOT NULL, `id_country` INT UNSIGNED NOT NULL, `id_group` INT UNSIGNED NOT NULL, `priority` SMALLINT UNSIGNED NOT NULL, `price` DECIMAL(20, 6) NOT NULL, `from_quantity` SMALLINT UNSIGNED NOT NULL, `reduction` DECIMAL(20, 6) NOT NULL, `reduction_type` ENUM('amount', 'percentage') NOT NULL, `from` DATETIME NOT NULL, `to` DATETIME NOT NULL, PRIMARY KEY(`id_specific_price`), KEY (`id_product`, `id_shop`, `id_currency`, `id_country`, `id_group`, `from_quantity`, `from`, `to`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8


INSERT INTO `sz_specific_price` (`id_product`, `id_shop`, `id_currency`, `id_group`, `price`, `from_quantity`, `reduction`, `reduction_type`, `from`, `to`) ( SELECT dq.`id_product`, 1, 1, 1, 0.00, dq.`quantity`, IF(dq.`id_discount_type` = 2, (dq.`value` / (1 + t.`rate` / 100)), dq.`value` / 100), IF (dq.`id_discount_type` = 2, 'amount', 'percentage'), '0000-00-00 00:00:00', '0000-00-00 00:00:00' FROM `sz_discount_quantity` dq INNER JOIN `sz_product` p ON (p.`id_product` = dq.`id_product`) INNER JOIN `sz_tax` t ON (t.`id_tax` = p.`id_tax`) )


DROP TABLE `sz_discount_quantity`


INSERT INTO `sz_specific_price` (`id_product`, `id_shop`, `id_currency`, `id_group`, `price`, `from_quantity`, `reduction`, `reduction_type`, `from`, `to`) ( SELECT p.`id_product`, 1, 1, 1, 0.00, 1, IF(p.`reduction_price` > 0, (p.`reduction_price` / (1 + t.`rate` / 100)), p.`reduction_percent` / 100), IF(p.`reduction_price` > 0, 'amount', 'percentage'), IF (p.`reduction_from` = p.`reduction_to`, '0000-00-00 00:00:00', p.`reduction_from`), IF (p.`reduction_from` = p.`reduction_to`, '0000-00-00 00:00:00', p.`reduction_to`) FROM `sz_product` p INNER JOIN `sz_tax` t ON (t.`id_tax` = p.`id_tax`)

[prestachina]

i am have problem when i upgrade from 1.3.1 to 1.4 , the site need start over again. so this time i test it in another test site that instored v1.4.01 and after i upgrade it to 1.402 i get error informatin as above. i don't know computer too much so i think these are some bugs. if anyone can fix these problem, please tell me how to do it, thanks

the site front office but when click payment tab the page is blank, i don't know whether it will affect others of the system in future. www.b2bsz.com

[prestachina]

the modules can't see them. the modules just show up for 2seconds and then diappeared when click the catalogs.

[jhnstcks]

You can't upgrade SVN versions, thats why theres so many errors

[prestachina]

i never use svn version, it is the restashop 1.4 Alpha 2
version i downloaded from PS

Prestashop 1.4 Alpha 2
Release for tests
Released on Nov. 10th, 2010
10,9 Mo
Consult the changelog
Download Prestashop v.1.4.0.2 Release for tests, not for production

[rocky]

According to the CHANGELOG, this bug has been fixed in PrestaShop v1.4 Alpha 3.

[prestachina]

ok thanks rocky, i think the prestashop team steal design it for France because many new modules in the new version are companies in France and most of these new modules are useless for other countries. Anyway thank the PS team offer us such a good shopping cart, i hope the new version design more module for international users. Such as add international carrier DHL, UPS etc, not just the carriers in France. lol