just finished updating various forums with no problems. However, one forum is giving me some trouble. none of the script will work at all. So for instance, I pasted the whole thing in and got an error, so I deleted the section with the Red Cross next to it (doing all this in phpMyAdmin).I did this until I had used the whole script but none of it worked. Any ideas?

Very vague. What scripts?

Sorry, I was a bit vague. 101_to_103. I have followed the manual and I almost know it word by word.

I think this is the very first fire board forum because hasn't got the online status. However, after reading through some of the threads, I'm led to believe that there was a problem with the packaging and whereas it says 1.0.0 on the forum I'm trying to upgrade, it is in fact 1.0.1, so I'm following these instructions. The forum I updated before this one was 1.0.0 beta, so I followed 1.0.1 beta instructions and it works perfectly okay. I'm using the same instructions for the forum that is giving me trouble. Hope that makes sense

So I pasted the whole script in and got an error. So then I pasted in the script without the part that gave me an error. I carried on until I didn't have any more script paste in

Install EasySQL.

k I'll try that

Before I press any buttons, in easy SQL I have a text field (command) and the drop down (table) . These two boxes are located directly above where you put the script. At the moment, the word "select " is in the text field, and in the table drop down, it is actually on securityimages(obviously the table that corresponds to this component). Should I change any of these before executing the script?

I wouldn't imagine leaving the table drop down on security images would be correct. I'm wondering whether I should select jos_fb_categories from the drop-down list. Also,I'm not sure which I should choose from the drop-down menu on the left hand side. There are quite a few commands in there, I don't want to make a mess so if you have any ideas, please enlighten me

Do I actually need to add the script? it doesn't matter what I paste into phpMyAdmin, none of it will work, I end up deleting everything. I'm just wondering if I don't need to put the script then. All the other websites that did accept the script didn't have half as many entries on the forum as this one

unfortunately still not getting anywhere with this. When I paste in the scripts from 101_to_103 I first get this error message. SQL query:

/* 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` ,
ADD KEY `msg_id` ( `id_last_msg` ) ,
COMMENT = '';

MySQL said: Documentation
#1060 - Duplicate column name 'headerdesc'


Now it says duplicate column name 'headerdesc'


I have been deleting :ADD COLUMN `headerdesc` text NOT NULL AFTER `description` ,
ADD COLUMN `class_sfx` varchar( 20 ) NOT NULL AFTER `headerdesc` , once I've done that, it then tells me the next line is also duplicate so then I delete that. Am I actually deleting the right content. When I say delete, I mean leave it out of the original script

well that's very strange. The forum seems to be okay now. No error messages or strange things going on. Not sure what I did but I wasn't aware that I got a successful "message" telling me that the script had gone in okay. What would be the obvious signs that something was very wrong with the forum other than strange warning messages coming up at the top of the forum?