Thanks for an excellent component!

I try to upgrade from 1.0.0 to 1.0.3 I but when I execute Fireboard_100_to_1.0.3.Stable.sql I get:
[code:1]Fel

Error

SQL query:

-- __^__ __^__
- - ( ___ ) ----------------------------------------- - ( ___ ) -- | / | SQL Upgrade | |
-- | / | Fireboard 1.0.0 to 1.0.3 Stable | |
-- |___| Rename jos_ to your db prefix |___|
- - ( _____ ) ----------------------------------------- - ( _____ ) --
/* Alter table in Second database */ ALTER TABLE `jos_fb_attachments` ADD KEY `mesid` ( `mesid` ) ,
COMMENT = '';

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--( ___ )------------------------------------------( ___ )
-- | / | ' at line 1 [/code:1]

Dont put this:

[code:1]-- __^__ __^__

- - ( ___ ) ----------------------------------------- - ( ___ ) -- | / | SQL Upgrade | |

-- | / | Fireboard 1.0.0 to 1.0.3 Stable | |

-- |___| Rename jos_ to your db prefix |___|

- - ( _____ ) ----------------------------------------- - ( _____ ) --[/code:1]

But start with:

[code:1]/* Alter table in Second database */ ALTER TABLE `jos_fb_attachments` ADD KEY `mesid` ( `mesid` ) ,

COMMENT = '';[/code:1]

Mien: Thanks!

I already try that and get:
[code:1]Error

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' [/code:1]

duplicate means that its already there..and you are trying to do it double..so then continue with the next lines /* and try them one by one..duplicates means that they are there already..so then just continue again with the next one!

in MyPHPadmin I get a "no database selected" error when I try to run the upgrade query from 1.0.2 to 1.0.3

So, I can't run the upgrade query.

I think that causes the "There are no forums in this category!" line in the frontend.

Does anybody know how I can fix this problem?

Do you get that error even after you have selected a database?

Mien: Thanks for try to help!

I try to execute one by one but after the second and all after I get these:
[code:1]Error

SQL query:

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 = ''

MySQL said: Documentation
#1091 - Can't DROP 'catid'; check that column/key exists
[/code:1]

grumblemarc wrote:
Do you get that error even after you have selected a database?

I managed to select the database and run the query.

Everything is working fine now. Thanks!

The new version looks great!

Now I successfully execute two /* but when I go to administrator>Fireboard i get these:

[code:1]Warning: main(/home//components/com_fireboard/class.fireboard.php) [function.main]: failed to open stream: No such file or directory in /home/administrator/components/com_fireboard/admin.fireboard.php on line 22

Fatal error: main() [function.require]: Failed opening required '/home/components/com_fireboard/class.fireboard.php' (include_path='.:/usr/local/lib/php') in /home/administrator/components/com_fireboard/admin.fireboard.php on line 22[/code:1]

I have control over and over again that I upload all files...

I am getting similar error of drop key.

Plz tell me whether you got solution or not ?