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

I have no idea what this means: MySQL ha dicho: #1061 - blablabla

Can you translate or ask in the language specific boards?

I"ve set blabla, meaning that whatever I say it all time get the same error.

Unfortunately I still don't know what "ha dicho" means and bla bla doesn't really provide any useful information in helping you. Sorry, hoepfully someone else can help you better.

sorry, I"ve not understanded you. Ha dicho, means "says"

Thx anyway for the attention

Ok, first error when upgrading:

Error

SQL query:

/* Alter table in Second database */ ALTER TABLE `guaci_fb_attachments` ADD KEY `mesid` ( `mesid` ) ,
COMMENT = '';

MySQL says: Documentation
#1061 - Duplicate key name 'mesid'

Duplicate key simply means the table already exists. You can safely ignore this error and execute the remaining statements since this structure already is the way it should be.

it says this error for me too. and i cannot continue on phpmyadmin?

[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]

this probably means your current version was 1.0.1
Try the upgrade sql from 101 to 103 instead. It should work

yes sql is ok now but version on fireboard com. is 1.0.0 beta still?