Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

Re: [fmp] Delete user error in 1.1.8 FR

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

I still have this kind of problem... (with 1.1.8 version of french gforum)

Do I have to change someting in the defs file ? if yes in which one ?

Hi FMP,

it seems as if you have at least one messed up def file, but that's not a big deal. We're going to fix this in a minute.

Just start your search for the problem at the def file of whatever you tried to delete, e.g. admin/defs/prefix_Users.def if you unsuccessfully tried to delete a user. In the appropriate file you'll find a hash key named 'fk_tables' which points to an anonymous array. This array contains each and every table that relates to at least one column of this table.

Say 'fk_tables' in lsql_Users.def looks like this:

'fk_tables' => [
'lsql_Links',
'lsql_Changes',
'lsql_Reviews',
'lsql_Editors',
'lsql_Sessions'
],

This tells you that the tables 'lsql_Links', 'lsql_Changes', 'lsql_Reviews', 'lsql_Editors' and 'lsql_Sessions' all in some way relate to 'lsql_Users'. Make sure there is no non-existent table in this list. Plugins which don't clean up properly after themselves could cause such a mess.

If the list of tables is ok, start looking into to corresponding def files. For instance, in lsql_Links.def there should be something like:

'fk' => {
'lsql_Users' => {
'LinkOwner' => 'Username'
}
},

This means that the column 'LinkOwner' in 'lsql_Links' relates to the column 'Username' in 'lsql_Users' an is called a foreign key. These foreign keys can be very useful, because if a user is deleted the Links system also automatically deletes all of her links (related to by the foreign key).

So basically you just have to look for some incosistencies in the foreign table and the foreign key declarations, e.g. non-existent tables and non-existent columns clearly indicate problems as do empty foreign key declarations in def files which are listed in foreign table declarations.

Hope that helps to at least get started.

Regards,

Lucas
Subject Author Views Date
Thread Delete user error in 1.1.8 FR Jag 15195 Oct 11, 2002, 8:29 AM
Thread Re: [Jag] Delete user error in 1.1.8 FR
Franco 14918 Oct 12, 2002, 5:23 AM
Thread Re: [Franco] Delete user error in 1.1.8 FR
Jag 14889 Oct 12, 2002, 6:18 AM
Thread Re: [Jag] Delete user error in 1.1.8 FR
Franco 14929 Oct 12, 2002, 6:23 AM
Thread Re: [Franco] Delete user error in 1.1.8 FR
Jag 14937 Oct 15, 2002, 2:45 AM
Thread Re: [Jag] Delete user error in 1.1.8 FR
Jag 14821 Oct 19, 2002, 3:56 PM
Thread Re: [Jag] Delete user error in 1.1.8 FR
Franco 14888 Oct 20, 2002, 7:33 AM
Thread Re: [Franco] Delete user error in 1.1.8 FR
Jag 14857 Oct 28, 2002, 4:54 AM
Post Re: [Jag] Delete user error in 1.1.8 FR
Franco 14735 Oct 29, 2002, 8:57 AM
Thread Re: [Jag] Delete user error in 1.1.8 FR
Jagerman 14789 Oct 30, 2002, 5:40 PM
Post Re: [Jagerman] Delete user error in 1.1.8 FR
Jag 14702 Nov 5, 2002, 4:55 AM
Thread Re: [Jagerman] Delete user error in 1.1.8 FR
Jag 14858 Nov 22, 2002, 5:28 AM
Thread Re: [Jag] Delete user error in 1.1.8 FR
Jagerman 14703 Nov 28, 2002, 12:51 PM
Post Re: [Jagerman] Delete user error in 1.1.8 FR
Jag 14630 Nov 30, 2002, 5:42 AM
Thread Re: [Jagerman] Delete user error in 1.1.8 FR
Franco 14639 Dec 2, 2002, 6:06 PM
Thread Re: [Franco] Delete user error in 1.1.8 FR
Jagerman 14696 Dec 2, 2002, 6:25 PM
Thread Re: [Jagerman] Delete user error in 1.1.8 FR
Franco 14612 Dec 2, 2002, 6:38 PM
Thread Re: [Franco] Delete user error in 1.1.8 FR
Jagerman 14652 Dec 2, 2002, 7:04 PM
Post Re: [Jagerman] Delete user error in 1.1.8 FR
ellipsiiis 14313 Jan 31, 2004, 3:58 PM
Post Re: [Jagerman] Delete user error in 1.1.8 FR
jaltuve 3211 Mar 1, 2005, 4:26 AM
Thread Re: [Jagerman] Delete user error in 1.1.8 FR
hoefti 14481 Oct 11, 2003, 3:28 AM
Post Re: [hoefti] Delete user error in 1.1.8 FR
hoefti 14445 Nov 2, 2003, 12:06 AM
Thread Re: [Jagerman] Delete user error in 1.1.8 FR
fmp 3171 Mar 3, 2006, 6:02 AM
Post Re: [fmp] Delete user error in 1.1.8 FR
MrMoon 3158 Mar 7, 2006, 1:53 AM
Thread Re: [Jagerman] Delete user error in 1.1.8 FR
Franco 14717 Nov 25, 2002, 8:57 PM
Thread Re: [Franco] Delete user error in 1.1.8 FR
Jagerman 14737 Nov 26, 2002, 11:39 AM
Thread Re: [Jagerman] Delete user error in 1.1.8 FR
Jag 14663 Nov 26, 2002, 12:59 PM
Post Re: [Jag] Delete user error in 1.1.8 FR
brewt 14690 Nov 26, 2002, 1:31 PM