Hi After installation when i click on FORM, i got below error
Column 'checked_out' in on clause is ambiguous SQL=SELECT f.*, l.id AS list_id,u.name AS editor FROM ilfs_fabrik_forms AS f LEFT JOIN ilfs_users AS u ON checked_out = u.id LEFT JOIN ilfs_fabrik_lists AS l ON l.form_id = f.id WHERE (f.published IN (0, 1)) ORDER BY label asc Column 'checked_out' in on clause is ambiguous SQL=SELECT f.*, l.id AS list_id,u.name AS editor FROM ilfs_fabrik_forms AS f LEFT JOIN ilfs_users AS u ON checked_out = u.id LEFT JOIN ilfs_fabrik_lists AS l ON l.form_id = f.id WHERE (f.published IN (0, 1)) ORDER BY label asc LIMIT 0, 20 Column 'checked_out' in on clause is ambiguous SQL=SELECT f.*, l.id AS list_id,u.name AS editor FROM ilfs_fabrik_forms AS f LEFT JOIN ilfs_users AS u ON checked_out = u.id LEFT JOIN ilfs_fabrik_lists AS l ON l.form_id = f.id WHERE (f.published IN (0, 1)) ORDER BY label asc
*********
and when i click on "Groups" below error displayed:
Column 'checked_out' in on clause is ambiguous SQL=SELECT g.*,u.name AS editor, fg.form_id AS form_id, f.label AS flabel FROM ilfs_fabrik_groups AS g LEFT JOIN ilfs_users AS u ON checked_out = u.id LEFT JOIN ilfs_fabrik_formgroup AS fg ON g.id = fg.group_id LEFT JOIN ilfs_fabrik_forms AS f ON fg.form_id = f.id ORDER BY name asc Column 'checked_out' in on clause is ambiguous SQL=SELECT g.*,u.name AS editor, fg.form_id AS form_id, f.label AS flabel FROM ilfs_fabrik_groups AS g LEFT JOIN ilfs_users AS u ON checked_out = u.id LEFT JOIN ilfs_fabrik_formgroup AS fg ON g.id = fg.group_id LEFT JOIN ilfs_fabrik_forms AS f ON fg.form_id = f.id WHERE (g.published IN (0, 1)) ORDER BY name asc
Please let me know how to resolve this issue.
Looking forward ...
Thanks in advance
Column 'checked_out' in on clause is ambiguous SQL=SELECT f.*, l.id AS list_id,u.name AS editor FROM ilfs_fabrik_forms AS f LEFT JOIN ilfs_users AS u ON checked_out = u.id LEFT JOIN ilfs_fabrik_lists AS l ON l.form_id = f.id WHERE (f.published IN (0, 1)) ORDER BY label asc Column 'checked_out' in on clause is ambiguous SQL=SELECT f.*, l.id AS list_id,u.name AS editor FROM ilfs_fabrik_forms AS f LEFT JOIN ilfs_users AS u ON checked_out = u.id LEFT JOIN ilfs_fabrik_lists AS l ON l.form_id = f.id WHERE (f.published IN (0, 1)) ORDER BY label asc LIMIT 0, 20 Column 'checked_out' in on clause is ambiguous SQL=SELECT f.*, l.id AS list_id,u.name AS editor FROM ilfs_fabrik_forms AS f LEFT JOIN ilfs_users AS u ON checked_out = u.id LEFT JOIN ilfs_fabrik_lists AS l ON l.form_id = f.id WHERE (f.published IN (0, 1)) ORDER BY label asc
*********
and when i click on "Groups" below error displayed:
Column 'checked_out' in on clause is ambiguous SQL=SELECT g.*,u.name AS editor, fg.form_id AS form_id, f.label AS flabel FROM ilfs_fabrik_groups AS g LEFT JOIN ilfs_users AS u ON checked_out = u.id LEFT JOIN ilfs_fabrik_formgroup AS fg ON g.id = fg.group_id LEFT JOIN ilfs_fabrik_forms AS f ON fg.form_id = f.id ORDER BY name asc Column 'checked_out' in on clause is ambiguous SQL=SELECT g.*,u.name AS editor, fg.form_id AS form_id, f.label AS flabel FROM ilfs_fabrik_groups AS g LEFT JOIN ilfs_users AS u ON checked_out = u.id LEFT JOIN ilfs_fabrik_formgroup AS fg ON g.id = fg.group_id LEFT JOIN ilfs_fabrik_forms AS f ON fg.form_id = f.id WHERE (g.published IN (0, 1)) ORDER BY name asc
Please let me know how to resolve this issue.
Looking forward ...
Thanks in advance