CBdException: Column 'id' cannot be null I receive the following error only when I clear the cache:



When I try to rebuild the image index, all of my image paths go missing.
I'm not sure what caused this error but I do need to fix it.

I've checked my image transforms and everything is named correctly. I even tried to delete and re-add and still nothing. I'm getting this same error on another one of my craft sites when I empty the cache.

I have no idea what's causing it.

I did come across this post:
CDbException: Column not found

I read through the comments but no solution has been posted. I did a db search for CONSTRAINT or FOREIGN KEY and have both.

Any and all help is appreciated.
Thanks in advance.



UPDATE!!!

Things I tested and found:

I looked at the assettransformindex in the database and it was empty.

I ran an INSERT statement to populate the rows with proper information - it inserted successfully.
I refreshed the site, the CBd exception was gone.

I cleared the cache, minus the image transform index and the site still worked perfectly.

I cleared the cache with image transform index selected and it stripped everything from the DB.

If I try to upload an asset that uses the transform, it throws the CBd exception again and clears the DB.

I hope this information helps...
Thank you in advance.
Turns out this was because several tables were missing the MySQL auto-increment flag for their id integer primary keys.