Errors after upgrading from 3.0.11 to 3.2.1

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)

OK,
after adding the ‘Attributes’ table to the database, and updating
DBIx:SearchBuilder from 1.1 to 1.10, a lot less gets logged:

[Tue Sep 21 10:24:52 2004] [debug]: Converting ‘us-ascii’ to ‘utf-8’
for text/plain - email test 01
(/usr/share/request-tracker3.2/lib/RT/I18N.pm:200)
[Tue Sep 21 10:24:52 2004] [warning]: DBD::mysql::st execute failed:
Column ‘Filename’ cannot be null at
/usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Handle.pm line 478.
(/usr/share/request-tracker3.2/lib/RT.pm:250)
[Tue Sep 21 10:24:52 2004] [warning]: RT::Handle=HASH(0x99f2474)
couldn’t execute the query ‘INSERT INTO Attachments (Subject,
ContentType, Filename, Headers, Creator, Parent, Created,
ContentEncoding, Content, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?,
?, ?, ?)’ at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Handle.pm
line 492.
(/usr/share/request-tracker3.2/lib/RT.pm:250)
[Tue Sep 21 10:24:52 2004] [debug]: About to think about scrips for
transaction2414
(/usr/share/request-tracker3.2/lib/RT/Transaction_Overlay.pm:118)
[Tue Sep 21 10:24:52 2004] [debug]: About to prepare scrips for
transaction2414
(/usr/share/request-tracker3.2/lib/RT/Transaction_Overlay.pm:122)
[Tue Sep 21 10:24:52 2004] [debug]: Found 2 scrips
(/usr/share/request-tracker3.2/lib/RT/Scrips_Overlay.pm:327)
[Tue Sep 21 10:24:53 2004] [debug]: About to commit scrips for
transaction2414
(/usr/share/request-tracker3.2/lib/RT/Transaction_Overlay.pm:131)
[Tue Sep 21 10:24:53 2004] [info]:
<rt-3.2.1-516-2414-22.6.79022878542845@FCBi online> #516/2414 - Scrip
22 (/usr/share/request-tracker3.2/lib/RT/Action/SendEmail.pm:209)
[Tue Sep 21 10:24:53 2004] [warning]: DBD::mysql::st execute failed:
Column ‘Filename’ cannot be null at
/usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Handle.pm line 478.
(/usr/share/request-tracker3.2/lib/RT.pm:250)
[Tue Sep 21 10:24:53 2004] [warning]: RT::Handle=HASH(0x99f2474)
couldn’t execute the query ‘INSERT INTO Attachments (Subject,
ContentType, Filename, Headers, Creator, Parent, Created,
ContentEncoding, Content, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?,
?, ?, ?)’ at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Handle.pm
line 492.
(/usr/share/request-tracker3.2/lib/RT.pm:250)
[Tue Sep 21 10:24:53 2004] [debug]: About to think about scrips for
transaction2415
(/usr/share/request-tracker3.2/lib/RT/Transaction_Overlay.pm:118)
[Tue Sep 21 10:24:53 2004] [info]:
<rt-3.2.1-516-2414-22.6.79022878542845@FCBi online> sent To:
fkaiser@fcbi.de Cc: Bcc:
(/usr/share/request-tracker3.2/lib/RT/Action/SendEmail.pm:269)
[Tue Sep 21 10:24:53 2004] [info]:
<rt-3.2.1-516-2414-3.19.0260712765402@FCBi online> #516/2414 - Scrip 3
(/usr/share/request-tracker3.2/lib/RT/Action/SendEmail.pm:209)
[Tue Sep 21 10:24:53 2004] [info]:
<rt-3.2.1-516-2414-3.19.0260712765402@FCBi online> No recipients found.
Not sending.
(/usr/share/request-tracker3.2/lib/RT/Action/SendEmail.pm:221)
[Tue Sep 21 10:24:53 2004] [info]: Ticket 516 created in queue
’EES-ESD3’ by fkaiser
(/usr/share/request-tracker3.2/lib/RT/Ticket_Overlay.pm:695)

I could not fully stop and start the apache server yet, since it is a
production system. I did stop and start during the upgrade to rt 3.2,
though.

Regards,
Harald

Just three more details

  • Replying to an existing Ticket by mail also does not get the message
    body recorded
  • Creating and replying to existing tickets by web ui does also help
  • A stop and start of apache did not help

I would not like to go back to rt 3.0, but it seems I’d need to if I
can’t get this fixed today.

Regards,
Harald

tbh it sounds like you didn’t upgrade properly. Did you execute all the schema
changes? Also, are there any elements of the old version still in your install
as it’s best to start afresh I found.

Harald Wagener wrote:

