Hi,

I m using Fireboard 1.0.0 version in my Forum site. Now we want to upgrade it to latest 1.0.4. We did everything as mentioned in update file.

But problems starts when run the SQL query in Database. None of the query runs there. It is giving error in all queries.

We are trapped. Dont know what to do know. We have to upgrade. Is there any option?

Do we need to uninstall the current installation and install fresh?

It would help if you could share some details, just saying it fails won't allow anybody on this forum to provide meaningful help.

What are the sqls you where trying to run, what where the error messages? Providing that output would be a first step.

m Sorry.

I tell u in details.

First I took backup of my installation and then copied Com_fireboard in root/component and in root/administrator/component

then i opened Fireeboard 100 to 103 stable.sql file

copied first query which is:

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

and pasted it in SQL in PHPmyadmin.

then it showed me this error

SQL query:

[code:1]ALTER TABLE `jos_fb_attachments` ADD KEY `mesid` ( `mesid` ) ,
COMMENT = ''

MySQL said: Documentation
#1061 - Duplicate key name 'mesid' [/code:1]

Then I skipped this part and move on to copy rest of the queries one by one, but none of the query run.

:S :dry:

This error says that the key already exisits - just ignore. Same for the rest?

yes almost same..

None of the query running actually.

when I see the frontend, everything seems ok but after each category it says, there is no forum in this category.

when I clicked on latest posts, it opens it well but shows an error, invalid argument supplied.....

Well, you will have to supply all output. Copy/paste all of it in here or attach a text file with it.

fine, just a moment. i will copy all the queries and outcome

Please check the Upgrading forum stickies concerning 1.0.0 to 1.0.3 upgrading. This issue is covered there extensively.