PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'instance_id' at row 1: INSERT INTO {cloud_aws_elastic_ip} (public_ip, cloud_type, public_ip_name, instance_id) VALUES.

Change the length of instance_id,public_ip from 16 to 64 or whatever you want.
you may face this issue in other tables, just change the length.

Comments

baldwinlouie’s picture

baldwinlouie commented
Status: Fixed » Active

Hi Ahmed,

can you roll a patch if you have this fixed. I'd like to get it checked back in.

ahmed_samir’s picture

ahmed_samir commented

I changed directly from mysql :), i'll try to write a patch.

baldwinlouie’s picture

baldwinlouie commented

no problem. I setup open stack to test, and have also come across these field issues. I'll it checked in a day or so.

baldwinlouie’s picture

baldwinlouie commented
Status: Active » Fixed

Added a hook_update() that takes care of lengthening a bunch of fields.

http://drupalcode.org/project/cloud.git/commit/d624dda

baldwinlouie’s picture

baldwinlouie commented
Status: Fixed » Closed (fixed)

Closing