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.
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.