Jump to content

erreur sql mise lour


Recommended Posts

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 NULL

ALTER TABLE 113749mjbfnrange_price CHANGE `delimiter2` `delimiter2` DECIMAL(13, 6) NOT NULL

ALTER TABLE 113749mjbfnrange_price CHANGE `id_carrier` `id_carrier` INT(10) UNSIGNED NOT NULL

ALTER 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 NULL

ALTER TABLE 113749mjbfnrange_weight CHANGE `delimiter2` `delimiter2` DECIMAL(13, 6) NOT NULL

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...