1click Update Fails for DB insert error

[sim1-81]

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?

Edited December 9, 2020 by sim1-81 (see edit history)

[MaximeMichaud]

I'm having the same problem but with 1.6 to 1.7

SQL 1.7.6.2 1136 in INSERT INTO `ps3_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 `ps3_product_lang` entity LEFT JOIN `ps3_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 1Error during database upgrade. You may need to restore your database.Error upgrading Doctrine schema

Edited February 18, 2021 by MaximeMichaud (see edit history)