Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Error when trying to delete catagory

Quote Reply
Error when trying to delete catagory
I'm getting the following error when trying to delete a category.


A fatal error has occured:
GT::SQL::Table (29788): Wrong argument passed to this subroutine. Could not create a condition object out of arguments. at /domain.com/cgi-bin/admin/Links/Table/Category.pm line 237.

Please enable debugging in setup for more details. OK
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@erotic-porn-search.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.

Any ideas what's wrong?
Quote Reply
Re: [tommeyboy] Error when trying to delete catagory In reply to
Can you enable debugging and post the result (remember to remove any private info)?

Adrian
Quote Reply
Re: [brewt] Error when trying to delete catagory In reply to
Thank you Adrian.

I have actually already resolved this.

Basically go to the SQL database, look up the category that is blocking the upgrade fix it then try to run it again.

It took few hours,... but we got it going.

thanks for the great templates and design..(I know you worked on the luna templates for a long time), very well done. Smile
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory

Last edited by:

katabd: Mar 9, 2006, 7:20 AM
Quote Reply
Re: [brewt] Error when trying to delete catagory In reply to
A fatal error has occured:

GT::SQL::Table (31957): Wrong argument passed to this subroutine. Could not create a condition object out of arguments. at /home/httpd/vhosts/domain.com/cgi-bin/admin/Links/Table/Category.pm line 237.

Please enable debugging in setup for more details.

Stack Trace
======================================
Links (31957): Links::environment called at /home/httpd/vhosts/domain.com/cgi-bin/admin/Links.pm line 712 with no arguments.
Links (31957): Links::fatal called at GT::Base::error line 378 with arguments
(GT::SQL::Table (31957): Wrong argument passed to this subroutine. Could not create a condition object out of arguments. at /home/httpd/vhosts/domain.com/cgi-bin/admin/Links/Table/Category.pm line 237.
).
Links (31957): GT::Base::error called at GT::Base::fatal line 290 with arguments
(GT::SQL::Table=HASH(0x999f370), BADARGS, FATAL, Could not create a condition object out of arguments.).
Links (31957): GT::Base::fatal called at /home/httpd/vhosts/domain.com/cgi-bin/admin/GT/SQL/Table.pm line 696 with arguments
(GT::SQL::Table=HASH(0x999f370), BADARGS, Could not create a condition object out of arguments.).
Links (31957): GT::SQL::Table::delete called at GT::SQL::Table::_do_opt line 2203 with arguments
(GT::SQL::Table=HASH(0x999f370), HASH(0x99a451c)).
Links (31957): GT::SQL::Table::_do_opt called at GT::SQL::Table::_delete_cond line 2228 with arguments
(Links::Table::Category=HASH(0x994c14c), cascade, HASH(0x99a451c), glinks_Cat_Ad).
Links (31957): GT::SQL::Table::_delete_cond called at /home/httpd/vhosts/domain.com/cgi-bin/admin/GT/SQL/Table.pm line 717 with arguments
(Links::Table::Category=HASH(0x994c14c), GT::SQL::Condition=HASH(0x995546c), cascade).
Links (31957): GT::SQL::Table::delete called at /home/httpd/vhosts/domain.com/cgi-bin/admin/Links/Table/Category.pm line 237 with arguments
(Links::Table::Category=HASH(0x994c14c), HASH(0x994f1b8)).
Links (31957): Links::Table::Category::delete called at Links::Browser::category_del line 480 with arguments
(Links::Table::Category=HASH(0x994c14c), HASH(0x994f1b8)).
Links (31957): Links::Browser::category_del called at /home/httpd/vhosts/domain.com/cgi-bin/admin/admin.cgi line 107 with arguments
(Links::Browser=HASH(0x986ed20)).
Links (31957): ModPerl::ROOT::ModPerl::Registry::home_domain_2ecom_cgi_2dbin_admin_admin_2ecgi::__ANON__ called at /home/httpd/vhosts/domain.com/cgi-bin/admin/GT/Plugins.pm line 133 with arguments
(Links::Browser=HASH(0x986ed20)).
Links (31957): GT::Plugins::dispatch called at /home/httpd/vhosts/domain.com/cgi-bin/admin/admin.cgi line 107 with arguments
(GT::Plugins=HASH(0x9861394), browser_category_del, CODE(0x98ef5f8), Links::Browser=HASH(0x986ed20)).
Links (31957): ModPerl::ROOT::ModPerl::Registry::home_domain_2ecom_cgi_2dbin_admin_admin_2ecgi::brow_request called at /home/httpd/vhosts/domain.com/cgi-bin/admin/admin.cgi line 60 with no arguments.
Links (31957): ModPerl::ROOT::ModPerl::Registry::home_domain_2ecom_cgi_2dbin_admin_admin_2ecgi::main called at /home/httpd/vhosts/domain.com/cgi-bin/admin/admin.cgi line 24 with no arguments.
Links (31957): ModPerl::ROOT::ModPerl::Registry::home_domain_2ecom_cgi_2dbin_admin_admin_2ecgi::handler called at /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/ModPerl/RegistryCooker.pm line 203 with arguments
(Apache2::RequestRec=SCALAR(0x9871b2c)).
Links (31957): (eval) called at /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/ModPerl/RegistryCooker.pm line 203 with arguments
(Apache2::RequestRec=SCALAR(0x9871b2c)).
Links (31957): ModPerl::RegistryCooker::run called at /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/ModPerl/RegistryCooker.pm line 169 with arguments
(ModPerl::Registry=HASH(0x986edf8)).
Links (31957): ModPerl::RegistryCooker::default_handler called at /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/ModPerl/Registry.pm line 30 with arguments
(ModPerl::Registry=HASH(0x986edf8)).
Links (31957): ModPerl::Registry::handler called at -e line 0 with arguments
(ModPerl::Registry, Apache2::RequestRec=SCALAR(0x9871b2c)).
Links (31957): (eval) called at -e line 0 with arguments
(ModPerl::Registry, Apache2::RequestRec=SCALAR(0x9871b2c)).

