Question default_ex template causes errors when drilling into categories

Hello there!
My hoster has open_base_url restriction or something like this.
So I'm too can't see "listcat" my forums
www.music-dream.com.ua/test/index.php?op...temid=0&func=listcat

Clean Joomla (Russian SeoEdition), no communitybuilder, no sef-links.

Can I PM somebody from Kunena's team acces to my "test" Joomla site to explore this problem.

With best regards.

It works fine for me?

A blank install works on my site too but an upgrade doesn't.

Ok, this time I think I've solved it! Because a blank install was working ok I had a feeling the problem lay in some corrupted threads in the db.

I started pruning the messages first from 90 days old. No luck. Then I tried 60 days old and this seemed to work. (link below might have a short life as its a test site)

www.hounslowtw3.net/dev/index.php?option...func=showcat&catid=2

Anyhow, I hope this can help others!

@ PaulyPaul:

You have restriction in your database, which forbids MySQL server to read more than MAX_JOIN_SIZE rows. Removing messages lowers the number of rows, so deleting messages works.

One solution would be to move old messages into another forum. I hope to get this issue fixed in K1.6.

Here's the error message I got by enabling debug mode:

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