Ok, was in a bit of a hurry so assumed grumblemarc meant to remove all lines causing error from the upgrade script. So did that and got through.

However I am now getting the:

There are no forums in this category!

problem!

bpowers84 suggestion doesn't seem to work for me.

"No categories showing!!! Argh! Ran the 1.0.1 script right behind it and BINGO categories!!! But what now?!!! Now no posts!!! Recount Categories Stats and BINGO all back to normal!! Fully upgraded FB!!!".

Did you try this? This is what got BoJosley's forum totally upgraded.

Somehow....by the grace of god and all kind living things on this good earth....

IT WORKS!!

Thanks for a great component!

Well Ive been following the thread with interest.

And Yes I have tried the same "fix".. Still no posts.. and Update stats times out!

i get this error:

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

MySQL said: Documentation
#1146 - Table 'cikopajo_joomla.jos_fb_attachments' doesn't exist

I'm sorry but it is SO obvious that you didn't read through this thread before you posted as this issue is covered RIGHT ON THE FIRST PAGE OF THE THREAD!!!

Hi,

I get an error running:
[code:1]
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='';
[/code:1]

I get the following error message:
"ERROR 1091 (42000): Can't DROP 'id'; check that column/key exists"

I've traced this down to:
[code:1]
alter table jos_fb_messages
drop primary key(`id`);
[/code:1]

Which results in the following error:
"ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key"

Is it safe to ignore the "drop key `id`," line?

This would result in a table definition of:
[code:1]
mysql> describe jos_fb_messages;
+-----------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| parent | int(11) | YES | | 0 | |
| thread | int(11) | YES | | 0 | |
| catid | int(11) | NO | | 0 | |
| name | tinytext | YES | | NULL | |
| userid | int(11) | NO | | 0 | |
| email | tinytext | YES | | NULL | |
| subject | tinytext | YES | | NULL | |
| time | int(11) | NO | MUL | 0 | |
| ip | varchar(15) | YES | | NULL | |
| topic_emoticon | int(11) | NO | | 0 | |
| locked | tinyint(4) | NO | MUL | 0 | |
| hold | tinyint(4) | NO | MUL | 0 | |
| ordering | int(11) | YES | | 0 | |
| hits | int(11) | YES | | 0 | |
| moved | tinyint(4) | YES | | 0 | |
| modified_by | int(7) | YES | | NULL | |
| modified_time | int(11) | YES | | NULL | |
| modified_reason | tinytext | YES | | NULL | |
+-----------------+-------------+------+-----+---------+----------------+
[/code:1]

Fireboard seems to work OK if I ignore this line, but thought I better check that this won't cause me problems later.

If it helps, we're running Joomla 1.0.13 and our forum history is:
Joomlaboard 1.1.3 -> Joomlaboard 1.1.4 -> Fireboard 1.0 release -> Fireboard 1.0.3 release

Thank you.

Skip all missing and duplicate errors. I'd hold off on upgrading. The new release is right around the corner. Just don't ask for a specific date 'cause I aint tellin'.

"No categories showing!!! Argh! Ran the 1.0.1 script right behind it and BINGO categories!!! But what now?!!! Now no posts!!! Recount Categories Stats and BINGO all back to normal!! Fully upgraded FB!!!".

Does anyone have this magic 1.0.1 script?
Or can anyone post this script here, please.
thanx.

Sorry, I found the file in the 1.0.3 Stable download file.
here is the link
joomlacode.org/gf/download/frsrelease/54...1.0.3_UnzipFirst.zip
Open the zip file and move to the upgrades folder.

i did the mysql update and finally - it WORKS !!!!!!!!!!!!
thanx to all of you.