Hello,
I have a problem, I have a joined view that I am using as a table. I would like to update some data on the view, however, upon changing any data and clicking save, dadabik simply returns to the results page and no change is made.
This is a problem i notice when the sql code for an UPDATE includes a LIMIT (some number)
i.e.
[pre]
UPDATE x SET y WHERE z = a LIMIT 1
[/pre]
now upon scanning the dadabik code I do not see any limit used in the sql statements, so I do not believe this is the problem, but this leaves me with no idea why it is failing.
any help would be appreciated
You are using DaDaBIK version 8.2-Lerici pro, installed on Dec 19, 2017 (installation code: 130575a022f599edc0), the latest version of DaDaBIK is 8.2-Lerici released on Dec 19, 2017
You are runnning the last release of DaDaBIK
PHP Version: 7.1.12-1+ubuntu16.04.1+deb.sury.org+1
mysql version: 5.7.20-0ubuntu0.16.04.1
Web server: Apache/2.4.18 (Ubuntu)
Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36
I have a problem, I have a joined view that I am using as a table. I would like to update some data on the view, however, upon changing any data and clicking save, dadabik simply returns to the results page and no change is made.
This is a problem i notice when the sql code for an UPDATE includes a LIMIT (some number)
i.e.
[pre]
UPDATE x SET y WHERE z = a LIMIT 1
[/pre]
now upon scanning the dadabik code I do not see any limit used in the sql statements, so I do not believe this is the problem, but this leaves me with no idea why it is failing.
any help would be appreciated
You are using DaDaBIK version 8.2-Lerici pro, installed on Dec 19, 2017 (installation code: 130575a022f599edc0), the latest version of DaDaBIK is 8.2-Lerici released on Dec 19, 2017
You are runnning the last release of DaDaBIK
PHP Version: 7.1.12-1+ubuntu16.04.1+deb.sury.org+1
mysql version: 5.7.20-0ubuntu0.16.04.1
Web server: Apache/2.4.18 (Ubuntu)
Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36