Hi Ruslan,
thanks for the hint !
Now I got RT up and running along with RTFM and RTIR but Merge fails.
If i try to merge i get something like
Merge Block #1: test
* Refine
* Antworten
* · Kommentar
* · Extract Article
SCALAR(0xa385ff0)
With Debug-Log enabled I get tons of messages when I try to merge:
[Wed Apr 19 14:15:44 2006] [warning]: DBD::mysql::st execute failed: Unknown column ‘main.name’ in ‘where clause’ at /usr/lib/perl5/site_perl/5.8.6/DBIx/Se
archBuilder/Handle.pm line 492. (/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm:492)
[Wed Apr 19 14:15:44 2006] [warning]: RT::Handle=HASH(0xa2e379c) couldn’t execute the query 'SELECT DISTINCT main.* FROM (((Tickets main LEFT JOIN ObjectC
ustomFields ObjectCustomFields_1 ON ( ObjectCustomFields_1.ObjectId = main.Queue) OR ( (ObjectCustomFields_1.ObjectId = ‘0’))) LEFT JOIN CustomFields Cus
tomFields_2 ON ( CustomFields_2.id = ObjectCustomFields_1.CustomField)) LEFT JOIN ObjectCustomFieldValues ObjectCustomFieldValues_3 ON ( ObjectCustomFie
ldValues_3.CustomField = CustomFields_2.id) AND ( (ObjectCustomFieldValues_3.ObjectId = main.id)) AND ( (ObjectCustomFieldValues_3.Disabled = ‘0’)) AND ( (
ObjectCustomFieldValues_3.ObjectType = ‘RT::Ticket’))) WHERE ((CustomFields_2.name = ‘_RTIR_State’)) AND ((main.EffectiveId = main.id)) AND ((main.Status
!= ‘deleted’)) AND ((main.Type = ‘ticket’)) AND ((main.name = ‘_RTIR_State’)AND(main.name = ‘_RTIR_State’)) AND ((main.Queue = ‘6’)AND(main.id != ‘1’)AND
( ( ( (ObjectCustomFieldValues_3.Content = ‘pending activation’) ) OR ( (ObjectCustomFieldValues_3.Content = ‘active’) ) OR ( (ObjectCustomFieldValues_3.
Content = ‘pending removal’) ) ) ) ) ORDER BY main.id ASC ’ at /usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 505
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0xa2e379c)’, ‘SELECT DISTINCT main.* FROM (((Tickets main LEFT JOIN Object…’) called a
t /usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder.pm line 231
DBIx::SearchBuilder::_DoSearch(‘RT::Tickets=HASH(0xa2bfcf4)’) called at /usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder.pm line 491
DBIx::SearchBuilder::Next(‘RT::Tickets=HASH(0xa2bfcf4)’) called at /opt/rt3/lib/RT/Tickets_Overlay.pm line 2541
RT:
:Next(‘RT::Tickets=HASH(0xa2bfcf4)’) called at /opt/rt3/lib/RT/Tickets_Overlay.pm line 2523
RT::ItemsArrayRef(‘RT::Tickets=HASH(0xa2bfcf4)’) called at /opt/rt3/lib/RT/Tickets_Overlay.pm line 2836
RT::_BuildItemMap(‘RT::Tickets=HASH(0xa2bfcf4)’) called at /opt/rt3/lib/RT/Tickets_Overlay.pm line 2867
RT::ItemMap(‘RT::Tickets=HASH(0xa2bfcf4)’) called at /opt/rt3/share/html/RTIR/Elements/QueueTabs line 53
HTML::Mason::Commands::ANON(‘QueueName’, ‘Blocks’, ‘Ticket’, ‘RT::Ticket=HASH(0xa0d8b28)’, ‘current_subtab’, ‘RTIR/Merge.html?id=1&Order=ASC&Qu
ery=(%20'CF.%7B_RTIR_State%…’, ‘Rows’, 50, ‘path’, …) called at /usr/lib/perl5/vendor_perl/5.8.6/HTML/Mason/Component.pm line 135
I can post the full output if neccessary.
Any ideas ?
Thanks and regards
Sascha