I recently upgraded to the latest version of MAMP and now my unit tests that load fixtures have stopped working:
CDbException:
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]:
Integrity constraint violation:
1062 Duplicate entry '0' for key 'PRIMARY'
I had a similar problem before when using CDbFixtureManager with a model that uses BIGINT as the primary key and found a work around - don’t use CDbFixtureManager to load fixtures for that model.
But now its models that use integer for the primary key.