laurent26 Posted February 7, 2008 Share Posted February 7, 2008 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 More sharing options...
DrÿSs' Posted February 8, 2008 Share Posted February 8, 2008 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 More sharing options...
laurent26 Posted February 9, 2008 Author Share Posted February 9, 2008 merci de votre reponse encore une question, la version 0.9.7 tien elle compte de ces modification ? merci d'avance Link to comment Share on other sites More sharing options...
laurent26 Posted March 11, 2008 Author Share Posted March 11, 2008 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 More sharing options...
Bruno Leveque Posted March 12, 2008 Share Posted March 12, 2008 Bonjour Laurent, Je ne vois aucune erreur dans le texte que vous avez collé ? Cordialement, Link to comment Share on other sites More sharing options...
laurent26 Posted March 17, 2008 Author Share Posted March 17, 2008 merci de votre réponse je souhaite juste savoir ce que ve dire ces messages dans le rapport merci d'avance pour votre réponse Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now