We backed up up the DB and backed up up the /opt/rt4 dir, tried the upgrade, which failed @ 4.1.1, then tried to revert by restoring the dir and the DB, but now RT won’t send mail and we are getting these errors.
Any help would be appreciated.
Best Regards,
Camron
Mar 15 09:21:14 admin-new RT: DBD::mysql::st execute failed: Unknown column ‘main.Queue’ in ‘where clause’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 587. (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:587)
Mar 15 09:21:14 admin-new RT: RT::Handle=HASH(0x7f6f5d101218) couldn’t execute the query 'SELECT DISTINCT main.* FROM Scrips main JOIN ScripConditions ScripConditions_1 ON ( ScripConditions_1.id = main.ScripCondition ) WHERE (main.Queue = ‘3’ OR main.Queue = ‘0’) AND (ScripConditions_1.ApplicableTransTypes LIKE ‘%Create%’ OR ScripConditions_1.ApplicableTransTypes LIKE ‘%Any%’) AND (main.Stage = ‘TransactionCreate’) ORDER BY main.Description ASC ’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 600#012#011DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x7f6f5d101218)’, ‘SELECT DISTINCT main.* FROM Scrips main JOIN ScripConditions …’) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 236#012#011DBIx::SearchBuilder::_DoSearch(‘RT::Scrips=HASH(0x7f6f6310c998)’) called at /opt/rt4/sbin/…/lib/RT/SearchBuilder.pm line 343#012#011RT::SearchBuilder::_DoSearch(‘RT::Scrips=HASH(0x7f6f6310c998)’) called at /opt/rt4/sbin/…/lib/RT/Scrips.pm line 375#012#011RT::Scrips::_FindScrips(‘RT::Scrips=HASH(0x7f6f6310c998)’, ‘Stage’, ‘TransactionCreate’, ‘Type’, ‘Create’) called at /opt/rt4/sbin/…/lib/RT/Scrips.pm line 219#012#011RT::Scrips::Prepare(‘RT::Scrips=HASH(0x7f6f6310c998)’, ‘Stage’, ‘TransactionCreate’, ‘Type’, ‘Create’, ‘Ticket’, 10571, ‘Transaction’, 158062, …) called at /opt/rt4/sbin/…/lib/RT/Transaction.pm line 179#012#011RT::Transaction::Create(‘RT::Transaction=HASH(0x7f6f5db8ec50)’, ‘ObjectId’, 10571, ‘ObjectType’, ‘RT::Ticket’, ‘TimeTaken’, 0, ‘Type’, ‘Create’, …) called at /opt/rt4/sbin/…/lib/RT/Record.pm line 1502#012#011RT::Record::_NewTransaction(‘RT::Ticket=HASH(0x7f6f630a7ab8)’, ‘Type’, ‘Create’, ‘TimeTaken’, 0, ‘MIMEObj’, ‘MIME::Entity=HASH(0x7f6f5d10a410)’, ‘CommitScrips’, 1, …) called at /opt/rt4/sbin/…/lib/RT/Ticket.pm line 676#012#011RT:
:Create(‘RT::Ticket=HASH(0x7f6f630a7ab8)’, ‘Requestor’, ‘ARRAY(0x7f6f630af280)’, ‘DependsOn’, ‘ARRAY(0x7f6f630adb60)’, ‘Cc’, ‘ARRAY(0x7f6f630a3ab8)’, ‘RefersTo’, ‘ARRAY(0x7f6f630a4478)’, …) called at /opt/rt4/local/plugin
Mar 15 09:21:14 admin-new RT: DBD::mysql::st execute failed: Unknown column ‘main.Queue’ in ‘where clause’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 587. (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:587)
Mar 15 09:21:14 admin-new RT: RT::Handle=HASH(0x7f6f5d101218) couldn’t execute the query 'SELECT COUNT(DISTINCT main.id) FROM Scrips main JOIN ScripConditions ScripConditions_1 ON ( ScripConditions_1.id = main.ScripCondition ) WHERE (main.Queue = ‘3’ OR main.Queue = ‘0’) AND (ScripConditions_1.ApplicableTransTypes LIKE ‘%Create%’ OR ScripConditions_1.ApplicableTransTypes LIKE ‘%Any%’) AND (main.Stage = ‘TransactionCreate’) ’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 600#012#011DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x7f6f5d101218)’, ‘SELECT COUNT(DISTINCT main.id) FROM Scrips main JOIN ScripCon…’) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 292#012#011DBIx::SearchBuilder::_DoCount(‘RT::Scrips=HASH(0x7f6f6310c998)’) called at /opt/rt4/sbin/…/lib/RT/SearchBuilder.pm line 354#012#011RT::SearchBuilder::_DoCount(‘RT::Scrips=HASH(0x7f6f6310c998)’) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 1408#012#011DBIx::SearchBuilder::Count(‘RT::Scrips=HASH(0x7f6f6310c998)’) called at /opt/rt4/sbin/…/lib/RT/Scrips.pm line 377#012#011RT::Scrips::_FindScrips(‘RT::Scrips=HASH(0x7f6f6310c998)’, ‘Stage’, ‘TransactionCreate’, ‘Type’, ‘Create’) called at /opt/rt4/sbin/…/lib/RT/Scrips.pm line 219#012#011RT::Scrips::Prepare(‘RT::Scrips=HASH(0x7f6f6310c998)’, ‘Stage’, ‘TransactionCreate’, ‘Type’, ‘Create’, ‘Ticket’, 10571, ‘Transaction’, 158062, …) called at /opt/rt4/sbin/…/lib/RT/Transaction.pm line 179#012#011RT::Transaction::Create(‘RT::Transaction=HASH(0x7f6f5db8ec50)’, ‘ObjectId’, 10571, ‘ObjectType’, ‘RT::Ticket’, ‘TimeTaken’, 0, ‘Type’, ‘Create’, …) called at /opt/rt4/sbin/…/lib/RT/Record.pm line 1502#012#011RT::Record::_NewTransaction(‘RT::Ticket=HASH(0x7f6f630a7ab8)’, ‘Type’, ‘Create’, ‘TimeTaken’, 0, ‘MIMEObj’, ‘MIME::Entity=HASH(0x7f6f5d10a410)’, ‘CommitScrips’, 1, …) called at /opt/rt4/sbin/…/lib/RT/Ticket.pm line 676#012#011RT::Create(‘RT::Ticket=HASH(0x7f6f630a7ab8)’, ‘Requestor’, ‘ARRAY(0x7f6f630af280)’, ‘DependsOn’, 'ARRAY(0x7f6f630adb6
Mar 15 09:21:14 admin-new RT: Use of uninitialized value in concatenation (.) or string at /opt/rt4/sbin/…/lib/RT/Scrips.pm line 377. (/opt/rt4/sbin/…/lib/RT/Scrips.pm:377)
Mar 15 09:21:14 admin-new RT: DBD::mysql::st execute failed: Unknown column ‘main.Queue’ in ‘where clause’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 587. (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:587)
Mar 15 09:21:14 admin-new RT: RT::Handle=HASH(0x7f6f5d101218) couldn’t execute the query 'SELECT DISTINCT main.* FROM Scrips main JOIN ScripConditions ScripConditions_1 ON ( ScripConditions_1.id = main.ScripCondition ) WHERE (main.Queue = ‘3’ OR main.Queue = ‘0’) AND (ScripConditions_1.ApplicableTransTypes LIKE ‘%Create%’ OR ScripConditions_1.ApplicableTransTypes LIKE ‘%Any%’) AND (main.Stage = ‘TransactionCreate’) ORDER BY main.Description ASC ’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 600#012#011DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x7f6f5d101218)’, ‘SELECT DISTINCT main.* FROM Scrips main JOIN ScripConditions …’) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 236#012#011DBIx::SearchBuilder::_DoSearch(‘RT::Scrips=HASH(0x7f6f6310c998)’) called at /opt/rt4/sbin/…/lib/RT/SearchBuilder.pm line 343#012#011RT::SearchBuilder::_DoSearch(‘RT::Scrips=HASH(0x7f6f6310c998)’) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 504#012#011DBIx::SearchBuilder::Next(‘RT::Scrips=HASH(0x7f6f6310c998)’) called at /opt/rt4/sbin/…/lib/RT/Scrips.pm line 129#012#011RT::Scrips::Next(‘RT::Scrips=HASH(0x7f6f6310c998)’) called at /opt/rt4/sbin/…/lib/RT/Scrips.pm line 223#012#011RT::Scrips::Prepare(‘RT::Scrips=HASH(0x7f6f6310c998)’, ‘Stage’, ‘TransactionCreate’, ‘Type’, ‘Create’, ‘Ticket’, 10571, ‘Transaction’, 158062, …) called at /opt/rt4/sbin/…/lib/RT/Transaction.pm line 179#012#011RT::Transaction::Create(‘RT::Transaction=HASH(0x7f6f5db8ec50)’, ‘ObjectId’, 10571, ‘ObjectType’, ‘RT::Ticket’, ‘TimeTaken’, 0, ‘Type’, ‘Create’, …) called at /opt/rt4/sbin/…/lib/RT/Record.pm line 1502#012#011RT::Record::_NewTransaction(‘RT::Ticket=HASH(0x7f6f630a7ab8)’, ‘Type’, ‘Create’, ‘TimeTaken’, 0, ‘MIMEObj’, ‘MIME::Entity=HASH(0x7f6f5d10a410)’, ‘CommitScrips’, 1, …) called at /opt/rt4/sbin/…/lib/RT/Ticket.pm line 676#012#011RT::Create(‘RT::Ticket=HASH(0x7f6f630a7ab8)’, ‘Requestor’, ‘ARRAY(0x7f6f630af280)’, ‘DependsOn’, ‘ARRAY(0x7f6f630adb60)’, ‘Cc’, 'ARRAY(0x7f6f630a3ab8
Mar 15 09:21:14 admin-new RT: Ticket 10571 created in queue ‘helpdesk’ by masafumi.oe@nao.ac.jp (/opt/rt4/sbin/…/lib/RT/Ticket.pm:688)
Mar 15 09:21:14 admin-new RT: DBD::mysql::st execute failed: Unknown column ‘main.Queue’ in ‘where clause’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 587. (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:587)
Mar 15 09:21:14 admin-new RT: RT::Handle=HASH(0x7f6f5d101218) couldn’t execute the query 'SELECT DISTINCT main.* FROM Scrips main JOIN ScripConditions ScripConditions_1 ON ( ScripConditions_1.id = main.ScripCondition ) WHERE (main.Queue = ‘3’ OR main.Queue = ‘0’) AND (ScripConditions_1.ApplicableTransTypes LIKE ‘%Create%’ OR ScripConditions_1.ApplicableTransTypes LIKE ‘%Any%’) AND (main.Stage = ‘TransactionBatch’) ORDER BY main.Description ASC ’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 600#012#011DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x7f6f5d101218)’, ‘SELECT DISTINCT main.* FROM Scrips main JOIN ScripConditions …’) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 236#012#011DBIx::SearchBuilder::_DoSearch(‘RT::Scrips=HASH(0x7f6f630af280)’) called at /opt/rt4/sbin/…/lib/RT/SearchBuilder.pm line 343#012#011RT::SearchBuilder::_DoSearch(‘RT::Scrips=HASH(0x7f6f630af280)’) called at /opt/rt4/sbin/…/lib/RT/Scrips.pm line 375#012#011RT::Scrips::_FindScrips(‘RT::Scrips=HASH(0x7f6f630af280)’, ‘Stage’, ‘TransactionBatch’, ‘Type’, ‘Create’) called at /opt/rt4/sbin/…/lib/RT/Scrips.pm line 219#012#011RT::Scrips::Prepare(‘RT::Scrips=HASH(0x7f6f630af280)’, ‘Type’, ‘Create’, ‘TransactionObj’, ‘RT::Transaction=HASH(0x7f6f5db8ec50)’, ‘Ticket’, undef, ‘TicketObj’, ‘RT::Ticket=HASH(0x7f6f630a7ab8)’, …) called at /opt/rt4/sbin/…/lib/RT/Scrips.pm line 167#012#011RT::Scrips::Apply(‘RT::Scrips=HASH(0x7f6f630af280)’, ‘Stage’, ‘TransactionBatch’, ‘TicketObj’, ‘RT::Ticket=HASH(0x7f6f630a7ab8)’, ‘TransactionObj’, ‘RT::Transaction=HASH(0x7f6f5db8ec50)’, ‘Type’, ‘Create’, …) called at /opt/rt4/sbin/…/lib/RT/Ticket.pm line 3382#012#011RT::_ApplyTransactionBatch(‘RT::Ticket=HASH(0x7f6f630a7ab8)’) called at /opt/rt4/sbin/…/lib/RT/Ticket.pm line 3353#012#011RT::ApplyTransactionBatch(‘RT::Ticket=HASH(0x7f6f630a7ab8)’) called at /opt/rt4/sbin/…/lib/RT/Ticket.pm line 3423#012#011RT::DESTROY(‘RT::Ticket=HASH(0x7f6f630a7ab8)’) called at /opt/rt4/sbin/…/lib/RT/Interf
Mar 15 09:21:14 admin-new RT: DBD::mysql::st execute failed: Unknown column ‘main.Queue’ in ‘where clause’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 587. (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:587)
Mar 15 09:21:14 admin-new RT: RT::Handle=HASH(0x7f6f5d101218) couldn’t execute the query 'SELECT COUNT(DISTINCT main.id) FROM Scrips main JOIN ScripConditions ScripConditions_1 ON ( ScripConditions_1.id = main.ScripCondition ) WHERE (main.Queue = ‘3’ OR main.Queue = ‘0’) AND (ScripConditions_1.ApplicableTransTypes LIKE ‘%Create%’ OR ScripConditions_1.ApplicableTransTypes LIKE ‘%Any%’) AND (main.Stage = ‘TransactionBatch’) ’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 600#012#011DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x7f6f5d101218)’, ‘SELECT COUNT(DISTINCT main.id) FROM Scrips main JOIN ScripCon…’) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 292#012#011DBIx::SearchBuilder::_DoCount(‘RT::Scrips=HASH(0x7f6f630af280)’) called at /opt/rt4/sbin/…/lib/RT/SearchBuilder.pm line 354#012#011RT::SearchBuilder::_DoCount(‘RT::Scrips=HASH(0x7f6f630af280)’) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 1408#012#011DBIx::SearchBuilder::Count(‘RT::Scrips=HASH(0x7f6f630af280)’) called at /opt/rt4/sbin/…/lib/RT/Scrips.pm line 377#012#011RT::Scrips::_FindScrips(‘RT::Scrips=HASH(0x7f6f630af280)’, ‘Stage’, ‘TransactionBatch’, ‘Type’, ‘Create’) called at /opt/rt4/sbin/…/lib/RT/Scrips.pm line 219#012#011RT::Scrips::Prepare(‘RT::Scrips=HASH(0x7f6f630af280)’, ‘Type’, ‘Create’, ‘TransactionObj’, ‘RT::Transaction=HASH(0x7f6f5db8ec50)’, ‘Ticket’, undef, ‘TicketObj’, ‘RT::Ticket=HASH(0x7f6f630a7ab8)’, …) called at /opt/rt4/sbin/…/lib/RT/Scrips.pm line 167#012#011RT::Scrips::Apply(‘RT::Scrips=HASH(0x7f6f630af280)’, ‘Stage’, ‘TransactionBatch’, ‘TicketObj’, ‘RT::Ticket=HASH(0x7f6f630a7ab8)’, ‘TransactionObj’, ‘RT::Transaction=HASH(0x7f6f5db8ec50)’, ‘Type’, ‘Create’, …) called at /opt/rt4/sbin/…/lib/RT/Ticket.pm line 3382#012#011RT::_ApplyTransactionBatch(‘RT::Ticket=HASH(0x7f6f630a7ab8)’) called at /opt/rt4/sbin/…/lib/RT/Ticket.pm line 3353#012#011RT::ApplyTransactionBatch(‘RT::Ticket=HASH(0x7f6f630a7ab8)’) called at /opt/rt4/sbin/…/lib/RT/Ticket.pm lin
Mar 15 09:21:14 admin-new RT: Use of uninitialized value in concatenation (.) or string at /opt/rt4/sbin/…/lib/RT/Scrips.pm line 377. (/opt/rt4/sbin/…/lib/RT/Scrips.pm:377)
Mar 15 09:21:14 admin-new RT: DBD::mysql::st execute failed: Unknown column ‘main.Queue’ in ‘where clause’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 587. (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:587)
Mar 15 09:21:14 admin-new RT: RT::Handle=HASH(0x7f6f5d101218) couldn’t execute the query 'SELECT DISTINCT main.* FROM Scrips main JOIN ScripConditions ScripConditions_1 ON ( ScripConditions_1.id = main.ScripCondition ) WHERE (main.Queue = ‘3’ OR main.Queue = ‘0’) AND (ScripConditions_1.ApplicableTransTypes LIKE ‘%Create%’ OR ScripConditions_1.ApplicableTransTypes LIKE ‘%Any%’) AND (main.Stage = ‘TransactionBatch’) ORDER BY main.Description ASC ’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 600#012#011DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x7f6f5d101218)’, ‘SELECT DISTINCT main.* FROM Scrips main JOIN ScripConditions …’) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 236#012#011DBIx::SearchBuilder::_DoSearch(‘RT::Scrips=HASH(0x7f6f630af280)’) called at /opt/rt4/sbin/…/lib/RT/SearchBuilder.pm line 343#012#011RT::SearchBuilder::_DoSearch(‘RT::Scrips=HASH(0x7f6f630af280)’) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 504#012#011DBIx::SearchBuilder::Next(‘RT::Scrips=HASH(0x7f6f630af280)’) called at /opt/rt4/sbin/…/lib/RT/Scrips.pm line 129#012#011RT::Scrips::Next(‘RT::Scrips=HASH(0x7f6f630af280)’) called at /opt/rt4/sbin/…/lib/RT/Scrips.pm line 223#012#011RT::Scrips::Prepare(‘RT::Scrips=HASH(0x7f6f630af280)’, ‘Type’, ‘Create’, ‘TransactionObj’, ‘RT::Transaction=HASH(0x7f6f5db8ec50)’, ‘Ticket’, undef, ‘TicketObj’, ‘RT::Ticket=HASH(0x7f6f630a7ab8)’, …) called at /opt/rt4/sbin/…/lib/RT/Scrips.pm line 167#012#011RT::Scrips::Apply(‘RT::Scrips=HASH(0x7f6f630af280)’, ‘Stage’, ‘TransactionBatch’, ‘TicketObj’, ‘RT::Ticket=HASH(0x7f6f630a7ab8)’, ‘TransactionObj’, ‘RT::Transaction=HASH(0x7f6f5db8ec50)’, ‘Type’, ‘Create’, …) called at /opt/rt4/sbin/…/lib/RT/Ticket.pm line 3382#012#011RT::_ApplyTransactionBatch(‘RT::Ticket=HASH(0x7f6f630a7ab8)’) called at /opt/rt4/sbin/…/lib/RT/Ticket.pm line 3353#012#011RT::ApplyTransactionBatch(‘RT::Ticket=HASH(0x7f6f630a7ab8)’) called at /opt/rt4/sbin/…/lib/RT/Ticket.pm line 3423#012#011RT::DESTR