[F] Can't delete user

[kvikkjokk]

mybb1.4.2 and PostgreSQL. When trying to delete a user I get:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
0 - ERROR: update or delete on table "mybb_users" violates foreign key constraint "mybb_userfields_ufid_fkey" on table "mybb_userfields" DETAIL: Key (uid)=(3) is still referenced from table "mybb_userfields".
Query:
DELETE FROM mybb_users WHERE uid='3'

Any ideas ?

Thanks

[Mr Skull]

Table not installed correctly?

[kvikkjokk]

(10-17-2008 02:53 PM)mcgroove Wrote:  Table not installed correctly?

How to check ?

[labrocca]

Looks like a possble postgre/mybb bug. I don't know any postgre to help you further.

[Dennis Tsang]

In admin/modules/user/users.php, find:

PHP Code:

$db->delete_query("users", "uid='{$user['uid']}'");
                $db->delete_query("userfields", "ufid='{$user['uid']}'");
                $db->delete_query("privatemessages", "uid='{$user['uid']}'");
                $db->delete_query("events", "uid='{$user['uid']}'");
                $db->delete_query("moderators", "uid='{$user['uid']}'");
                $db->delete_query("forumsubscriptions", "uid='{$user['uid']}'");
                $db->delete_query("threadsubscriptions", "uid='{$user['uid']}'");
                $db->delete_query("sessions", "uid='{$user['uid']}'");
                $db->delete_query("banned", "uid='{$user['uid']}'");
                $db->delete_query("threadratings", "uid='{$user['uid']}'"); 


Replace with:

PHP Code:

$db->delete_query("userfields", "ufid='{$user['uid']}'");
                $db->delete_query("privatemessages", "uid='{$user['uid']}'");
                $db->delete_query("events", "uid='{$user['uid']}'");
                $db->delete_query("moderators", "uid='{$user['uid']}'");
                $db->delete_query("forumsubscriptions", "uid='{$user['uid']}'");
                $db->delete_query("threadsubscriptions", "uid='{$user['uid']}'");
                $db->delete_query("sessions", "uid='{$user['uid']}'");
                $db->delete_query("banned", "uid='{$user['uid']}'");
                $db->delete_query("threadratings", "uid='{$user['uid']}'");
                $db->delete_query("users", "uid='{$user['uid']}'"); 


Sorry I don't have an installation of PgSQL to test on, so please reply back if it works or not, or if there are any other issues.

[kvikkjokk]

(10-17-2008 06:21 PM)DennisTT Wrote:  In admin/modules/user/users.php, find:

PHP Code:

$db->delete_query("users", "uid='{$user['uid']}'");
                $db->delete_query("userfields", "ufid='{$user['uid']}'");
                $db->delete_query("privatemessages", "uid='{$user['uid']}'");
                $db->delete_query("events", "uid='{$user['uid']}'");
                $db->delete_query("moderators", "uid='{$user['uid']}'");
                $db->delete_query("forumsubscriptions", "uid='{$user['uid']}'");
                $db->delete_query("threadsubscriptions", "uid='{$user['uid']}'");
                $db->delete_query("sessions", "uid='{$user['uid']}'");
                $db->delete_query("banned", "uid='{$user['uid']}'");
                $db->delete_query("threadratings", "uid='{$user['uid']}'"); 


Replace with:

PHP Code:

$db->delete_query("userfields", "ufid='{$user['uid']}'");
                $db->delete_query("privatemessages", "uid='{$user['uid']}'");
                $db->delete_query("events", "uid='{$user['uid']}'");
                $db->delete_query("moderators", "uid='{$user['uid']}'");
                $db->delete_query("forumsubscriptions", "uid='{$user['uid']}'");
                $db->delete_query("threadsubscriptions", "uid='{$user['uid']}'");
                $db->delete_query("sessions", "uid='{$user['uid']}'");
                $db->delete_query("banned", "uid='{$user['uid']}'");
                $db->delete_query("threadratings", "uid='{$user['uid']}'");
                $db->delete_query("users", "uid='{$user['uid']}'"); 


Sorry I don't have an installation of PgSQL to test on, so please reply back if it works or not, or if there are any other issues.

Hi Dennis,
yep, solved the problem. Good stuff.
Thanks!

[Dennis Tsang]

Thank you for your bug report.

This bug has been fixed in our internal code repository. Please note that the problem will not be fixed here until these forums are updated.

With regards,
MyBB Group