Error saving record to database after upload

[smartfun]

OS info

• Operating System : Mac OSX 17.7.0
• Wappler Version : 1.9.9

Problem description

ERROR 500
I’m trying to insert several records on my database through a repeating insert query.

Steps to reproduce

[scott]

@smartfun,

I can not speak for others that may try to help you out, but I would need more information to be able to assist you.

Could you post screenshots of your insert page in Wappler?

[Teodor]

@smartfun
Please follow this guide to see what is the exact error returned:

Debugging Server Connect Errors

You can easily debug issues related to server-side processing such as - form not sending email, record not inserting or updating, query not showing data etc. The first thing you need to do is to open the server connect settings. They are located in the Workflows Panel > Server Actions: [Screenshot 2021-09-27 at 10.02.35] And enable the Debug Mode: [Screenshot 2021-09-27 at 10.03.08] Click Save: [Screenshot 2021-09-27 at 10.03.26] In your browser, open the Developer tools. If you don’t k…

[smartfun]

[Teodor]

@smartfun could you please follow what is explained in the tutorial I sent you and send me the error message reported in your browser console?

[smartfun]

code	“HY000”
file	“/Applications/MAMP/htdocs/WapGaleries/dmxConnectLib/lib/db/Connection.php”
line	88
message	“SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘’ for column ‘imageDisplyOrder’ at row 1”
trace	“#0 /Applications/MAMP/htdocs/WapGaleries/dmxConnectLib/lib/db/Connection.php(88): PDOStatement->execute()\n#1 /Applications/MAMP/htdocs/WapGaleries/dmxConnectLib/modules/dbupdater.php(38): lib\db\Connection->execute(‘INSERT INTO `im…’, Array)\n#2 /Applications/MAMP/htdocs/WapGaleries/dmxConnectLib/lib/App.php(159): modules\dbupdater->insert(Object(stdClass), ‘insImatges’)\n#3 /Applications/MAMP/htdocs/WapGaleries/dmxConnectLib/lib/App.php(128): lib\App->execSteps(Object(stdClass))\n#4 /Applications/MAMP/htdocs/WapGaleries/dmxConnectLib/lib/App.php(98): lib\App->execSteps(Array)\n#5 /Applications/MAMP/htdocs/WapGaleries/dmxConnectLib/modules/core.php(62): lib\App->exec(Object(stdClass), true)\n#6 /Applications/MAMP/htdocs/WapGaleries/dmxConnectLib/lib/App.php(159): modules\core->repeat(Object(stdClass), ‘repeat’)\n#7 /Applications/MAMP/htdocs/WapGaleries/dmxConnectLib/lib/App.php(128): lib\App->execSteps(Object(stdClass))\n#8 /Applications/MAMP/htdocs/WapGaleries/dmxConnectLib/lib/App.php(98): lib\App->execSteps(Array)\n#9 /Applications/MAMP/htdocs/WapGaleries/dmxConnectLib/lib/App.php(71): lib\App->exec(Object(stdClass))\n#10 /Applications/MAMP/htdocs/WapGaleries/dmxConnect/api/Imatges/ImInserta.php(8): lib\App->define(Object(stdClass))\n#11 {main}”

[smartfun]

Here is the code generated By the server action commands.

[George]

@smartfun

“SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘’ for column ‘imageDisplyOrder’ at row 1”

well this error explains it ... you are storing something else (or nothing) in the field that need to be integer number.

[smartfun]

In which step is the variable ‘ImageDisplayOrder’ filled?

[smartfun]

I did this following the 22 videos tutorial “Creating an Image Gallery”, appeared in YouTube (Wappler account) since 14/10/2018. On the database (table “Images”) of this tutorial is a field named “Imageorder” than I can’t see which server side action fills it. My temporary solution is define this field as “Null” allowed. I think this is not a good solution and needs to fix this mistake. Thanks

[George]

Well usually in your Server Connect Action, you have the variable defined as $_POST input field that you use afterwards in your own database insert/update step, see:

Insert Database Record

[smartfun]

Thank you to George, Teodor, scott. All of you have given a lot of solutions and ideas to me.