Question SMF to Kunea

Which versions of Joomla, Fireboard and SMF is this for?

I have tried smf2fb but I get the following message:

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'' at line 1.

What's that? How do I get it to work?

Upgrade your SQL. Looks like it's old. Beyond that can't help. This isn't a Kunena provided solution. Be prepared though. You will be losing a lot of functionality.

I've had a quick look at the code provided by fred2. It looks as though it will populate Kunena tables with SMF data. Although they're referred to as "Fireboard", the resultant, converted tables look as though they're Kunena in all but name.

There are a few missing steps in the procedure:

1. The SMF tables must be stored in the same database as the Joomla and Kunena tables.
2. You have to install Kunena
3. You need to edit the file mysql.php and change the following lines as indicated:
   Code:

   { if( false == mysql_connect("localhost", "user", "password") ) // FILL with your connections details ie location is usually localhost etc. die("Error"); if( false == mysql_select_db("database_name") ) // FILL with your database name die("Error."); }

After doing these things, you're then in a position to run the file called "index.php". After running the preliminary conversion you can then run the SQL query referred to in message #7539 .

This procedure may not necessarily overcome the problem that gjhvs cites in message #16454 but, at least, it puts the process into some more understandable context - e.g. I suspect that gjhvs did not edit the file mysql.php. It's also just as likely, as GM wrote, that the gjhvs' problem involves some vagary of the MySQL version that's being used.

fred2 wrote:

Hi.!

I used smf2fb and for me worked perfectly. Only users not imported, but you can import before. I just imported 40k posts and no problem.

You must do some stetic cleanups in text of database, example remove and replace all <br /> for \r\n and things like that. If you have a few experience edditing db text you will do without any problem.

I hope this will help somebody, here is the small script.

Fred

File Attachment:

File Name: smf2fb.zip
File Size:3.9 KB

Can you explain to me how I import users? Have the same problem. The messages/posts are done but there are no users after the conversion.