Question Upgrade Fireboard 1.0.5RC to Kunena 1.5.4

Dear all,

Firstly I need to apologize for my lack of knowledge in MySQL so I hoping for some back-to-basic hints here.

I had a Fireboard forum on Joomla 1.0. I updated to Joomla 1.5 and updated to FireBoard 1.0.5RC.

The forum "works" but, I cannot edit or delete posts. It says the following table is missing:

jos_fb_attachments

I have tried to update to Kunena 1.5.4 but I get the error "Your Kunena installation is incomplete!" which there is already a locked post in this forum talking about it.

I have read over similar instances of this and from what I gather I need to create this table in my DB and this would also be why the update to Kunena didn't work. PLease correct me if I am wrong.

Here is the dumb question: assuming I know nothing about MySQl how do I make this table? And, what fields are needed in this table?

I do have MS SQL Sever Management Studio Express on this PC but I don't think this can edit MySQL tables?

I opened the database .sql file into MS Sever Man. Stud. and did a quick search. The table jos_fb_attachments could not be found so I am sure it is missing. I just don't know how to edit this file and create the table. more so, what fields and values are needed.

i.e. the jos_fb_announcement CREATE TABLE command looks like this:

CREATE TABLE `jos_fb_announcement` (
`id` int(3) NOT NULL auto_increment,
`title` tinytext,
`sdescription` text NOT NULL,
`description` text NOT NULL,
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
`ordering` tinyint(4) NOT NULL default '0',
`showdate` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

I really want to keep using FireBoard and more so want to update to Kunena. I think this platform is great but i can't resolve this I will need to start again with a new forum and lose all the great posts I already have.

Finally, if someone could suggest a free MySQL DB editor that would be perfect.

Thanks so much for a great tool and forum.


Brenden

G'day, brenden

We can do this the easy way, or we can do things the Microsoft way. You asked (among other things) if anyone knows of a free DB management tool? phpMyAdmin (can't get any easier, or cheaper, than that). But will it work in a Microsoft IIS environment? As Shakespeare would probably have said "Aye, there's the rub!"

The most important question to all of this is how much have you invested in Fireboard and could you afford to abandon it or start all over again? This would be a much easier solution ... but it depends on how much courage you have. So, in essence what I'm asking is this: do you have a lot of Fireboard messages you want to keep?

Another question that have relates to a comment you made early in your message:

I had a Fireboard forum on Joomla 1.0. I updated to Joomla 1.5 and updated to FireBoard 1.0.5RC.

Do you still have your original J! 1.0.x website ... or have you trashed it? When you upgraded Fireboard, presumably from an older version of it, did you run the conversion procedure beforehand? In other words, can you go back to what you had originally? If you could go back, have you read this discussion topic which might help you: Move users and posts from Fireboard J1.0 to Kunena J1.5 You see, you're not the first person who's been in this situation before ... and you won't be the last. This is what I call "getting back to basics." :lol:

But the whole discussion might be purely an academic one if you cannot get Kunena 1.5.4 to co-operate on your Microsoft web-server (I'm assuming that's what you're using) even though it should work. Have you verified that you can use K 1.5.4 on a J! 1.5.x website built on your server? :S

Hi Sozzled,

Thanks for the reply!

Firstly just to clarify it is not on an MS server. I just have have Windows on my notebook and was going to inspect the database locally after restoring a backup from the site.

Server details:

Apache version 1.3.41 (Unix)
PHP version 5.2.4
MySQL version 5.0.81-community
Operating system Linux

Well, we would prefer not to start over again... I only wish I realized Kunena before...

We have 5,432 and growing daily. We have a loyal following who have invested a lot of effort in posting so to scrap... but I'd run out of tissues!

Current version is now 1.0.4... I found i could actually uninstall 1.0.5RC and reinstall 1.0.4 and all my database errors went away.

The forum is working totally fine now but I still want to upgrade to Kunena. I tried to install Kunena again and this is the result:

Version installing: com_kunena_v1.0.11_stable_b1354_2009-07-10.zip

>> After install all seems well:
===============================================


I N S T A L L : Successful

php version: 5.2.4 (Required >= 4.3.9)
mysql version: 5.0.81-community (Required > 4.1.19)
===============================================

BUT, the success message says Upgrading "com_kunena" (Version: 1.5.4 / Version Date: 2009-07-11 / Install Date: 2009-07-29 / Build: 1730 / Version Name: Fale)

This can't be right, as it is V1.0.11 stable so it seems to be remembering 1.5.4 install from software? Anyway to purge this old files / data? I checked the folders with FTP and the com_kunena folder is not there before I installed it.

Then;

Components > Kunena:

===============================================


* Your Kunena installation is incomplete!

Notice

* Because of the above errors your Forum is now Offline and Forum Administration has been disabled.

Message

* Possible reasons for this error:
* 1) Kunena installation process has failed or timed out (try to install it again)
* 2) You have manually modified or removed some of the Kunena tables from your database
* You can find solutions to the most common issues on our community documentation wiki: Kunena Documentation Wiki
* Our support forum can be found from: www.kunena.com


===============================================

... you've heard it all before

Uninstalled then tried com_kunena_v1.5.4_stable_b1730_2009-07-11.zip.

Success message : Upgrading "com_kunena" (Version: 1.5.4 / Version Date: 2009-07-11 / Install Date: 2009-07-29 / Build: 1730 / Version Name: Fale)

I hope you can help with this. I really want Kunena! Thanks guys


Brenden