Hi to all!
I have modified simpleboard to smf converter so it can work to convert fireboard to smf.
I know it is not so hard, but someone could have problems so I attach fireboard to smf converter.
Sory for my bad English.
Greetings from Croatia!
Thanks for your contribution. I'll respond to this to bump it up and maybe Orstio will see it and know what to do with it.
I currently have Fireboard installed but noone likes it because of the lack of Polls and other features which most people use. I would like to consider converting from Fireboard to SMF as I have seen these features used here that my members like.
Can you give a some indepth detail on how to go about doing the converstion and mention weither or not I will lose my current post?
Thanks,
James
I imagine the converter is just like any other. Read this:
Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)
Hi, and thanks for this converter, but i have a problem... seems that all is ok less the content of posts... appear something that this:
img width=][img width=][img width=][img width=][img width=][img width=][img width=][img width=][img width=][img width=][img width=][img width=]]http://www.[img width=]darqu[img width=]t[img width=]ctura.[img width=]nfo/co[img width=]pon[img width=]nt[img width=]/co[img width=]_f[img width=]r[img width=]board/upload[img width=]d/[img width=][img width=]a[img width=][img width=][img width=]/[img width=][img width=]lf[img width=]uf[img width=]c[img width=][img width=]nt[img width=][img width=][img width=].jp[img width=][/[img width=][img width=][img width=]][img width
Any solution?
Thanks¡¡
Can someone advise where I should point this for FireBoard, I tried:
/www/www/forum/components/com_fireboard
I also tried:
/www/www/forum/administrator/components/com_fireboard
both come up saying it can't find the setting file for SimpleBoard.
Unable to find the settings for Simpleboard 1.0 and 1.1. Please double check the path and try again.
I did the conversion with parent path of joomla, and all ok less the content of posts... as you can see in previous post...
Try it, and please, if u can do the conversion, explain me¡ thanks
I got it working, realize my mistake, wrong path.
Anyway, I have the same problem as you. Be good to find a solution.
thanks for the converter but the posts come out as miristilo said they do
any solution to that?
I wonder if this data shows up in the database. Perhaps if we export the database, and remove [img width=] it'll work?
I can remove the img width crap out of the database, but it's just gibberish etc
I'd say it's something in this screwing us:
/******************************************************************************/
--- Converting posts (this may take some time)...
/******************************************************************************/
TRUNCATE {$to_prefix}messages;
TRUNCATE {$to_prefix}attachments;
---* {$to_prefix}messages 200
---{
$row['body'] = preg_replace('~[file name=.+?]http.+?[/file]~i', '', $row['body']);
$row['body'] = preg_replace('~[img size=(\d+)]~i', '[img width=$1]', $row['body']);
---}
SELECT
m.id AS ID_MSG, m.thread AS ID_TOPIC, m.time AS posterTime,
SUBSTRING(m.subject, 1, 255) AS subject, m.userid AS ID_MEMBER,
SUBSTRING(m.name, 1, 255) AS posterName,
SUBSTRING(m.email, 1, 255) AS posterEmail,
SUBSTRING(m.ip, 1, 255) AS posterIP, m.catid AS ID_BOARD,
SUBSTRING(mt.message, 1, 65534) AS body, '' AS modifiedName, 'xx' AS icon
FROM ({$from_prefix}fb_messages AS m, {$from_prefix}fb_messages_text AS mt)
WHERE mt.mesid = m.id;
---*
Same problem all categories good but the content is all ******, anyone got the bug resolved?
I could seriously use a working converter right now. Migrating my site to drupal and I dont want to use their forum module
This was never an "official" converter in the first place therefore support for it seems limited to the original author who modded the Simpleboard one.
I am not saying you will not get support on this but you have to also understand that Fireboard is a relatively new software.
Quote from: redone on July 14, 2007, 04:32:34 PM
This was never an "official" converter in the first place therefore support for it seems limited to the original author who modded the Simpleboard one.
I am not saying you will not get support on this but you have to also understand that Fireboard is a relatively new software.
dude we are just looking for help, its not like we are demanding anything.
Quote from: redone on July 14, 2007, 04:32:34 PM
This was never an "official" converter in the first place therefore support for it seems limited to the original author who modded the Simpleboard one.
I am not saying you will not get support on this but you have to also understand that Fireboard is a relatively new software.
I understand that and thats why i test the converter in a development joomla/fireboard installation and not in the main site, but fireboard as easy to install and ready to use is ok, but is millions years from full production forums out there, i have many sites whit Vbulleting and IPB, but SMF seems the #1 option to integrate whit joomla CMS.
Sorry for my grammar, English is not my main language.
Quote from: Pacha on July 14, 2007, 05:31:03 PM
I understand that and thats why i test the converter in a development joomla/fireboard installation and not in the main site, but fireboard as easy to install and ready to use is ok, but is millions years from full production forums out there, i have many sites whit Vbulleting and IPB, but SMF seems the #1 option to integrate whit joomla CMS.
Sorry for my grammar, English is not my main language.
on my part, I am looking towards ditching joomla completely
I got it working. Don't know how. I thought it was buggy, but used the SMF admin to re-calculate posts etc and now it works fine!
I'm going to try it on my second site, and if it works again, I'll upload the modded version for people to try!
BUt how, i keep getting all forums, members, titles post count fine but the messages text are all ****** up. What version of SMF and Fireboard are you using
Yep my modified files works fine. It errors at forum statistics, but you can recalculate that in SMF!
All my software is the latest :)
Can you put the modified file?
Ok,
I am not guaranteeing this will work, but it has worked on two of my sites!
What I did was run this script as normal, it will error and say statistics did not update, but this is fine! You will need admin access to your SQL database, as you might have to update your user to admin, as it may drop your permissions.
To fix the statistics issue, simply log into the admin section of the site, go to Forum Maintenance and then run 'Recount all forum totals and statistics.'
thanks
how how how I need to know how!
Work perfect on my test site WOW man thx alot <3 you!!
it always drop the user admin permissions to member but it only do that to the admin user, i have other user whit admin privilege and work fine, just go to members permission and make the user admin, administrator again. i dint get the error you mention but is a test site whit dummy data maybe i will get that errors on the working site.
I recommend you go through and just run all the maintenance stuff in the admin panel, as this will fix errors etc :)
ok the script made me just a member and not an admin, how do I make myself admin again?
Make another account admin before running the scrip. the script always make the "admin" user a regular member but if you got another account whit admin privilege work fine. after running the scrip log whit the other user and make the "admin" user administrator again via smf members control panel.
If you have access to your database, you need to set your user level to 1 instead of 0
k thanks hawker, I changed my privilages through the database.
Can someome list some simple yet detailed instructions on how to utilize this script? I am using Joomla obviously and will also be using the JoomlaHacks SMF Bridge. Your help is appreciated.
Thanks,
James
Quote from: clanspot on July 30, 2007, 02:00:46 PM
Can someome list some simple yet detailed instructions on how to utilize this script? I am using Joomla obviously and will also be using the JoomlaHacks SMF Bridge. Your help is appreciated.
Thanks,
James
Hi clanspot,
I had the same question as you, but I have managed to migrate succesfully to SMF from fireboard and joomla.
The steps that I had followed:
1) Install SMF to your web server
2) download the file fireboard_converter-HawkeR.zip
3) extract this file localy to your pc. upload the 2 files that you will find in the extracted directory " fireboard_converter-HawkeR " to your SMF directory :
- convert.php
- fireboard_to_smf.sql
4) at your webserver's SM directory, open the " Settings.php " file. In there, you will find the user name and the password for the database access :
example :
########## Database Info ##########
$db_server = *************
$db_name = *************
$db_user = 'web_smf';
$db_passwd = 'rfGassdfdGFG';
$db_prefix = *************
$db_persist = 0;
$db_error_send = 1;
5) copy the db_user db_passwd values to a local text file to your pc.
6) Go to the sql admin. Add db_user value to the databases of your SMS and Joomla installation.
7) Go to www.(yourwebaddress)/(smf_installation)/convert.php
8 ) declare the joomla directory at first level (no need to point to the components to reach to the fireboard
9) input your smf web server path
10) input (better copy paste from the local file to be sure) the db_passwd value
You are finished. For me, this steps worked very nice and smooth. Thanks everybody and especially hawker for the scripts modifications.
Good luck to your migration efforts.
hi,
not konvert czech char :( ěščřž. pls help
what fix? viz log?
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting topic notifications... Successful.
Converting moderators... Successful.
Clearing unused tables... Successful.
Converting attachments...
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/images/1012101_LRG.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/images/wmc001.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/images/post_173_1180382073.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/files/media_center_1.zip) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/images/44486v.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/files/DECCHECKSetup.zip) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/files/videoinspector.zip) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/images/imgres.htm) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/files/images.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/files/Ram_Graf_v1_91.zip) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/images/8600gts.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/images/D965S14.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/files/NeroDriveSpeed_300.zip) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/images/uzivatele.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/images/J7F4K1G5D.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/images/spectra.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/images/LE37M87BD.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/images/spectrabb.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/images/lc16m_v1.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/images/karma.gif) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/images/basso.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/images/leadtek_8500gt_lp2.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/images/mpiso_front.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/images/kubuntulogo2.png) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Warning: copy(/home/ftpsite/mach4.cz/www//components/com_fireboard/uploaded/images/mythtv_logo.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 4
Successful.
Converting avatars...
Parse error: syntax error, unexpected '"' in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 6
Parse error: syntax error, unexpected '"' in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 6
Parse error: syntax error, unexpected '"' in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 6
Parse error: syntax error, unexpected '"' in C:\wamp\www\forum\convert.php(827) : eval()'d code on line 6
Successful.
Recalculating forum statistics... Unsuccessful!
This query:
ALTER TABLE `joomla`.smf_smileys
ORDER BY LENGTH(code) DESC;
Caused the error:
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 'LENGTH(code) DESC' at line 2
why script paragraph of all benefits řčů ... me be in our language need (czech)
pardoning behind my bad English
Thanks so much Vostri I am going to try it out when I get home. Would you happen to have MSN Messenger so that if I need help you could possible assist me? I am not too familiar with SQL DB and I would hate to lose what information I have. A backup is going to happen but I would rather it be a one shot try thing.
If so, my MSN Messenger is:
[email protected]Thanks,
James
I am not a coder, but I am pretty good at following directions. Here was the error I just got. Suggestions?
Converting categories... Unsuccessful!
This query:
INSERT INTO `the***_***latest`.smf_categories
(ID_CAT, name, catOrder)
VALUES ('501', 'Board Business', '1'),
('502', 'Welcome to The ***********Center Community ', '2'),
('503', 'Chit Chat', '3'),
('505', 'Natural Pregnancy and Birth', '4'),
('506', 'Natural Parenting', '5'),
('509', 'Natural Living', '6'),
('507', 'Ages and Stages', '7'),
('508', 'Others Like You', '8'),
('504', 'Classifieds', '9');
Caused the error:
Duplicate entry '255' for key 1
This worked brilliantly on my test server. I wonder if a full test will work as well. Leave it to me to find out eeh? Thank you once again for your support and response to
Hi !
I try convert FB to SM with this script but during the process I've somtehing like this:
Converting...
Converting members... Unsuccessful!
This query:
INSERT INTO `skarzysk_sko`.smf_members
(ID_MEMBER, memberName, realName, signature, posts, karmaGood, passwd, emailAddress, location, is_activated, dateRegistered, lastLogin, hideEmail, ID_GROUP, lngfile, buddy_list, pm_ignore_list, messageLabels, personalText, websiteTitle, websiteUrl, ICQ, AIM, YIM, MSN, timeFormat, avatar, usertitle, memberIP, secretQuestion, secretAnswer, validation_code, additionalGroups, smileySet, passwordSalt, memberIP2)
VALUES
('62', 'admin', 'admin', '', '233', '18', '2198534f6a6ff14f786f246c9a8d1ef5', 'mail adres', 'Polska', '1', '1172438493', '1187256823', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('62', 'admin', 'admin', '', '233', '18', '2198534f6a6ff14f786f246c9a8d1ef5', 'mail adres', 'Polska', '1', '1172438493', '1187256823', '1', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('62', 'admin', 'admin', '', '233', '18', '2198534f6a6ff14f786f246c9a8d1ef5', 'mail adres', '', '1', '1172438493', '1187256823', '1', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
...
Powtórzone wyst?pienie '62' dla klucza 1
I've no idea, how could I change admin ID. I should delete my admin on FB or something?
Rgds from Wroclaw,
K
does this converter works with fireboard 1.0.3 too?
i've got this error... why?
Warning: Unknown: failed to open stream: Permission denied in Unknown on line 0
Warning: Unknown: Failed opening '/home/httpd/vhosts/XXXXXXXXXX/subdomains/provaforum/httpdocs/smf/convert.php' for inclusion (include_path='.:/usr/share/pear') in Unknown on line 0
Quote from: ikki_83 on September 30, 2007, 09:01:23 PM
i've got this error... why?
Warning: Unknown: failed to open stream: Permission denied in Unknown on line 0
Warning: Unknown: Failed opening '/home/httpd/vhosts/XXXXXXXXXX/subdomains/provaforum/httpdocs/smf/convert.php' for inclusion (include_path='.:/usr/share/pear') in Unknown on line 0
Looks like a permission issue. Chmod convert.php to 777 (or 755 in some hosts).
How do I chmod? / what is chmod? (http://docs.simplemachines.org/index.php?topic=477)
ok now it works, but i can't access with my admin password... why?
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
Hmm, I swear I have posted something like this
Using phpMyAdmin (What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0))
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 :P
Quote from: hawker on July 09, 2007, 10:37:40 PM
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
Ok added this to the list of converters to update. A question. Is fireboard standalone or I need to install Joomla to use it?
You must install Joomla because Fireboard is only component. FB is not standalone. ;)
Quote from: eLeS on October 23, 2007, 05:42:42 PM
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?
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?
Quote from: Cubjo on October 14, 2007, 07:43:54 AM
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.
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.
Quote from: SleePy on October 14, 2007, 08:08:44 PM
Hmm, I swear I have posted something like this
Using phpMyAdmin (What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0))
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 :P
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
So what is it doing Janan? Is it giving you any errors? Can we have a link and test it out as well?
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!
Quote from: opfa on December 16, 2007, 12:03:25 PM
((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.
QuoteThe 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?
Make sure that the config file for fireboard is readable.
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.
=)
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?
Quote from: lcx on February 04, 2008, 04:58:56 PM
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.
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 (http://test.vwclub.ro/smf/index.php?topic=2794.msg2865#new)
and this is the original
http://test.vwclub.ro/index.php/Help-/-FAQ-/-Sugestii/2865-ReCum-fac-upload-la-poze.html#2865 (http://test.vwclub.ro/index.php/Help-/-FAQ-/-Sugestii/2865-ReCum-fac-upload-la-poze.html#2865)
I modified the converter so that Fireboard images like [ img size=480] will be replaced with simple [ img]
Also the [ youtube]...[ /youtube] will be replaced in a way that SMF MOD "AUTO EMBED VIDEO CLIPS" will be able to embed the videos.
Oh yes, and the " now appear without a slash :)
Now I just have to see if I can fix my UTF issue and do some tests and I will post the modified converter.
Oh that would be great. Fireboard is pretty much just a piece of poorly written, badly copied board crap code :)
Unfortunately it looked good in the first place so I already have a community built up with it.
I'd be willing to test the converter and maybe add some of my limited "wisdom" :D
Here is my modified converter. The only thing it would need would be some regex to remove "[ img]...[ /img]" so that the huge images won't be showed. You can rebuild the thumbs with fix_attachment_thumb.php which was posted somewhere here on the forum.
Hi !
I have that error message at the begin :
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.
P.S. : The CMOD of Config folder and config file of FSB are 777
open_basedir has nothing to do with permissions.
For example, your simpleboard/fireboard is installed here:
/var/www/sites/joomla/
and your SMF here:
/var/www/sites/smf/
now if your open_basedir allows your PHP skript only to work in /var/www/sites/smf/ then it will forbid an access to /var/www/sites/joomla/
To solve this, either deactivate open_basedir or put your smf installation within the same path as your joomla installation so that open_basedir restrictions won't forbid an access.
Ok
Could you tell me how deactivate open_basedir ???
I have access to the server in plesk mode so tell me what to do please !
Sorry, I don't know plesk and this sure is nothing that is related to the converter.
Check out: http://php.net/manual/en/features.safe-mode.php#ini.open-basedir perhaps this can help you if not, try this: http://www.google.com/search?hl=en&client=safari&rls=en-us&sa=X&oi=spell&resnum=0&ct=result&cd=1&q=plesk+turn+off+safe+mode&spell=1
were you successful in disabling open-basedir?
What's the deal with this changing of values from 0 to 1 thing? I can get into phpmyadmin and look at/change the default values. ID_GROUPS was set to 0, i changed it to 1 and i'm still not getting admin access on my admin accounts. I made a new admin account before converting the forums and it's still shown as a regular user.
Can I get the exact DB files i need to edit with their entries please?
Thanks.
update smf_members set ID_GROUP=1 where memberName='YOUR USERNAME HERE';
There are no files to edit, just this sql statement. This has to be done after the conversion and you have to change the value for your user and not the default value! If you change the default value then every new user will be admin! Don't really think you want that ;)
yes! thank you very much, that worked out great. :)
thanks to everyone in this thread for making this happen. joomla/fireboard were pissing me off to no end.
Quote from: lcx on February 05, 2008, 04:10:37 AM
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 :)
Hello lcx, have you managed to fix the conversion to UTF-8?
From what I understand, the easiest way would be to convert the Joomla/Fireboard database to UTF-8 and then retry the conversion to SMF. When two databases are in the same character set (UTF-8 in this case), no character encoding problems should occur.
It is a bit strange. What I did was to ignore all the UTF stuff, just do the import without any UTF8 and don't convert the SMF database to utf8 ... and everything works.
Quote from: lcx on March 03, 2008, 03:53:54 AM
It is a bit strange. What I did was to ignore all the UTF stuff, just do the import without any UTF8 and don't convert the SMF database to utf8 ... and everything works.
That's not strange at all. As I said, have to be in the same character set and everything should work OK.
But if the original database was, in fact, using UTF-8, exporting it as latin1 would mess things up. It looks like it wasn't in your case, so enjoy! :)
finally I did the convert on the real site. Unfortunately some things did go wrong. For some reason the attached images where not attached on SMF! I still have the [img] link inside the post so I could live with that, the problem is that I have no thumbnails, which I would have if the image would have been attached. Anyone knows how I could fix this?
I'm thinking of implementing a thickbox integration, which I used on Fireboard also.
Trying to run the converter, but keep getting the following error message;
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Simpleboard 1.0 and 1.1. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.
The error MySQL gave was: SELECT command denied to user 'web49-testforum'@'localhost' for table 'jos_users'
Bit of a noob at this sort of thing :-[
did you create a new user for the SMF forum? It might be that you need to give the new user access to the Joomla database.
If you intend in using smf + smf_bridge from joomlahacks then you must install SMF in the same database as Joomla!
Quote from: lcx on March 05, 2008, 07:42:52 AM
did you create a new user for the SMF forum? It might be that you need to give the new user access to the Joomla database.
If you intend in using smf + smf_bridge from joomlahacks then you must install SMF in the same database as Joomla!
Apologies if being stupid here :)
Do you mean a user when I installed the SMF forum? IF so, I did but don't know how to give any access rights.
OR
Do you mean creating a stand alone MySQL user? Ain't done that either :o
I don't intend to use a bridge, well not anytime soon anyway as SMF looks like it has everything I would need :)
I mean a mysql user.
If you can, just login to mysql with your user and password you use for SMF and try if you can execute the SQL statement it mentioned in the error.
Not entirely sure what you mean, there is no specific details of the command it failed on. It is a select command but there are no specifics or arguments
shure there is! This says everything you need to know!
SELECT command denied to user 'web49-testforum'@'localhost' for table 'jos_users'
mysql localhost -u web49-testforum -p
select * from jos_users;
Quote from: lcx on March 05, 2008, 11:02:14 AM
shure there is! This says everything you need to know!
SELECT command denied to user 'web49-testforum'@'localhost' for table 'jos_users'
mysql localhost -u web49-testforum -p
select * from jos_users;
First, you have to select the database before running SELECT on tables. For example, if the Joomla! database is named joom, you have to go in this order:
mysql localhost -u web49-testforum -p
use joom;
select * from jos_users;
I assume your SMF install is on a separate, different database? Do you have some sort of control panel? You need to assign web49-testforum to the Joomla! database, as well as the SMF database. cPanel, for example, allows you to do this.
The MySQL user needs access to both databases:
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Okay, installed a seperate joomla and put a backup from the main site in there. Then installed SMF into the same directory and on the same database. conversion worked with a couple of minor errors.
My control panel is running really slow so trying to fix now.
Thanks for the help and fast responses so far, much appreciated :)
Okay, I don't actually have Fireboard on any site, since my Joomla site crashed out and I transferred over to Drupal. I do, however, still have the database files, and I currently have both the jos_fb tables in the same db as the smf ones, so that I can just run the SQL queries. I tried opening the fireboard_to_smf.sql and running each query in phpmyadmin, but immediately I get an error:
#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 '{$to_prefix}members' at line 1 . I thought it might have been that my jos_fb was in latin, so I converted it to utf8 and it still did the same error. Can someone please help? My site is in serious trouble and I just want to get my forums back up and running.
you can't run the query directly, as you can see: {$to_prefix}members, $to_prefix is a variable! you have to replace this by your joomla prefix I guess.
that's what I was thinking, because I didn't recognize that. So you think it will work if I replace that code with the jos_fb_ prefix?
Okay, disregard, apparently it isn't that simple. That .sql file was clearly meant to be used in conjunction with the covert.php. Come to think of it, I do have all the joomla files stored on my server. Maybe I can find the path and try the converter.
I gave the right path to joomla and to smf and got another error:
The error MySQL gave was: Table 'fatalfit_drupal.jos_users' doesn't exist
I have no idea why it's trying to put the db name with the table
Update: it was because there was one missing "fb_" before a "users" and after that it quit giving me that issue. Only thing is that I need to figure out where the file is to edit the config for fireboard so it points to the correct database.
I had to install Joomla again, with fireboard, repopulate the jos_fb tables with my data, so that I could use this converter. I put BOTH FB and SMF into the same database with the same username and the same password, so there would be no room for error. But this is what came up:
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Simpleboard 1.0 and 1.1. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.
The error MySQL gave was: Incorrect database name ''
[SMF Converter] Fireboard 1.0.x (http://www.simplemachines.org/community/index.php?topic=228775.0)