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

[Chris Gregors]

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.

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