Jump to content

pb update 0.9.5.2 ==> 0.9.6


Recommended Posts

bonjour aprés la mise à jour de la base de donner j'ai un rapport erreur ???

 

---------------------------------------------------------------

 

/* STRUCTURE */ CREATE TABLE `ps_alias` ( alias varchar(255) NOT NULL, search varchar(255) NOT NULL, active tinyint(1) NOT NULL default 1, id_alias int(10) NOT NULL auto_increment, PRIMARY KEY (id_alias), UNIQUE KEY alias (alias) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

 

 

ALTER TABLE `ps_configuration` ADD UNIQUE `name` (`name`)

 

 

ALTER TABLE `ps_product` ADD `wholesale_price` DECIMAL( 13, 6 ) NOT NULL AFTER `price`

 

 

ALTER TABLE `ps_range_weight` CHANGE `delimiter1` `delimiter1` DECIMAL( 13, 6 ) NOT NULL DEFAULT '0.000000'

 

 

ALTER TABLE `ps_range_weight` CHANGE `delimiter2` `delimiter2` DECIMAL( 13, 6 ) NOT NULL DEFAULT '0.000000'

 

 

ALTER TABLE `ps_discount_type_lang` CHANGE `name` `name` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL

 

 

ALTER TABLE `ps_product` CHANGE `bargain` `on_sale` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0

 

 

ALTER TABLE `ps_image_type` ADD `suppliers` BOOL NOT NULL DEFAULT 1

 

 

/* CONTENTS */ /* Adding tab alias */ INSERT INTO `ps_tab` (`id_parent`, `class_name`, `position`) VALUES ((SELECT `id_tab` FROM `ps_tab` t WHERE t.class_name = 'AdminTools' LIMIT 1), 'AdminAliases', 9)

 

(1093) You can't specify target table 'ps_tab' for update in FROM clause

 

INSERT INTO `ps_tab_lang` (id_lang, id_tab, name) ( SELECT id_lang, (SELECT `id_tab` FROM `ps_tab` t WHERE t.class_name = 'AdminAliases' LIMIT 1), 'Alias' FROM `ps_lang`)

 

 

INSERT INTO `ps_access` (`id_profile`, `id_tab`, `view`, `add`, `edit`, `delete`) VALUES ('1', (SELECT `id_tab` FROM `ps_tab` t WHERE t.class_name = 'AdminAliases' LIMIT 1), '1', '1', '1', '1')

 

(1048) Column 'id_tab' cannot be null

 

/* Adding tab import */ INSERT INTO `ps_tab` (`id_parent`, `class_name`, `position`) VALUES ((SELECT `id_tab` FROM `ps_tab` t WHERE t.class_name = 'AdminTools' LIMIT 1), 'AdminImport', 10)

 

(1093) You can't specify target table 'ps_tab' for update in FROM clause

 

INSERT INTO `ps_tab_lang` (id_lang, id_tab, name) ( SELECT id_lang, (SELECT `id_tab` FROM `ps_tab` t WHERE t.class_name = 'AdminImport' LIMIT 1), 'Import' FROM `ps_lang`)

 

 

INSERT INTO `ps_access` (`id_profile`, `id_tab`, `view`, `add`, `edit`, `delete`) VALUES ('1', (SELECT `id_tab` FROM `ps_tab` t WHERE t.class_name = 'AdminImport' LIMIT 1), '1', '1', '1', '1')

 

(1048) Column 'id_tab' cannot be null

 

INSERT INTO `ps_hook` (`name`, `title`, `description`) VALUES ('adminOrder', 'Display in Back-Office, tab AdminOrder', 'Launch modules when the tab AdminOrder is displayed on back-office.')

 

 

/* CONFIGURATION VARIABLE */ /* STRUCTURE */ ALTER TABLE `ps_product` CHANGE `wholesale_price` `wholesale_price` DECIMAL(13, 6) NULL

 

 

/* CONTENTS */ /* CONFIGURATION VARIABLE */

 

 

----------------------------------------------------------------------------------

 

pouvez vous m'aidez svp

 

Link to comment
Share on other sites

Votre serveur MySQL est configuré en mode strict, il n'accepte pas que l'on fasse un select sur la même table où l'on est en train d'insérer une donnée.

 

Nous allons essayer de trouver un autre moyen de procéder pour la prochaine release, merci pour votre patience :)

Link to comment
Share on other sites

  • 1 month later...

bonjour j'ai upgrader en 0.9.7 et j'ai encore ce message dans le rapport de mise à jour

/* STRUCTURE */ ALTER TABLE `ps_module` ADD INDEX (`name`)

 

 

/* CONTENTS */ INSERT INTO `ps_hook` (`name` , `title`, `description`, `position`) VALUES ('footer', 'Footer', 'Add block in footer', 1), ('PDFInvoice', 'PDF Invoice', 'Allow the display of extra informations into the PDF invoice', 0)

 

 

UPDATE `ps_hook` SET `description` = 'Add blocks in the header', `position` = '1' WHERE `name` = 'head

 

que cela signifie, et quel impact sur la mise à jour

d'avance merci

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
×
×
  • Create New...