I get this error and have done new installation using the latest (installed using drush) Drupal 7 and the latest Mailchimp module. Same on two different sites. Very promising until I save the new list. Is it because there's too much text?
Error:
PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'description' at row 1: INSERT INTO {mailchimp_lists} (name, mc_list_id, label, description, list_type, settings, created, updated) 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, :db_insert_placeholder_6, :db_insert_placeholder_7); Array ( [:db_insert_placeholder_0] => support_koh_ra_ecolodge [:db_insert_placeholder_1] => f125a0f765 [:db_insert_placeholder_2] => Support Koh Ra Ecolodge [:db_insert_placeholder_3] => Koh Ra Ecolodge supports Koh Ra. We host Naucrates Turtle Project Scientists and Conservationists, Reefcheck and the community because they support the wildlife, the jungle, the sea creatures and birds and the environment. We're in this together, so sign up to stay in touch, support your friends who're doing what you know needs doing, and come back to Koh Ra soon. We miss you and need your help. [:db_insert_placeholder_4] => freeform [:db_insert_placeholder_5] => a:9:{s:5:"roles";a:2:{i:1;s:1:"1";i:2;s:1:"2";}s:11:"mergefields";a:4:{s:5:"EMAIL";s:4:"mail";s:5:"FNAME";s:0:"";s:5:"LNAME";s:0:"";s:7:"WEBSITE";s:0:"";}s:8:"doublein";i:1;s:18:"show_register_form";i:0;s:17:"show_account_form";i:0;s:23:"include_interest_groups";i:1;s:21:"interest_groups_label";s:15:"Interest Groups";s:4:"cron";i:0;s:8:"webhooks";i:0;} [:db_insert_placeholder_6] => 1351420877 [:db_insert_placeholder_7] => 1351420877 ) in drupal_write_record() (line 7036 of /home/kohra/domains/kohraecolodge.com/public_html/includes/common.inc).

Comments

levelos’s picture

Status: Active » Closed (cannot reproduce)