Low search is not supporting channel fields
Hi Support
We are using low search module with range and field search filter but now getting an error "SQLSTATE[HY000]: General error: 1116 Too many tables; MySQL can only use 61 tables in a join:" as we have 32 field in channel data. So please tell me what is solution for that as given below error are fetching record form channel entries and that may increase
• #0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(111): CI_DB_mysqli_connection->query('SELECT t.entry...')
• #1 ee/legacy/database/DB_driver.php(269): CI_DB_mysqli_driver->_execute('SELECT t.entry...')
• #2 ee/legacy/database/DB_driver.php(179): CI_DB_driver->simple_query('SELECT t.entry...')
• #3 ee/EllisLab/Addons/channel/mod.channel.php(265): CI_DB_driver->query('SELECT t.entry...')
• #4 user/addons/low_search/mod.low_search.php(2038): Channel->entries()
• #5 user/addons/low_search/mod.low_search.php(937): Low_search->_channel_entries()
• #6 ee/legacy/libraries/Template.php(1843): Low_search->results()
Also our EE version is 4.3.2 and low serach version is 46.1.3
Thanks
Replies
Low 2 May 2019 07:24
Looks like the same issue as this one. Please refer to that thread for further support.