OMG! I"m not any god in MySQL, but isn"t needed to understand that when SQL says

MySQL ha dicho:
#1061 - blablabla

anytime you try change from SQL queries or files, it"s because it"s a problem.

My file content (changed the prefix) is:

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

alter table `guaci_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 `guaci_fb_groups`(
`id` int(4) NOT NULL auto_increment ,
`title` varchar(255) NULL ,
PRIMARY KEY (`id`)
);


alter table `guaci_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 `guaci_fb_messages_text`
drop key `mesid`,
add PRIMARY KEY(`mesid`), COMMENT='';

alter table `guaci_fb_moderation`
drop key `catid`, COMMENT='';

create table `guaci_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 `guaci_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 `guaci_fb_whoisonline`
add KEY `userid`(`userid`), COMMENT='';

INSERT INTO `guaci_fb_groups` VALUES ('1', 'Registered User');

INSERT INTO `guaci_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 `guaci_fb_users` SET `rank`=8 WHERE `moderator`=1 AND `rank`=0;[/code:1]

What"s wrong in there? I"m trying to do it manually but there are few things that I don"t understand an can"t change. Anyone can give me hand?

Thx for the attention, anyway I"m sure that 1.0.3 would be a nice release, take all care,
Dade