I switched over to use project file settings and now I occasionally get a constraint violation when trying to run the craft projectconfig/sync command.

I think this is a bug, because the

UPDATE `info` SET `id`=1, `version`='', `schemaVersion`='3.3.3', `maintenance`=0, `config`=' ...` 

statement seem to be missing a WHERE, which means it tries to set ALL rows in table info to the same values. For some reason, I end up having 2 rows in info where the one with id=2 is basically empty.

This is on version

Invoking a DELETE FROM info WHERE id = 2; resolves the situation in my case, but it is a bit cumbersome that this happens.


As far as I know the craft_info table should only have one row.

This would mean that either:

  1. You have something installed / configured wrongly somewhere causing it to insert a 2nd row into the table

  2. Or it's actually a craft bug, I'd advise you to search through The CraftCMS Github Issues and check if there's any issue resembling yours, if not create an issue there so it gets solved in the next few updates.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.