bonjour,
problème mise à jour depuis la version com_virtuemart.3.6.3.10163 et suivantes
un nouveau champ noninheritable semble être ajouté quand on regardes install.sql
CREATE TABLE IF NOT EXISTS `#__virtuemart_product_customfields` (
`virtuemart_customfield_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'field id',
`virtuemart_product_id` int(1) NOT NULL DEFAULT '0',
`virtuemart_custom_id` int(1) NOT NULL DEFAULT '1' COMMENT 'custom group id',
`customfield_value` varchar(2500) COMMENT 'field value',
`customfield_price` decimal(15,6) COMMENT 'price',
`disabler` INT(1) UNSIGNED NOT NULL DEFAULT '0',
`override` INT(1) UNSIGNED NOT NULL DEFAULT '0',
`noninheritable` INT(1) UNSIGNED NOT NULL DEFAULT '0',
`customfield_params` text COMMENT 'Param for Plugins',
`product_sku` varchar(64),
`product_gtin` varchar(64),
`product_mpn` varchar(64),
`published` tinyint(1) NOT NULL DEFAULT '1',
`created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_by` int(1) UNSIGNED NOT NULL DEFAULT '0',
`modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified_by` int(1) UNSIGNED NOT NULL DEFAULT '0',
`locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`locked_by` int(1) UNSIGNED NOT NULL DEFAULT '0',
`ordering` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`virtuemart_customfield_id`),
KEY `virtuemart_product_id` (`virtuemart_product_id`,`ordering`),
KEY `virtuemart_custom_id` (`virtuemart_custom_id`),
KEY `published` (`published`),
KEY `ordering` (`ordering`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='custom fields' AUTO_INCREMENT=1 ;
Dans la version précédente com_virtuemart.3.6.2.10159 , il n'y est pas
CREATE TABLE IF NOT EXISTS `#__virtuemart_product_customfields` (
`virtuemart_customfield_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'field id',
`virtuemart_product_id` int(1) NOT NULL DEFAULT '0',
`virtuemart_custom_id` int(1) NOT NULL DEFAULT '1' COMMENT 'custom group id',
`customfield_value` varchar(2500) COMMENT 'field value',
`customfield_price` decimal(15,6) COMMENT 'price',
`disabler` INT(1) UNSIGNED NOT NULL DEFAULT '0',
`override` INT(1) UNSIGNED NOT NULL DEFAULT '0',
`customfield_params` text COMMENT 'Param for Plugins',
`product_sku` varchar(64),
`product_gtin` varchar(64),
`product_mpn` varchar(64),
`published` tinyint(1) NOT NULL DEFAULT '1',
`created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_by` int(1) UNSIGNED NOT NULL DEFAULT '0',
`modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified_by` int(1) UNSIGNED NOT NULL DEFAULT '0',
`locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`locked_by` int(1) UNSIGNED NOT NULL DEFAULT '0',
`ordering` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`virtuemart_customfield_id`),
KEY `virtuemart_product_id` (`virtuemart_product_id`,`ordering`),
KEY `virtuemart_custom_id` (`virtuemart_custom_id`),
KEY `published` (`published`),
KEY `ordering` (`ordering`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='custom fields' AUTO_INCREMENT=1 ;
Pouriez-vous effectuer la correction afin que ce champ
`noninheritable` INT(1) UNSIGNED NOT NULL DEFAULT '0',
se mette à jour dans les versions récentes , SVP ?
Secours: requête utiliser pour l'ajout de ce champ
ALTER TABLE `xxxx_virtuemart_product_customfields` ADD `noninheritable` INT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `override`;
cordialement,
Phil