Question Database errors in my Kunena forum

First off, I'm running Kunena 1.5.11 and Joomla 1.5.15.

Whenever Kunena needs to list a number of threads (Recent Discussions, My Discussions, You click on a particular forum) I get all kinds of errors.

Here are some examples....

Recent Discussions

My Discussions

My General Discussion Forum

On the other hand, both the threads themselves and the Categories page appear just fine. Any ideas?

OK, so what's changed recently. Is this the way that Kunena has always worked for you?

One thing that I have noticed about your website, your Kunena template looks like the default_ex template but it's clear to me that it behaves differently to the original, unmodified Kunena template. This is either because of your Joomla site template or it's because you've customised your Kunena template.

What version of Kunena did you upgrade from? The last messages that you wrote about here, at www.kunena.com , involved Community Builder. What version of Community Builder are you now using?

Did the installation of K 1.5.11 complete successfully? You can repeat the installation again, you know. Did you take a backup of your website before you upgraded to K 1.5.11? Lots of questions, sorry, and we can't help much until we know what you've been doing.

sozzled wrote:

OK, so what's changed recently. Is this the way that Kunena has always worked for you?

One thing that I have noticed about your website, your Kunena template looks like the default_ex template but it's clear to me that it behaves differently to the original, unmodified Kunena template. This is either because of your Joomla site template or it's because you've customised your Kunena template.

What version of Kunena did you upgrade from? The last messages that you wrote about here, at www.kunena.com , involved Community Builder. What version of Community Builder are you now using?

Did the installation of K 1.5.11 complete successfully? You can repeat the installation again, you know. Did you take a backup of your website before you upgraded to K 1.5.11? Lots of questions, sorry, and we can't help much until we know what you've been doing.

In order...

-Yes, it's always worked for me that way.

-I'm using the unmodified default_ex template. The template I use for the rest of the site modifies its look slightly.

-I upgraded from Kunena 1.5.9, yes it completed successfully.

-Community Builder version 1.2.1.

-Yes, I took a backup, but the problem started before the upgrade. I was hoping the upgrade would fix it.

Does that help?

Yes, this does help; it helps me to know how to classify this topic. Because the problem started before the upgrade, and it's likely that the problem occurred either because of K 1.5.9 or entirely independently of Kunena, we can't backtrack to K 1.5.9 for an answer. So we now have to move forward.

What's likely to have occurred is that there has been a database "glitch" - these things do happen from time to time - and finding what, specifically, has gone awry is not something that I'm an expert with, by any stretch of the imagination. If we put several minds to work on this problem we may be able to come up with a solution ... but the ultimate decisions are yours and yours alone.

If you know when these symptoms started happening, that might give you a clue. It's also possible that the problem can be tracked to a badly formed database record. It's also possible that the database has become destabilised in some way. Running a database integrity check would also be a good idea. Using a tool like phpMyAdmin is a definite start.

There have also been a lot of discussion topics given to helping users who've had flaky database issues. Searching through those, to see what suggestions have been offered in the past, will also be a big help to you.

So then my question would be...

If I ran every check available under phpMyAdmin, and it's showing the database and tables to be okay, where should I look next?

The only thing I did today before the problem occurred was delete some old Joomla templates that were not in use. I did restore them just to make that wasn't the cause of the problem, but it didn't help the situation.

So, for each of the 17 Kunena database tables (they have the prefix jos_fb_*) you have gone to the "operations" tab in phpMyAdmin and run the various table maintenance utilities: Check table, Analyze table (and possibly Repair table) and you haven't detected anything or nothing has changed?