MyBB Community Forums

Full Version: MyBB Merge delete UFID
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
As shown in this support thread:

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
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:

Connected issues:

So marking as duplicate.