p38
Active Member
Hi,
Seems to be a bug with Fabrik 3 and J3.3
When saving, An sql error occurs if I use an element isuniquevalues validation on a joined list. It looks like the sql query gets mixed up between the master list and the joined list.
eg:
master list : keys_users, id field = id
joined list : authenticationcodes, id field = userid
isuniquevalue validation on authenticationcodes.authocode
it should be along the lines of
If I switch the joined list element validation off, then the save works perfectly.
Seems to be a bug with Fabrik 3 and J3.3
When saving, An sql error occurs if I use an element isuniquevalues validation on a joined list. It looks like the sql query gets mixed up between the master list and the joined list.
eg:
master list : keys_users, id field = id
joined list : authenticationcodes, id field = userid
isuniquevalue validation on authenticationcodes.authocode
Code:
Unknown column 'authocode' in 'where clause' SQL=SELECT COUNT(*) FROM `keys_users`
WHERE `authocode` = '123456789' AND `keys_users`.`id` != '225'
it should be along the lines of
Code:
SQL=SELECT COUNT(*) FROM `authenticationcodes` WHERE `authocode` = '123456789' AND `authenticationcodes`.`userid` != '225'
If I switch the joined list element validation off, then the save works perfectly.