Social: Error on upgrade to 0.2.100 on PostgreSQL

[lachmanfrantisek]

Got an error when upgrading to 0.2.100 from 0.2.6 on PostgreSQL.

Doctrine\DBAL\Exception\NotNullConstraintViolationException:
An exception occurred while executing 'ALTER TABLE oc_social_a2_cache_documts ADD resized_copy TEXT NOT NULL':
SQLSTATE[23502]: Not null violation: 7 ERROR: column "resized_copy" contains null values

I can add more info about my server if it is needed.

[ArtificialOwl]

can you empty the entries from the table oc_social_a2_cache_documts ?

[service4me-gk]

I had the same problem and yes DELETE FROM oc_social_a2_cache_documts; did clear the problem for me.

[warnerbryce]

Had the same problem : DELETE FROM oc_social_a2_cache_documts; inside psql made the trick.
Hope it will be modified soon for a fix on the next version.

[ArtificialOwl]

should be fixed with 0.2.101

[service4me-gk]

On an other installation with PostgreSQL the update from 0.2.6 to 0.2.101 works without Problem for me.
Thanks for the quick fix;)

[lachmanfrantisek]

Upgrade to 0.2.101 works well, thanks!