Current time: 05-24-2012, 01:47 PM Hello There, Guest! (LoginRegister)


 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[F] Can't delete user
10-17-2008, 08:30 AM
Post: #1
[F] Can't delete user
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
Find all posts by this user
10-17-2008, 02:53 PM
Post: #2
RE: Can't delete user
Table not installed correctly?

Pic-monster My site does work! You're just visiting wrong url!
Visit this user's website Find all posts by this user
10-17-2008, 04:35 PM
Post: #3
RE: Can't delete user
(10-17-2008 02:53 PM)mcgroove Wrote:  Table not installed correctly?

How to check ?
Find all posts by this user
10-17-2008, 05:11 PM
Post: #4
RE: Can't delete user
This user has been denied support. This user has been denied support.
Looks like a possble postgre/mybb bug. I don't know any postgre to help you further.

New MyBB plugin is "My Awards 2.0".
[Image: 468x60_SF.gif]
Visit this user's website Find all posts by this user
10-17-2008, 06:21 PM (This post was last modified: 10-17-2008 06:24 PM by Dennis Tsang.)
Post: #5
RE: Can't delete user
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.

Dennis Tsang :: MyBB Developer
Follow me on Twitter: @dennistt
Visit this user's website Find all posts by this user
10-20-2008, 06:29 AM
Post: #6
RE: Can't delete user
(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!
Find all posts by this user
10-20-2008, 07:28 PM
Post: #7
[F] Can't delete user
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

Dennis Tsang :: MyBB Developer
Follow me on Twitter: @dennistt
Visit this user's website Find all posts by this user


Forum Jump:


User(s) browsing this thread: 1 Guest(s)

Contact Us | MyBB | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication