Question category page shows white page

I believe, Matias has knowledge of this problem, it is similiar to this one:

www.kunena.com/forum?func=view&catid=81&id=16037

But this here will be also reported to Matias

And no, it is not exclusive

www.kitesurferen.dk/index.php?option=com...&catid=2&func=fb_pdf

www.thaiportal.nl/forum.html?id=18448&catid=47&func=fb_pdf

www.redeamigadacrianca.org.br/forum.html...&catid=2&func=fb_pdf

I'm also experiencing the same issue. Here is a bit more information to help diagnose the issue.

My Setup:
Joomla 1.0.15
Community Builder 1.2.1
PHP 5.2.3
MySQL 5.0.45-community

I am also receiving the 'white screen' and same error message when a logged in 'Registered' user tries to view the 'Categories' page. It only happens on the Categories page and only for logged in Registered users. All other areas of the forum work as expected.

Also, the Categories page displays as expected when Viewing the page without logging in OR if logged in as a Super Administrator. The problem seams to be isolated to Registered users.

Please let me know if any other info would help diagnose the issue. Thank you.

Thank you for the information that you've posted, djackso1.

Can we eliminate one factor, please? Would it be possible for you to create, an "empty" test website, using Joomla 1.0.15 and Kunena 1.0.10 (with or without CB 1.2.1) and one or two registered users, to see if the error reproduces itself? If the error is reproduced in that cut-down test environment, could you then create another "empty" website using Joomla 1.5.10 (with the "legacy mode" plugin enabled, of course) and Kunena 1.0.10 - again, with or without CB 1.2.1 (the choice is yours) - to establish if the error is reproduced?

There has been one documented case where it's been established that Joomla 1.0.15 was responsible for clobbering Kunena 1.0.10 - Category TAB gives several PHP errors - similar to what you've described but, at the same time, different insofar as the other case didn't mention that the error was isolated to registered users. As you will see if you look at the other case, it took a lot of time and patience to identify the cause of the problem.

Additional Information:



I turned debug on for the site and the following error message is created when navigating to the 'Categories' view on the forum as a logged in Registered user:

Notice: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group by thread' at line 1 in /home/usatf5/public_html/includes/database.php on line 307

/home/usatf5/public_html/includes/database.php:498
/home/usatf5/public_html/components/com_kunena/template/default_ex/listcat.php:269
/home/usatf5/public_html/components/com_kunena/kunena.php:689
/home/usatf5/public_html/index.php:236

I'll keep testing and report back if I find anything. -Dave

djackso1 wrote:

Additional Information:



I turned debug on for the site and the following error message is created when navigating to the 'Categories' view on the forum as a logged in Registered user:

Notice: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group by thread' at line 1 in /home/usatf5/public_html/includes/database.php on line 307

/home/usatf5/public_html/includes/database.php:498
/home/usatf5/public_html/components/com_kunena/template/default_ex/listcat.php:269
/home/usatf5/public_html/components/com_kunena/kunena.php:689
/home/usatf5/public_html/index.php:236

I'll keep testing and report back if I find anything. -Dave

A couple of small edits to the listcat.php file and everything is working as expected for me. Here is what I did:

Changed line 270 from this:
$database->setQuery("SELECT DISTINCT thread from #__fb_messages where catid=$singlerow->id and hold=0 and moved=0 and time>$prevCheck group by thread");

To This:
$database->setQuery("SELECT DISTINCT thread FROM #__fb_messages WHERE catid='$singlerow->id' AND hold=0 AND moved=0 and time>'$prevCheck' GROUP BY thread");

AND, Changed line 466 from this:
$database->setQuery("SELECT thread from #__fb_messages where catid=$forumparent->id and hold=0 and time>$prevCheck group by thread");

To This:
$database->setQuery("SELECT thread FROM #__fb_messages WHERE catid='$forumparent->id' AND hold=0 AND time>'$prevCheck' GROUP BY thread");

Thank you for posting your solution. :woohoo:

That is bizarre! In your case, merely capitalising the SQL keywords FROM, WHERE and AND is what fixed the problem (and I always though that SQL queries were case insensitive! :huh: ). I still believe that there's a fundamental issue for Kunena 1.0.10 involving Joomla 1.0 - as much as your particular version MySQL seems to be involved - so I wonder how many other instances of SQL statements lurk in Kunena (and goodness knows how many other Joomla extensions you may be using) that would need this same correction to be made? :S

Congratulations and well done!