MyBB Community Forums

As shown in this support thread: http://community.mybb.com/thread-185181.html

When trying to merge two accounts the source account will not be deleted and a SQL error is produced

MyBB SQL 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 MariaDB server version for the right syntax to use near ')' at line 1
Query:
DELETE FROM mybb_userfields WHERE ufid IN()

It appears the ufid column doesn't exist?

ufid column does exist, but no values are provided for DELETE. That might happen if you merge a super admin into another account: https://github.com/mybb/mybb/blob/featur....php#L2073

Connected issues:
https://github.com/mybb/mybb/pull/2247
https://github.com/mybb/mybb/pull/2201#i...-141454619

So marking as duplicate.

ashkir

Destroy666