OK,
after adding the ‘Attributes’ table to the database, and updating
DBIx:SearchBuilder from 1.1 to 1.10, a lot less gets logged:

[Tue Sep 21 10:24:52 2004] [debug]: Converting ‘us-ascii’ to ‘utf-8’ for
text/plain - email test 01
(/usr/share/request-tracker3.2/lib/RT/I18N.pm:200)
[Tue Sep 21 10:24:52 2004] [warning]: DBD::mysql::st execute failed:
Column ‘Filename’ cannot be null at
/usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Handle.pm line 478.
(/usr/share/request-tracker3.2/lib/RT.pm:250)
[Tue Sep 21 10:24:52 2004] [warning]: RT::Handle=HASH(0x99f2474)
couldn’t execute the query ‘INSERT INTO Attachments (Subject,
ContentType, Filename, Headers, Creator, Parent, Created,
ContentEncoding, Content, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?,
?, ?)’ at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Handle.pm line
492.
(/usr/share/request-tracker3.2/lib/RT.pm:250)
[Tue Sep 21 10:24:52 2004] [debug]: About to think about scrips for
transaction2414
(/usr/share/request-tracker3.2/lib/RT/Transaction_Overlay.pm:118)
[Tue Sep 21 10:24:52 2004] [debug]: About to prepare scrips for
transaction2414
(/usr/share/request-tracker3.2/lib/RT/Transaction_Overlay.pm:122)
[Tue Sep 21 10:24:52 2004] [debug]: Found 2 scrips
(/usr/share/request-tracker3.2/lib/RT/Scrips_Overlay.pm:327)
[Tue Sep 21 10:24:53 2004] [debug]: About to commit scrips for
transaction2414
(/usr/share/request-tracker3.2/lib/RT/Transaction_Overlay.pm:131)
[Tue Sep 21 10:24:53 2004] [info]:
<rt-3.2.1-516-2414-22.6.79022878542845@FCBi online> #516/2414 - Scrip
22 (/usr/share/request-tracker3.2/lib/RT/Action/SendEmail.pm:209)
[Tue Sep 21 10:24:53 2004] [warning]: DBD::mysql::st execute failed:
Column ‘Filename’ cannot be null at
/usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Handle.pm line 478.
(/usr/share/request-tracker3.2/lib/RT.pm:250)
[Tue Sep 21 10:24:53 2004] [warning]: RT::Handle=HASH(0x99f2474)
couldn’t execute the query ‘INSERT INTO Attachments (Subject,
ContentType, Filename, Headers, Creator, Parent, Created,
ContentEncoding, Content, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?,
?, ?)’ at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Handle.pm line
492.
(/usr/share/request-tracker3.2/lib/RT.pm:250)
[Tue Sep 21 10:24:53 2004] [debug]: About to think about scrips for
transaction2415
(/usr/share/request-tracker3.2/lib/RT/Transaction_Overlay.pm:118)
[Tue Sep 21 10:24:53 2004] [info]:
<rt-3.2.1-516-2414-22.6.79022878542845@FCBi online> sent To:
fkaiser@fcbi.de Cc: Bcc:
(/usr/share/request-tracker3.2/lib/RT/Action/SendEmail.pm:269)
[Tue Sep 21 10:24:53 2004] [info]:
<rt-3.2.1-516-2414-3.19.0260712765402@FCBi online> #516/2414 - Scrip 3
(/usr/share/request-tracker3.2/lib/RT/Action/SendEmail.pm:209)
[Tue Sep 21 10:24:53 2004] [info]:
<rt-3.2.1-516-2414-3.19.0260712765402@FCBi online> No recipients found.
Not sending.
(/usr/share/request-tracker3.2/lib/RT/Action/SendEmail.pm:221)
[Tue Sep 21 10:24:53 2004] [info]: Ticket 516 created in queue
’EES-ESD3’ by fkaiser
(/usr/share/request-tracker3.2/lib/RT/Ticket_Overlay.pm:695)

I could not fully stop and start the apache server yet, since it is a
production system. I did stop and start during the upgrade to rt 3.2,
though.

Regards,
Harald


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT wiki at http://wiki.bestpractical.com

With regards,

Say_Ten

This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed. In the event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or any information contained in it.

In the event of misdirection, illegible or incomplete transmission please telephone (023) 8024 3137
or return the E.mail to postmaster@multiplay.co.uk.

tbh it sounds like you didn’t upgrade properly. Did you execute all
the schema changes? Also, are there any elements of the old version
still in your install as it’s best to start afresh I found.

Starting with a newly initialized database, no errors are appearing.
Quite possibly, the old database was broken in more than one aspect.

Thanks for Your patience.

Regards,
Harald