IMPORTANT: We moved to new Unified Support Forum

Please post all new support queries in our New Forum →

The forum is in read only mode

Please access New Forum to get support:

Resolved Error 1104, MAX_JOIN_SIZE

GURU Active
  1. Thomas
  2. Guru
  3. Wednesday, 11 October 2017
  4.  Subscribe via email
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.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 LEFT JOIN #__guru_mediarel as lm on LEFT JOIN #__guru_task as lt on WHERE 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

What can I do to make it work again?

Thank in advance for any help,
You do not have permission to view the content of this accepted answer.

There are replies in this post but you are not allowed to view the replies from this post.