Question Kunena Internal Error - "500 - JDatabaseMySQL::query: 1104"

500 - JDatabaseMySQL::query: 1104 - 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 a.*, t.mesid, t.message AS messagetext, m.mesid AS attachmesid, (f.thread>0) AS myfavorite, u.avatar, MAX(b.time) AS lastpost FROM jos_fb_messages AS a JOIN jos_fb_messages_text AS t ON a.thread = t.mesid LEFT JOIN jos_fb_messages AS b ON b.thread = a.thread LEFT JOIN jos_fb_attachments AS m ON m.mesid = a.id LEFT JOIN jos_fb_favorites AS f ON f.thread = a.id && f.userid='0' LEFT JOIN jos_fb_users AS u ON u.userid = a.userid WHERE a.parent = '0' AND a.catid = '2' AND a.hold = '0' GROUP BY id ORDER BY ordering DESC, lastpost DESC LIMIT 0, 50

As Matias and your hoster said you should use the "SET SQL_MAX_JOIN_SIZE=#" statement to tell the SQL-server that there is a large join request.
To use it I think you must manipulate the request part in Kunena code. Maybe the developers will make an option available in 1.6.1 or later.

FYI - This is a SQL server setting. We will most like never put any such settings into our code. Just like we don't put php or apache settings into our code. Us forcing different settings will break in many other places.
I recommend you see if you can get your hoster to change that setting.

Oh yeah, you're right I forgot that SQL is not really standartisiert.

SET SQL_MAX_JOIN_SIZE=# is a MYSQL Server setting - hast nothing todo with SQL standards.

Well then I dont understand why you will not implement code making this setting available in SQL-statements.

@fxstein: pls pm me the answer in german cause my english is still not good enough for those specific things

A repsonse back from my UK host (Heart Internet):

"Our settings in MySQL are done to strike a balance between allowing maximum functionality for customers and their databases and preserving resources to ensure that all customers enjoy unimpeded access to the server. We cannot change these settings globally, but if this cannot be added into the query somewhere, then I suspect this forum will not able to be used on our shared hosting."