Can the length of the url field be increased?

Causes WSOD.

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'url' at row 1: INSERT INTO {eventbrite_organizer} (user_key, organizer_id, status, name, url, description) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => 12706590764073624320 [:db_insert_placeholder_1] => 3660178145 [:db_insert_placeholder_2] => 1 [:db_insert_placeholder_3] => ThirdStreetNeighbors.com [:db_insert_placeholder_4] => http://www.eventbrite.com/o/thirdstreetneighborscom-3660178145 [:db_insert_placeholder_5] => Organized by 3rd Street Neighbors with the goal of having fun while connecting Bayview Hunter's Point residents, homeowners, businesses, musicians, crafters and artists who live, work, and play here. At the same time, we want to promote our Bayview businesses and art at these family friendly venues/spaces, while having oodles and oodles of fun together in a safe environment! ) in drupal_write_record() (line 7224 of /var/aegir/platforms/7/servers/sng-contrib/sng-d7.26-oa-2.15/includes/common.inc).

Comments

caspervoogt’s picture

Same here.

Here's what I did;

Changed table eventbrite_organizer's "url" field from varchar(50) to varchar(255)

After this I still got errors, but for table "field_data_field_eventbrite"'s field_eventbrite_value column instead. Changed it from varchar(10) to varchar(255).

After that I still got similar errors, this time for table "field_revision_field_eventbrite"'s field_eventbrite_value column. Changed it from varchar(10) to varchar(255).

That solved it for me. So it seems the schema needs to be updated. My particular EventBrite event had 11 characters for its event ID ... so that obviously would cause a problem when varchar is set to 10.

mile23’s picture

The field_eventbrite_value problem seems to be fixed in dev, complete with upgrade path.

mile23’s picture

Status: Active » Postponed (maintainer needs more info)

Calling this postponed. @SocialNicheGuru, give a shout if its still broken, or mark it as fixed if it's not. Thanks.

socialnicheguru’s picture

Status: Postponed (maintainer needs more info) » Closed (fixed)

I am no longer using this module so I can't comment on if this issue has been fixed or not.
Marking as fixed. Others can re-open if they see the issue.

mile23’s picture

Status: Closed (fixed) » Fixed

Thanks.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.