pasting the statement from /* on into the SQL tab.

palebluedot wrote:
RUFiO wrote:
SQL query:

Upgrades / Fireboard_101_to_1 .0 .3.Stable.sql

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 'Upgrades/Fireboard_101_to_1.0.3.Stable.sql' at line 1

Thats my error, no idea whats wrong.

Are you trying to import the SQL file or are you copying/pasting the SQL statements into the SQL tab on PHPMyAdmin

Its the error I get after running:
Upgrades/Fireboard_101_to_1 .0 .3.Stable.sql
In the SQL query section of phpmyadmin

EDIT: The installation manual never specified where the Upgrades folder should go, so I jsut stuck it in the Joomla default directory.

I myself am pasting after /* and still get the message :

MySQL said:

#1060 - Duplicate column name 'headerdesc'

The upgrades folder is for local use only. It never gets uploaded to the site. The SQL files are simply there for you to get the necessary SQL statements to execute.

palebluedot wrote:
The upgrades folder is for local use only. It never gets uploaded to the site. The SQL files are simply there for you to get the necessary SQL statements to execute.

So what command should I be running
Upgrades / Fireboard_101_to_1 .0 .3.Stable.sql with some sort of /*

ntzeke wrote:
I myself am pasting after /* and still get the message :

MySQL said:

#1060 - Duplicate column name 'headerdesc'

Try running all remaining lines of the SQL statement following the one that gave you the error. Duplicate errors aren't problematic in the end because the structure has already been set.

RUFiO wrote:
palebluedot wrote:
The upgrades folder is for local use only. It never gets uploaded to the site. The SQL files are simply there for you to get the necessary SQL statements to execute.

So what command should I be running
Upgrades / Fireboard_101_to_1 .0 .3.Stable.sql with some sort of /*

Paste this in the SQL tab box:

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

/* 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`, 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 `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`, COMMENT='';

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

Thanks palebluedot,
Everything is working fine now, perhaps the documentation needs to be updates because I honestly thought SQl was executing a command based on the files inside the upgrade folder. Regardless thanks for your help.

PGLion and ntzeke. Any progress on your issues?

I have tried deleting each line that says is duplicated, only to find the next line says the same thing. I couldn't find one bit of the SQL file that wasn't duplicated.

The installation seems to work fine (except for my dark green template not working). Is there any danger in not getting the SQL query ran if all of it seems to be duplicated?

Thanks for your help in this.