Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

Delete user error in 1.1.8 FR

Quote Reply
Delete user error in 1.1.8 FR
I get the following error when I tried to delete a user that wasn't confirmed :

A fatal error has occurred:

GT::SQL::Table (17562): Wrong argument passed to this subroutine. Usage: Could not create a condition object out of arguments. at /path_to/cgi-bin/admin/GT/SQL/Table.pm line 643.

Please enable debugging in setup for more details.

Stack Trace
======================================
GForum (17562): GT::Base::error called at /path_to/cgi-bin/admin/GT/SQL/Table.pm line 643 with arguments
(GT::SQL::Table=HASH(0x511a1c), BADARGS, FATAL, Could not create a condition object out of arguments.).
GForum (17562): GT::SQL::Table::delete called at GT::SQL::Table::_do_opt line 2172 with arguments
(GT::SQL::Table=HASH(0x511a1c), HASH(0x4fe8a0)).
GForum (17562): GT::SQL::Table::_do_opt called at GT::SQL::Table::_delete_cond line 2200 with arguments
(GForum::Table::User=HASH(0x3ea3fc), cascade, HASH(0x4fe8a0), gforum_Block_PM).
GForum (17562): GT::SQL::Table::_delete_cond called at /path_to/cgi-bin/admin/GT/SQL/Table.pm line 664 with arguments
(GForum::Table::User=HASH(0x3ea3fc), GT::SQL::Condition=HASH(0x4e6aa4), cascade).
GForum (17562): GT::SQL::Table::delete called at GForum::Table::User::_plg_delete line 386 with arguments
(GForum::Table::User=HASH(0x3ea3fc), 48).
GForum (17562): GForum::Table::User::_plg_delete called at /path_to/cgi-bin/admin/GForum/Table/User.pm line 369 with arguments
(GForum::Table::User=HASH(0x3ea3fc), HASH(0x4d5d40)).
GForum (17562): GForum::Table::User::__ANON__ called at /path_to/cgi-bin/admin/GT/Plugins.pm line 108 with arguments
(GForum::Table::User=HASH(0x3ea3fc), HASH(0x4d5d40)).
GForum (17562): GT::Plugins::dispatch called at /path_to/cgi-bin/admin/GForum/Table/User.pm line 369 with arguments
(GT::Plugins, /path_to/cgi-bin/admin/Plugins/GForum, delete_user, CODE(0x40515c), GForum::Table::User=HASH(0x3ea3fc), HASH(0x4d5d40)).
GForum (17562): GForum::Table::User::delete called at GForum::User::admin_validate_submit line 707 with arguments
(GForum::Table::User=HASH(0x3ea3fc), HASH(0x4d5d40)).
GForum (17562): GForum::User::admin_validate_submit called at GT::Template::_call_func line 762 with no arguments.
GForum (17562): GT::Template::_call_func called at path_to/cgi-bin/admin/templates/admin/compiled/users_admin_validate.html.compiled line 26 with arguments
(GForum::Template=HASH(0x38001c), GForum::User::admin_validate_submit).
GForum (17562): GT::Template::parsed_template called at /path_to/cgi-bin/admin/GT/Template.pm line 600 with arguments
(GForum::Template=HASH(0x38001c)).
GForum (17562): GT::Template::_parse called at /path_to/cgi-bin/admin/GT/Template.pm line 97 with arguments
(GForum::Template=HASH(0x38001c), users_admin_validate.html, HASH(0x37ffec)).
GForum (17562): GT::Template::parse called at /path_to/cgi-bin/admin/GForum/Template.pm line 169 with arguments
(GForum::Template, users_admin_validate.html, ARRAY(0x31e674), HASH(0x37ffec), 1).
GForum (17562): GForum::Template::parse called at /path_to/cgi-bin/admin/GT/Template.pm line 111 with arguments
(GForum::Template, users_admin_validate.html, GT::CGI=HASH(0x366788), HASH(0x2364e0), 1).
GForum (17562): GT::Template::parse_print called at GForum::page line 354 with arguments
(GForum::Template, users_admin_validate.html, GT::CGI=HASH(0x366788), HASH(0x2364e0)).
GForum (17562): GForum::page called at /path_to/cgi-bin/admin/admin.cgi line 52 with no arguments.
GForum (17562): main::main called at /path_to/cgi-bin/admin/admin.cgi line 26 with no arguments.


System Information
======================================
Perl Version: v5.6.1
Gossamer Forum Version: 1.1.8
GForum.pm version: 1.118
GT::SQL Version: 1.099
GT::Template Version: 2.084
DBI.pm Version: 1.30
@INC =
/path_to/cgi-bin/admin
/usr/local/lib/perl5/5.6.1/sun4-solaris
/usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris
/usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl
/usr/local/lib/perl5/5.00503
/usr/local/lib/site_perl
.
GT::SQL::error = GT::SQL::Table (17562): Wrong argument passed to this subroutine. Usage: Could not create a condition object out of arguments. at /path_to/cgi-bin/admin/GT/SQL/Table.pm line 643.


CGI INPUT
======================================
48 => delete
do => page
page => users_admin_validate.html
validate_delete => 1

