Dear list
I have the RT almost up and running on a Mac OS X Server. But I ran in
another problem.
Replying to tickets isn't possible yet. The mails aren't sent to the
requestor. I've seen lots of strange error message in the apache2
error_log (several Scrip Prepare died). But I don't
Please, run the following SQL query:
SELECT u.Name, txn.Field, txn.ReferenceType, txn.NewReference, t.id
tid FROM Tickets t JOIN Transactions txn ON txn.Type = 'AddWatcher'
AND txn.ObjectType = 'RT::Ticket' AND txn.ObjectId = t.id LEFT JOIN
Users u ON u.id = txn.NewValue WHERE t.id = X;
Jesse et al:
With a bit of coaxing, the tools - off line item from RT's
main menu,
will take a tab-separated spreadsheet in the same format as
RT's export
to spreadsheet search result functionality.
Since the spreadsheet I have is in a proprietary format, I wrote a Perl
script that would
Ruslan,
I will do this as soon as I get to work tonight.
Mathew
Ruslan Zakirov wrote:
Please, run the following SQL query:
SELECT u.Name, txn.Field, txn.ReferenceType, txn.NewReference, t.id
tid FROM Tickets t JOIN Transactions txn ON txn.Type = 'AddWatcher'
AND txn.ObjectType =
Am I correct in assuming that all the txn and u and such are just
abbreviations and need to be replaced with Users and Transactions in the
actual query?
Mathew
Ruslan Zakirov wrote:
Please, run the following SQL query:
SELECT u.Name, txn.Field, txn.ReferenceType, txn.NewReference, t.id
tid
On 2/8/07, Mathew [EMAIL PROTECTED] wrote:
Am I correct in assuming that all the txn and u and such are just
abbreviations and need to be replaced with Users and Transactions in the
actual query?
Yes, it's aliases, but you shouldn't replace anything except as
it's SQL's feature. Look into
On Feb 8, 2007, at 1:02 AM, Mathew Snyder wrote:
Shredder doesn't like when an email address contains either a
single- or
double-qoute. Understandably so considering this messes with Perl
and makes it
look for a closing, matching mark. This makes me wonder if it is
possible to
I don't
I've updated the Scalar-List-Util from 1.18 to 1.19 and this fixed my
problem with the scrips.
Thx anyway.
Ruslan Zakirov wrote:
Several reasons
1) the module has been installed from bad binary package, reinstall it
from CPAN or compile package yourself
2) perl and libperl have been with
Well, i did run the script too but ill run it again.
On 2/7/07, Jesse Vincent [EMAIL PROTECTED] wrote:
fname lname wrote:
Im getting an error when i go to the global / RT at a glance error .
error: Can't call method Content on an undefined value at
Hi.
I need to set up a parallel 'everyone' group so that I can give the new
group CreateTicket on most-but-not-all-queues, revoke CreateTicket from
Everyone, and not have to update 2 places when I add a new user - and so
that I don't have to do anything special for auto-created users when
someone
Hello,I'm new to RT so maybe this seems obvious to you, but since I installed
RT (on Windows) I've got this problem:In my company we use internally an
e-mailaddress that sends to every mailbox in the domain.Let's say it's the
address: everybody AT ourdomain.comEverybody means everybody and so
It is definitely the email portion and not the RT username portion.
When I get to work tonight I will create a user with an email address
such as the one I describe so I can reproduce the error. I'll post it here.
Mathew
der Mouse wrote:
Shredder doesn't like when an email address contains
I pushed the schema and everything is working. I installed vi yum on
fc6. plus i was upgrading from and old mysql database. So i done all
the 3.1.0/ 3.1.15/ 3.1.17/ 3.3.0/ 3.3.11/ 3.5.1/ updates via
rt-setup-database and just did an --action schema --datafile
schema.mysql
and now this are
http://wiki.bestpractical.com/?EmailInterface has several solutions,
you can either merge your solution with one those or create new page
for it.
On 2/8/07, Daniel Collis-Puro [EMAIL PROTECTED] wrote:
Folks,
We've been using RT for over a year - and it's saved us much time. Thanks.
I hacked
This query has me confused. There are lowercase letters placed by themselves in
locations I'm not used to seeing criteria placed. Can someone please clarify
what I'm supposed to enter?
Mathew
Ruslan Zakirov wrote:
Please, run the following SQL query:
SELECT u.Name, txn.Field,
I'm just trying to help you figure out what had happened with your
tickets and as well gather debug info to fix shredder.
To get debug infon you have to run the following query from mysql or
Pg shell, but first of all you should find a ticket that generate that
error you posted and replace
I know. I just didn't understand the SQL syntax.
Mathew
Ruslan Zakirov wrote:
I'm just trying to help you figure out what had happened with your
tickets and as well gather debug info to fix shredder.
To get debug infon you have to run the following query from mysql or
Pg shell, but first
There's no need for hostilities.
Mathew
Ruslan Zakirov wrote:
On 2/9/07, Mathew Snyder [EMAIL PROTECTED] wrote:
I know. I just didn't understand the SQL syntax.
And? Should I describe it? I don't think so. Google for 'Learning SQL'.
Mathew
Ruslan Zakirov wrote:
I'm just trying to
It would appear I removed someone that was added as a CC:
++---+---+--+---+
| Name | Field | ReferenceType | NewReference | tid |
++---+---+--+---+
| NULL | Cc| NULL | NULL |
I created a user called, for no reason in particular,
splat'[EMAIL PROTECTED] The error received is:
sh: -c: line 0: unexpected EOF while looking for matching `''
Eek! It's a *shell* reading that?
Perhaps try for [EMAIL PROTECTED] and see what happens! This could
have pretty hair-raising
That might be what the problem is actually. I still haven't figured out how to
use the methods of Shredder in order to run it entirely within the script so
right now Shredder runs as a 'system' call.
Mathew
der Mouse wrote:
I created a user called, for no reason in particular,
splat'[EMAIL
[top-posting damage repaired manually -dM]
SELECT u.Name, txn.Field, txn.ReferenceType, txn.NewReference, t.id
tid FROM Tickets t JOIN Transactions txn ON txn.Type = 'AddWatcher'
AND txn.ObjectType = 'RT::Ticket' AND txn.ObjectId = t.id LEFT JOIN
Users u ON u.id = txn.NewValue WHERE t.id =
Several reasons
1) the module has been installed from bad binary package, reinstall it
from CPAN or compile package yourself
2) perl and libperl have been with different options
On 2/8/07, Thomas Koch [EMAIL PROTECTED] wrote:
Dear list
I have the RT almost up and running on a Mac OS X Server.
On 2/9/07, Mathew Snyder [EMAIL PROTECTED] wrote:
It would appear I removed someone that was added as a CC:
++---+---+--+---+
| Name | Field | ReferenceType | NewReference | tid |
++---+---+--+---+
|
I'm terribly sorry bu here is more correct queries:
SELECT p.id, p.PrincipalType, txn.id txn_id, txn.Field, txn.NewValue,
txn.ReferenceType, txn.NewReference, t.id tid FROM Tickets t JOIN
Transactions txn ON txn.Type = 'AddWatcher' AND txn.ObjectType =
'RT::Ticket' AND txn.ObjectId = t.id LEFT
The results of each query are attached as .txt files.
Ruslan Zakirov wrote:
I'm terribly sorry bu here is more correct queries:
SELECT p.id, p.PrincipalType, txn.id txn_id, txn.Field, txn.NewValue,
txn.ReferenceType, txn.NewReference, t.id tid FROM Tickets t JOIN
Transactions txn ON
Ok, I've got all info I needed. Thanks.
Now you can delete these transactions and get rid of those errors.
If you're using mysql 4.1 and greater then you can use the following queries:
DELETE txn FROM Transactions txn LEFT JOIN Principals p ON (
txn.NewValue = p.id ) WHERE txn.Type =
sweet. Thanks Ruslan. I'll have to print all of this out for future use
because I KNOW it will come up again... se la vie
Thanks again.
Ruslan Zakirov wrote:
Ok, I've got all info I needed. Thanks.
Now you can delete these transactions and get rid of those errors.
If you're using mysql
28 matches
Mail list logo
