Help with Database Insert

[Logan]

Hi,

I am following webinar 2 (these are great thank you!) and I am stuck setting up the database insert for my form. I have followed all of the steps done in the video but I cannot seem to get the database insert to work.

When I test the form I see the errors below:

Any advice would be appreciated,

Thank you!

[Teodor]

Please provide the exact error you see as described here:

Debugging Problems

[Logan]

Thanks Teodor,

Here is the error:

1. code: “23000”
2. file: “C:\Users\logan\WapplerProjectFiles\ProjectOne\dmxConnectLib\lib\db\Connection.php”
3. line: 108
4. message: “SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘ContactID(sr)’ cannot be null”
5. trace: “#0 C:\Users\logan\WapplerProjectFiles\ProjectOne\dmxConnectLib\lib\db\Connection.php(108): PDOStatement->execute()↵#1 C:\Users\logan\WapplerProjectFiles\ProjectOne\dmxConnectLib\modules\dbupdater.php(38): lib\db\Connection->execute(‘INSERT INTO `Co…’, Array, false, ‘Contacts’)↵#2 C:\Users\logan\WapplerProjectFiles\ProjectOne\dmxConnectLib\lib\App.php(159): modules\dbupdater->insert(Object(stdClass), ‘insert1’)↵#3 C:\Users\logan\WapplerProjectFiles\ProjectOne\dmxConnectLib\lib\App.php(128): lib\App->execSteps(Object(stdClass))↵#4 C:\Users\logan\WapplerProjectFiles\ProjectOne\dmxConnectLib\lib\App.php(98): lib\App->execSteps(Array)↵#5 C:\Users\logan\WapplerProjectFiles\ProjectOne\dmxConnectLib\lib\App.php(71): lib\App->exec(Object(stdClass))↵#6 C:\Users\logan\WapplerProjectFiles\ProjectOne\dmxConnect\api\Insert.php(8): lib\App->define(Object(stdClass))↵#7 {main}”

It looks like this has something to do with the ‘contactID’ field. Any ideas?

[ben]

It looks like contactID is ot getting a value. Have a look at Webinar 1 at the 19th minute mark where the database table is created. Notice how contactID gets auto-incremented.

[Logan]

Thanks Ben,

I did notice that earlier and made the changes accordingly. Now I’m seeing a new error:

1. code: “23000”
2. file: “C:\Users\logan\WapplerProjectFiles\ProjectOne\dmxConnectLib\lib\db\Connection.php”
3. line: 108
4. message: “SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘First Name’ cannot be null”

I will of course try and figure this out myself but I can’t figure out whether the issue is something I’ve done in Wappler or something related to my server set up. I’ve tried building the project from scratch a few times including the server setup but I still have this problem.

If it helps, my page is set up as the webinar 2 project is. I have manually added data to my table through phpmyadmin, however only one of the columns will actually display on my page. I cannot seem to add data to the table through the server connect form and the error above occurs when I submit the form.

I should also add that I have a text input for the column “first name” as part of my form that is required in order to submit.

Any thoughts?

[Teodor]

The error says your database is not receiving a value on insert. This could be your insert step is not sending any $_POST value for the column listed in the error, it could also be your input name is different than the $_POST var you are sending in the insert step.
Check the step by step guide explaining how to insert database records:

Insert Database Record

[Logan]

Thank you Teodor!

So it turns out that the problem was with the names of my columns. While they were the same as the text inputs on the form, the problem seems to be that they cannot be more than one word. So for the error above I simply had to change “first name” to “firstname” and the problem was solved. I still had to make sure the names matched, so no space in the text input name as well.

Thanks again for your help!

[Teodor]

Yes, it’s never a good idea to use spaces in database column names!
Use underscores instead, for better readability _, for example column_name