Fireboard to SMF

[ikki_83]

ok now it works, but i can't access with my admin password... why?

[Cubjo]

Whenever i try and convert I keep getting this message

Converting...
Converting members... Successful.
Converting categories... Unsuccessful!
This query:
INSERT INTO `tassiedi_smf3`.smf_categories
(ID_CAT, name, catOrder)
VALUES ('501', 'Important Announcements', '1'),
('504', 'Newbie Corner', '2'),
('502', 'Diving', '3'),
('505', 'Dive Businesses', '4'),
('503', 'Off Topic', '5'),
('506', 'Photos and photoshop', '6');
Caused the error:

Duplicate entry '255' for key 1


Can anyone help.

Cheers

[SleePy]

Hmm, I swear I have posted something like this

Using phpMyAdmin (What is phpMyAdmin?)
View your smf_categories table and click structure if it isn't already on it.
Then edit the id_cat column and change the type to a mediumnint.

This should boast up the number of categories that can be handled in SMF.
I don't know why some boards think that someone will need  more than 255 categories though. If you get that many you are doing something wrong

[faedler]

I got it working, realize my mistake, wrong path.

Anyway, I have the same problem as you. Be good to find a solution.

Hi hawker, what path did you use, im having the same error, cannot find the path to my fireboard . Thank you

[JayBachatero]

Ok added this to the list of converters to update.  A question.  Is fireboard standalone or I need to install Joomla to use it?

[eLeS]

You must install Joomla because Fireboard is only component. FB is not standalone.

[JayBachatero]

You must install Joomla because Fireboard is only component. FB is not standalone.

Oh ok thanks.  Can I get a database dump with some data to test this out?

[Janan]

hawker
i am trying to convert my Fire board forum to SMF.
first i installed SMF's latest (1.1.4) version with database name "SMF" for conversion
i started the conversion and the first step was successful, members were transfered to the new SMF forum from my Joomla-fireboard but after that i got a duplicate entry error in smf_categories, i did re installation n tried it again for almost 10 times.
i thought it could be a version problem so i downloaded n install SMF 1.1.2. but still getting same error while transferring Categories
i removed boards n categories from the SMF and tried conversion again but still getting same duplicate error

here is the error messege

Converting...
Converting members... Successful.
Converting categories... Unsuccessful!
This query:

    INSERT INTO `smf`.smf_categories
    (ID_CAT, name, catOrder)
    VALUES ('505', 'Religion', '2'),
    ('508', 'General', '3'),
    ('504', 'Instant messaging', '4'),
    ('502', 'Entertainment', '5'),
    ('506', 'Languages', '6'),
    ('503', 'Computer & Mobile Help', '7'),
    ('507', 'Recycle Bin', '8'),
    ('513', 'Miscellaneous', '9');

Caused the error:

    Duplicate entry '255' for key 1

what should i do now? how to solve this error?

[franciscojasousa]

Whenever i try and convert I keep getting this message

Converting...
Converting members... Successful.
Converting categories... Unsuccessful!
This query:
INSERT INTO `tassiedi_smf3`.smf_categories
(ID_CAT, name, catOrder)
VALUES ('501', 'Important Announcements', '1'),
('504', 'Newbie Corner', '2'),
('502', 'Diving', '3'),
('505', 'Dive Businesses', '4'),
('503', 'Off Topic', '5'),
('506', 'Photos and photoshop', '6');
Caused the error:

Duplicate entry '255' for key 1


Can anyone help.

Cheers

Hi,

I'm gettin gthe same as Janan a stage earlier, at the "Converting Members...".

The error:

Converting members... Unsuccessful!
.
.
.

Caused the error:

    Duplicate entry '62' for key 1

Entry '62' is the first user - me - (admin) and, in fact, it apears twice on the output of the script but I just see one record '62' at the "fb_users" table?!?!

I'm puzzled here!

Can anyone give me a hint?

Thanks

The Best to You All.

[franciscojasousa]

Got it.

The script was importing the Joomla account and the fireboard account which are exactly the same.

Just changed the ID of the Joomla one and the script went fine.

Thanks Hawker for it.

[Janan]

Hmm, I swear I have posted something like this

Using phpMyAdmin (What is phpMyAdmin?)
View your smf_categories table and click structure if it isn't already on it.
Then edit the id_cat column and change the type to a mediumnint.

This should boast up the number of categories that can be handled in SMF.
I don't know why some boards think that someone will need  more than 255 categories though. If you get that many you are doing something wrong

after following the above method all of my forum data is transfered except attachments where i got lots of errors, but i am facing a lil problem now as i am unable to login. i know after conversion my admin account will become a normal member account so i have to grant admin permission again from phpmyadmin but i cant even login as a member. i tried another account but still unable to login

[IchBin™]

So what is it doing Janan? Is it giving you any errors? Can we have a link and test it out as well?

[opfa]

hi,

i dont understand step 6,

((6) Go to the sql admin. Add db_user value to the databases of your SMS and Joomla installation.))

i have to import something in the database but where in there?

Thank you!

[Sarge]

((6) Go to the sql admin. Add db_user value to the databases of your SMS and Joomla installation.))

It means that you have to add the database user to both databases.

In other words, the database user that you use to connect to the SMF database has to be added to the Joomla database too, unless they're on the same database.

[tanjong30]

The converter detected that your host has open_basedir enabled on this server. Please ask your host to disable this setting or try moving the contents of your Simpleboard 1.0 and 1.1 to the public html folder of your site.

what should i do?

[JayBachatero]

Make sure that the config file for fireboard is readable.

[Prasetio]

Thx.. It's works for me....

There's problem when finished convert.. I can't use my password... but it's easy.. Use Forgot Password.. When i login.. I can't get Admin... that problem fixed.. I just edit my username (ini filed smf_members) and change the value ID_GROUPS from 0 to 1.

=)

[lcx]

worked great for me, but I found some little bugs I would like to fix before converting my productive forum.
I seem to have some issues with UTF8, posts from the old forum look a bit strange because it seems like it's not inserted as UTF8 to the DB.
the " appear as \" and images that have a size ( [img size=123]) are not displayed.
Anybody else had similar problems?

[Sarge]

the " appear as \" and images that have a size ( [img size=123]) are not displayed.

As far as I know, those errors are not related to UTF-8.

[lcx]

sorry, was a bit tired yesterday.
No, these are other issues. I just wanted to post what little problems I have.
I think I could sort out the other issues, only the UTF problems will be a bit harder. At least there are not many people posting with Romanian letters so if this won't work I could live with that.
The Problem is that the joomla/Fireboard DB is not UTF8, it's latin1. I found a post about a modification to the converter which was done for phpBB to work with utf8 and some tips you have posted how to convert and then use the SMF UTF8 conversion. But this also didn't help. I just got different characters

here is an example:
this is what I have after converting from fireboard this is how it looks:
http://test.vwclub.ro/smf/index.php?topic=2794.msg2865#new [nofollow]

and this is the original
http://test.vwclub.ro/index.php/Help-/-FAQ-/-Sugestii/2865-ReCum-fac-upload-la-poze.html#2865 [nofollow]