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...
Upgrading from 1.0.0 to 1.0.3/1.0.4 Issues
TOPIC: Upgrading from 1.0.0 to 1.0.3/1.0.4 Issues
#20600
Upgrading from 1.0.0 to 1.0.3/1.0.4 Issues 10 Years, 2 Months ago  
OMG! I\"m not any god in MySQL, but isn\"t needed to understand that when SQL says

[quote]MySQL ha dicho:
#1061 - blablabla[/quote]

anytime you try change from SQL queries or files, it\"s because it\"s a problem.

My file content (changed the prefix) is:

[code:1]alter table `guaci_fb_attachments`
add KEY `mesid`(`mesid`), COMMENT=\'\';

alter table `guaci_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 `guaci_fb_groups`(
`id` int(4) NOT NULL auto_increment ,
`title` varchar(255) NULL ,
PRIMARY KEY (`id`)
);


alter table `guaci_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 `guaci_fb_messages_text`
drop key `mesid`,
add PRIMARY KEY(`mesid`), COMMENT=\'\';

alter table `guaci_fb_moderation`
drop key `catid`, COMMENT=\'\';

create table `guaci_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 `guaci_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 `guaci_fb_whoisonline`
add KEY `userid`(`userid`), COMMENT=\'\';

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

INSERT INTO `guaci_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 `guaci_fb_users` SET `rank`=8 WHERE `moderator`=1 AND `rank`=0;[/code:1]

What\"s wrong in there? I\"m trying to do it manually but there are few things that I don\"t understand an can\"t change. Anyone can give me hand?

Thx for the attention, anyway I\"m sure that 1.0.3 would be a nice release, take all care,
Dade
#20600
Upgrading from 1.0.0 to 1.0.3/1.0.4 Issues 10 Years, 2 Months ago  
OMG! I\"m not any god in MySQL, but isn\"t needed to understand that when SQL says

[quote]MySQL ha dicho:
#1061 - blablabla[/quote]

anytime you try change from SQL queries or files, it\"s because it\"s a problem.

My file content (changed the prefix) is:

[code:1]alter table `guaci_fb_attachments`
add KEY `mesid`(`mesid`), COMMENT=\'\';

alter table `guaci_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 `guaci_fb_groups`(
`id` int(4) NOT NULL auto_increment ,
`title` varchar(255) NULL ,
PRIMARY KEY (`id`)
);


alter table `guaci_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 `guaci_fb_messages_text`
drop key `mesid`,
add PRIMARY KEY(`mesid`), COMMENT=\'\';

alter table `guaci_fb_moderation`
drop key `catid`, COMMENT=\'\';

create table `guaci_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 `guaci_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 `guaci_fb_whoisonline`
add KEY `userid`(`userid`), COMMENT=\'\';

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

INSERT INTO `guaci_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 `guaci_fb_users` SET `rank`=8 WHERE `moderator`=1 AND `rank`=0;[/code:1]

What\"s wrong in there? I\"m trying to do it manually but there are few things that I don\"t understand an can\"t change. Anyone can give me hand?

Thx for the attention, anyway I\"m sure that 1.0.3 would be a nice release, take all care,
Dade
#20606
Re:Upgrading from 1.0.0 to 1.0.3 Issues 10 Years, 2 Months ago  
I have no idea what this means: MySQL ha dicho: #1061 - blablabla

Can you translate or ask in the language specific boards?
#20608
Re:Upgrading from 1.0.0 to 1.0.3 Issues 10 Years, 2 Months ago  
I\"ve set blabla, meaning that whatever I say it all time get the same error.
#20611
Re:Upgrading from 1.0.0 to 1.0.3 Issues 10 Years, 2 Months ago  
Unfortunately I still don\'t know what \"ha dicho\" means and bla bla doesn\'t really provide any useful information in helping you. Sorry, hoepfully someone else can help you better.
#20664
Re:Upgrading from 1.0.0 to 1.0.3 Issues 10 Years, 2 Months ago  
sorry, I\"ve not understanded you. Ha dicho, means \"says\"

Thx anyway for the attention
#20671
Re:Upgrading from 1.0.0 to 1.0.3 Issues 10 Years, 2 Months ago  
Ok, first error when upgrading:

[quote]Error

SQL query:

/* Alter table in Second database */ ALTER TABLE `guaci_fb_attachments` ADD KEY `mesid` ( `mesid` ) ,
COMMENT = \'\';

MySQL says: Documentation
#1061 - Duplicate key name \'mesid\' [/quote]
#20758
Re:Upgrading from 1.0.0 to 1.0.3 Issues 10 Years, 2 Months ago  
Duplicate key simply means the table already exists. You can safely ignore this error and execute the remaining statements since this structure already is the way it should be.
#20964
Re:Upgrading from 1.0.0 to 1.0.3 Issues 10 Years, 2 Months ago  
it says this error for me too. and i cannot continue on phpmyadmin?

[code:1]Error

SQL query:

/* Alter table in Second database */ ALTER TABLE `jos_fb_attachments` ADD KEY `mesid` ( `mesid` ) ,
COMMENT = \'\';

MySQL said: Documentation
#1061 - Duplicate key name \'mesid\' [/code:1]
#20975
Re:Upgrading from 1.0.0 to 1.0.3 Issues 10 Years, 2 Months ago  
this probably means your current version was 1.0.1
Try the upgrade sql from 101 to 103 instead. It should work
#21210
Re:Upgrading from 1.0.0 to 1.0.3 Issues 10 Years, 2 Months ago  
yes sql is ok now but version on fireboard com. is 1.0.0 beta still?
Page: 123