Good Day
Everything is working fine on my localhost, but after I upload all to server I get the following errors in admin.
Under groups I get:
500 - An error has occurred.
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 jos_fabrik_groups AS g LEFT JOIN jos_users AS u ON checked_out = u.id LEFT JOIN jos_fabrik_formgroup AS fg ON g.id = fg.group_id LEFT JOIN jos_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 jos_fabrik_groups AS g LEFT JOIN jos_users AS u ON checked_out = u.id LEFT JOIN jos_fabrik_formgroup AS fg ON g.id = fg.group_id LEFT JOIN jos_fabrik_forms AS f ON fg.form_id = f.id WHERE (g.published IN (0, 1)) ORDER BY name asc
And under elements I get:
500 - An error has occurred.
Column 'checked_out' in on clause is ambiguous SQL=SELECT e.*, e.ordering AS ordering,u.name AS editor, (SELECT DISTINCT( IF( ISNULL(jj.table_join), CONCAT(ll.db_table_name, '___', ee.name), CONCAT(jj.table_join, '___', ee.name)) ) FROM jos_fabrik_elements AS ee LEFT JOIN jos_fabrik_joins AS jj ON jj.group_id = ee.group_id LEFT JOIN jos_fabrik_formgroup as fg ON fg.group_id = ee.group_id LEFT JOIN jos_fabrik_lists AS ll ON ll.form_id = fg.form_id WHERE (jj.list_id != 0 AND jj.element_id = 0) AND ee.id = e.id AND ee.group_id <> 0 LIMIT 1) AS full_element_name, g.name AS group_name, l.db_table_name FROM jos_fabrik_elements AS e LEFT JOIN jos_users AS u ON checked_out = u.id LEFT JOIN jos_fabrik_groups AS g ON e.group_id = g.id LEFT JOIN jos_fabrik_formgroup AS fg ON fg.group_id = e.group_id LEFT JOIN jos_fabrik_lists AS l ON l.form_id = fg.form_id WHERE (e.published IN (0, 1)) AND g.id = 14 ORDER BY ordering asc Column 'checked_out' in on clause is ambiguous SQL=SELECT e.*, e.ordering AS ordering,u.name AS editor, (SELECT DISTINCT( IF( ISNULL(jj.table_join), CONCAT(ll.db_table_name, '___', ee.name), CONCAT(jj.table_join, '___', ee.name)) ) FROM jos_fabrik_elements AS ee LEFT JOIN jos_fabrik_joins AS jj ON jj.group_id = ee.group_id LEFT JOIN jos_fabrik_formgroup as fg ON fg.group_id = ee.group_id LEFT JOIN jos_fabrik_lists AS ll ON ll.form_id = fg.form_id WHERE (jj.list_id != 0 AND jj.element_id = 0) AND ee.id = e.id AND ee.group_id <> 0 LIMIT 1) AS full_element_name, g.name AS group_name, l.db_table_name FROM jos_fabrik_elements AS e LEFT JOIN jos_users AS u ON checked_out = u.id LEFT JOIN jos_fabrik_groups AS g ON e.group_id = g.id LEFT JOIN jos_fabrik_formgroup AS fg ON fg.group_id = e.group_id LEFT JOIN jos_fabrik_lists AS l ON l.form_id = fg.form_id WHERE (e.published IN (0, 1)) AND g.id = 14 ORDER BY ordering asc LIMIT 0, 20 Column 'checked_out' in on clause is ambiguous SQL=SELECT e.*, e.ordering AS ordering,u.name AS editor, (SELECT DISTINCT( IF( ISNULL(jj.table_join), CONCAT(ll.db_table_name, '___', ee.name), CONCAT(jj.table_join, '___', ee.name)) ) FROM jos_fabrik_elements AS ee LEFT JOIN jos_fabrik_joins AS jj ON jj.group_id = ee.group_id LEFT JOIN jos_fabrik_formgroup as fg ON fg.group_id = ee.group_id LEFT JOIN jos_fabrik_lists AS ll ON ll.form_id = fg.form_id WHERE (jj.list_id != 0 AND jj.element_id = 0) AND ee.id = e.id AND ee.group_id <> 0 LIMIT 1) AS full_element_name, g.name AS group_name, l.db_table_name FROM jos_fabrik_elements AS e LEFT JOIN jos_users AS u ON checked_out = u.id LEFT JOIN jos_fabrik_groups AS g ON e.group_id = g.id LEFT JOIN jos_fabrik_formgroup AS fg ON fg.group_id = e.group_id LEFT JOIN jos_fabrik_lists AS l ON l.form_id = fg.form_id WHERE (e.published IN (0, 1)) AND g.id = 14 ORDER BY ordering asc
What could it be?
thanx
Everything is working fine on my localhost, but after I upload all to server I get the following errors in admin.
Under groups I get:
500 - An error has occurred.
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 jos_fabrik_groups AS g LEFT JOIN jos_users AS u ON checked_out = u.id LEFT JOIN jos_fabrik_formgroup AS fg ON g.id = fg.group_id LEFT JOIN jos_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 jos_fabrik_groups AS g LEFT JOIN jos_users AS u ON checked_out = u.id LEFT JOIN jos_fabrik_formgroup AS fg ON g.id = fg.group_id LEFT JOIN jos_fabrik_forms AS f ON fg.form_id = f.id WHERE (g.published IN (0, 1)) ORDER BY name asc
And under elements I get:
500 - An error has occurred.
Column 'checked_out' in on clause is ambiguous SQL=SELECT e.*, e.ordering AS ordering,u.name AS editor, (SELECT DISTINCT( IF( ISNULL(jj.table_join), CONCAT(ll.db_table_name, '___', ee.name), CONCAT(jj.table_join, '___', ee.name)) ) FROM jos_fabrik_elements AS ee LEFT JOIN jos_fabrik_joins AS jj ON jj.group_id = ee.group_id LEFT JOIN jos_fabrik_formgroup as fg ON fg.group_id = ee.group_id LEFT JOIN jos_fabrik_lists AS ll ON ll.form_id = fg.form_id WHERE (jj.list_id != 0 AND jj.element_id = 0) AND ee.id = e.id AND ee.group_id <> 0 LIMIT 1) AS full_element_name, g.name AS group_name, l.db_table_name FROM jos_fabrik_elements AS e LEFT JOIN jos_users AS u ON checked_out = u.id LEFT JOIN jos_fabrik_groups AS g ON e.group_id = g.id LEFT JOIN jos_fabrik_formgroup AS fg ON fg.group_id = e.group_id LEFT JOIN jos_fabrik_lists AS l ON l.form_id = fg.form_id WHERE (e.published IN (0, 1)) AND g.id = 14 ORDER BY ordering asc Column 'checked_out' in on clause is ambiguous SQL=SELECT e.*, e.ordering AS ordering,u.name AS editor, (SELECT DISTINCT( IF( ISNULL(jj.table_join), CONCAT(ll.db_table_name, '___', ee.name), CONCAT(jj.table_join, '___', ee.name)) ) FROM jos_fabrik_elements AS ee LEFT JOIN jos_fabrik_joins AS jj ON jj.group_id = ee.group_id LEFT JOIN jos_fabrik_formgroup as fg ON fg.group_id = ee.group_id LEFT JOIN jos_fabrik_lists AS ll ON ll.form_id = fg.form_id WHERE (jj.list_id != 0 AND jj.element_id = 0) AND ee.id = e.id AND ee.group_id <> 0 LIMIT 1) AS full_element_name, g.name AS group_name, l.db_table_name FROM jos_fabrik_elements AS e LEFT JOIN jos_users AS u ON checked_out = u.id LEFT JOIN jos_fabrik_groups AS g ON e.group_id = g.id LEFT JOIN jos_fabrik_formgroup AS fg ON fg.group_id = e.group_id LEFT JOIN jos_fabrik_lists AS l ON l.form_id = fg.form_id WHERE (e.published IN (0, 1)) AND g.id = 14 ORDER BY ordering asc LIMIT 0, 20 Column 'checked_out' in on clause is ambiguous SQL=SELECT e.*, e.ordering AS ordering,u.name AS editor, (SELECT DISTINCT( IF( ISNULL(jj.table_join), CONCAT(ll.db_table_name, '___', ee.name), CONCAT(jj.table_join, '___', ee.name)) ) FROM jos_fabrik_elements AS ee LEFT JOIN jos_fabrik_joins AS jj ON jj.group_id = ee.group_id LEFT JOIN jos_fabrik_formgroup as fg ON fg.group_id = ee.group_id LEFT JOIN jos_fabrik_lists AS ll ON ll.form_id = fg.form_id WHERE (jj.list_id != 0 AND jj.element_id = 0) AND ee.id = e.id AND ee.group_id <> 0 LIMIT 1) AS full_element_name, g.name AS group_name, l.db_table_name FROM jos_fabrik_elements AS e LEFT JOIN jos_users AS u ON checked_out = u.id LEFT JOIN jos_fabrik_groups AS g ON e.group_id = g.id LEFT JOIN jos_fabrik_formgroup AS fg ON fg.group_id = e.group_id LEFT JOIN jos_fabrik_lists AS l ON l.form_id = fg.form_id WHERE (e.published IN (0, 1)) AND g.id = 14 ORDER BY ordering asc
What could it be?
thanx