just upgrading from 1.0.0 to 1.0.3 I first tested on a test website and all went out quickly okay, however the forum didn't have any entries, apart from one. The website and doing at the moment has loads of entries so I guess that is the problem. Anyway, I entered the script into my SQL and it brought up this error, could someone give me an idea of how I can put things right

/* 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`,
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 */

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;

did you spot my deliberate mistake?

I posted the wrong text. Here is the error code

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'

I knew it.
www.bestofjoomla.com/component/option,co...w/id,26252/catid,79/

I bet I have made your day?

I haven't missed it all up just yet. I've got all my files backed up so if the worst comes to the worst, shall just put the old version back

The problem is, not all of us have got experience with doing this. Everybody's got to start from the beginning. If they were simple instructions that told me what I needed to do to the script and I'll be up and running. For instance, I paste script in and then get a message telling me a table already exists, or there is a duplicate key, can't quite remember. I can't find any simple easy to understand instructions that tell you what to do in this case. I have tried deleting part of the script and then posting again but you just keep getting error messages.

but I will get there in the end so enjoy yourself while you can

Don't know why your panties are in a bunch. This isn't even your thread.

actually it is. I made some alterations including delete the cache and this morning I couldn't login as Ironside so had to create another username. But I've still got an e-mail informing me of a new post and forgot I had changed my username when I replied

I see. So you SPAM the boards asking the same question as another user. Nice. Well the link I gave you was another thread that I pointed you to in the stickies that you claim did not help you. I came to the conclusion that you skimmed over ONE of those threads and weren't going to read anymore so you were left to your own devices.

I'll try to steer clear of your posts in the future.

please don't accuse me of spamming, I have already told you why I have got another username. looking back, you're the one to blame for me spending so long looking at the wrong instructions. I could have probably sorted this out months ago if you had linked to the correct instructions. But I kept giving up, I know now why. And it's not just me, I came across another thread where somebody had an issue with you are handing out the wrong instructions.

If you had any decency, you would try and help rather than watch me struggle. The only reason why we are having this conversation is because you couldn't be bothered to try and help me.

Look. Don't try and blame ME for you running BETA software (for so long1) on live sites when you were warned right up front NOT to. I like how I hand out wrong instructions when I have personally gone and performed the upgrade on MANY peoples sites that were having the same issues YOU seem to be having so much problem with.

AND I didn't make the damn instructions up in the first place. Blame the devs for that AND the tedious and confusing upgrade process that is causing the issues in the first place. There are so many stickies posted up there regarding upgrading that it's a shame.

So don't try and blame ME for you not reading EVERYTHING there was on the subject of upgrading PRIOR to doing it. Others tried to help you and also failed. Don't blame ME or anyone ELSE for not holding your hand while you did the upgrade.

I won't go into a repeat of the documentation provided in the Wiki so I'll just provide the link. www.bestofjoomla.net/wiki/com_fireboard/release_1.0/upgrading

Please follow the link on your own thread and then look at the instruction for upgrading from 1.0.0 THEY ARE WRONG. so me and probably countless Other people have followed your link and have tried to upgrade by following the wrong instructions, it's no wonder we didn't get anywhere. Do you realise how long I spent trying to work out where I was going wrong? How many times I asked the same question regarding the missing fbfiles directory? I appreciate that you didn't write those instructions so you aren't to blame for them being wrong, however If you knew the instructions are wrong, why didn't you make it quite clear in your thread ? I'm not a bloody mindreader, you're supposed to be the expert on here, I am only learning, and unfortunately for me, and rely on people like you to try and help. Go back and see how many times I asked the same question and didn't get any answers. In the end, you told me where I could find the PDF manual which is where I found out where I was going wrong. I have read everything so please don't accuse me of not reading.

As for using a beta version of Fire board, it doesn't say anything about beta in the backend of my website. All it says is 1.0.0.

Anyway, I'm done arguing with you. I'm sick of asking questions on this forum and getting no positive answers.