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 Problems

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: [image] And enable the Debug Mode: [image] Click Save: [image] In your browser, open the Developer tools. If you don’t know how to open them please refer to your browser’s documentation. Then open the Network tab(1) and select XHR(2): [image] Now with the develo…

[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]

“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.