[rt-users] Problem with 1.0.2 ticket addition (probally simple)

[Jesse]

On Sun, Mar 26, 2000 at 01:20:47PM -0700, Chris Gregors wrote:
> I got RT installed and running but when I insert a request, it fails. The
> following is in the error_log file.
> 
> I also went thru the process from the command line.. Attached is the session
> output.
> 
Hrm. For kicks try restarting mysqld? it looks like for some reason it didn't 
create the ticket row. Actually, could you send me the output of mysqldump rt?

	jesse

> I know the answer is gonna be simple.... but I gotta ask anyway!
> <crs>
> 
> -- error_log trimmings --
> [Sun Mar 26 12:59:40 2000] [error] [client 192.168.2.2] (13)Permission
> denied: mod_mime_magic: can't read `/usr/local/rt/bin/cgi/web
> rt.cgi'
> DBD::mysql::st execute failed: You have an error in your SQL syntax near '
> 0, 'root', 'create', '', 954100784)' at line 1 at /usr/op
> t/perl5/lib/site_perl/5.005/aix/Mysql.pm line 172.
> [add_transaction] Query had some problem: You have an error in your SQL
> syntax near ' 0, 'root', 'create', '', 954100784)' at line 1
> Query: INSERT INTO transactions (id, effective_sn, serial_num, actor, type,
> trans_data, trans_date)  VALUES (NULL, , 0, 'root', 'cre
> ate', '', 954100784)
> Can't call method "insert_id" on an undefined value at
> /usr/local/rt/lib/rt/database.pm line 114.
> [Sun Mar 26 12:59:44 2000] [error] [client 192.168.2.2] Premature end of
> script headers: /usr/local/rt/bin/cgi/webrt.cgi
> --- end cut ---
> 
> --- cli_session ---
> # ./rtadmin queue -modify test
> Welcome to Request Tracker 1.0.2
> Queue email alias (ex: support at somewhere.com) [chris.gregors at notadot.com]:
> Mail request owner on transaction [N]:
> Mail queue members on transaction [N]:
> Mail requestors on transaction [N]:
> Autoreply to requestor on creation [N]:
> Mail correspondence to queue members [N]:
> Mail queue members on comment [N]:
> Allow non-queue members to create requests [N]:y
> Default request priority (1-100):
> Default final request priority (1-100):
> Are you satisfied with your answers [N]:y
> Queue test updated.
> # ./rt -create
> Welcome to Request Tracker 1.0.2
> Place Request in queue:test
> Place Request in area:
> Give request to:gregors
> Requestor(s):gregors
> Subject:test
> Starting Priority:
> Final Priority:
> Date due (MM/DD/YY):
> Please enter a detailed description of this request, terminated
> by a line containing only a period:
> test
>  .
> DBD::mysql::st execute failed: You have an error in your SQL syntax near '
> 0, 'root', 'create', '', 954101665)' at line 1 at
> /usr/opt/perl5/lib/site_perl/5.005/aix/Mysql.pm line 172, <STDIN> chunk 10.
> [add_transaction] Query had some problem: You have an error in your SQL
> syntax near ' 0, 'root', 'create', '', 954101665)' at line 1
> Query: INSERT INTO transactions (id, effective_sn, serial_num, actor, type,
> trans_data, trans_date)  VALUES (NULL, , 0, 'root', 'create', '', 954101665)
> Can't call method "insert_id" on an undefined value at
> /usr/local/rt/lib/rt/database.pm line 114, <STDIN> chunk 10.
> 
> --- end cli_session ---
> 
> --- install_info ---
> os = aix 4.3
> http = apache 1.3.12
> rt = 1.0.2
> MySQL = 3.22.32
> perl = 5.005_03 built for aix
> modules =	DBI-1.13
> 		Data-ShowTable-3.3
> 		Msql-Mysql-modules-1.2209
> 		CGI.pm-2.59
> 		Digest-MD5-2.09
> 
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 

-- 
jesse reed vincent -- jrvincent at wesleyan.edu -- jesse at fsck.com 
pgp keyprint:  50 41 9C 03 D0 BC BC C8 2C B9 77 26 6F E1 EB 91
--------------------------------------------------------------
. . . when not in doubt, get in doubt.  -- Old Discordian Proveb