Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

Re: [Jag] Delete user error in 1.1.8 FR

Quote Reply
Re: [Jag] Delete user error in 1.1.8 FR In reply to
Hi Jag,

It took me a while, but I managed to track down the problem to the "Block_PM" and "Block_User" plugins; for some reason, they create foreign keys to the User table to the effect that the User table knows it has foreign keys pointing to it from the Block_PM/Block_User tables, but when GT::SQL looks at those tables to try to find the relevant columns it can't find any, thus causing the error. I'm going to have to look around some more to figure out why those foreign key entries weren't in the def file to Block_User/Block_PM, but I've added them manually to your copy in order to fix this without having to uninstall those plugins.

For other people who are getting the same error, I've outlined the fix below:

You need to edit admin/defs/gforum_Block_User.def and .../gforum_Block_PM.def. In those files, look for

Code:
'fk' => {},


You need to change this to:

Code:
'fk' => { gforum_User => { blocker_user_id => 'user_id' } },


If it is already there (it may be on multiple lines, but will start with: 'fk' => {), you don't need to change anything.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com

Last edited by:

Jagerman: Nov 28, 2002, 12:54 PM
Subject Author Views Date
Thread Delete user error in 1.1.8 FR Jag 15727 Oct 11, 2002, 8:29 AM
Thread Re: [Jag] Delete user error in 1.1.8 FR
Franco 15438 Oct 12, 2002, 5:23 AM
Thread Re: [Franco] Delete user error in 1.1.8 FR
Jag 15410 Oct 12, 2002, 6:18 AM
Thread Re: [Jag] Delete user error in 1.1.8 FR
Franco 15451 Oct 12, 2002, 6:23 AM
Thread Re: [Franco] Delete user error in 1.1.8 FR
Jag 15456 Oct 15, 2002, 2:45 AM
Thread Re: [Jag] Delete user error in 1.1.8 FR
Jag 15342 Oct 19, 2002, 3:56 PM
Thread Re: [Jag] Delete user error in 1.1.8 FR
Franco 15413 Oct 20, 2002, 7:33 AM
Thread Re: [Franco] Delete user error in 1.1.8 FR
Jag 15382 Oct 28, 2002, 4:54 AM
Post Re: [Jag] Delete user error in 1.1.8 FR
Franco 15256 Oct 29, 2002, 8:57 AM
Thread Re: [Jag] Delete user error in 1.1.8 FR
Jagerman 15311 Oct 30, 2002, 5:40 PM
Post Re: [Jagerman] Delete user error in 1.1.8 FR
Jag 15224 Nov 5, 2002, 4:55 AM
Thread Re: [Jagerman] Delete user error in 1.1.8 FR
Jag 15380 Nov 22, 2002, 5:28 AM
Thread Re: [Jag] Delete user error in 1.1.8 FR
Jagerman 15223 Nov 28, 2002, 12:51 PM
Post Re: [Jagerman] Delete user error in 1.1.8 FR
Jag 15151 Nov 30, 2002, 5:42 AM
Thread Re: [Jagerman] Delete user error in 1.1.8 FR
Franco 15161 Dec 2, 2002, 6:06 PM
Thread Re: [Franco] Delete user error in 1.1.8 FR
Jagerman 15218 Dec 2, 2002, 6:25 PM
Thread Re: [Jagerman] Delete user error in 1.1.8 FR
Franco 15135 Dec 2, 2002, 6:38 PM
Thread Re: [Franco] Delete user error in 1.1.8 FR
Jagerman 15172 Dec 2, 2002, 7:04 PM
Post Re: [Jagerman] Delete user error in 1.1.8 FR
ellipsiiis 14833 Jan 31, 2004, 3:58 PM
Post Re: [Jagerman] Delete user error in 1.1.8 FR
jaltuve 3319 Mar 1, 2005, 4:26 AM
Thread Re: [Jagerman] Delete user error in 1.1.8 FR
hoefti 15002 Oct 11, 2003, 3:28 AM
Post Re: [hoefti] Delete user error in 1.1.8 FR
hoefti 14967 Nov 2, 2003, 12:06 AM
Thread Re: [Jagerman] Delete user error in 1.1.8 FR
fmp 3276 Mar 3, 2006, 6:02 AM
Post Re: [fmp] Delete user error in 1.1.8 FR
MrMoon 3262 Mar 7, 2006, 1:53 AM
Thread Re: [Jagerman] Delete user error in 1.1.8 FR
Franco 15237 Nov 25, 2002, 8:57 PM
Thread Re: [Franco] Delete user error in 1.1.8 FR
Jagerman 15262 Nov 26, 2002, 11:39 AM
Thread Re: [Jagerman] Delete user error in 1.1.8 FR
Jag 15186 Nov 26, 2002, 12:59 PM
Post Re: [Jag] Delete user error in 1.1.8 FR
brewt 15210 Nov 26, 2002, 1:31 PM