I got this problem too, except mine says

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

Problem with apostrophes?

the script is not mine my friend . I would not know where to start. My installation is 1.0.12

Oh, that's great. Provide a converter without ANY type of support.

We still need an OFFICIAL converter that WORKS. Any response from the FB team please???

My install on SMF is version 1.1RC3...do I need to upgrade my SMF before converting and, even if I convert, will I still have those timeout issues as with the other converters?

I also have this error :

Invalid query:
INSERT INTO `jos_fb_users` (userid, posts, signature) VALUES ('153', '395', 'FirstName LastName
Co & Co

Listen to the music, not the room ! (D'antonio)'
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 'antonio)'' at line 1

the aphostrope is in signature of my member...... I think script look it as a syntax

How to fix this?

I had tested your solution.

I did not have many messages in my Simple machine forum, but only 4 messages are being imported into Fireboard.

Sub-forums are imported like a forums (the relationship was not respected).

Méjean

I was able to successfully import my users from my SMF into my Joomla/FB tables. And they are able to login, though they have to do a password recovery because the passwords didn't import correctly.

I could write up a tutorial and zip the files together if anyone is interested. It's not fancy, and it consists of 4 separate import scripts. But it's fairly straight forward.

As for the forums, I followed the sticky topic above and it seemed to work okay. Though it's not my final import, when I'm ready I'll close my SMF, do an export, then use that for the final import.

It seems that this script would work great if someone could fix the problem with apostrophes. Someone please help!

I'm getting the same error... it must be a bit more complicated however than just apostrophe's. Wish I knew anything about this stuff to debug.

I managed to convert the database, messages and boards are fine. But it didn't convert users and attachments.

"Total users 4162, Inserted 1 of the users..."
"Populating 89832 messages into FireBoard.
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 'shalloweencostumes'' at line 1"

If there a converter that converts attachments?

Hey guys, I got my forum to work finally, but it takes a little work. But definietly use this converter and not the other ones.

When you encounter an error, copy and paste the part which is causing the error for example:

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 'error here'' at line 1"

Then go into your MySQL admin and go to the smf_messages table. Do a search by clicking on the search tab.

Enter your error-causing text into either the posterName, posterEmail, body, or subject fields, and select %LIKE...% as the search operator, then do the search. The messages which is causing your error should show up. Edit it, or delete it all together if you don't mind losing it.

Then empty your fb_messages and fb_messages_text tables and try the script again. If you get another error, repeat the process.