Re: [rt-users] Only some searches in RT fail (Sphinx)
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
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
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?
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
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?
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?
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