Dear FireBoard users,
In order to further develope the need of Joomla for a robust forum, FireBoard component has been moved to its own new home and new name. You can find more information regarding the Kunena, the successor of FireBoard, at kunena.com. The current forum here will stay for some time more for referencing needs. You can find the FireBoard files under joomlacode.org and other files
Upgrading to Kunena is highly recommended!

Kunena! - To Speak!

A revolution is coming... Kunena - Swahili for: To Speak! THE Next generation of native Joomla based Forum ultra component. Forget what you know about Joomla based forums...
Amazingly Simple Lean and Clean Easier Customization
Kunena is about to redefine the world of Joomla! with the most simplistic ultra component out there. For ultimate performance based on state of the art development techniques, Kunena! is about to bring you... With an integrated plugin system that will allow you to extend Kunena beyond your wildest imaginations...
Upgrade from 1.0.0 to 1.0.3, 1.0.4 Stable
TOPIC: Upgrade from 1.0.0 to 1.0.3, 1.0.4 Stable
#27233
Upgrade from 1.0.0 to 1.0.3, 1.0.4 Stable 9 Years, 11 Months ago  
I have been following the instructions in \'Fireboard Forum_Installation_Upgrade_Manual.pdf\' and everything goes fine until you ask me to
[quote]If necessary, rename all the “jos_” occurrences to your own database prefix. Hence, if your db prefix it “boj_” then you should rename all “jos_” to “boj_”.[/quote]
I can see all datatables contain the \'jos_\' prefix from myphpadmin. I have a couple of questions:
1) how do I rename them?
2) is it [u]all[/u] my tables?

I continued without renaming but ended up with a lot of SQL errors when I ran \'Fireboard_100_to_1.0.3.Stable.sql\'

Can anyone help my site is down and I am worried.
#27233
Upgrade from 1.0.0 to 1.0.3, 1.0.4 Stable 9 Years, 11 Months ago  
I have been following the instructions in \'Fireboard Forum_Installation_Upgrade_Manual.pdf\' and everything goes fine until you ask me to
[quote]If necessary, rename all the “jos_” occurrences to your own database prefix. Hence, if your db prefix it “boj_” then you should rename all “jos_” to “boj_”.[/quote]
I can see all datatables contain the \'jos_\' prefix from myphpadmin. I have a couple of questions:
1) how do I rename them?
2) is it [u]all[/u] my tables?

I continued without renaming but ended up with a lot of SQL errors when I ran \'Fireboard_100_to_1.0.3.Stable.sql\'

Can anyone help my site is down and I am worried.
#27235
Re:Upgrade from 1.0.0 to 1.0.3 Stable 9 Years, 11 Months ago  
Ok I have found how to rename data tables it was under the operations tab in myphpadmin. I renamed all jos_fb* to boj_* and tried to run the \'Fireboard_100_to_1.0.3.Stable.sql\' - I still get SQL errors this time relating to not being able to read data tables called jos_fb*. My site is still down and I am beginning to regret waking this morning.
#27243
Re:Upgrade from 1.0.0 to 1.0.3 Stable 9 Years, 11 Months ago  
It was [b]not neccessary[/b] to change your database prefix at all... your site was set up in the most common way (default) using \'jos_\' as the SQL prefix..

Change all your \'bos_\' amendments back to \'jos_\' and all should be fine
#27245
Re:Upgrade from 1.0.0 to 1.0.3 Stable 9 Years, 11 Months ago  
Thanks for your comments freefallnz I had done it already. Now when I look at my forum from the front end it renders ok but I can only see the main categories of the forum and none of the messages at all. I guess this is because I could not get the \'Fireboard_100_to_1.0.3.Stable.sql\' to run. Have you any further suggestions?
#27360
Re:Upgrade from 1.0.0 to 1.0.3 Stable 9 Years, 11 Months ago  
Interesting,

I\'ve go that same problem..

I have seen in a couple of other post to run the update statistics.

Sadly in my case update statistics just times out.. and like the forum is lucky if its got 40 posts on it.
#27383
Re:Upgrade from 1.0.0 to 1.0.3 Stable 9 Years, 11 Months ago  
I think that the nub of this problem is that the \'Fireboard_100_to_1.0.3.Stable.sql\' has not worked for us. Any suggestions out there?
#27406
Re:Upgrade from 1.0.0 to 1.0.3 Stable 9 Years, 11 Months ago  
\"Could not get it to run\". Are you referring to the errors that you get that \"prevent\" the SQL from running? Easy way to get around them. Here\'s an example with the 1.0.1 to 1.0.3 script-others are similar. When you get an error delete the code you have run up to that point and run the SQL again. I would run them in sections-noted by the \"alter table\" at the beginning or each new query.

