Conversion: phpbb -> minibb

whats about UTF8 vs. latin-1 and quotings, bb-tags? post texts from phpbb looks like

[quote:0f2956d3e8="MReith"]Hello...

and your script do not convert this stuff. output is not really usable :/

yep, this is just a quick-and-dirty data migration. feel free to post patches/additions ;)

post texts from phpbb looks like
Huh? phpbb stores bb code in its native format and converts it everytime on the fly?

I instaled miniBB and I converted database from phpBB.
All is ok, but when someone trying sign up script show announcement "Unable to sign up new user. Possibly username or email already taken, or admininistrator info isn\'t filled, yet."
I know that username or email isn't exist.

Be sure you have user with ID=1. It should be administrator's account.

o yes in phpBB was ID=2 I don't know why. It's ok thanks.

how do you use this script please?

Anonymous
You need to run these commands in SQL command window in your mySQL manager (phpMyAdmin or whatever). But if you even don't know about it, it's better even not to try to convert it... will be too difficult for you.

I tried to modify this script for converting phpbb 2.x to miniBB 1.7 but I got always SQL errors while the command 'update'.

#1064 - You have an error in your SQL syntax near ' minibb_users set minibb_topics.topic_poster_name =
minibb_users.username where' at line 2

Anyone an idea?

Has nobody an idea about my problem here listed in previous post?

What is exact request you are trying to execute, when you get this error?

# get poster name
update minibb_topics, minibb_users set minibb_topics.topic_poster_name =
minibb_users.username where minibb_topics.topic_poster =
minibb_users.user_id;

I copied this code to the phpMyAdmin SQL query field.

Which mySQL version do you have? This might not work in mySQL 3.x.

Yes, it is a mySQL 3.x database.

Unfortunatelly, this will not work in mySQL 3.x. I would recommend to create this convertion locally on mySQL 4.x then do a backup/restore to mySQL 3.x