plan2net/webp

Database update error

plojewski opened this issue · 2 comments

plojewski commented

Hi there,
after update from ^3.3 to ^4.1 I'm trying to Analyze Database Structure:

ALTER TABLE "tx_webp_failed" ALTER "configuration_hash" TYPE VARCHAR(32) Current value: configuration_hash VARCHAR(40) DEFAULT NULL

After that I've got an error:

Database update failed
Error: SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too long for type character varying(32)

I use PostgreSQL 12.5 and PostgreSQL 13.1

akiessling commented

That happens on MySQL too since the field is now smaller due to 5aca921#diff-63c8ca47fb6e2c18d65f7949fe8c05ca6c9108b1bf825b90803d1e0190c601eaL7
So we should probably just truncate the table?

wazum commented

Please simply truncate the table tx_webp_failed. I think that here the effort of a migration is not in relation to the benefit.