String or Binary Data will be truncated, Only in Live Version

I am using the SQL Server plug in and I am inserting rows from a user form. The rows write perfectly in Development Mode but when I switch to the live version I get an error
image

As far as I can tell the data going into the insert statement is not too long.

Also I can’t even pass empty values, the database fields all allow null values.

This is only the case for the Live version of the app, not the Dev version

Some thoughts not sure if they would help.

  • Check your field sizes relative to what you are sending. I assume you have, but double check.
  • Display your values visually in Bubble before you send them to make sure you not sending something else.
  • Check data types, make sure you are not sending chars when integers are required.
  • Speculating if Bubble is attaching or appending some extra data in live mode. Unlikely.

Rick
Freelancer

Thanks, I just found the problem. One of the searches I was using to get some related info was populating with multiple values.

Big props for the step through debugger, really enjoyed using that

My suggestion:
" * Display your values visually in Bubble before you send them to make sure you not sending something else."

That’s what debuggers do…