Skip to main content

Hi.

I’m trying to insert new rows in mySQL via Google Sheets but seem to encounter this error every time I test it. The Verified column in mySQL is tagged as a Bit column, while the one in my Google Sheets has a number format. 

An Insert script in mySQL works fine, but the one Zapier makes has this error below. Any tips on how to fix this? Thanks in advance!

(pymysql.err.DataError) (1406, "Data too long for column 'verified' at row 1") aSQL: 'INSERT INTO visitor (company_name, email, first_name, last_name, verified, data_expiration_date) VALUES (%(company_name)s, %(email)s, %(first_name)s, %(last_name)s, %(verified)s, %(data_expiration_date)s)'] 'parameters: {'company_name': 'AAA COMPANY', 'email': 'aip@gmail.ph', 'first_name': 'AN', 'last_name': 'LASTNAME', 'verified': '1', 'data_expiration_date': '2020-10-24T14:16:40-05:00'}]

The column of type “bit” in mysql accepts integers (1 or 0) or string (‘true’ or ‘false’). I think zapier is trying to insert your data 1 as a string. Try to use the string ‘true’ instead. Let me know how it goes.

Moved to “Ask The Community” to get more visibility.

Hi @vdhf ,

Circling back to see how you got on with this Zap! Did @stephenking ‘s suggestion help get you squared away? 

Terms & Conditions