MyBB Community Forums

Hi,

I did a convert a while ago, but i just discovered this problem now.

When I click on the "Sent items" link in PM I get this error:

MyBB has experienced an internal SQL error and cannot continue.

SQL 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 'ildikó,Koyuki,apolika,pillangó)' at line 1
Query:
SELECT uid, username, usergroup, displaygroup FROM mybb_users WHERE uid IN (mikikol10,jolanda11,retek,ForgetMeNot,Tarawels,Nerina,nothenx,Moniqe,ziziliba,s ​erious,Gabor,vattacuki,radikál,Frida,ocsi,botka ildikó,Koyuki,apolika,pillangó)

Please contact the MyBB Group for support.

A friend of mine experienced the same problem.

Hi.

I also had the same problem merging myBB 1.4.4 databases.
Apparently the converter recorded wrong values to recipients field of the privatemessages table.
like this:

a:1:{s:2:"to";a:1:{i:0;s:12:"Paul Gilbert";}}

I have no idea how to fix that.

It's because of the weird o(o`) in the title, or whatever that is - I'm guessing..

Sorry. I don`t understand.

take a look:

before merging...in recipients table field source:

a:1:{s:2:"to";a:1:{i:0;s:12:"14";}}

after mergin...in the destination

a:1:{s:2:"to";a:1:{i:0;s:12:"Paul Gilbert";}}

This bug has been fixed in the latest version of the MyBB Merge System.

Please note the latest code is not live on the site or for download. An update for the MyBB Merge System will be released which contains this fix.

With regards,
The MyBB Group