MyBB Community Forums - Bug Reports

ipb2.2 conversion

Wed, 08 Apr 2009 00:57:07 +0000

I had an issue with the ipb2.php conversion and the names being wrong...

Seemed to stem directly from this function: encode_to_utf8().

I have removed it and the conversion went well. The problems was the usernames were empty when inserting into database. I haven't looked into it further but thought to report this.

Post content lost

Tue, 07 Apr 2009 10:20:41 +0000

I merged from SMF 1.1.7 and some post content was lost in some posts.

punBB 1.2 > myBB 1.2.14 - MySQL error: 1064

Wed, 18 Mar 2009 19:59:41 +0000

i am having this same issue when trying to convert a punbb 1.2 database to mybb 1.2.14. it occurs when configurin/converting the threads and halts with the same 1064 limit 1 error for a user id.

Quote:Inserting thread #1805... MySQL 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 's new online' LIMIT 1' at line 1
Query: SELECT id, username FROM users WHERE username = 'reddit.com: what's new online' LIMIT 1

i am new to sql... so what do i need to query through myphpadmin in order to fix this? if you could give me the steps, that'd be great!

reddit.com: what's new online

thank you in advance!

[punbb] Possible Apostrophe(quote) in username bug

Thu, 30 Oct 2008 18:34:54 +0000

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

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.

(phpbb3) A couple bugs

Thu, 14 Aug 2008 17:34:17 +0000

Okay the first is a fairly normal conversion bug. After the import, all my members appear as offline when they log in. Is there an sql query I could run to switch everyone back to visible? The second one I hadn't even thought of when I did it. The converter uses the password conversion plugin to convert passwords. Now when you upgrade to 1.4, the plugin is no longer compatible. I don't suppose there's a way to deactivate the plugin but make the converted passwords stick. Thanks.

(phpbb3) Last user isnt imported

Mon, 14 Jul 2008 01:44:34 +0000

apparently this was an issue with phpbb2 and it was fixed, but i am having this problem now with phpbb3

(phpbb3) Merge causes the root acount of phpbb to be deleted

Tue, 17 Jun 2008 19:16:27 +0000

^_^ title says it all

(SMF) Quotes and Smilies bug

Tue, 17 Jun 2008 19:15:44 +0000

The quotes and smilies do not display properly after converting to myBB.

(phpBB2) Not all users converted

Sun, 25 May 2008 14:47:48 +0000

phpBB2 to MyBB again. This is my final thread about this but I wanted to keep the issues separate for clarity. Move this to general support if you feel it's more appropriate.

Of my 2000 users there were 20 that did not get converted. There was nothing special about these ones and but they were always not converted after multiple attempts. Their threads were there but the poster was listed as unregistered.

To fix this what I had to do was copy these users into a new table and run the conversion again, but with the same MyBB target database. Dependent tables had to be copied as well. With only 20 users in this phpBB2 table it converted these into my target database and fixed the problem. This shows there was nothing special about these people, they just weren't getting picked up for some reason.

The side effect of this was the threads and posts by these 20 users would still be show them as unregistered. To fix this I ran two update queries to reconnect the threads and posts to the newly added users. Anyone else experiencing unlinked users will find this useful.

UPDATE mybb_threads,mybb_users SET mybb_threads.uid = mybb_users.uid WHERE mybb_threads.uid=0 AND mybb_threads.username=mybb_users.username

UPDATE mybb_posts,mybb_users SET mybb_posts.uid = mybb_users.uid WHERE mybb_posts.uid=0 AND mybb_posts.username=mybb_users.username

(phpBB2) Private messages

Sun, 25 May 2008 14:39:54 +0000

After conversion from phpBB2 to MyBB, both the inbox has sent messages, not received ones. So the inbox and sent box both have sent messages.

This wasn't a big deal for me so I just deleted all the messages, but for some people it might be.

(phpBB2) last poster is guest

Sat, 24 May 2008 10:16:53 +0000

Hi,

Conversion from phpBB 2 to MyBB has been completed. Everything appears to have worked apart from the Guest issue which was brought up back in February. Some last poster usernames were correct but about 90% were guests, this also shows up on the thread listing as well as the last poster.

I'm not sure if the above fix is in the code by now, but how do I correct this on my newly converted MyBB? I tried doing the 'last poster' recount which has now made every single username show up as Guest on the last poster.

(SMF) Conversion problems

Fri, 28 Mar 2008 10:55:29 +0000

Ok, a few more problems I stumbled upon:

1) Thread and post titles turned out to be HTML-encoded - e.g. an < was displayed as < (same for >, &, and "). Either there's some extraneous HTML escaping happening, or SMF stores thread/post subjects as HTML escaped in the db (*boggle*).

2) Single ticks (') were stored as \x03 in the database. Sounds a bit weird to me. Might be SMF is storing it that way internally? (*reboggle*)

I fixed both by editing the db directly.

Otherwise, no problems so far - the conversion script even survived my ISP disconnecting me for a few hours in the middle of the post import, and resumed happily after that. Nice work, thanks a lot :-)