I have been getting the following type of error when viewing any list on the back-end:
I have enabled big selects on all lists in my system.
I have also added
I am getting this error every time I open a list to edit it's properties... any help is greatly appreciated.
getJoinsToThisKey: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT db_table_name, name, plugin, l.label AS listlabel, l.id as list_id, el.id AS element_id, el.label AS element_label, f.id AS form_id, el.params AS element_params FROM cs0iq_fabrik_elements AS el LEFT JOIN cs0iq_fabrik_formgroup AS fg ON fg.group_id = el.group_id LEFT JOIN cs0iq_fabrik_forms AS f ON f.id = fg.form_id LEFT JOIN cs0iq_fabrik_lists AS l ON l.form_id = f.id WHERE el.published = 1 AND (plugin = 'databasejoin' AND el.params like '%"join_db_name":"bm_bookings"%' AND el.params like '%"join_conn_id":"1%') OR (plugin = 'cascadingdropdown' AND el.params like '"%cascadingdropdown_table":"1"%' AND el.params like '"%cascadingdropdown_connection":"1"%') AND (plugin = 'user' AND el.params like '%"join_conn_id":"1%"' )
I have enabled big selects on all lists in my system.
I have also added
after:$db->setQuery("SET OPTION SQL_BIG_SELECTS=1");
$db->query();
in administrator/components/com_fabrik/models/elements.php$db = $this->getDbo();
I am getting this error every time I open a list to edit it's properties... any help is greatly appreciated.