Kunena 7.0.4 Released

The Kunena team has announce the arrival of Kunena 7.0.4 [K 7.0.4] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0

Topics that are moved into this category are generally considered to be closed. Users may want to add additional information but these topics should not be resurrected in order to discuss new problems or unrelated matters.

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

More
15 years 3 months ago #84684 by bmroa
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

Please Log in or Create an account to join the conversation.

More
15 years 3 months ago - 15 years 3 months ago #84688 by sozzled
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.
Last edit: 15 years 3 months ago by sozzled.
The following user(s) said Thank You: bmroa

Please Log in or Create an account to join the conversation.

More
15 years 3 months ago #84711 by Matias
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?
The following user(s) said Thank You: bmroa

Please Log in or Create an account to join the conversation.

More
15 years 3 months ago #84794 by bmroa
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

Please Log in or Create an account to join the conversation.

Time to create page: 0.265 seconds