Hi,
I updated my Guru site with some new courses and reworked the categories.
Suddenly I can´t open the courses in the frontend any more.
The courses are shown, but when I try to open one I get the following error message:
Error 1104:
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT lp.id, lp.name, lp.startpublish, sum(lt.time) AS course_time, CASE lp.level WHEN 0 THEN 'beginner_level' WHEN 1 THEN 'intermediate_level' WHEN 2 THEN 'advanced_level' END AS level FROM #__guru_program as lp LEFT JOIN #__guru_days as ld on lp.id=ld.pid LEFT JOIN #__guru_mediarel as lm on ld.id=lm.type_id LEFT JOIN #__guru_task as lt on lt.id=lm.media_id WHERE lp.author=0 AND lp.published=1 AND lp.startpublish<='2017-10-11 05:45:20' AND (lp.endpublish>'2017-10-11 05:45:20' or lp.endpublish='0000-00-00 00:00:00') GROUP BY lp.id
What can I do to make it work again?
Thank in advance for any help,
Thomas