Duplice means the structure exists...the way the SQL statement is trying to change it to. So, no it should be fine.

i have this also


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


i'm running it as an sql query ..

ok. i removed this from the sql file:

-- __^__ __^__
--( ___ )------------------------------------------( ___ )
-- | / | SQL Upgrade | |
-- | / | Fireboard 1.0.1 to 1.0.3 Stable | |
-- |___| Rename jos_ to your db prefix |___|
--(_____)------------------------------------------(_____)
--

and ran teh script again and it worked ...

I get the error

[code:1]#1054 - Unknown column 'uhits' in 'jos_fb_users' [/code:1]

Upgrading from 1.0.1b

Thanks

Its OK had a look at the 1.0.0 upgrade and used that and seems to have worked - but I know I installed 1.0.1b??

Cheers anyway

palebluedot wrote:
PGLion and ntzeke. Any progress on your issues?

I manually checked all tables and columns and found out I missed several lines. After adding those missing lines everything works likes a charm, except the ranks part but I am still investigating that.

gwmbox wrote:
[quote]I get the error

[code:1]#1054 - Unknown column 'uhits' in 'jos_fb_users' [/code:1]

Upgrading from 1.0.1b

Thanks[/quote]

There is 2 columns missed (group_id and uhits) from 1.0.1b to 1.0.3

So it should like this:

[code:1]alter table `jos_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`, COMMENT='';[/code:1]

note that 1.0.1 beta was mistakenly placed as 1.0.0 so uhhh make sure you had 1.0.1 beta.

other then that, i had issues with the comments as well. what i did was remove the comments, copy paste the code and let it execute instead of uploading it. so hope that helps

[quote]

There is 2 columns missed (group_id and uhits) from 1.0.1b to 1.0.3

So it should like this:

[code:1]alter table `jos_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`, COMMENT='';[/code:1][/quote]

I wonder how did they miss that? This should definately be placed in the updgrad .sql file

Yes, remove the header, remove the comment

And if you get error for something cannot found "uhits" and "group_id" add the 2 missed columns, execute via phpadmin, that is.