SMF -> Joomlaboard conversion
-
- Joomla! Apprentice
- Posts: 8
- Joined: Fri Jul 21, 2006 2:31 pm
Re: SMF -> Joomlaboard conversion
I'm also looking into converting an existing, JoomlaHacks bridged SMF install to JoomlaBoard. We only have '3386 Posts in 789 Topics by 48 Members' and some of those might be manually weeded out before the conversion just to make it as smooth as possile.
My question is: How does the converter handle the child boards that we use SMF? Does it just break the child link and make each child board its own board?
My question is: How does the converter handle the child boards that we use SMF? Does it just break the child link and make each child board its own board?
- fungkur
- Joomla! Apprentice
- Posts: 32
- Joined: Wed Jan 11, 2006 4:28 pm
- Location: Germany
- Contact:
Re: SMF -> Joomlaboard conversion
what kind of error is this and how to get it right?
Populating Categories...
OK...categories and boards imported successfully!
Populating Users Table...
, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
Total users 739, Inserted 739 of the users...
(NOTE: If inserted is less than actual, it is due to the user having made a post but has since deleted their account. The post will still show up as usual though...)
User import into JoomlaBoard successful!!
Populating 4268 messages into JoomlaBoard.
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 's Room'' at line 1
Populating Categories...
OK...categories and boards imported successfully!
Populating Users Table...
, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
Total users 739, Inserted 739 of the users...
(NOTE: If inserted is less than actual, it is due to the user having made a post but has since deleted their account. The post will still show up as usual though...)
User import into JoomlaBoard successful!!
Populating 4268 messages into JoomlaBoard.
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 's Room'' at line 1
-
- Joomla! Apprentice
- Posts: 19
- Joined: Mon Oct 02, 2006 3:19 pm
- Location: Regina, SK, Canada
- Contact:
Re: SMF -> Joomlaboard conversion
Yesnevamore wrote: I'm also looking into converting an existing, JoomlaHacks bridged SMF install to JoomlaBoard. We only have '3386 Posts in 789 Topics by 48 Members' and some of those might be manually weeded out before the conversion just to make it as smooth as possile.
My question is: How does the converter handle the child boards that we use SMF? Does it just break the child link and make each child board its own board?
The text of one of the posts within your SMF forum has an "'" (apostrophe) that is screwing up the SQL...you have to ensure that all posts all properly demilimited - that is - "\'" (The backslash tells the parser to ignore the usual meaning of the apostrophe)fungkur wrote: what kind of error is this and how to get it right?
Populating Categories...
OK...categories and boards imported successfully!
Populating Users Table...
, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
Total users 739, Inserted 739 of the users...
(NOTE: If inserted is less than actual, it is due to the user having made a post but has since deleted their account. The post will still show up as usual though...)
User import into JoomlaBoard successful!!
Populating 4268 messages into JoomlaBoard.
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 's Room'' at line 1
That might not make much sense - but that's what's happening.
Regards;
Kevin
-
- Joomla! Apprentice
- Posts: 11
- Joined: Sat Apr 21, 2007 12:19 am
Re: SMF -> Joomlaboard conversion
how do you ensure that all posts all properly demilimited?
{ - that is - "\'" (The backslash tells the parser to ignore the usual meaning of the apostrophe)}
{ - that is - "\'" (The backslash tells the parser to ignore the usual meaning of the apostrophe)}
-
- Joomla! Fledgling
- Posts: 1
- Joined: Thu Aug 16, 2007 11:25 pm
Re: SMF -> Joomlaboard conversion
radianation wrote: I'm getting this error message:
96202CATEGORIE INEXISTANTE DANS LA BASE MAMBO!!!
I have no idea what it's trying to tell me?
can anyone help me? i get the same error, but without the number 96202. can anyone explain a little bit better what to do?radianation wrote: I seem to recall seeing this about 6 months ago when I first looked into the conversion, but I didn't see it anywhere when I looked this time. So I need to recreate the forum categories by hand in Joomlaboard and then make the conversion. Got it. I'll give it a shot.
thanks in advance.....
- Oldiesmann
- Joomla! Apprentice
- Posts: 14
- Joined: Sun Sep 04, 2005 12:03 am
- Location: Cincinnati, Ohio
- Contact:
Re: SMF -> Joomlaboard conversion
According to http://www.free-translation.com:
In other words, the category doesn't exist in the database.NONEXISTENT CATEGORIE IN THE BASIS MAMBO!!!
-
- Joomla! Apprentice
- Posts: 18
- Joined: Thu Sep 29, 2005 4:34 pm
[SOLVED] Re: SMF -> Joomlaboard conversion
I Installed Joomlaboard (smf and joomla same database)installed fine
Fixed mysql.php uploaded it and index2.php to taijutsu.com/forum.
tried to run http://taijutsu.com/forum/index2.php and got the following error
Any ideas?
NEVERMIND I used wrong file
Fixed mysql.php uploaded it and index2.php to taijutsu.com/forum.
tried to run http://taijutsu.com/forum/index2.php and got the following error
Code: Select all
Populating Categories...
Invalid query:
TRUNCATE TABLE jos_fb_categories
Table 'taijutsu_joom1.jos_fb_categories' doesn't exist
NEVERMIND I used wrong file
Last edited by shinbushi on Fri Aug 31, 2007 11:59 pm, edited 1 time in total.
-
- Joomla! Apprentice
- Posts: 8
- Joined: Sat Aug 25, 2007 4:38 pm
Re: SMF -> Joomlaboard conversion
Thank you cruisinflatout for the wonderful script. I have used the script and could successfully migrate from SMF to Joomla Board and then subsequently to FireBoard. There is one observation though in the script.
The script will give unpredictable results if boards in different SMF categories have the same name. For example, if A is a category and B and C are boards in it. If there is another category called D with two boards in it named, E and C, then the script fails to work properly. To work around, just rename the board whose name is same across categories in SMF and then run the script. Once the script is successful, rename the board to old one in Joomla Board.
Thanks again for the very useful script.
Cheers
Vijay
The script will give unpredictable results if boards in different SMF categories have the same name. For example, if A is a category and B and C are boards in it. If there is another category called D with two boards in it named, E and C, then the script fails to work properly. To work around, just rename the board whose name is same across categories in SMF and then run the script. Once the script is successful, rename the board to old one in Joomla Board.
Thanks again for the very useful script.
Cheers
Vijay
-
- Joomla! Apprentice
- Posts: 9
- Joined: Sat Aug 26, 2006 10:51 pm
Re: SMF -> Joomlaboard conversion
I am having the same problem. How can I fix this ?kenya wrote:
how do you ensure that all posts all properly demilimited?
{ - that is - "\'" (The backslash tells the parser to ignore the usual meaning of the apostrophe)}
-
- Joomla! Apprentice
- Posts: 9
- Joined: Mon Oct 23, 2006 12:41 am
Re: SMF -> Joomlaboard conversion
I am rather a noob honestly
I ran into a problem in connect dbb part.
I don't know how do I create a connection file
If I understood correctly in my convert folder there should be 3 files: 1- mysql.php, 2- index.php and 3 - a connection file.
But I don't know which name to give to the connection file. I presume that it is going to be a php.( I think I can fill in the variables correctly)
Can you explain please which name and which format is required?
It would be so nice if someone can recapitulate the whole process and include all the 3 files as attachements.
(The information is scattered and scripts are to be collected in various posts)
Thanks a lot
I ran into a problem in connect dbb part.
I don't know how do I create a connection file
If I understood correctly in my convert folder there should be 3 files: 1- mysql.php, 2- index.php and 3 - a connection file.
But I don't know which name to give to the connection file. I presume that it is going to be a php.( I think I can fill in the variables correctly)
Can you explain please which name and which format is required?
It would be so nice if someone can recapitulate the whole process and include all the 3 files as attachements.
(The information is scattered and scripts are to be collected in various posts)
Thanks a lot
-
- Joomla! Apprentice
- Posts: 19
- Joined: Mon Oct 02, 2006 3:19 pm
- Location: Regina, SK, Canada
- Contact:
Re: SMF -> Joomlaboard conversion
Your connection details go into mysql.php. There are only 2 files total.derinliktutkunu wrote: I am rather a noob honestly
I ran into a problem in connect dbb part.
I don't know how do I create a connection file
If I understood correctly in my convert folder there should be 3 files: 1- mysql.php, 2- index.php and 3 - a connection file.
But I don't know which name to give to the connection file. I presume that it is going to be a php.( I think I can fill in the variables correctly)
Can you explain please which name and which format is required?
It would be so nice if someone can recapitulate the whole process and include all the 3 files as attachements.
(The information is scattered and scripts are to be collected in various posts)
Thanks a lot
I do apologize to those that are running into issues converting. I created this script for my own needs and posted it here for those that could use it.
If you are still running into problems, I would try posting on the Fireboard forums and see if an official script (or better one) is in the works.
-
- Joomla! Apprentice
- Posts: 9
- Joined: Mon Oct 23, 2006 12:41 am
Re: SMF -> Joomlaboard conversion
Thanks cruisinflatout to reply
I still need some help where to insert connection parameters paragraph in mysql.php. I gave a try and did some insertion attempts but I did not manage to find correct line to insert. I got "can not redeclare..." type of warning. Can you put here mysql.php with this db connection string in place?
Never mind if we run or not into issues. I do this on a test installation and you are providing help for the rest of us. In fireboard forum there is no satisfactory converter solution. I tried before their converter. In my case forum categories were converted but not the messages. This was 3 months ago. I gave up after many attempts. So I stick with your solution.
It is so unfortunate that I am not myself a coder but I provide language specific support in groupjive forums to pay back my dept to open source community.
Kindly
I still need some help where to insert connection parameters paragraph in mysql.php. I gave a try and did some insertion attempts but I did not manage to find correct line to insert. I got "can not redeclare..." type of warning. Can you put here mysql.php with this db connection string in place?
Never mind if we run or not into issues. I do this on a test installation and you are providing help for the rest of us. In fireboard forum there is no satisfactory converter solution. I tried before their converter. In my case forum categories were converted but not the messages. This was 3 months ago. I gave up after many attempts. So I stick with your solution.
It is so unfortunate that I am not myself a coder but I provide language specific support in groupjive forums to pay back my dept to open source community.
Kindly
-
- Joomla! Apprentice
- Posts: 9
- Joined: Mon Oct 23, 2006 12:41 am
Re: SMF -> Joomlaboard conversion
So I finally make the mysql script to work. But I get this categories inexistant error too. I created one of the categories manually in joomlaboard and script tells another inexistant category. I dont think we are supposed to manually create the very same categories in joomlaboard side. So what is wrong?
I am using joomla 1.0.13 , SMF 1.1 RC2 and latest joomlaboard-1.1.5.2... Is there a version issue?
You said: "I created one that I've tested on Joomla 1.0.8 and SMF 1.1 RC2" What was your joomlaboard version?
I am using joomla 1.0.13 , SMF 1.1 RC2 and latest joomlaboard-1.1.5.2... Is there a version issue?
You said: "I created one that I've tested on Joomla 1.0.8 and SMF 1.1 RC2" What was your joomlaboard version?
Last edited by derinliktutkunu on Fri Feb 08, 2008 3:04 am, edited 1 time in total.