EDIT*
[b]OR[/b] you can try [url=http://www.bestofjoomla.com/component/option,com_fireboard/Itemid,38/func,view/id,26252/catid,79/]this[/url] if the following script editing is not our cup of tea.


Example script.
[quote]
[color=#FF0000][b]-- __^__ __^__
--( ___ )------------------------------------------( ___ )
-- | / | SQL Upgrade | \\ |
-- | / | Fireboard 1.0.0 to 1.0.3 Stable | \\ |
-- |___| Rename jos_ to your db prefix |___|
--(_____)------------------------------------------(_____)
--[/b][/color] [b]Don\'t copy/paste this part.[/b]
/* Alter table in Second database */
alter table `jos_fb_attachments`
add KEY `mesid`(`mesid`), COMMENT=\'\';

/* Alter table in Second database */
alter table `jos_fb_categories`
add column `headerdesc` text NOT NULL after `description`,
add column `class_sfx` varchar(20) NOT NULL after `headerdesc`,
add column `id_last_msg` int(10) NOT NULL DEFAULT \'0\' after `class_sfx`,
add column `numTopics` mediumint(8) NOT NULL DEFAULT \'0\' after `id_last_msg`,
add column `numPosts` mediumint(8) NOT NULL DEFAULT \'0\' after `numTopics`,
add column `time_last_msg` int(11) NULL after `numPosts`,
[b]drop key `catid`, [/b] [color=#0000FF][b]Error here? Delete everything BEFORE \"alter table `jos_fb_categories`\" and this point and run SQL again[/b][/color]
[b]drop key `catparent`, [/b][color=#0000FF][b]Error here? Delete everything BEFORE \"alter table `jos_fb_categories`\" and this point and run SQL again[/b][/color]
add KEY `msg_id`(`id_last_msg`),
add KEY `parent`(`parent`),
[b]add PRIMARY KEY(`id`),[/b][color=#0000FF][b]Error here? Delete everything BEFORE \"alter table `jos_fb_categories`\" and this point and run SQL again[/b][/color]
add KEY `published_pubaccess_id`(`published`,`pub_access`,`id`), COMMENT=\'\';
/* Create table in Second database */

create table `jos_fb_groups`(
`id` int(4) NOT NULL auto_increment ,
`title` varchar(255) NULL ,
PRIMARY KEY (`id`)
);


/* Alter table in Second database */
alter table `jos_fb_messages`
add column `modified_by` int(7) NULL after `moved`,
add column `modified_time` int(11) NULL after `modified_by`,
add column `modified_reason` tinytext NULL after `modified_time`,
add KEY `hold_time`(`hold`,`time`),
drop key `id`,
add KEY `locked`(`locked`),
add KEY `time`(`time`), COMMENT=\'\';

/* Alter table in Second database */
alter table `jos_fb_messages_text`
drop key `mesid`,
add PRIMARY KEY(`mesid`), COMMENT=\'\';

/* Alter table in Second database */
alter table `jos_fb_moderation`
drop key `catid`, COMMENT=\'\';
/* Create table in Second database */

create table `jos_fb_ranks`(
`rank_id` mediumint(8) unsigned NOT NULL auto_increment ,
`rank_title` varchar(255) NOT NULL ,
`rank_min` mediumint(8) unsigned NOT NULL DEFAULT \'0\' ,
`rank_special` tinyint(1) unsigned NOT NULL DEFAULT \'0\' ,
`rank_image` varchar(255) NOT NULL ,
PRIMARY KEY (`rank_id`)
);


/* Alter table in Second database */
alter table `jos_fb_users`
add column `group_id` int(4) NULL DEFAULT \'1\' after `karma_time`,
add column `uhits` int(11) NULL DEFAULT \'0\' after `group_id`,
add column `personalText` tinytext NULL after `uhits`,
add column `gender` tinyint(4) NOT NULL DEFAULT \'0\' after `personalText`,
add column `birthdate` date NOT NULL DEFAULT \'0000-00-00\' after `gender`,
add column `location` varchar(50) NULL after `birthdate`,
add column `ICQ` varchar(50) NULL after `location`,
add column `AIM` varchar(50) NULL after `ICQ`,
add column `YIM` varchar(50) NULL after `AIM`,
add column `MSN` varchar(50) NULL after `YIM`,
add column `SKYPE` varchar(50) NULL after `MSN`,
add column `hideEmail` tinyint(1) NOT NULL DEFAULT \'1\' after `SKYPE`,
add column `showOnline` tinyint(1) NOT NULL DEFAULT \'1\' after `hideEmail`,
add column `rank` tinyint(4) NOT NULL DEFAULT \'0\' after `showOnline`,
add column `GTALK` varchar(50) NULL after `rank`,
add column `websitename` varchar(50) NULL after `GTALK`,
add column `websiteurl` varchar(50) NULL after `websitename`,
add KEY `group_id`(`group_id`), COMMENT=\'\';

/* Alter table in Second database */
alter table `jos_fb_whoisonline`
add KEY `userid`(`userid`), COMMENT=\'\';

INSERT INTO `jos_fb_groups` VALUES (\'1\', \'Registered User\');

INSERT INTO `jos_fb_ranks` (`rank_id`, `rank_title`, `rank_min`, `rank_special`, `rank_image`) VALUES
(1, \'Fresh Boarder\', 0, 0, \'rank1.gif\'),
(2, \'Junior Boarder\', 20, 0, \'rank2.gif\'),
(3, \'Senior Boarder\', 40, 0, \'rank3.gif\'),
(4, \'Expert Boarder\', 80, 0, \'rank4.gif\'),
(5, \'Gold Boarder\', 160, 0, \'rank5.gif\'),
(6, \'Platinum Boarder\', 320, 0, \'rank6.gif\'),
(7, \'Administrator\', 0, 1, \'rankadmin.gif\'),
(8, \'Moderator\', 0, 1, \'rankmod.gif\'),
(9, \'Spammer\', 0, 1, \'rankspammer.gif\');

UPDATE `jos_fb_users` SET `rank`=8 WHERE `moderator`=1 AND `rank`=0;
[/quote]
#27412
Re:Upgrade from 1.0.0 to 1.0.3 Stable 9 Years, 11 Months ago  
I have tried again and run the sql in blocks marked by \"/* Alter table\" as you suggested. I got quite a few error messages usually associated with not being able to \"DROP\". When this happened I moved on to the next block and pasted that in. Some blocks ran without errors and some did not. I am not totally sure if you wanted me to delete the offending \"Drop\" line in the SQL try to re-run it. Is that correct?

Once I had completed the process my fireboard shows but says \"There are no forums in this category!\" in each category. The good news is that the Recent post show some messages which I can successfully navigate to and read. So it seems I have just lost the connection between categories and forums. Can you help any more?
#27416
Re:Upgrade from 1.0.0 to 1.0.3 Stable 9 Years, 11 Months ago  
I have just installed the EasySQL joomla component and ran the SQL script here. But I still have the same problem \"There are no forums in this category!\" in all categories.

I guess its the following code that did not run
[code:1]/* Alter table in Second database */
alter table `jos_fb_categories`
add column `headerdesc` text NOT NULL after `description`,
add column `class_sfx` varchar(20) NOT NULL after `headerdesc`,
add column `id_last_msg` int(10) NOT NULL DEFAULT \'0\' after `class_sfx`,
add column `numTopics` mediumint(8) NOT NULL DEFAULT \'0\' after `id_last_msg`,
add column `numPosts` mediumint(8) NOT NULL DEFAULT \'0\' after `numTopics`,
add column `time_last_msg` int(11) NULL after `numPosts`,
drop key `catid`,
drop key `catparent`,
add KEY `msg_id`(`id_last_msg`),
add KEY `parent`(`parent`),
add PRIMARY KEY(`id`),
add KEY `published_pubaccess_id`(`published`,`pub_access`,`id`), COMMENT=\'\';
/* Create table in Second database */[/code:1]
#27423
Re:Upgrade from 1.0.0 to 1.0.3 Stable 9 Years, 11 Months ago  
I guess I am going to have to restore my 1.0.0(Beta) FireBoard. If anyone can tell me why I had this problem I would be very grateful - otherwise I\'ll be stuck in a 1.0.0(Beta) time warp.
Page: 123... 5