Receive the following error.

An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?id=69&op=do StatusText: Service unavailable (with message) ResponseText: PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'tags' at row 1: INSERT INTO {shopify_products} (product_id, variant_id, title, body_html, handle, product_type, published_scope, vendor, tags, options, barcode, compare_at_price, fulfillment_service, grams, inventory_management, inventory_policy, inventory_quantity, old_inventory_quantity, option_values, price, requires_shipping, sku, taxable, weight, weight_unit, created_at, published_at, updated_at) 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, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23, :db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27); Array ( [:db_insert_placeholder_0] => 1810641027 [:db_insert_placeholder_1] => 0 [:db_insert_placeholder_2] => Bat Blood Apothecary Jar [:db_insert_placeholder_3] => Glass Apothecary Jar

Perfect for your Halloween Display, Table or Haunt

Realistic looking old Apothecary jar adds a finishing touch to any witches scene, shelf or tabletop.
Uniquely aged glass jar complete with realistic looking contents.

Jar is approximately: 4.5 inches tall x 1.5 inches wide x 1.5 inches deep [:db_insert_placeholder_4] => bat-blood-apothecary-jar [:db_insert_placeholder_5] => Apothecary Jars [:db_insert_placeholder_6] => global [:db_insert_placeholder_7] => Halloween24x7 [:db_insert_placeholder_8] => Aged potion jar, bat blood, curiousities, curse, dirty jars, distressed jar, elixir, enchanted ingredients, Halloween decor, Halloween decoration, Halloween prop, herb jar, magic, pagan, scene accent, spell, spooky, vintage bottle, wicca, witch accessory, witches brew, witches jar [:db_insert_placeholder_9] => a:1:{i:0;a:5:{s:2:"id";i:2181957955;s:10:"product_id";i:1810641027;s:4:"name";s:5:"Title";s:8:"position";i:1;s:6:"values";a:1:{i:0;s:13:"Default Title";}}} [:db_insert_placeholder_10] => [:db_insert_placeholder_11] => [:db_insert_placeholder_12] => [:db_insert_placeholder_13] => [:db_insert_placeholder_14] => [:db_insert_placeholder_15] => [:db_insert_placeholder_16] => [:db_insert_placeholder_17] => [:db_insert_placeholder_18] => [:db_insert_placeholder_19] => [:db_insert_placeholder_20] => [:db_insert_placeholder_21] => [:db_insert_placeholder_22] => [:db_insert_placeholder_23] => [:db_insert_placeholder_24] => [:db_insert_placeholder_25] => 1437786123 [:db_insert_placeholder_26] => 1437783960 [:db_insert_placeholder_27] => 1438061154 ) in drupal_write_record() (line 7316 of /home/hallowee/public_html/includes/common.inc).

Comments

daboo’s picture

I worked around this issue the same as the issue here was:
https://www.drupal.org/node/2491603

I changed the column 'tags' in the shopify_products table to have a length of 512 from 256. Probably overkill, but it worked, so I'm going to stick with that change for now.

daboo’s picture

Assigned: daboo » Unassigned
negnetsolutions’s picture

Same problem with options column. Needs to be larger than 256.

  • John Carbone committed 4833916 on 7.x-1.x
    Issue #2541818: PDOException: SQLSTATE[22001]: String data, right...
John Carbone’s picture

Priority: Major » Normal
Status: Active » Fixed

@negnetsolutions re: #3, that's fixed in the dev version of the module. We need to roll out a new alpha.

Status: Fixed » Closed (fixed)

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