SendCloud / sendcloud

A Magento 2 module for Sendcloud
9 stars 21 forks source link

Error when upgrading to version 1.8.2 (using Composer) #122

Closed DJB95 closed 2 years ago

DJB95 commented 2 years ago

When upgrading to the latest version using Magento Marketplace (using Composer), I'm getting this error after setup:upgrade command:

SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'sen_condition_name' doesn't exist in table, query was: ALTER TABLE sendcloud_servicepointrate DROP COLUMN sen_condition_name, ADD CONSTRAINT UNQ_C0DB67076EAA5EA868F15196691297E7 UNIQUE KEY (website_id,dest_country_id,dest_region_id,dest_zip,condition_name,condition_value)

When checking the table, the column DOES exist image

Can you tell me how I can fix this?

bamboekeizer commented 2 years ago

I have the same issue. But how is it possible the upgraded version is 1.8.2 while according to github version 1.8.0 is the latest?

DJB95 commented 2 years ago

@bamboekeizer I've been in contact with them. should be fixed somewhere next week. update from Magento Marketplace https://marketplace.magento.com/sendcloud-sendcloud.html

temporary fix would be to downgrade back to 1.8.0 (I did this to fix it for the time being)

michel334 commented 2 years ago

Same error is in Sendcloud version 1.8.3 using composer (magento version 2.3.2)

$ COMPOSER_MEMORY_LIMIT=-1 composer require sendcloud/sendcloud Using version ^1.8 for sendcloud/sendcloud ./composer.json has been updated Loading composer repositories with package information Updating dependencies (including require-dev) Package operations: 0 installs, 1 update, 0 removals

$ php bin/magento setup:upgrade Cache cleared successfully File system cleanup: Updating modules: Schema creation/updates: SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'sen_condition_name' doesn't exist in table, query was: ALTER TABLE sendcloud_servicepointrate DROP COLUMN sen_condition_name, ADD CONSTRAINT UNQ_C0DB67076EAA5EA868F15196691297E7 UNIQUE KEY (website_id,dest_country_id,dest_region_id,dest_zip,condition_name,condition_value)

pkrstojevic-logeecom commented 2 years ago

New version of the plugin released. Closing this issue.