Important Performance Problem

I have the same performance issues since i migrated my Fireboard to Kunena 1.5.5. I not quite shure if I can handle the solution from failbit (I´m an SQL N00b) so i wanted to ask if there´s another way to rebuild the index. Thanx a lot in advance!

I'm sorry, i can't deliver a complete list of the differences. Since i upgraded manually, i don't have access to the old tables anymore.

Aside the missing keys, there was different auto increments (f.e. in jos_fb_messages: ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=37000 <-??). Also there were tables in my old installation which didn't exist in the new structure.

I would highly recommend to import your Data in a fresh sql-structure. If i remember correctly there were 30+ changes.. Some of these changes are not easy to apply to a not empty database.

@failbit: Would it be poosible for you to post a more detailed explaination? I know the basics about working with the phpmyadmin, but I don´t really know how to export the data only and import it into a clean structure.

Just for understanding: I´m using the latest Joomla 1.5
I uninstalled my fireboard and installed Kunena 1.5.5. I am experiencing a lack of performance since the update. Opening a section from the section view takes much longer than in the old fireboard. So I think your solution would workfor me too.

Many thanx in advance dude

@Ratman: i initially updatet from fireboard to kunena 1.0.11 first. I don't know if this is important.. After that i updatet to Kunena 1.5.

For the phpmyadmin part:

1) choose your database (the one which have the poor performance)
2) click export
3) choose only the jos_fb* tables
4) choose gzip compression and click "send" at the bottom of the page. you will receive a complete backup of all your forum data. (this is for backup only). keep it at a safe place.
5) repeat 1-3
6) on the right side, there is "structure" enabled. disable it, and do step 4 (this time you only get the data)
7) uninstall kunena, and after that delete all jos_fb* tables with phpmyadmin (CATION: be sure your backup is working!!!!!)
make a fresh kunena install
9) in phpmyadmin in your database, click "import". choose the second file you have saved.

there may be some conflicts, about tables not existing any more. in that case, you could edit the file and delete conflicting items. or you write again in this thread

Hope that helps!

Thank you very much, I´ll test this the next weekend, because it seems this will be a little bit time-expensive

Well... after some hours of hard work I flushed the whole Fireboard-tables in my database, edited the sql backupfiles from a few days before, deleted old paths to even older files and put the tables back in my database, only the pure data, no structure.

It helped, it is fast like before in fireboard. Many thanx go to failbit!