Postgres: 8.3.6
RT 3.8.2
CentOS 4
My graphing isn't working under ToolsReports.
Any ideas?
Cheers,
Kristian
/var/log/message
Mar 12 10:50:27 ghole postgres[11326]: [2-1] ERROR: function
lower(timestamp without time zone) does not exist at character 315
Mar 12 10:50:27 ghole postgres[11326]:
Hi Bill,
I really appreciate your time and helpful answers. They have certainly
pointed me in the right direction, and I'll update the list when I have it
solved.
It's been a bit of a challenge to make this run on Mac OS X, all kinds of
different preinstalled software points to that it 'should'
On Thu, Mar 12, 2009 at 11:00:21AM +, Kristian Davies wrote:
Postgres: 8.3.6
RT 3.8.2
CentOS 4
My graphing isn't working under ToolsReports.
Any ideas?
Cheers,
Kristian
/var/log/message
Mar 12 10:50:27 ghole postgres[11326]: [2-1] ERROR: function
lower(timestamp without
Unfortunately I'd already tried those. I did however get excellent
results from your full text search wiki page though.
Mar 12 12:48:19 ghole postgres[13129]: [2-1] ERROR: function
lower(timestamp without time zone) does not exist at character 259
Mar 12 12:48:19 ghole postgres[13129]: [2-2]
It looks like the problem is caused by trying to change the
case of a timestamp, which is nonsensical. Could you send me
a sample advanced search input that I could try with my setup
and queues to see if I can reproduce the problem locally?
You could also define a lower() function that does
Kristian,
I think the problem is in SearchBuilder/Handle.pm in the function
_MakeClauseCaseInsensitive. It looks like it only skips the lower()
for integer values. I think that you can replace the if test with
something like:
if ($value !~ /^[\d:- ]+$/) { # don't downcase integer values or
On Thu, Mar 12, 2009 at 08:44:23AM -0500, Kenneth Marshall wrote:
Kristian,
I think the problem is in SearchBuilder/Handle.pm in the function
_MakeClauseCaseInsensitive. It looks like it only skips the lower()
for integer values. I think that you can replace the if test with
something like:
Murat TAS wrote:
Hi,
We have RT 3.8.2 installed on Ubuntu Server 8.10
We have translate some words in /opt/rt3/lib/RT/I18N/tr.po file and
restarted the rt-server
But we did not see any change in the RT web interface..
Is there any other command to refresh the RT (i.e to reload the
Derek Cunningham wrote, On 3/12/09 8:30 AM:
Hi Bill,
I really appreciate your time and helpful answers. They have certainly
pointed me in the right direction, and I'll update the list when I have it
solved.
It's been a bit of a challenge to make this run on Mac OS X, all kinds of
Calvin Chiang wrote, On 3/5/09 4:04 AM:
HI
This has been happening just since this morning. When i add a link -
parent/child/referred etc the link appears fine. but when i
click-through, the url of the page is pointing to localhost e.g.
http://localhost/Ticket/Display.html?id=166
I can't seem to let this go. Comparing the Download (untitled) data
with my signature, I see that they are the same length and shape -- the
same number of characters on each line. That should be a big clue as to
the truncation problem, as well as the 'random' spaces in the middle of
words --
To all,
FIRST and FOREMOST!!! I am NOT a Unix guy. I know it runs on a server
and we have a Sparc server and our DataBase is Oracle 10g and we are on
RT 3.6.4.
However, I have NO IDEA how directories work when it comes to how an
install program looks for or defines where to go
Hi all. I've been an RT user for a short while now and I'm continuing
to dig deeper as we extend its use. Thanks to Jesse and team for a
product which delivers significant flexibility while preserving
simplicity of use.
Here's my current question: Is there an easy way to add logic such that
Hi Damon,
We have been using RT for a while and I think that you can
setup Scrips to do your stage validation at each step along
the way and prevent the ticket from moving to the next stage.
As far as the drop-down type input or input options revealed
when a selection is made, that sounds like
I have an installation of RT (3.6.4) on Oracle and am trying to write a
report (a modified MyDay report) that displays only those tickets that have
been updated by the current user within a given period. I can get a list of
all tickets that have been modified by setting:
$Query = LastUpdated
Is the MySQL schema upgrade for the 3.8.x series absolutely critical?
The perl script provided with RT (upgrade-mysql-schema.pl) requires
DBD::mysql 4.
However, RHEL5 comes with DBD::mysql 3.
I'm having a heck of a time trying to get DBD::mysql4 to install on RHEL5.
What have others done to
Kenneth Crocker wrote:
To all,
FIRST and FOREMOST!!! I am NOT a Unix guy. I know it runs on a server
and we have a Sparc server and our DataBase is Oracle 10g and we are on
RT 3.6.4.
However, I have NO IDEA how directories work when it comes to how an
install program looks
John Arends wrote:
Is the MySQL schema upgrade for the 3.8.x series absolutely critical?
The perl script provided with RT (upgrade-mysql-schema.pl) requires
DBD::mysql 4.
However, RHEL5 comes with DBD::mysql 3.
I'm having a heck of a time trying to get DBD::mysql4 to install on RHEL5.
It fails in all sorts of spectacular ways. I tried doing a manual
install, had trouble with that too. Since this step only needs to be
done once I'm just going to set up a throw away virtual machine and
force an RPM to install over the current version and use it to run the
script.
Tom Lahti
Damon Kenneth,
I copied /share/html/Elements/EditCustomField into
/local/html/Elements/EditCustomField and made these changes after line
76 (rt 3.6.4):
if ($Type eq Text) {
$Rows = 8;
$Cols = 50;
} elsif ($Type eq Wikitext) {
$Rows = 8;
$Cols = 50;
Joop,
Thanks for your response. I'll look in my several directories and see
if there are redundant perl modules. Thanks.
Kenn
LBNL
On 3/12/2009 1:04 PM, Joop van de Wege wrote:
Kenneth Crocker wrote:
To all,
FIRST and FOREMOST!!! I am NOT a Unix guy. I know it runs on a
Hello all,
I just wanted to point out that I've unraveled some more of the mysteries of
Offline edits, and documented them at
http://wiki.bestpractical.com/view/OfflineEdits
It's starting to look like a handy tool, and we hope to use it for
bulk ticket creation.
--
Cambridge Energy Alliance:
John Arends wrote:
It fails in all sorts of spectacular ways. I tried doing a manual
install, had trouble with that too. Since this step only needs to be
done once I'm just going to set up a throw away virtual machine and
force an RPM to install over the current version and use it to run
If you're working on something that's only for you then it's easier to
use $RT::Handle ( in 3.8 it should be written as RT-DatabaseHandle )
that returns connection to the DB. This object has SimpleQuery method
to execute any SQL. SimpleQuery returns sth (statement handle)
described in `perldoc
Thank you for putting it together. It's really appreciated.
On Fri, Mar 13, 2009 at 12:25 AM, Jerrad Pierce
jpie...@cambridgeenergyalliance.org wrote:
Hello all,
I just wanted to point out that I've unraveled some more of the mysteries of
Offline edits, and documented them at
Kenneth Crocker wrote, On 3/12/09 3:37 PM:
To all,
FIRST and FOREMOST!!! I am NOT a Unix guy. I know it runs on a server
and we have a Sparc server and our DataBase is Oracle 10g and we are on
RT 3.6.4.
However, I have NO IDEA how directories work when it comes to how an
Does anyone still have a copy of this? The website listed on
Contributions is gone,
and there's no archive.org entry for it...
--
Cambridge Energy Alliance: Save money. Save the planet.
___
On Thu, Mar 12, 2009 at 1:51 PM, Kenneth Marshall k...@rice.edu wrote:
On Thu, Mar 12, 2009 at 08:44:23AM -0500, Kenneth Marshall wrote:
Kristian,
I think the problem is in SearchBuilder/Handle.pm in the function
_MakeClauseCaseInsensitive. It looks like it only skips the lower()
for integer
28 matches
Mail list logo