SMF -> Joomlaboard conversion

Discuss the integration of SMF here.
nevamore
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Fri Jul 21, 2006 2:31 pm

Re: SMF -> Joomlaboard conversion

Post by nevamore » Fri Mar 09, 2007 3:54 pm

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?

 
User avatar
fungkur
Joomla! Apprentice
Joomla! Apprentice
Posts: 32
Joined: Wed Jan 11, 2006 4:28 pm
Location: Germany
Contact:

Re: SMF -> Joomlaboard conversion

Post by fungkur » Tue Jun 12, 2007 1:15 am

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

cruisinflatout
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Mon Oct 02, 2006 3:19 pm
Location: Regina, SK, Canada
Contact:

Re: SMF -> Joomlaboard conversion

Post by cruisinflatout » Tue Jun 12, 2007 1:51 am

nevamore 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?
Yes
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
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)

That might not make much sense - but that's what's happening.

Regards;

Kevin

kenya
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Sat Apr 21, 2007 12:19 am

Re: SMF -> Joomlaboard conversion

Post by kenya » Tue Jul 10, 2007 8:41 pm

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)}

neimles
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Thu Aug 16, 2007 11:25 pm

Re: SMF -> Joomlaboard conversion

Post by neimles » Thu Aug 16, 2007 11:28 pm

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?
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.
can anyone help me? i get the same error, but without the number 96202. can anyone explain a little bit better what to do?

thanks in advance.....

User avatar
Oldiesmann
Joomla! Apprentice
Joomla! Apprentice
Posts: 14
Joined: Sun Sep 04, 2005 12:03 am
Location: Cincinnati, Ohio
Contact:

Re: SMF -> Joomlaboard conversion

Post by Oldiesmann » Fri Aug 17, 2007 4:10 pm

According to http://www.free-translation.com:
NONEXISTENT CATEGORIE IN THE BASIS MAMBO!!!
In other words, the category doesn't exist in the database.
The Oldiesmann
SMF Project Manager
SMF+Gallery2 - also works with Joomla! (Beta 3.1 now avaliable!)

shinbushi
Joomla! Apprentice
Joomla! Apprentice
Posts: 18
Joined: Thu Sep 29, 2005 4:34 pm

[SOLVED] Re: SMF -> Joomlaboard conversion

Post by shinbushi » Fri Aug 31, 2007 11:54 pm

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

Code: Select all

Populating Categories...

Invalid query:
TRUNCATE TABLE jos_fb_categories
Table 'taijutsu_joom1.jos_fb_categories' doesn't exist
Any ideas?  ???

NEVERMIND I used wrong file
Last edited by shinbushi on Fri Aug 31, 2007 11:59 pm, edited 1 time in total.

thebitsguy
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Sat Aug 25, 2007 4:38 pm

Re: SMF -> Joomlaboard conversion

Post by thebitsguy » Sun Sep 30, 2007 10:55 am

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

flavius
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Sat Aug 26, 2006 10:51 pm

Re: SMF -> Joomlaboard conversion

Post by flavius » Sun Dec 09, 2007 2:13 pm

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)}
I am having the same problem. How can I fix this ?

derinliktutkunu
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Mon Oct 23, 2006 12:41 am

Re: SMF -> Joomlaboard conversion

Post by derinliktutkunu » Thu Feb 07, 2008 4:35 pm

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

cruisinflatout
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Mon Oct 02, 2006 3:19 pm
Location: Regina, SK, Canada
Contact:

Re: SMF -> Joomlaboard conversion

Post by cruisinflatout » Thu Feb 07, 2008 9:06 pm

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

Your connection details go into mysql.php.  There are only 2 files total.

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.

derinliktutkunu
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Mon Oct 23, 2006 12:41 am

Re: SMF -> Joomlaboard conversion

Post by derinliktutkunu » Thu Feb 07, 2008 11:53 pm

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

derinliktutkunu
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Mon Oct 23, 2006 12:41 am

Re: SMF -> Joomlaboard conversion

Post by derinliktutkunu » Fri Feb 08, 2008 2:48 am

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?
Last edited by derinliktutkunu on Fri Feb 08, 2008 3:04 am, edited 1 time in total.

 

Locked

Return to “SMF - Simplemachines.org Forum”