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: https://member.joomlart.com/forums/ijoomla

Resolved Error 1104, MAX_JOIN_SIZE

Licenses:
GURU Active
0
Votes
Undo
  1. Thomas
  2. Guru
  3. Wednesday, 11 October 2017
  4.  Subscribe via email
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
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.