All
I ran this issue by one of our DBAs and this is his comment:
Charles,
The problem with the following query is that the summary statement
(GROUP BY) references the wrong column. The query is doing a summary
count by user name. The table.column_name in the SELECT clause has to
On 14 Apr 2009, at 3:09 pm, Asif Iqbal wrote:
On Tue, Nov 18, 2008 at 10:37 PM, Tim Cutts t...@sanger.ac.uk wrote:
On 18 Nov 2008, at 3:27 pm, Asif Iqbal wrote:
What switches did you use to dump the mysql? I see few gotcha's about
using binary characters
and separate dump for attachment
On Thu, Apr 16, 2009 at 7:36 PM, Tim Cutts t...@sanger.ac.uk wrote:
On 14 Apr 2009, at 3:09 pm, Asif Iqbal wrote:
On Tue, Nov 18, 2008 at 10:37 PM, Tim Cutts t...@sanger.ac.uk wrote:
On 18 Nov 2008, at 3:27 pm, Asif Iqbal wrote:
What switches did you use to dump the mysql? I see few
SELECT COUNT(main.id) AS id,
Users_2.Name AS col1
FROM Tickets main
LEFT JOIN Users Users_2 ON ( Users_2.id = main.Owner )
LEFT JOIN Users Users_1 ON ( Users_1.id = main.Owner )
WHERE (main.Status != 'deleted')
AND (main.Status = 'resolved' AND main.Queue = '5')
AND
On Wed, Nov 19, 2008 at 8:08 PM, Tim Cutts t...@sanger.ac.uk wrote:
On 18 Nov 2008, at 4:47 pm, Tim Cutts wrote:
What switches did you use to dump the mysql? I see few gotcha's about
using binary characters
and separate dump for attachment table and stuff
OK, yes, I've just looked at
Asif, it's getting really hard to tell whose writing what with the way you
are quoting/replying to emails. It sounds like you are trying to not only
upgrade RT but also move your database from mysql 4.x.x to 5.x.x.
I would start by getting your current RT database dumped and successfully
moved
Hi All,
I am trying to figure out why External Authentication in my production
RT (version 3.6) works, but the test server I set up using (version
3.8.2) is not authenticating against the same ldap server? I followed
the steps in http://wiki.bestpractical.com/view/ExternalAuth and yet it
is
John,
Thanks for the reply.
I honestly have no idea what would be the best way (or the correct way
for that matter) to do this query (my specialty is actually in
networking, not database engineering).
The problem is simply that out of the box, 2 of the 3 reports fail to
produce any results
Hi,
I have an user that has multiple email addresses and would like to send in
requests from all of them. From example:
asm...@company.com
asm...@gmail.com
Currently I have AD working fine but don't want to set up another Auth source.
How can I do this?
Thanks
Michael Mai
I have a couple of things my users are asking me to change about the way
RT displays the ticket history. Any help on any of these would be
greatly appreciated.
1.) Email submissions are double spaced. This takes up a lot of room
when viewing the ticket history.
2.) Top posting - can the most
1.) Email submissions are double spaced. This takes up a lot of room
when viewing the ticket history.
They aren't in my RT. Without knowing what's causing it in your
installation, there's no way to know how to fix it.
You could make a local Display.html that unwraps the text and then rewraps
Steve OBrien wrote:
I have a couple of things my users are asking me to change about the way
RT displays the ticket history. Any help on any of these would be
greatly appreciated.
2.) Top posting - can the most recent actions be on top so you don't
have to scroll all the way down to see
I believe this issue has been fixed in 3.8.HEAD, please test first RC
when it will be available.
On Mon, Apr 13, 2009 at 8:25 PM, Charles Kugelman
charles.kugel...@kaplan.com wrote:
All,
It’s been pointed out that the “Resolved by owner” report isn’t outputting
results. I looked in the RT
Please ignore my previous email. I solved my problem.
Hossein
Hossein Rafighi wrote:
Hi All,
I am trying to figure out why External Authentication in my production
RT (version 3.6) works, but the test server I set up using (version
3.8.2) is not authenticating against the same ldap
Another suggestion from my pilot group is that they would like tickets
to automatically change status from new to open when taken. Any help
accomplishing that would be appreciated.
TIA,
Steve
___
On Thu, 2009-04-16 at 14:42 -0700, Tom Lahti wrote:
1.) Email submissions are double spaced. This takes up a lot of room
when viewing the ticket history.
They aren't in my RT. Without knowing what's causing it in your
installation, there's no way to know how to fix it.
It just seems to
Hmmm, I will have to look at that. Seems like it might be hard to
discern the sig from the rest of the email.
Convention dictates that signatures be preceded by a line matching
-- \n i.e; 0x2d0x2d0x200x0a
Of course, not everyone follows it.
--
Cambridge Energy Alliance: Save money. Save the
Steve OBrien wrote:
Another suggestion from my pilot group is that they would like tickets
to automatically change status from new to open when taken. Any help
accomplishing that would be appreciated.
It's not really open until someone actually works on it, is it? Seems like
a semantic issue
3.) Stripping out the signatures from emails. Is it possible?
Two options: hack rt-mailgate to strip them before inserting into the
database, or make a local Display.html History.html to display it without
the signatures. The latter is probably safer in that if your parsing is
wrong, you
On Thu, 2009-04-16 at 16:52 -0700, Tom Lahti wrote:
It's not really open until someone actually works on it, is it? Seems like
a semantic issue to me. New means its recorded and waiting for
activity, open means its being worked on. If its just assigned and no
activity, its not being worked
That's exactly what I told them, but they told me that they pick up the
ticket and are working on it and then enter in the details when they are done.
They don't have to enter details. Once they do something meaningful on
the ticket, RT will automagically set it to open.
--
Cambridge Energy
http://wiki.bestpractical.com/view/CustomConditionSnippets
On Fri, Apr 17, 2009 at 3:32 AM, Steve OBrien steve.obr...@hdesd.org wrote:
Another suggestion from my pilot group is that they would like tickets
to automatically change status from new to open when taken. Any help
accomplishing that
I'm trying to shred users without tickets (from spam), and have run
into a rarely reported error
(one of the few mentions of it on the lists was by me, in a different context).
The user is 729, and the user was actually an alternate email address for one
of our queues that got auto-created
23 matches
Mail list logo