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!
– 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@somewhere.com) [chris.gregors@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
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, 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, 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