Hello everybody,
i'm trying to update from 1.5.2 to 1.7.7 with 1-Click Upgrade module v4.11.0, but it fails with those errors:
SQL 1.7.6.2 1136 in INSERT INTO `prefix_category_lang` SELECT `entity`.`id_category`, 1, `entity`.`id_lang`, `entity`.`name`, `entity`.`description`, `entity`.`link_rewrite`, `entity`.`meta_title`, `entity`.`meta_keywords`, `entity`.`meta_description` FROM `prefix_category_lang` entity LEFT JOIN `prefix_category_lang` entity2 ON `entity2`.`id_shop` = 1 AND `entity`.`id_category` = `entity2`.`id_category` WHERE `entity2`.`id_shop` IS NULL: Column count doesn't match value count at row 1SQL 1.7.6.2 1136 in INSERT INTO `prefix_product_lang` SELECT `entity`.`id_product`, 1, `entity`.`id_lang`, `entity`.`description`, `entity`.`description_short`, `entity`.`link_rewrite`, `entity`.`meta_description`, `entity`.`meta_keywords`, `entity`.`meta_title`, `entity`.`name`, `entity`.`available_now`, `entity`.`available_later`, `entity`.`delivery_in_stock`, `entity`.`delivery_out_stock` FROM `prefix_product_lang` entity LEFT JOIN `prefix_product_lang` entity2 ON `entity2`.`id_shop` = 1 AND `entity`.`id_product` = `entity2`.`id_product` WHERE `entity2`.`id_shop` IS NULL: Column count doesn't match value count at row 1
Error during database upgrade. You may need to restore your database.Error upgrading Doctrine schema
The problem is that, some installed module has added colums to table category_lang and product_lang, those fields are managed using the classes override as indicated into the best pratcties. Why the module does'not use the simply listing of fields INSERT INTO (field1,field2,field3,...) VALUES (......) instead to use SELECT ..... to retrieve the fields?
i think this is a bug because the added fields are nullable
how/where i can intervene in the module code to fix this?