Jump to content

1click Update Fails for DB insert error


Recommended Posts

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 by sim1-81 (see edit history)
Link to comment
Share on other sites

  • 2 months later...

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 by MaximeMichaud (see edit history)
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...