[rt-users] Errors after upgrading from 3.0.11 to 3.2.1

Tue Sep 21 05:03:14 EDT 2004

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 at 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 at FCBi 
online>
sent To: fkaiser at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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)