Idea Recent Discussions - Fatal Error

I just installed Kunena and I imported my old phpbb2 forum database.

All seems good, but when I click on the "Recent Discussions" tab, I get the following error:

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 42 bytes) in /home/recipes/public_html/home/libraries/joomla/database/database/mysql.php on line 462

How can I correct this ?



The link to the forum: home.recipesnoop.com/index.php?option=com_kunena

You have too less memory. Please ask your provider to set these preferences:



php max_execution_time >= 120
php memory_limit >= 64M
safe_mode = off

I made those adjustments to my PHP... That solved the problem with the "recent discussion" tab.

Everything seems to work fine, but one of my sub forums give a Fatal Error when I try to access it...

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 16 bytes) in /home/recipes/public_html/home/libraries/joomla/database/database/mysql.php on line 462


What could be causing this with only this one forum. How can I correct this?

Can you send me an URL to the broken page? (PM me)

Kunena tries to read too many entries from database to memory (I think).

home.recipesnoop.com/index.php?option=co...unc=showcat&catid=10



Is there a way to limit how many entries it grabs?

19 threads and 36 000 messages in them?!? Wow. And I thought that I had too many huge threads with 1000-2000 messages (2-3 for a forum).

One possibility is to show less threads per page (15->8-10), as it would save you ~1800 messages per thread and it could be enough.. Another possibility is to add max allowed memory for php to 92M and change Apache settings so that Apache threads to not live forever (1000 requests should be ok).

It looks like we really need to fix this issue. Actually I already have a fix for it, but it's not yet quite ready.