INSERT behavior code is right, but no record gets created

I've been using these behaviors for years, and everything looks right. Simple form, inserting into mySQL. No errors in Console on the page. Form submits and redirects, but no record actually shows up in the table. No errors on the page. No errors in error logs. Just... nothing. Been staring at this for hours. Anyone seen this before???

Please attach the page and I'll see if I can spot the problem.

PM

Find this line:

$InsertQuery->saveInSession("");
  $InsertQuery->execute();
  $InsertGoTo = "list-vendors.php";

and update it to:

$InsertQuery->saveInSession("");
  $InsertQuery->execute();

var_dump($InsertQuery);
die();

  $InsertGoTo = "list-vendors.php";

That will print information about the insert onto the page and might give you information on how or why it fails.

Here in PM is what it outputs.. but I'm not sure it'a string issue, because no record actually gets initiated into the table at all.

You can see the error:

Data too long for column 'State' at row 1

You probably have state defined as two characters but you are trying to insert "Washington"

Hi, yes I saw the error, and tried it again with just two characters, but the behavior persists. No record is created. I'm a little surprised the error isn't expressed on the page in some way as well. Other suggestions?

What is the error when you do it with two characters? Send the output again and I can look.

Originally Said By: Ray Borduin

  What is the error when you do it with two characters? Send the output again and I can look.  

Found the error. There was also a required field in the DB table that wasn't noted as required on the form. insert working properly now. Still unsure why there wasn't any error on the page when the DB requirements weren't met, but maybe I'm expecting too much. ANyways, thanks for the help. Any chance we can get some updates on that custom code I sent before?

In general you don't want to show errors to your customers when they happen, so they aren't displayed by default. You can turn them on manually to debug like I showed you.

I'm not sure what custom code you are referring to. In general it is hard to comment on custom code and that is generally saved for paid premier support tickets.