Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Problem deleting categories

Quote Reply
Problem deleting categories
When ever I try to delete cateogries from the dmoz dump, I get the following error, any ideas?

Stack Trace
======================================
Links (28979): Links::environment called at /home/site/cgi-bin/admin/Links.pm line 446 with no arguments.Links (28979): Links::fatal called at (eval 7) line 88 with arguments (GT::SQL::Table (28979): BADCATID at (eval 9) line 6.
).Links (28979): GT::Base::error called at /home/site/cgi-bin/admin/Links/Category.pm line 304 with arguments (Links::Category=HASH(0x842eb84), BADCATID, FATAL, 282578).Links (28979): Links::Category::children called at /home/site/cgi-bin/admin/Links/Category.pm line 161 with arguments (Links::Category=HASH(0x842eb84), 282578).Links (28979): Links::Category::_delete called at /home/site/cgi-bin/admin/Links/Category.pm line 166 with arguments (Links::Category=HASH(0x842eb84), 282578, SCALAR(0x8425168), GT::SQL::Relation=HASH(0x84e529c)).Links (28979): Links::Category::_delete called at /home/site/cgi-bin/admin/Links/Category.pm line 166 with arguments (Links::Category=HASH(0x842eb84), 282511, SCALAR(0x8425168), GT::SQL::Relation=HASH(0x84e529c)).Links (28979): Links::Category::_delete called at /home/site/cgi-bin/admin/Links/Category.pm line 166 with arguments (Links::Category=HASH(0x842eb84), 282360, SCALAR(0x8425168), GT::SQL::Relation=HASH(0x84e529c)).Links (28979): Links::Category::_delete called at /home/site/cgi-bin/admin/Links/Category.pm line 166 with arguments (Links::Category=HASH(0x842eb84), 282307, SCALAR(0x8425168), GT::SQL::Relation=HASH(0x84e529c)).Links (28979): Links::Category::_delete called at /home/site/cgi-bin/admin/Links/Category.pm line 143 with arguments (Links::Category=HASH(0x842eb84), 282306, SCALAR(0x8425168), GT::SQL::Relation=HASH(0x84e529c)).Links (28979): Links::Category::_plg_delete called at /home/site/cgi-bin/admin/Links/Category.pm line 120 with arguments (Links::Category=HASH(0x842eb84), HASH(0x8423eb8)).Links (28979): Links::Category::__ANON__ called at /home/site/cgi-bin/admin/GT/Plugins.pm line 99 with arguments (HASH(0x8423eb8)).Links (28979): GT::Plugins::dispatch called at /home/site/cgi-bin/admin/Links/Category.pm line 120 with arguments (GT::Plugins, /home/site/cgi-bin/admin/Plugins, delete_category, CODE(0x842be44), HASH(0x8423eb8)).Links (28979): Links::Category::delete called at /home/site/cgi-bin/admin/Links/Browser.pm line 404 with arguments (Links::Category=HASH(0x842eb84), HASH(0x8423eb8)).Links (28979): Links::Browser::category_del called at /home/site/cgi-bin/admin/browser.cgi line 47 with arguments (Links::Browser=HASH(0x8420f44)).Links (28979): main::main called at /home/site/cgi-bin/admin/browser.cgi line 27 with no arguments.

System Information
======================================
Perl Version: 5.006
Links SQL Version: 2.0.0
DBI.pm Version: 1.14
GT::SQL::error = GT::SQL::Table (28979): BADCATID at (eval 9) line 6.

@INC =
/home/site/cgi-bin/admin
/usr/local/lib/perl5/5.6.0/i686-linux
/usr/local/lib/perl5/5.6.0
/usr/local/lib/perl5/site_perl/5.6.0/i686-linux
/usr/local/lib/perl5/site_perl/5.6.0
/usr/local/lib/perl5/site_perl
.

CGI INPUT
======================================
action => category_del
category_id => 282306


CGI Cookies
======================================


ENVIRONMENT
======================================
DOCUMENT_ROOT => /home/site/html/
GATEWAY_INTERFACE => CGI/1.1
HTTP_ACCEPT => image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/msword, application/vnd.ms-excel, */*
HTTP_ACCEPT_ENCODING => gzip, deflate
HTTP_ACCEPT_LANGUAGE => en-us
HTTP_CONNECTION => Keep-Alive
HTTP_HOST => XXX.XXX.XXX.XXX
HTTP_REFERER => http://XXX.XXX.XXX.XXX/cgi-bin/admin/browser.cgi?category_id=282306&action=category_del_form
HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 5.0; MSNIA; Windows 98; DigExt)
PATH => /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
QUERY_STRING => action=category_del&category_id=282306
REMOTE_ADDR => XXX.XXX.XXX.XXX
REMOTE_PORT => 1618
REQUEST_METHOD => GET
REQUEST_URI => /cgi-bin/admin/browser.cgi?action=category_del&category_id=282306
SCRIPT_FILENAME => /home/site/cgi-bin/admin/browser.cgi
SCRIPT_NAME => /cgi-bin/admin/browser.cgi
SERVER_ADDR => XXX.XXX.XXX.XXX
SERVER_ADMIN => root@localhost
SERVER_NAME => site.com
SERVER_PORT => 80
SERVER_PROTOCOL => HTTP/1.1
SERVER_SIGNATURE => Apache/1.3.14 Server at site.com Port 80

SERVER_SOFTWARE => Apache/1.3.14 (Unix) (Red-Hat/Linux) mod_perl/1.21



Quote Reply
Re: Problem deleting categories In reply to
did you repair tables first?

http://www.ASciFi.com/ - The Science Fiction Portal
Quote Reply
Re: Problem deleting categories In reply to
Actually, I imported the dmoz dump but I wanted to delete the categories that I didn't need before we did anything else. Suggestions?

Quote Reply
Re: Problem deleting categories In reply to
repair your tables before deleeting them, it helps that is what i had to do.

http://www.ASciFi.com/ - The Science Fiction Portal