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;