Gossamer Forum
Home : Products : DBMan SQL : Discussion :

weird error while deleting

Quote Reply
weird error while deleting
Hi,

I get a weird error while trying to delete an entry from table bookings_staff. I am able to delete entries from another table. The problems seems to be related to the fact that this table is related to another (aff_partners) in the way that one bookings_staff has many aff_partners. It might be not allowed do delete an entry from bookings_staff if there are still related entries in aff_partners, but that is not the case.

I hope someone has seen this error before and knows what to do.....

This is the error message that I get:
Code:
A fatal error has occured:

GT::SQL::Table (1000): Wrong argument passed to this subroutine. Usage: Could not create a condition object out of arguments. at Dbsql::Home::delete_records line 37.


Please enable debugging in setup for more details.

Stack Trace
======================================
Dbsql (1000): GT::Base::error called at /var/www/dbman/cgi-bin/admin//GT/SQL/Table.pm line 643 with arguments
    (GT::SQL::Table=HASH(0x8da5aa8), BADARGS, FATAL, Could not create a condition object out of arguments.).
Dbsql (1000): GT::SQL::Table::delete called at GT::SQL::Table::_do_opt line 2172 with arguments
    (GT::SQL::Table=HASH(0x8da5aa8), HASH(0x8da5b14)).
Dbsql (1000): GT::SQL::Table::_do_opt called at GT::SQL::Table::_delete_cond line 2200 with arguments
    (GT::SQL::Table=HASH(0x8e037bc), cascade, HASH(0x8da5b14), aff_partners).
Dbsql (1000): GT::SQL::Table::_delete_cond called at /var/www/dbman/cgi-bin/admin//GT/SQL/Table.pm line 664 with arguments
    (GT::SQL::Table=HASH(0x8e037bc), GT::SQL::Condition=HASH(0x8c7831c), cascade).
Dbsql (1000): GT::SQL::Table::delete called at Dbsql::Home::delete_records line 37 with arguments
    (GT::SQL::Table=HASH(0x8e037bc), HASH(0x9113af0)).
Dbsql (1000): Dbsql::Home::delete_records called at /var/www/dbman/cgi-bin/admin//GT/Plugins.pm line 165 with arguments
    (Dbsql::Home=HASH(0x918fa34)).
Dbsql (1000): GT::Plugins::dispatch_method called at /var/www/dbman/cgi-bin/admin//Dbsql/Home.pm line 82 with arguments
    (GT::Plugins, /var/www/dbman/cgi-bin/admin/Plugins/Dbsql, delete_records, Dbsql::Home=HASH(0x918fa34), delete_records).
Dbsql (1000): Dbsql::Home::process called at /var/www/dbman/cgi-bin/db.cgi line 29 with arguments
    (Dbsql::Home=HASH(0x918fa34), in, GT::CGI=HASH(0x8e01938), sql, GT::SQL=HASH(0x8bc4318), cfg, Dbsql::Config=HASH(0x9192d58)).
Dbsql (1000): Apache::ROOTjasper_2einternal_2ebookings_2enl::cgi_2dbin::db_2ecgi::main called at /var/www/dbman/cgi-bin/db.cgi line 22 with no arguments.
Dbsql (1000):
Apache::ROOTjasper_2einternal_2ebookings_2enl::cgi_2dbin::db_2ecgi::handler
called at /usr/lib/perl5/vendor_perl/5.6.1/i386-linux/Apache/Registry.pm
line 143 with arguments
    (Apache=SCALAR(0x9191508)).
Dbsql (1000): (eval) called at
/usr/lib/perl5/vendor_perl/5.6.1/i386-linux/Apache/Registry.pm line 143
with arguments
    (Apache=SCALAR(0x9191508)).
Dbsql (1000): Apache::Registry::handler called at /dev/null line 0 with arguments
    (Apache=SCALAR(0x9191508)).
