yack54 Posted October 19, 2010 Share Posted October 19, 2010 bonjour a toute et tous Comme beaucoup d'entre nous , je ne suis pas expert en la matière , mais apres une tentative de mise a jour je suis bloquer car le rapport m'indique des erreurs sql , en voici une copie , si quelqu'un peut me donner une indiquation sur la marche a suivre , merci a tous pour votre aide ALTER TABLE 113749mjbfnproduct_attribute ADD INDEX supplier_reference (supplier_reference)ALTER TABLE 113749mjbfnproduct_lang ADD INDEX id_product (id_product)ALTER TABLE 113749mjbfnproduct_lang ADD INDEX id_lang (id_lang)ALTER TABLE 113749mjbfnproduct_lang ADD INDEX `name` (`name`)ALTER TABLE 113749mjbfnproduct_lang ADD FULLTEXT KEY ftsname (`name`)ALTER TABLE 113749mjbfncart_discount ADD INDEX `id_discount` (`id_discount`)ALTER TABLE 113749mjbfndiscount_category ADD PRIMARY KEY (id_category,id_discount)ALTER TABLE 113749mjbfnimage_lang ADD INDEX id_image (id_image)ALTER TABLE 113749mjbfnrange_price CHANGE `delimiter1` `delimiter1` DECIMAL(13, 6) NOT NULLALTER TABLE 113749mjbfnrange_price CHANGE `delimiter2` `delimiter2` DECIMAL(13, 6) NOT NULLALTER TABLE 113749mjbfnrange_price CHANGE `id_carrier` `id_carrier` INT(10) UNSIGNED NOT NULLALTER TABLE 113749mjbfnrange_price DROP INDEX `range_price_unique`ALTER TABLE 113749mjbfnrange_price ADD UNIQUE KEY `id_carrier` (`id_carrier`,`delimiter1`,`delimiter2`)ALTER TABLE 113749mjbfnrange_weight CHANGE `delimiter1` `delimiter1` DECIMAL(13, 6) NOT NULLALTER TABLE 113749mjbfnrange_weight CHANGE `delimiter2` `delimiter2` DECIMAL(13, 6) NOT NULL 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