If anybody knows what's wrong ???

Thanks, John
Significant Media
Quote Reply
Re: [Jag] Delete user error in 1.1.8 FR In reply to
See http://www.gossamer-threads.com/...i?post=218162#218162.

François
Quote Reply
Re: [Franco] Delete user error in 1.1.8 FR In reply to
Hi François,

Did you get an answer to this ???? Unsure

It doesn't look as if there are any bug fixes that cover this in the official bug fixes area.

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

... Not yet. I'm still waiting for it. Unsure

François
Quote Reply
Re: [Franco] Delete user error in 1.1.8 FR In reply to
Hi Jagerman,

Err, how should I put this, not being able to delete users in a forum is a bit of a pain...

Would you have a few minutes to provide some feedback on this issue...

Thanks, John
Significant Media
Quote Reply
Re: [Jag] Delete user error in 1.1.8 FR In reply to
Jagerman,

Maybe you didn't see this post but not being able to delete users is a pain and in my books should be considered as a category 1 bug (i.e. blocking).

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

I'm still waiting too for a solution to this bug and also to the bug with moved posts (see http://www.gossamer-threads.com/...i?post=217626#217626).

GT staff is really quiet this month. Unsure

François
Quote Reply
Re: [Franco] Delete user error in 1.1.8 FR In reply to
After private messages to staff and various messages posted I was wondering whether any users had found a solution to this BIG problem ?

