MyBB Community Forums
[Duplicate] MyBB Merge delete UFID - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Development (https://community.mybb.com/forum-161.html)
+--- Forum: MyBB 1.8 Development (https://community.mybb.com/forum-165.html)
+---- Forum: 1.8 Bugs and Issues (https://community.mybb.com/forum-157.html)
+----- Forum: Rejected (https://community.mybb.com/forum-184.html)
+----- Thread: [Duplicate] MyBB Merge delete UFID (/thread-185294.html)



MyBB Merge delete UFID - ashkir - 2015-10-19

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?


RE: MyBB Merge delete UFID - Destroy666 - 2015-10-19

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/feature/admin/modules/user/users.php#L2073

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

So marking as duplicate.