System Information
======================================
Current user: apache (48)
Perl version: 5.8.3
Gossamer Links version: 3.1.0
GT::SQL version: 1.111
GT::Template version: 2.151
DBI.pm Version: 1.42
Running under mod_perl: Yes (version 2.000002), mod_perl 2 detected
Running under SpeedyCGI: No
@INC =
../..
/home/httpd/vhosts/domain.com/cgi-bin/admin
/usr/lib/perl5/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/5.8.3
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl/5.8.2
/usr/lib/perl5/site_perl/5.8.1
/usr/lib/perl5/site_perl/5.8.0
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.2/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl/5.8.2
/usr/lib/perl5/vendor_perl/5.8.1
/usr/lib/perl5/vendor_perl/5.8.0
/usr/lib/perl5/vendor_perl
.
/usr/local/apache2
GT::SQL::error = GT::SQL::Table (31957): Wrong argument passed to this subroutine. Could not create a condition object out of arguments. at /home/httpd/vhosts/domain.com/cgi-bin/admin/Links/Table/Category.pm line 237.


CGI Input
======================================
action => category_del
category_id => 19

CGI Cookies
======================================
ADCYCLE_LOGIN => brandon|4490071|
editor_cols => 120
editor_rows => 10

Environment
======================================
AUTH_TYPE => Basic
DOCUMENT_ROOT => /home/httpd/vhosts/domain.com/httpdocs
GATEWAY_INTERFACE => CGI/1.1
GT_TMPDIR => /home/httpd/vhosts/domain.com/cgi-bin/admin/tmp
HTTP_AAAAAAAAAAAAAAA => +++++++++++++
HTTP_ACCEPT => text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_CHARSET => ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_LANGUAGE => en-us,en;q=0.5
HTTP_CONNECTION => keep-alive
HTTP_COOKIE => editor_cols=120; ADCYCLE_LOGIN=tommeyboy|4490071|; editor_rows=10
HTTP_HOST => www.domain.com
HTTP_KEEP_ALIVE => 300
HTTP_REFERER => http://www.domain.com/cgi-bin/admin/admin.cgi?category_id=19&action=category_del_form
HTTP_USER_AGENT => Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.1) Gecko/20060111 Firefox/1.5.0.1
MOD_PERL => mod_perl/2.0.2
MOD_PERL_API_VERSION => 2
PATH => /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:.:/root/bin
QUERY_STRING => action=category_del&category_id=19
REMOTE_ADDR => 222.222.222.222
REMOTE_PORT => 2271
REMOTE_USER => tommeyboy
REQUEST_METHOD => GET
REQUEST_URI => /cgi-bin/admin/admin.cgi?action=category_del&category_id=19
SCRIPT_FILENAME => /home/httpd/vhosts/domain.com/cgi-bin/admin/admin.cgi
SCRIPT_NAME => /cgi-bin/admin/admin.cgi
SERVER_ADDR => 222.222.222.222
SERVER_ADMIN => webmaster@domain.com
SERVER_NAME => www.domain.com
SERVER_PORT => 80
SERVER_PROTOCOL => HTTP/1.1
SERVER_SIGNATURE =>
SERVER_SOFTWARE => Apache
UNIQUE_ID => q60xkUI3hVcAAHzVnHwAAAAm

OK

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@domain.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Last edited by:

brewt: Mar 10, 2006, 5:29 PM
Quote Reply
Re: [tommeyboy] Error when trying to delete catagory In reply to
Can you send me admin panel access so I can debug this further? Thanks.

Adrian
Quote Reply
Re: [brewt] Error when trying to delete catagory In reply to
Brewt... pm'd you.
Quote Reply
Re: [tommeyboy] Error when trying to delete catagory In reply to
The problem was that your Category was referencing a non-existent foreign key table (Cat_Ad). I removed the table from your def file and it's working now.

Adrian
Quote Reply
Re: [brewt] Error when trying to delete catagory In reply to
Thank you.