Hello,
We seemingly upgraded successfully from RT 3.0.11 to 3.2.1 on debian
(thanks again to Stephen for the packaging!).
Unfortunately, the bodies of incoming emails are not recorded, but a
ticket gets created.
In the syslog, I found the error messages below. Any input is highly
regarded.
System specs:
Apache 1.3.31
MySQL 4.0.21
Perl 5.8.4
RT 3.2.1
mod_perl setup
Regards,
Harald
log excerpt:
Sep 21 10:36:14 germany RT: Converting ‘us-ascii’ to ‘utf-8’ for
text/plain - em
ail test 01
Sep 21 10:36:14 germany RT: DBD::mysql::st execute failed: Column
‘Filename’ can
not be null at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/sh
are/request-tracker3.2/lib/RT.pm:250)
Sep 21 10:36:14 germany RT: RT::Handle=HASH(0x99f4df0) couldn’t execute
the quer
y ‘INSERT INTO Attachments (Subject, ContentType, Filename, Headers,
Creator, Pa
rent, Created, ContentEncoding, Content, TransactionId) VALUES (?, ?,
?, ?, ?, ?
, ?, ?, ?, ?)’ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line
417. (/usr
/share/request-tracker3.2/lib/RT.pm:250)
Sep 21 10:36:14 germany RT: About to think about scrips for
transaction2386
Sep 21 10:36:14 germany RT: About to prepare scrips for transaction2386
Sep 21 10:36:14 germany RT: Found 2 scrips
Sep 21 10:36:14 germany RT: DBD::mysql::st execute failed: Table
'rt3.Attributes
’ doesn’t exist at /usr/share/perl5/DBIx/SearchBuilder.pm line 140.
(/usr/share
/request-tracker3.2/lib/RT.pm:250)
Sep 21 10:36:14 germany RT: DBIx::SearchBuilder error:Table
‘rt3.Attributes’ doe
sn’t exist ^IQuery String is SELECT main.* FROM Attributes main WHERE
((main.O
bjectId = 507)) AND ((main.ObjectType = ‘RT::Ticket’))
(/usr/share/request-tra
cker3.2/lib/RT.pm:250)
Sep 21 10:36:14 germany RT: DBD::mysql::st fetchrow_hashref failed:
fetch() with
out execute() at /usr/share/perl5/DBIx/SearchBuilder.pm line 158.
(/usr/share/r
equest-tracker3.2/lib/RT.pm:250)
Sep 21 10:36:14 germany RT: About to commit scrips for transaction2386
Sep 21 10:36:14 germany RT: <rt-3.2.1-507-2386-22.10.3671703314811@FCBi
online>
#507/2386 - Scrip 22
(/usr/share/request-tracker3.2/lib/RT/Action/SendEmail.pm:
209)
Sep 21 10:36:15 germany RT: DBD::mysql::st execute failed: Column
‘Filename’ can
not be null at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/sh
are/request-tracker3.2/lib/RT.pm:250)
Sep 21 10:36:15 germany RT: RT::Handle=HASH(0x99f4df0) couldn’t execute
the quer
y ‘INSERT INTO Attachments (Subject, ContentType, Filename, Headers,
Creator, Pa
rent, Created, ContentEncoding, Content, TransactionId) VALUES (?, ?,
?, ?, ?, ?
, ?, ?, ?, ?)’ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line
417. (/usr
/share/request-tracker3.2/lib/RT.pm:250)
Sep 21 10:36:15 germany RT: About to think about scrips for
transaction2387
Sep 21 10:36:15 germany RT: <rt-3.2.1-507-2386-22.10.3671703314811@FCBi
online>
sent To: fkaiser@fcbi.de Cc: Bcc:
(/usr/share/request-tracker3.2/lib/RT/Action
/SendEmail.pm:269)
Sep 21 10:36:15 germany RT: <rt-3.2.1-507-2386-3.19.4701891914255@FCBi
online> #
507/2386 - Scrip 3
(/usr/share/request-tracker3.2/lib/RT/Action/SendEmail.pm:20
9)
Sep 21 10:36:15 germany RT: <rt-3.2.1-507-2386-3.19.4701891914255@FCBi
online> N
o recipients found. Not sending.
(/usr/share/request-tracker3.2/lib/RT/Action/S
endEmail.pm:221)
Sep 21 10:36:15 germany RT: Ticket 507 created in queue ‘EES-ESD3’ by
fkaiser (/
usr/share/request-tracker3.2/lib/RT/Ticket_Overlay.pm:695)
Sep 21 10:37:34 germany RT: Converting ‘ISO-8859-15’ to ‘utf-8’ for
text/plain -
Re: [FCBi #507] EES-ESD3: email test 01
Sep 21 10:37:34 germany RT: Found a ticket ID. It’s 507
Sep 21 10:37:34 germany RT: DBD::mysql::st execute failed: Column
‘Filename’ can
not be null at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/sh
are/request-tracker3.2/lib/RT.pm:250)
Sep 21 10:37:34 germany RT: RT::Handle=HASH(0x99f3a60) couldn’t execute
the quer
y ‘INSERT INTO Attachments (Subject, ContentType, Filename, Headers,
Creator, Pa
rent, Created, ContentEncoding, Content, TransactionId) VALUES (?, ?,
?, ?, ?, ?
, ?, ?, ?, ?)’ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line
417. (/usr
/share/request-tracker3.2/lib/RT.pm:250)
Sep 21 10:37:34 germany RT: About to think about scrips for
transaction2388
Sep 21 10:37:34 germany RT: About to prepare scrips for transaction2388
Sep 21 10:37:34 germany RT: Found 4 scrips
Sep 21 10:37:34 germany RT: DBD::mysql::st execute failed: Table
'rt3.Attributes
’ doesn’t exist at /usr/share/perl5/DBIx/SearchBuilder.pm line 140.
(/usr/share
/request-tracker3.2/lib/RT.pm:250)
Sep 21 10:37:34 germany RT: DBIx::SearchBuilder error:Table
‘rt3.Attributes’ doe
sn’t exist ^IQuery String is SELECT main.* FROM Attributes main WHERE
((main.O
bjectId = 507)) AND ((main.ObjectType = ‘RT::Ticket’))
(/usr/share/request-tra
cker3.2/lib/RT.pm:250)
Sep 21 10:37:34 germany RT: DBD::mysql::st fetchrow_hashref failed:
fetch() with
out execute() at /usr/share/perl5/DBIx/SearchBuilder.pm line 158.
(/usr/share/r
equest-tracker3.2/lib/RT.pm:250)
Sep 21 10:37:34 germany RT: About to commit scrips for transaction2388
Sep 21 10:37:34 germany RT: <rt-3.2.1-507-2388-4.10.60391729832@FCBi
online> #50
7/2388 - Scrip 4
(/usr/share/request-tracker3.2/lib/RT/Action/SendEmail.pm:209)
Sep 21 10:37:34 germany RT: <rt-3.2.1-507-2388-4.10.60391729832@FCBi
online> No
recipients found. Not sending.
(/usr/share/request-tracker3.2/lib/RT/Action/Sen
dEmail.pm:221)
Sep 21 10:37:34 germany RT: <rt-3.2.1-507-2388-5.0.952641047561826@FCBi
online>
#507/2388 - Scrip 5
(/usr/share/request-tracker3.2/lib/RT/Action/SendEmail.pm:2
09)
Sep 21 10:37:34 germany RT: <rt-3.2.1-507-2388-5.0.952641047561826@FCBi
online>
No recipients found. Not sending.
(/usr/share/request-tracker3.2/lib/RT/Action/
SendEmail.pm:221)
Sep 21 10:37:34 germany RT: <rt-3.2.1-507-2388-6.1.66167793401932@FCBi
online> #
507/2388 - Scrip 6
(/usr/share/request-tracker3.2/lib/RT/Action/SendEmail.pm:20
9)
Sep 21 10:37:41 germany RT: WebRT: Attachment ‘’ could not be loaded ()
(/usr/sh
are/request-tracker3.2/html/Elements/Error:53)