DMXzone App Connect Support Product Page

Solved

Error when submitting Multi Record Update.

Reported 28 Nov 2017 23:51:54
1
has this problem
28 Nov 2017 23:51:54 Ken Pollard posted:
I am trying to do a multi-record update with App Connect and Server Connect. I am populating the form with a query. The form shows and it has the data but when I try and submit it I get the following error (this is partial error)

{"type":"Error","fileName":"modules/core.asp","lineNumber":21,"message":"Repeater data is not an array or object.","stack":[{"fileName":"lib/core/response.asp","lineNumber":180,"method":"error","args":[{"type":"Error","fileName":"modules/core.asp","lineNumber":21,"message":"Repeater data is not an array or object.","stack":[{"fileName":"modules/core.asp","lineNumber":21,"method":"repeat","args":[{"repeat":"{{$_POST.record}}","exec":{"steps":{"name":"record_update","module":"dbupdater","action":"update","options":{"connection":"app","sql":{"type":"update","table":"equipment","values":[{"table":"equipment","column":"step_id","value":"14","type":"number"},{"table":"equipment","column":"product_id_application","value":"{{product_id_application}}","type":"number"},{"table":"equipment","column":"product_other_application","value":"{{product_other_application}}","type":"text"},{"table":"equipment","column":"qty_application","value":"{{qty_application}}","type":"number"},{"table":"equipment","column":"stations_application","value":"{{stations_application}}","type":"number"}],"wheres":[{"table":"equipment","column":"id","bool":"and","operator":"=","value":"{{id}}","type":"number"}]}},"meta":[{"name":"affected","type":"number"}]}}},"record_repeat"]},

Replies

Replied 29 Nov 2017 08:09:59
29 Nov 2017 08:09:59 Teodor Kuduschiev replied:
Hi Ken.
Can you send us a link to your page, where we can check what exactly you setup?
Please send it to:
Replied 01 Dec 2017 01:06:22
01 Dec 2017 01:06:22 Ken Pollard replied:
Hi Teodor, I just sent an email with info.
Replied 01 Dec 2017 09:29:30
01 Dec 2017 09:29:30 Teodor Kuduschiev replied:
Hi Ken,
I checked the site and the error. That is not a problem in the database updater, it is in your database. You are trying to update data to something that is not allowed. Please check what kind of constraint "qty_application" is, it is limiting the values that are allowed in the table.
Replied 01 Dec 2017 15:59:42
01 Dec 2017 15:59:42 Ken Pollard replied:
Thanks! appreciate your help.

Reply to this topic