Saving an entry with a cropped image fails, field too long for column
Craft throws this error on save:
CDbCommand failed to execute the SQL statement: SQLSTATE: String data, right truncated: 1406 Data too long for column ‘field_imageCropped’ at row 1
This did not occur before the latest plugin and craft updates. Any help would be greatly appreciated.
Hi mxdgt, sorry for the delay.
I have been unable to reproduce this issue. How many images do you have in the field when this is happening?
June 12, 2017, 9:32 am
Only a single image is in the field. Out of interest, I setup a fresh install of Craft, installed the plugin, setup a section with a single field for ansel and got the same error.
June 15, 2017, 8:51 pm
I think I found a solution - see private info
June 15, 2017, 9:25 pm
Ahh, yeah, I could see that being a problem. Odd that I am not able to reproduce it though. I’m traveling this weekend but I should be able to push that fix out Monday or Tuesday.
June 16, 2017, 7:04 am
I’ve attached a beta of 1.0.4 which updates the content column and contains a migration that should update all existing Ansel fields (by re-saving them to get Craft to pick up the column changes). If you could give that a shot and make sure nothing blows up, I would appreciate it.
June 20, 2017, 11:34 pm
Sure, I can give it a shot, however the site that I was working on I already switched the column type manually in the DB - so I can’t test the migration. But it’ll be interesting to see if it has any adverse effects (a double migration of sorts that is). I’ll need to make sure of this anyhow as this site will be going to production shortly.
What I can do though is test it on the temp test site I setup, I’ll let you know how I go. When do you expect to have 1.0.4 released?
June 20, 2017, 11:47 pm
I’ll probably release it before end of day tomorrow (I’m in central daylight time in the U.S.).
June 20, 2017, 11:48 pm
Good news! It’s worked in both circumstances.
June 21, 2017, 12:17 am
1.0.4 has been released.
June 21, 2017, 10:01 am
Your account with the old support system does not carry over to the new support system. The new system is all tied together and connected with your account for purchasing and licenses. If you have a license, you have an account and you can log in with that email address and password. If you have not set a new password yet, you can do so with the forgot password link. Very sorry for any inconvenience.