dutchheight / craft-cookie-boss

Allow your visitors to set their cookie preference.
Other
3 stars 1 forks source link

1.3.1 update not applying well on first install nor on update #14

Closed WHITE-developer closed 4 years ago

WHITE-developer commented 4 years ago

The new migrations from the 1.3.1 update aren't applying on a first install of the plugin. Trying to first install 1.3.0 and then updating to 1.3.1 is also not working. Bumping the schemaVersion by hand first to trigger the database update gives the following error:

Database Exception: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'desc' can't have a default value
The SQL being executed was: ALTER TABLE cookieboss_consentgroup CHANGE desc desc text NOT NULL DEFAULT ''

Migration: dutchheight\cookieboss\migrations\m200821_142415_edit_cookieboss_consentgroup_description

Output:

> alter column desc in table {{%cookieboss_consentgroup}} to text NOT NULL DEFAULT '' ...Exception: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'desc' can't have a default value
KevinBeckers commented 4 years ago

Fixed in v1.3.2