Question category page shows white page

sozzled wrote:

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!

Thanks, its always nice to be able to give back.

I'm not an SQL expert, but I believe adding the single quotes around $prevCheck made a difference too.

My apologies: my poor eyesight first thing in the morning ... old age, you know! :laugh:

Yes, using a quoted text string makes a huge difference. The odd thing, though, is that I haven't found your problem (after several days testing on a Joomla 1.5.7 website). I wonder why that would be? :S And, technically-speaking, it's not just SQL that's involved: it's PHP, too.

Yes, it's the $prevCheck variable. Could you please echo it and give the result back to me?

BTW: karma up!

Not solved before I get my answer.

Matias wrote:

Not solved before I get my answer.

I'm not sure what you need Matias. I was able to fix my problem by adding the single quotes as mentioned in my previous post. Please let me know if there is anything else I can provide that will help you.

I just need output of:

echo "prevCheck: '$prevCheck'";

When you get that error.