Question Kunena Internal Error: Please enable Kunena Debug Mode and report problem in the www.kunena.org foru

Hi,

I've just upgraded a site and, although everything seems to work, the subgect error is being displayed.

Any suggestions would be appreciated:

Bug Report:

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 u.id AS uid, m.catid FROM jos_users AS u INNER JOIN jos_kunena_users AS p ON u.id=p.userid LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid LEFT JOIN jos_kunena_categories AS c ON m.catid=c.id WHERE u.block='0' AND p.moderator='1' AND (m.catid IS NULL OR c.moderated='1')

Call stack
# Function Location
1 JSite->dispatch() /home/sites/magistrates-association-temp.org.uk/public_html/members/index.php:68
2 JComponentHelper->renderComponent() /home/sites/magistrates-association-temp.org.uk/public_html/members/includes/application.php:124
3 require_once() /home/sites/magistrates-association-temp.org.uk/public_html/members/libraries/joomla/application/component/helper.php:162
4 KunenaApp->__construct() /home/sites/magistrates-association-temp.org.uk/public_html/members/components/com_kunena/kunena.php:874
5 CKunenaListcat->display() /home/sites/magistrates-association-temp.org.uk/public_html/members/components/com_kunena/kunena.php:532
6 CKunenaTools->loadTemplate() /home/sites/magistrates-association-temp.org.uk/public_html/members/components/com_kunena/funcs/listcat.php:347
7 require() /home/sites/magistrates-association-temp.org.uk/public_html/members/components/com_kunena/class.kunena.php:755
8 CKunenaListcat->displayCategories() /home/sites/magistrates-association-temp.org.uk/public_html/members/components/com_kunena/template/default/categories/listcat.php:50
9 CKunenaTools->loadTemplate() /home/sites/magistrates-association-temp.org.uk/public_html/members/components/com_kunena/funcs/listcat.php:273
10 require() /home/sites/magistrates-association-temp.org.uk/public_html/members/components/com_kunena/class.kunena.php:755
11 CKunenaLink->GetProfileLink() /home/sites/magistrates-association-temp.org.uk/public_html/members/components/com_kunena/template/default/categories/categories.php:88
12 CKunenaTools->isModerator() /home/sites/magistrates-association-temp.org.uk/public_html/members/components/com_kunena/lib/kunena.link.class.php:207
13 KunenaAccessJoomla15->isModerator() /home/sites/magistrates-association-temp.org.uk/public_html/members/components/com_kunena/class.kunena.php:493
14 KunenaAccessJoomla15->loadModerators() /home/sites/magistrates-association-temp.org.uk/public_html/members/administrator/components/com_kunena/libraries/integration/joomla15/access.php:89
15 JDatabaseMySQL->loadObjectList() /home/sites/magistrates-association-temp.org.uk/public_html/members/administrator/components/com_kunena/libraries/integration/joomla15/access.php:49
16 JDatabaseMySQL->query() /home/sites/magistrates-association-temp.org.uk/public_html/members/libraries/joomla/database/database/mysql.php:458
17 JError->raiseError() /home/sites/magistrates-association-temp.org.uk/public_html/members/libraries/joomla/database/database/mysql.php:231
18 JError->raise() /home/sites/magistrates-association-temp.org.uk/public_html/members/libraries/joomla/error/error.php:171
19 JException->__construct() /home/sites/magistrates-association-temp.org.uk/public_html/members/libraries/joomla/error/error.php:136



Cheers

Barry

G'day, Barry, and welcome to Kunena.

Is there any chance that we might be able to see your K 1.6 configuration report, please? Are we able to access this website of yours? Thanks.

MAX_JOIN_SIZE is usually enabled only in cheap shared hosting..

There's missing key/index in jos_kunena_users, adding it will fix this issue:

ALTER TABLE `jos_kunena_users` ADD INDEX ( `moderator` );

But your failed query is pretty simple, so could there be other failing queries as well?

Hi,

Adding the index has cleared the error.

I should have looked deeper before crying for help. :blush:

Thanks for the quick response, and keep up the excelent work.

Cheers

Barry