Dbsql (1000): (eval) called at /dev/null line 0 with arguments
    (Apache=SCALAR(0x9191508)).


System Information
======================================
Perl Version: 5.006001
DBMan SQL Version: 2.1.0
DBI.pm Version: 1.21
Mod Perl Version: 1.26
GT::SQL::error = GT::SQL::Table (1000): Wrong argument passed to
this subroutine. Usage: Could not create a condition object out of
arguments. at Dbsql::Home::delete_records line 37.

@INC =
/var/www/dbman/cgi-bin/admin/
/home/jasper/cvs/tt2_contacts/lib/
/home/jasper/cvs/tt2_contacts/lib/Apache
/var/www/dbman/cgi-bin/admin
/usr/lib/perl5/5.6.1/i386-linux
/usr/lib/perl5/5.6.1
/usr/lib/perl5/site_perl/5.6.1/i386-linux
/usr/lib/perl5/site_perl/5.6.1
/usr/lib/perl5/site_perl/5.6.0/i386-linux
/usr/lib/perl5/site_perl/5.6.0
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.6.1/i386-linux
/usr/lib/perl5/vendor_perl/5.6.1
/usr/lib/perl5/vendor_perl
.
/usr/local/apache/
/usr/local/apache/lib/perl

CGI INPUT
======================================
1-id => 15
Submit => Delete
db => bookings_staff
delete => 1
do => delete_records
sid => 8c0923cd6177a5297e2f7dd7da0dcba8


ENVIRONMENT
======================================
CONTENT_LENGTH => 103
CONTENT_TYPE => application/x-www-form-urlencoded
DOCUMENT_ROOT => /var/www/dbman/html/
GATEWAY_INTERFACE => CGI-Perl/1.1
HTTP_ACCEPT => text/html, image/png, image/jpeg, image/gif, image/x-xbitmap, */*
HTTP_ACCEPT_CHARSET => iso-8859-1;q=1.0, utf-8;q=1.0, utf-16;q=1.0, iso-8859-1;q=0.6, *;q=0.1
HTTP_ACCEPT_ENCODING => deflate, gzip, x-gzip, identity, *;q=0
HTTP_CONNECTION => Keep-Alive, TE
HTTP_HOST => jasper.internal.bookings.nl:90
HTTP_REFERER => http://jasper.internal.bookings.nl:90/cgi-bin/db.cgi?sid=8c0923cd6177a5297e2f7dd7da0dcba8
HTTP_TE => deflate, gzip, chunked, identity, trailers
HTTP_USER_AGENT => Opera/6.02 (Linux 2.4.18-3 i686; U) [en]
MOD_PERL => mod_perl/1.27
PATH => /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
PERL_SEND_HEADER => On
QUERY_STRING =>
REMOTE_ADDR => 192.168.10.132
REMOTE_PORT => 34011
REQUEST_METHOD => POST
REQUEST_URI => /cgi-bin/db.cgi
SCRIPT_FILENAME => /var/www/dbman/cgi-bin/db.cgi
SCRIPT_NAME => /cgi-bin/db.cgi
SERVER_ADDR => 192.168.10.132
SERVER_ADMIN => jasper@bookings.nl
SERVER_NAME => jasper.internal.bookings.nl
SERVER_PORT => 90
SERVER_PROTOCOL => HTTP/1.1
SERVER_SIGNATURE =>
Apache/1.3.24 Server at jasper.internal.bookings.nl Port 90


SERVER_SOFTWARE => Apache/1.3.24 (Unix) mod_perl/1.27


OK

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

Please contact the server administrator, jasper@bookings.nl 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.



Apache/1.3.24 Server at jasper.internal.bookings.nl Port 90


http://www.bookings.org
Quote Reply
Re: [jaspercram] weird error while deleting In reply to
Hi,

It could be something wrong with your def files. Can you send me those files via email? I will have a closer look.

TheStone.

B.

Last edited by:

TheStone: Jul 16, 2003, 1:08 PM