lcollong
FabriKant d'applications web
Hi,
Following a recent update (through J! extension menu) of Joomla (3.7.3) and Fabrik (3.7) we have some js errors on the cascading drop down plugin. Strange enough, the error occurs only for regristred users. As a super-user, it works.
The master DBjoin element has the following Sql restrict :
giving : (debug output) :
but the cdd debug query shows (twice) :
Thus empty result.
Here is the console output :
Following a recent update (through J! extension menu) of Joomla (3.7.3) and Fabrik (3.7) we have some js errors on the cascading drop down plugin. Strange enough, the error occurs only for regristred users. As a super-user, it works.
The master DBjoin element has the following Sql restrict :
Code:
WHERE ({thistable}.id IN (SELECT contrats.fk_entreprise FROM fk_contrats_has_utilisateurs map, fk_contrats contrats WHERE map.fk_contrat=contrats.id AND map.fk_utilisateur={$my->id})) OR (8 IN ({$my->groups}))
Code:
SELECT DISTINCT(`fk_entreprises`.`id`) AS value, `nom` AS text FROM `fk_entreprises` AS `fk_entreprises` WHERE (`fk_entreprises`.id IN (SELECT contrats.fk_entreprise FROM fk_contrats_has_utilisateurs map, fk_contrats contrats WHERE map.fk_contrat=contrats.id AND map.fk_utilisateur=450)) OR (8 IN (2,44,50,52,54)) ORDER BY text ASC
Code:
SELECT DISTINCT(`fk_contrats`.`id`) AS value, `fk_contrats`.`nom`AS text FROM `fk_contrats` AS `fk_contrats` WHERE 4 = -4 ORDER BY text ASC
Here is the console output :
JavaScript:
JQMIGRATE: Migrate is installed, version 1.4.1
utils.js:3 no content option set for window.html
utils.js:3 fk_rdv___fk_contrat attach to form:TypeError: this.options.value.getLast is not a function
utils.js:3 fk_rdv___fk_lieu_rdv attach to form:TypeError: this.options.value.getLast is not a function
utils.js:3 fk_rdv_has_contacts___fk_contact_0 attach to form:TypeError: this.options.value.getLast is not a function
databasejoin.js:774 Uncaught TypeError: this.options.value.getLast is not a function
at Object.getValue (databasejoin.js:774)
at Object.e.extend.$owner (mootools-core.js?3afb010?:38)
at Object.<anonymous> (form.js:3)
at Function.<anonymous> (mootools-core.js?3afb010?:9)
at Object.forEach (mootools-more.js?3afb010?:139)
at Object.getFormElementData (form.js:3)
at Object.e.extend.$owner (mootools-core.js?3afb010?:38)
at Object.change (cascadingdropdown-min.js:3)
at Object.e.extend.$owner (mootools-core.js?3afb010?:38)
at Object.dowatch (cascadingdropdown-min.js:3)
getValue @ databasejoin.js:774
e.extend.$owner @ mootools-core.js?3afb010?:38
(anonymous) @ form.js:3
(anonymous) @ mootools-core.js?3afb010?:9
forEach @ mootools-more.js?3afb010?:139
getFormElementData @ form.js:3
e.extend.$owner @ mootools-core.js?3afb010?:38
change @ cascadingdropdown-min.js:3
e.extend.$owner @ mootools-core.js?3afb010?:38
dowatch @ cascadingdropdown-min.js:3
e.extend.$owner @ mootools-core.js?3afb010?:38
doChange @ cascadingdropdown-min.js:3
e.extend.$owner @ mootools-core.js?3afb010?:38
m @ mootools-core.js?3afb010?:119
ListPicker._handleMouseUp @ about:blank:663
databasejoin.js:774 Uncaught TypeError: this.options.value.getLast is not a function
at Object.getValue (databasejoin.js:774)
at Object.e.extend.$owner (mootools-core.js?3afb010?:38)
at Object.<anonymous> (form.js:3)
at Function.<anonymous> (mootools-core.js?3afb010?:9)
at Object.forEach (mootools-more.js?3afb010?:139)
at Object.getFormElementData (form.js:3)
at Object.e.extend.$owner (mootools-core.js?3afb010?:38)
at Object.change (cascadingdropdown-min.js:3)
at Object.e.extend.$owner (mootools-core.js?3afb010?:38)
at Object.dowatch (cascadingdropdown-min.js:3)