For some reason when I add an item to the database I get a 500 ISE when I submit the add.cgi form. It is still being added to the database but when I go to validate, the category is missing. No changes have been made to the script or the templates recently and it has been working on this server for several months without error.

Any ideas?

P.S. Earlier I was able to add the category in the validation. Now it won't take it.

I am now getting this response from the debug:

A fatal error has occured:GT::SQL::Table (5425): Wrong argument passed to this subroutine. Usage: Must pass category id to template_set at /home/r1001rec/public_html/db/admin/Links/Category.pm line 307.
Please enable debugging in setup for more details.
Stack Trace
======================================
Links (5425): Links::environment called at /home/r1001rec/public_html/db/admin/Links.pm line 431 with no arguments.
Links (5425): Links::fatal called at GT::Base::error line 362 with arguments
(GT::SQL::Table (5425): Wrong argument passed to this subroutine. Usage: Must pass category id to template_set at /home/r1001rec/public_html/db/admin/Links/Category.pm line 307.
).
Links (5425): GT::Base::error called at /home/r1001rec/public_html/db/admin/Links/Category.pm line 307 with arguments
(Links::Category=HASH(0x85a4338), BADARGS, FATAL, Must pass category id to template_set).
Links (5425): Links::Category::template_set called at Links::Build::build_detailed line 55 with arguments
(Links::Category=HASH(0x85a4338), [undef]).
Links (5425): Links::Build::build_detailed called at /home/r1001rec/public_html/db/admin/GT/Plugins.pm line 108 with arguments
(HASH(0x8692ab0)).
Links (5425): GT::Plugins::dispatch called at /home/r1001rec/public_html/db/admin/Links/Build.pm line 30 with arguments
(GT::Plugins, /home/r1001rec/public_html/db/admin/Plugins, build_detailed, *Links::Build::build_detailed, HASH(0x8692ab0)).
Links (5425): Links::Build::build called at /home/r1001rec/public_html/db/admin/Plugins/DetailedInCat.pm line 114 with arguments
(detailed, HASH(0x8692ab0)).
Links (5425): Plugins::DetailedInCat::build_detailed called at /home/r1001rec/public_html/db/admin/GT/Plugins.pm line 97 with arguments
(GT::SQL::Condition=HASH(0x84fd678)).
Links (5425): GT::Plugins::dispatch called at nph-build.cgi line 132 with arguments
(GT::Plugins, /home/r1001rec/public_html/db/admin/Plugins, create_detailed_changed, CODE(0x82d43b4), GT::SQL::Condition=HASH(0x84fd678)).
Links (5425): main::build_changed called at nph-build.cgi line 39 with no arguments.
Links (5425): main::main called at nph-build.cgi line 30 with no arguments.


System Information
======================================
Perl Version: 5.008004
Links SQL Version: 2.1.2
DBI.pm Version: 1.48
Persistant Env: mod_perl (0) SpeedyCGI (0)
GT::SQL::error = GT::SQL::Table (5425): Wrong argument passed to this subroutine. Usage: Must pass category id to template_set at /home/r1001rec/public_html/db/admin/Links/Category.pm line 307.

@INC =
/home/r1001rec/public_html/db/admin
/usr/lib/perl5/5.8.4/i686-linux
/usr/lib/perl5/5.8.4
/usr/lib/perl5/site_perl/5.8.4/i686-linux
/usr/lib/perl5/site_perl/5.8.4
/usr/lib/perl5/site_perl/5.8.0
/usr/lib/perl5/site_perl
.

CGI INPUT
======================================
do => changed


CGI Cookies
======================================
1001Recipes2Send.com Forum Admin => tp::By+Threads%2C+Reversed
1001Recipes2Send.com Recipes Forum => tp::
WebBBS Master => nm::Chris%2C+WebAdmin.


ENVIRONMENT
======================================
AUTH_TYPE => Basic
DOCUMENT_ROOT => /home/r1001rec/public_html
GATEWAY_INTERFACE => CGI/1.1
GT_TMPDIR => /home/r1001rec/public_html/db/admin/tmp
HTTP_ACCEPT => image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/msword, application/x-gsarcade-launch, */*
HTTP_ACCEPT_ENCODING => gzip, deflate
HTTP_ACCEPT_LANGUAGE => en-ca
HTTP_CONNECTION => Keep-Alive
HTTP_COOKIE => WebBBS+Master=nm%3A%3AChris%252C%2BWebAdmin.%26em%3A%3AChris@1001Recipes2Send.com%26wn%3A%3Ayes%26pw%3A%3A; 1001Recipes2Send.com+Recipes+Forum=tp%3A%3A%26tm%3A%3A%26m1%3A%3A305%26v1%3A%3A1114359571%26m2%3A%3A312%26v2%3A%3A1117151345%26ts%3A%3A1117151474%26uf%3A%3ANo; 1001Recipes2Send.com+Forum+Admin=tp%3A%3ABy%2BThreads%252C%2BReversed%26tm%3A%3A2%2BMonth(s)%26m1%3A%3A%26v1%3A%3A1107229433%26m2%3A%3A285%26v2%3A%3A1108350430%26ts%3A%3A1108350464%26uf%3A%3ANo
HTTP_HOST => www.1001recipes2send.com
HTTP_REFERER => http://www.1001recipes2send.com/db/admin/admin.cgi?page=home_left.html
HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Alexa Toolbar; .NET CLR 1.1.4322)
PATH => /usr/local/bin:/usr/bin:/bin
QUERY_STRING => do=changed
REMOTE_ADDR => 70.30.83.95
REMOTE_PORT => 4721
REMOTE_USER => kriis
REQUEST_METHOD => GET
REQUEST_URI => /db/admin/nph-build.cgi?do=changed
SCRIPT_FILENAME => /home/r1001rec/public_html/db/admin/nph-build.cgi
SCRIPT_NAME => /db/admin/nph-build.cgi
SERVER_ADDR => 205.234.147.235
SERVER_ADMIN => webmaster@1001recipes2send.com
SERVER_NAME => www.1001recipes2send.com
SERVER_PORT => 80
SERVER_PROTOCOL => HTTP/1.1
SERVER_SOFTWARE => Apache/1.3.33 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.10 FrontPage/5.0.2.2635 mod_ssl/2.8.22 OpenSSL/0.9.7a

--

Kriis

I have since discovered that I can add the category information manually to the MySQL table directly so the table isn't frozen or anything. Still the new additions to the database are somehow being sent to Validation without the category_id and they are still being validated, again without a category assignment.

Please help!

--

Kriis