500 Server error on insert form

Wappler General
#1

I have done dozens of insert forms with no problem. However I have a very simple insert form that does not submit and throws a 500 Server error.

13%20PM
Screen Shot 2018-10-30 at 12.27.13 PM.png1944×160 31.2 KB 

<form id="formAddComment" method="post" is="dmx-serverconnect-form" action="dmxConnect/api/employers/profile/forms/addcomments.php" dmx-on:success="commentsshortlist.load({});commentsfulllist.load({})">
                    <div class="form-group">
                      <input type="hidden" class="form-control" id="hiddenempidcomments" name="hiddenempidcomments" aria-describedby="input4_help" placeholder="Enter some text" dmx-bind:value="query.profile">
                    </div>
                    <div class="form-group">
                      <input type="hidden" class="form-control" id="hiddencommentsstafffirts" name="hiddencommentsstafffirts" aria-describedby="input3_help" placeholder="Enter some text" dmx-bind:value="userdetails.data.query1[0].staffFirst">
                    </div>
                    <div class="form-group">
                      <input type="hidden" class="form-control" id="hiddencommentsstafflast" name="hiddencommentsstafflast" aria-describedby="input2_help" placeholder="Enter some text" dmx-bind:value="userdetails.data.query1[0].staffLast">
                    </div>
                    <div class="form-group">
                      <input type="hidden" class="form-control" id="hiddencommentsdate" name="hiddencommentsdate" aria-describedby="input1_help" placeholder="Enter some text" dmx-bind:value="var1.datetime.formatDate(&quot;yyyy-MM-dd&quot;)">
                    </div>
                    <div class="form-group">
                      <textarea id="textareaEmployerComment" class="form-control" required=""></textarea>
                    </div>
                    <button class="btn btn-warning btn-sm btn-block" type="submit">Add Comment</button>
                  </form>
#2

Brad, please report the error as explained here: Debugging Problems

#3

03%20AM
Screen Shot 2018-11-01 at 10.40.03 AM.png2230×218 53.5 KB

Looks like it is not recognizing what is typed in the textarea?

#4

So when I remove the textarea from the form it submits fine. What is wrong with my textarea?

#5

Your textarea is missing the name attribute, so it doesn’t submit

1 Like
#6

Oh my god! I’ve been working on this for three days and that’s all it was. Thank you so much Patrick.

Can’t believe I missed that. :flushed:

#7

Hello all

I am having this error too after following the doc step-by-step: https://docs.wappler.io/t/insert-database-record/2863

Here is what I am see while debugging:

{"code":"23000","file":"C:\\MAMP\\htdocs\\paper-trader\\dmxConnectLib\\lib\\db\\Connection.php","line":88,"message":"SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'ticker' cannot be null","trace":"#0 C:\\MAMP\\htdocs\\paper-trader\\dmxConnectLib\\lib\\db\\Connection.php(88): PDOStatement->execute()\n#1 C:\\MAMP\\htdocs\\paper-trader\\dmxConnectLib\\modules\\dbupdater.php(38): lib\\db\\Connection->execute('INSERT INTO `ti...', Array)\n#2 C:\\MAMP\\htdocs\\paper-trader\\dmxConnectLib\\lib\\App.php(159): modules\\dbupdater->insert(Object(stdClass), 'insert1')\n#3 C:\\MAMP\\htdocs\\paper-trader\\dmxConnectLib\\lib\\App.php(128): lib\\App->execSteps(Object(stdClass))\n#4 C:\\MAMP\\htdocs\\paper-trader\\dmxConnectLib\\lib\\App.php(98): lib\\App->execSteps(Array)\n#5 C:\\MAMP\\htdocs\\paper-trader\\dmxConnectLib\\lib\\App.php(71): lib\\App->exec(Object(stdClass))\n#6 C:\\MAMP\\htdocs\\paper-trader\\dmxConnect\\api\\database\\insert_symbol.php(8): lib\\App->define(Object(stdClass))\n#7 {main}"}

Table structure:

image
image.png1525×241 30.9 KB

So I wanted to share the solution I arrived at after hours of troubleshooting (please try not to take that as an indication of my intelligence, but rather, my determination…:joy:)

I had to check No Auto Load because the Server Connect Action was running even before I submitted the form, and my table structure for this column was configured to not allow NULL values, therefore it was failing because it didn’t have any value in the {{$_POST.ticker}} variable yet!

image

Lastly, I will note, however, that the Dynamic Event I set on the Server Connect to reset the Server Connect form was not working, even though my database record was being inserted successfully:

{"insert1":{"identity":"0","affected":1}}

So what I realized after 6 more hours of debugging (just kidding) is that the Dynamic Event should actually be set on the Form:serverconnectform1 if you used the Bootstrap 4 Form Generator as the documentation recommends. I mistakenly added the Server Connect component separately which was unnecessary.

image
image.png608×956 91.6 KB

:sunglasses:

#8

Yes, the conhection would run without no load checked. HOWEVER you do nor need that connection at all, the save server action can be linked directly from the form settings

#9

Hi Brian (@Hyperbytes), yes, I came to realize that with a little more experimentation Thank you for pointing that out!

#10

we tend to recognise these little mistakes as we all made them when lesrning. it"s just i am 7 months ahead of you!

2 Likes