Re: [rt-users] Only some searches in RT fail (Sphinx)

2014-07-03 Thread Daniel Eiteneuer
Thanks a lot for pointing me to this commit:
https://github.com/bestpractical/rt/commit/378c7e352916494000db735fae550f22eae2b5e7

This solved my problem. Now the searches run without errors. But I have another 
problem related to the sphinx search.
If I search for tickets within the RT with these conditions:

Subject LIKE 'something'
OR Content LIKE 'something'

I get 11 search results. Then I narrow the search condition to 

Content LIKE 'something'

and I get 242 results.
I think this is not possible, is it? For the search term I've used, 242 
matching tickets seems reasonable.

Regards
Daniel

-Ursprüngliche Nachricht-
Von: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von 
Kevin Falcone
Gesendet: Mittwoch, 2. Juli 2014 20:46
An: rt-users@lists.bestpractical.com
Betreff: Re: [rt-users] Only some searches in RT fail (Sphinx)

On Wed, Jul 02, 2014 at 02:19:40PM +, Daniel Eiteneuer wrote:
 But the main problem occurs, if I just search for something in the tickets'
 content (not the subjects). The webinterface tells me, there are 0 
 results. The apache error log states:
 
  
 
 [4387] [Wed Jul  2 14:11:19 2014] [warning]: DBD::mysql::st execute failed:
 There was a problem processing the query on the foreign data source. 
 Data source error: INTERNAL ERROR: 1st column must be bigint to accept 
 64-bit DOCID at 
 /usr/local/share/perl/5.18.2/DBIx/SearchBuilder/Handle.pm line 589. 
 (/usr/
 local/share/perl/5.18.2/DBIx/SearchBuilder/Handle.pm:589)
  
 
 Does anyone knows, how to solve this problem?

Replace the id column of the AttachmentsIndex table with a BIGINT column.  Fix 
included in the upcoming 4.2.6rc1

https://github.com/bestpractical/rt/commit/378c7e352916494000db735fae550f22eae2b5e7

-kevin
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training


[rt-users] Upload multiple files customfield in Articles : no content

2014-07-03 Thread Daniel Eiteneuer
Hello,
I found this mail in the archive:

On Tue, Nov 06, 2012 at 09:42:05AM +0100, L B wrote:
I have an article with an Upload multiple files custom field. I have 
 defined two PDFs in my
article for this custom field.
When I try to use the article in a RT reply, I just see the two file names 
 but not the
content. I don't see many other ways to make it work.
Is it normal / a bug / a feature ?

Articles do not support attaching files from upload files/images CFs.

-kevin


Is it planned to change this behaviour? Would be a great feature.
If the above does not work, then what's the purpose of these file attachments 
in articles?

Regards
Daniel
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

Re: [rt-users] Upload multiple files customfield in Articles : no content

2014-07-03 Thread Kevin Falcone
On Thu, Jul 03, 2014 at 08:00:09AM +, Daniel Eiteneuer wrote:
 Is it planned to change this behaviour? Would be a great feature.

Sure, but we have a lot of features to work on, so until it makes it
to the top of our list, or becomes a priority for a client, it'll have
to wait for resource allocation.

 If the above does not work, then what's the purpose of these file attachments
 in articles?

People use articles as a type of wiki, when visiting an Article, those
attachments are available for download.

-kevin


pgp82P7iE5Ps8.pgp
Description: PGP signature
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

Re: [rt-users] how to unset a ticket's Due date?

2014-07-03 Thread Kevin Falcone
Just for the mailing list records, a fix for this regression has been
merged to 4.2-trunk and will be in 4.2.6

-kevin


pgpghlyiQvevP.pgp
Description: PGP signature
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

Re: [rt-users] NotifyActor doesn't work anymore

2014-07-03 Thread Kevin Falcone
On Thu, Jul 03, 2014 at 06:55:40AM -0700, martiniano wrote:
 i am using RT Version 4.0.11 
 i have turned the debug option on but where can i see some info about the
 notifyactor?

This log covers a lot of activity.
Which transaction on which ticket (you can hover over the # in ticket
history to see a transaction id) did you expect to generate mail, and
to whom.  Without that information, it's hard to dig through your
whole log.  Later RT releases (in the 4.2 series) have better logging
here.

-kevin


pgptEfMdl7uUq.pgp
Description: PGP signature
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

[rt-users] Spreadsheet view?

2014-07-03 Thread Keith Creasy
It would be very nice if RT had a spreadsheet view for administrators. My use 
case is in editing and adjusting time estimates. Doing this one ticket at a 
time is very time consuming so if there wer a spreadsheet view or an editable 
search things could be done much more efficiently.


Keith

-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

Re: [rt-users] Spreadsheet view?

2014-07-03 Thread Alex Peters
In earlier versions of RT, an Offline tool existed which would allow a
user to display the summaries of a set of tickets in an editable text box.
 It wasn't exactly a spreadsheet, but it would permit quick and easy
updating of many fields across many tickets in a manner that was easy
enough to understand.  I believe its removal was due to neglect.

I wonder if that tool will ever make a comeback (even if only as an
extension?), because it was definitely handy for this exact scenario.  I
too find myself spending a lot of time clicking through screens to set up
dependencies, time estimates etc.


On 4 July 2014 00:44, Keith Creasy kcre...@aph.org wrote:

  It would be very nice if RT had a spreadsheet view for administrators.
 My use case is in editing and adjusting time estimates. Doing this one
 ticket at a time is very time consuming so if there wer a spreadsheet view
 or an editable search things could be done much more efficiently.





 Keith



 --
 RT Training - Boston, September 9-10
 http://bestpractical.com/training

-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training