Since the version 1.1.8 is going to be the last stable version before vers. 2.0 (unless I'm mistakenBlush) it would be an idea to smooth out problems of this magnitude that hamper everyday usage of the forum...

I'm not sure whether this is just an error in the 1.1.8 French version or whether it is a general 1.1.8 issue.

John
Significant Media
Quote Reply
Re: [Jag] Delete user error in 1.1.8 FR In reply to
I'm agree with Jag...

The delete user error appears probably only in french version... And that's probably why we don't have a fast answer... Unsure

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

I can't seem to reproduce this error on my 1.1.8-fr copy. Can you tell me exactly where you click in order to make the error come up?

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com
Quote Reply
Re: [Jagerman] Delete user error in 1.1.8 FR In reply to
Hi Jagerman I basically tried every possible way available to an admin to delete a user (getting the same error message)...
In the admin panel I tried in the list of users delete next to modify and details, also in the forum as an admin I clicked on delete...

I think maybe Franco will have tried different ways to delete users but none seem to work. Let me know if you want to try it out on mine...

John
Significant Media
Quote Reply
Re: [Jagerman] Delete user error in 1.1.8 FR In reply to
Jason,

This is really becoming a BIG PROBLEM for the daily usage of the forum and I'm getting tired of having no solution even through the database.

I've offered to give you access to my forum in order to understand what is going wrong and I'm sure Franco would let have a look at his but PLEASE can we have some reaction on this. It is making administration of the forum really messy.

Thanks, John
Significant Media
Quote Reply
Re: [Jagerman] Delete user error in 1.1.8 FR In reply to
I'm tired too to wait for a solution to this bug. Mad Mad

Jason, if you need I can send you access info to try it on my forum.

François
Quote Reply
Re: [Franco] Delete user error in 1.1.8 FR In reply to
Hi François,

Jag sent me access to his forum, where I am currently looking trying to track down the problem; I should have a fix available shortly.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com
Quote Reply
Re: [Jagerman] Delete user error in 1.1.8 FR In reply to
I was just wondering, when you delete a user does it delete all private messages and posted messages as well ? I was thinking of the holes it may leave in a discussion when a user gets clobbered.

Thanks, John
Significant Media
Quote Reply
Re: [Jag] Delete user error in 1.1.8 FR In reply to
No, it leaves those messages and posts behind.

Adrian
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
Quote Reply
Re: [Jagerman] Delete user error in 1.1.8 FR In reply to
Jason,

Thanks, It works great, not that deleting users is my sole occupation but it will certainly let me now delete the users that have never connected after their signing-up !

Thanks for the time you spent finding the solution Cool

John
Significant Media
Quote Reply
Re: [Jagerman] Delete user error in 1.1.8 FR In reply to
Hi Jason,

I tried your solution, but when I try to delete a user I get now this message: "0 record(s) were deleted." And the user I want to delete still there (not deleted). Crazy

Thank you for your help!

François
Quote Reply
Re: [Franco] Delete user error in 1.1.8 FR In reply to
Hi François,

My guess is that you missed the checkbox on the left hand side of the user record - it is a delete confirmation. Getting rid of that checkbox is a definite 2.0 feature - many, many people have been caught by it.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com
Quote Reply
Re: [Jagerman] Delete user error in 1.1.8 FR In reply to
I tried again but it still not working, and the checkbox was really checked. Crazy

Thank you!

François

Last edited by:

Franco: Dec 2, 2002, 6:39 PM
Quote Reply
Re: [Franco] Delete user error in 1.1.8 FR In reply to
Hi François,

Can you e-mail me admin panel access? I'll take a look for you.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com

Last edited by:

Jagerman: Dec 2, 2002, 7:04 PM
Quote Reply
Re: [Jagerman] Delete user error in 1.1.8 FR In reply to
In Reply To:

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

Hello
i have the same problem
but i dosent find a file like
gforum_Block_User.def in admin/defs

The same problem is comming, when i want to delete a user in the Community

Can someone help me?

greeting hoefti

ps:
i get an error in Forum as in Community
like:

$!:
$@: GT::SQL::Table (10466): Wrong argument passed to this subroutine. Usage: Could not create a condition object out of arguments. at GForum::Table::User::_plg_delete line 420.

$GT::SQL::error: GT::SQL::Table (10466): Wrong argument passed to this subroutine. Usage: Could not create a condition object out of arguments. at GForum::Table::User::_plg_delete line 420.
linktobuy Web Directory
Ratgeber Recht

Last edited by:

hoefti: Oct 11, 2003, 3:56 AM
Quote Reply
Re: [hoefti] Delete user error in 1.1.8 FR In reply to
hello

i fix it in gforum_Block_User.def
but i dosent found a file
gforum_Block_User.def in admin/defs

in the Forum and in the Community the same problem.

Whats wrong?

hoefti
linktobuy Web Directory
Ratgeber Recht
Quote Reply
Re: [Jagerman] Delete user error in 1.1.8 FR In reply to
I'm now having this problem in 1.2.1, English version. I did the original fix and am now getting the 0 users deleted problem Franco described. And yes, the box is checked.


Realiiity.com Forums
Quote Reply
Re: [Jagerman] Delete user error in 1.1.8 FR In reply to
Hi, it's two years later... but, in 1.2.1 I have this same error. My guess is that a plugin is causing this right? because of foreign keys relations?
Quote Reply
Re: [Jagerman] Delete user error in 1.1.8 FR In reply to
In Reply To:
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.


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 ?

Txs for your help....

Here is the message error I get...

A fatal error has occurred:
GT::SQL::Table (16289): Wrong argument passed to this subroutine. Usage: Could not create a condition object out of arguments. at /home/site/cgi-bin/gforum/admin/GT/SQL/Table.pm line 643.
Please enable debugging in setup for more details.
Stack Trace
======================================
GForum (16289): GT::Base::error called at /home/site/cgi-bin/gforum/admin/GT/SQL/Table.pm line 643 with arguments
([undef], GT::SQL::Table=HASH(0x844ee98), BADARGS, FATAL, Could not create a condition object out of arguments.).
GForum (16289): GT::SQL::Table::delete called at GT::SQL::Table::_do_opt line 2172 with arguments
(GT::SQL::Table=HASH(0x844ee98), HASH(0x8458a1c)).
GForum (16289): GT::SQL::Table::_do_opt called at GT::SQL::Table::_delete_cond line 2200 with arguments
(GT::SQL::Table=HASH(0x839877c), cascade, HASH(0x8458a1c), forum_Online).
GForum (16289): GT::SQL::Table::_delete_cond called at /home/site/cgi-bin/gforum/admin/GT/SQL/Table.pm line 664 with arguments
(GT::SQL::Table=HASH(0x839877c), GT::SQL::Condition=HASH(0x8223630), cascade).
GForum (16289): GT::SQL::Table::delete called at /home/site/cgi-bin/gforum/admin/GForum.pm line 547 with arguments
(GT::SQL::Table=HASH(0x839877c), GT::SQL::Condition=HASH(0x844a9c8)).
GForum (16289): GForum::_plg_authenticate called at /home/site/cgi-bin/gforum/admin/GT/Plugins.pm line 108 with no arguments.
GForum (16289): GT::Plugins::dispatch called at /home/site/cgi-bin/gforum/admin/GForum.pm line 486 with arguments
(GT::Plugins, /home/site/cgi-bin/gforum/admin/Plugins/GForum, authenticate, CODE(0x82a928c)).
GForum (16289): GForum::authenticate called at /home/site/cgi-bin/gforum/gforum.cgi line 53 with no arguments.
GForum (16289): main::main called at /home/site/cgi-bin/gforum/admin/GT/Plugins.pm line 108 with no arguments.
GForum (16289): GT::Plugins::dispatch called at /home/site/cgi-bin/gforum/gforum.cgi line 22 with arguments
(GT::Plugins, /home/site/cgi-bin/gforum/admin/Plugins/GForum, main, CODE(0x8325680)).


System Information
======================================
Perl Version: v5.6.0
Gossamer Forum Version: 1.1.8
GForum.pm version: 1.118
GT::SQL Version: 1.099
GT::Template Version: 2.084
DBI.pm Version: 1.18
@INC =
/home/site/cgi-bin/gforum/admin
/usr/lib/perl5/5.6.0/i386-linux
/usr/lib/perl5/5.6.0
/usr/lib/perl5/site_perl/5.6.0/i386-linux
/usr/lib/perl5/site_perl/5.6.0
/usr/lib/perl5/site_perl
.
GT::SQL::error = GT::SQL::Table (16289): Wrong argument passed to this subroutine. Usage: Could not create a condition object out of arguments. at /home/site/cgi-bin/gforum/admin/GT/SQL/Table.pm line 643.


regards
FMP
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