AW: Re: [Rt-devel] RTFM

[ml at charliesangels.biz]

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::Tickets::Next('RT::Tickets=HASH(0xa2bfcf4)') called at /opt/rt3/lib/RT/Tickets_Overlay.pm line 2523
        RT::Tickets::ItemsArrayRef('RT::Tickets=HASH(0xa2bfcf4)') called at /opt/rt3/lib/RT/Tickets_Overlay.pm line 2836
        RT::Tickets::_BuildItemMap('RT::Tickets=HASH(0xa2bfcf4)') called at /opt/rt3/lib/RT/Tickets_Overlay.pm line 2867
        RT::Tickets::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

>'/Elements/TitleBoxStart' component was moved and refactored, but in
>3.6.0preX there were added thin wrapper for backward compatibility.
>Try 3.6.0preX.
>
>On 4/18/06, ml at charliesangels.biz <ml at charliesangels.biz> wrote:
>> Hi List,
>>
>> I am a bit desperate: I am trying to install RT 3.5.7 along with 
>RTFM-2.2.0RC2 on a Fedora Core 4 Box. So fax install runs smoothly, but 
>whenever I try to klick on RTFM in RT´s Web-Interface I get:
>>
>> error:          could not find component for path '/Elements/TitleBoxStart'
>> context:
>> ...
>> 15:     %# GNU General Public License for more details.
>> 16:     %#
>> 17:     %# END LICENSE BLOCK
>> 18:
>> 19:     <& /Elements/TitleBoxStart, title => loc("[_1] newest articles", 
>$rows), bodyclass=> '' &>
>> 20:     <TABLE BORDER=0 cellspacing=0 cellpadding=1 WIDTH=100%>
>> 21:     <TR>
>> 22:     <TH ALIGN=RIGHT><&|/l&>#</&></TH>
>> 23:     <TH ALIGN=LEFT><&|/l&>Name</&></TH>
>> ...
>> code stack:     /opt/rt3/share/html/RTFM/Elements/NewestArticles:19
>> /opt/rt3/share/html/RTFM/index.html:24
>> /opt/rt3/share/html/autohandler:247
>>
>> Any idea why this occurs ?
>>
>> Thanks and regards
>> Sascha
>> _______________________________________________
>> List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
>>
>> Best Practical is hiring! Come hack Perl for us: 
>http://bestpractical.com/about/jobs.html
>>
>
>
>--
>Best regards, Ruslan.