2008-10-30, 06:34 PM
I seem to be having a problem with the merge system. I'm currently in the processing of moving a mixture of boards including SMF & punBB over to myBB, things are going spendidly on SMF and I'm about 75% complete on my second 400K post board conversion.
However some problems have cropped up on the merge from the punbb board.
From what I can make out it seems to be an issue with quotes (or apostrophes) in peoples usernames
Everything goes swimmingly until I get through to the convert threads section
Then I get the following error
My guess is it's barfing on the ' in Patches username. Strangely enough if it's an issue with the quotes in usernames nothing popped up during the username conversion.
I've had a quick look through the punbb convert code but nothing jumps out at me as to where the problem is, and only being new to the code it'll probably be quicker to bring it up here.
If someone can point me in the right direction I can have a look myself.
thanks,
Dan.
However some problems have cropped up on the merge from the punbb board.
From what I can make out it seems to be an issue with quotes (or apostrophes) in peoples usernames
Everything goes swimmingly until I get through to the convert threads section
Then I get the following error
Quote:Inserting thread #58... MySQLi error: 1064
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 'Houlihan' LIMIT 1' at line 1
Query: SELECT id, username FROM forums_users WHERE username = 'Patches O'Houlihan' LIMIT 1
My guess is it's barfing on the ' in Patches username. Strangely enough if it's an issue with the quotes in usernames nothing popped up during the username conversion.
I've had a quick look through the punbb convert code but nothing jumps out at me as to where the problem is, and only being new to the code it'll probably be quicker to bring it up here.
If someone can point me in the right direction I can have a look myself.
thanks,
Dan.