[SOLUCIONADO] Problema BD en migración 1.3.0.10 -> 1.3.5.0: Unknown column 'reduction_percent' in 'field list'

[tuverano.com]

Hola, me he actualizado de versión. No he actualizado la BD solo el paquete 1.3.0.10. Obtengo en el momento de finalizar un pedido:

Unknown column 'reduction_percent' in 'field list'

INSERT INTO `order_detail`
(`id_order`, `product_id`, `product_attribute_id`, `product_name`, `product_quantity`, `product_quantity_in_stock`, `product_price`, `reduction_percent`, `reduction_amount`, `group_reduction`, `product_quantity_discount`, `product_ean13`, `product_reference`, `product_supplier_reference`, `product_weight`, `tax_name`, `tax_rate`, `ecotax`, `ecotax_tax_rate`, `discount_quantity_applied`, `download_deadline`, `download_hash`)
VALUE ...
'')

Para una migración de este tipo existe algún fichero .sql para actualizar la base de datos ??? No lo he visto.

Gracias de antemano.

Saludos,

[tuverano.com]

ok, veo que están en install/sql/upgrade. He ejecutado manualmente los sql desde la versión 1.3.0.1 a 1.3.5.0. Parece que durante la instalación hubo algún problema y no se ejecutaron:

SET NAMES 'utf8';

ALTER TABLE `order_detail` ADD `reduction_percent` DECIMAL(10, 2) NOT NULL AFTER `product_price`;
ALTER TABLE `order_detail` ADD `reduction_amount` DECIMAL(20, 6) NOT NULL AFTER `reduction_percent`;

ALTER TABLE `country` CHANGE `need_identification_number` `need_identification_number` TINYINT(1) NOT NULL DEFAULT '0';

INSERT INTO `configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES
('PS_1_3_2_UPDATE_DATE', NOW(), NOW(), NOW());

ALTER TABLE `search_index` CHANGE `weight` `weight` SMALLINT(4) unsigned NOT NULL DEFAULT '1';

ALTER TABLE `image` DROP INDEX `product_position`, ADD UNIQUE `product_position` (`id_product`, `position`);

ALTER TABLE `zone` DROP `enabled`;

SET @id_hook = (SELECT id_hook FROM hook WHERE name = 'backOfficeHeader');
SET @position = (SELECT IFNULL(MAX(position),0)+1 FROM hook_module WHERE id_hook = @id_hook);
INSERT IGNORE INTO hook_module (id_hook, id_module, position) VALUES (@id_hook, (SELECT id_module FROM module WHERE name = 'statsbes
tcustomers'), @position);
SET @position = @position + 1;
INSERT IGNORE INTO hook_module (id_hook, id_module, position) VALUES (@id_hook, (SELECT id_module FROM module WHERE name = 'statsbes
tproducts'), @position);
SET @position = @position + 1;
INSERT IGNORE INTO hook_module (id_hook, id_module, position) VALUES (@id_hook, (SELECT id_module FROM module WHERE name = 'statsbes
tvouchers'), @position);
SET @position = @position + 1;
INSERT IGNORE INTO hook_module (id_hook, id_module, position) VALUES (@id_hook, (SELECT id_module FROM module WHERE name = 'statsbes
tcategories'), @position);
SET @position = @position + 1;
INSERT IGNORE INTO hook_module (id_hook, id_module, position) VALUES (@id_hook, (SELECT id_module FROM module WHERE name = 'statsbes
tcarriers'), @position);