I copied the patch files
and now i executed the queries with this link
http://joomlacode.org/gf/project/fireboa....sql&view=markup
so my sql file looked like this ( all my tables start with joom_ so i renamed this in the sql file)
/* Alter table in Second database */
alter table `joom_fb_attachments`
add KEY `mesid`(`mesid`), COMMENT='';
/* Alter table in Second database */
alter table `joom_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='';
/* Create table in Second database */
create table `joom_fb_groups`(
`id` int(4) NOT NULL auto_increment ,
`title` varchar(255) NULL ,
PRIMARY KEY (`id`)
);
/* Alter table in Second database */
alter table `joom_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='';
/* Alter table in Second database */
alter table `joom_fb_messages_text`
drop key `mesid`,
add PRIMARY KEY(`mesid`), COMMENT='';
/* Alter table in Second database */
alter table `joom_fb_moderation`
drop key `catid`, COMMENT='';
/* Create table in Second database */
create table `joom_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 `joom_fb_users`
add column `group_id` int(4) NULL DEFAULT '1' after `karma_time`,
add column `uhits` int(11) NULL DEFAULT '0' after `group_id`,
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`,
add KEY `group_id`(`group_id`), COMMENT='';
/* Alter table in Second database */
alter table `joom_fb_whoisonline`
add KEY `userid`(`userid`), COMMENT='';
INSERT INTO `joom_fb_groups` VALUES ('1', 'Registered User'
;
INSERT INTO `joom_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 `joom_fb_users` SET `rank`=8 WHERE `moderator`=1 AND `rank`=0;
and i get so many errors
I should just copy and paste that text to sql window right?
Or should i copy and paste each line, without the comment lines
I have 1.00 version and I upgraded to the latest version
Here are some of the errors that I receive
SQL-poizvedba:
ALTER TABLE `joom_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 je vrnil:
#1091 - Can't DROP 'catid'; check that column/key exists
and on my site i get these errors
Warning: Invalid argument supplied for foreach() in /home/xxxxx/public_html/seo/components/com_fireboard/template/default/plugin/who/whoisonline.php on line 75
Hidden Users:
Warning: Invalid argument supplied for foreach() in /home/xxxxx/public_html/seo/components/com_fireboard/template/default/plugin/who/whoisonline.php on line 102
Am I doing mistakes?
Please help
Favoured: 20
