[Rt-devel] bug on chart ? on RT3.8 postrgresql 8.3
jul
jul-rt at julbox.net
Wed Mar 11 20:43:35 EDT 2009
Hello everyone,
New to the list, (should lurk before post, I know)
after having installed rt3.8 from
deb http://debian.etc.gen.nz etch rt
with a postgresql 8.3
with a rt 3.8 version I have when trying to graph data based on time the
following error in my log
Mar 11 18:29:03 XXXXXXX RT: RT::Handle=HASH(0x3204970) couldn't execute
the query 'SELECT COUNT(main.id) AS id, SUBSTR(LastUpdated,1,10) AS
lastupdateddaily FROM Tickets main WHERE (main.Status != 'deleted') AND
(main.id > '0') AND (main.Type = 'ticket') AND (main.EffectiveId =
main.id) GROUP BY SUBSTR(LastUpdated,1,10) ' at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 518
^IDBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x3204970)',
'SELECT COUNT(main.id) AS id, SUBSTR(LastUpdated,1,10) AS last...') called
at /usr/share/perl5/DBIx/SearchBuilder.pm line 238
^IDBIx::SearchBuilder::_DoSearch('RT::Report::Tickets=HASH(0x5811660)')
called at /usr/share/request-tracker3.8/lib/RT/Report/Tickets.pm line 164
^IRT::Report::Tickets::_DoSearch('RT::Report::Tickets=HASH(0x5811660)')
called at /usr/share/perl5/DBIx/SearchBuilder.pm line 498
^IDBIx::SearchBuilder::Next('RT::Report::Tickets=HASH(0x5811660)') called
at /usr/share/request-tracker3.8/lib/RT/Report/Tickets.pm line 228
^IRT::Report::Tickets::Next('
So I opened pgsql to find that
SELECT count(main.id) AS id, substr( CAST ( LastUpdated AS TEXT ) , 1 ,10
) AS lastupdateddaily FROM Tickets main WHERE (main.Status != 'deleted')
AND (main.id > '0') AND (main.Type = 'ticket') AND (main.EffectiveId =
main.id) GROUP BY substr( CAST ( LastUpdated AS TEXT ) , 1 ,10 )
Worked better.
Is this an old bug or a current one ? How can I patch my rt so that the
cast is included ?
Here come sys config from RT page :
Perl v5.10.0 under linux
Apache::Session v1.86;
Apache::Session::Generate::MD5 v2.1;
Apache::Session::Lock::Null v1.01;
Apache::Session::Postgres v1.01;
Apache::Session::Serialize::Base64 v1.01;
Apache::Session::Store::DBI v1.02;
Apache::Session::Store::Postgres v1.03;
AutoLoader v5.63;
base v2.13;
bytes v1.03;
Cache::Simple::TimedExpiry v0.27;
Carp v1.08;
CGI v3.29;
CGI::Cookie v1.28;
CGI::Util v1.5_01;
Class::Container v0.12;
Class::Data::Inheritable v0.08;
Class::Inspector v1.23;
Class::ReturnValue v0.55;
Clone v0.28;
constant v1.13;
Cwd v3.2701;
Data::Dumper v2.121_14;
Date::Format v2.22;
Date::Parse v2.27;
DateTime v0.42;
DateTime::Locale v0.35;
DateTime::Set v0.25;
DateTime::TimeZone v0.7701;
DateTime::TimeZone::Floating v0.01;
DateTime::TimeZone::Local v0.01;
DateTime::TimeZone::OffsetOnly v0.02;
DateTime::TimeZone::UTC v0.01;
DBD::Pg v2.8.2;
DBI v1.605;
DBIx::SearchBuilder v1.53;
DBIx::SearchBuilder::Union v0;
DBIx::SearchBuilder::Unique v0.01;
Devel::StackTrace v1.1901;
Devel::StackTraceFrame v1.1901;
Digest::base v1.00;
Digest::MD5 v2.36_01;
DynaLoader v1.08;
Email::Address v1.889;
Encode v2.23;
Encode::Alias v2.07;
Encode::Config v2.04;
Encode::Encoding v2.05;
Errno v1.1;
Exception::Class v1.24;
Exception::Class::Base v1.2;
Exporter v5.62;
Exporter::Heavy v5.62;
Fcntl v1.06;
File::Basename v2.76;
File::Glob v1.06;
File::Path v2.04;
File::ShareDir v0.05;
File::Spec v3.2701;
File::Spec::Unix v3.2701;
File::Temp v0.18;
FileHandle v2.01;
GD v2.39;
GD::Graph v1.44;
GD::Graph::colour v1.10;
GD::Graph::Data v1.22;
GD::Graph::Error v1.8;
GD::Graph::pie v1.21;
GD::Graph::utils v1.7;
GD::Image v2.27;
GD::Text v0.86;
GD::Text::Align v1.18;
GraphViz v2.03;
HTML::Element v3.23;
HTML::Entities v1.35;
HTML::Formatter v2.04;
HTML::FormatText v2.04;
HTML::Mason v1.36;
HTML::Mason::CGIHandler v1.00;
HTML::Mason::Exception v1.1;
HTML::Mason::Exception::Abort v1.1;
HTML::Mason::Exception::Compilation v1.1;
HTML::Mason::Exception::Compilation::IncompatibleCompiler v1.1;
HTML::Mason::Exception::Compiler v1.1;
HTML::Mason::Exception::Decline v1.1;
HTML::Mason::Exception::Params v1.1;
HTML::Mason::Exception::Syntax v1.1;
HTML::Mason::Exception::System v1.1;
HTML::Mason::Exception::TopLevelNotFound v1.1;
HTML::Mason::Exception::VirtualMethod v1.1;
HTML::Mason::Exceptions v1.43;
HTML::Parser v3.56;
HTML::Scrubber v0.08;
HTML::Tagset v3.20;
HTML::TreeBuilder v3.23;
I18N::LangTags v0.35;
integer v1.00;
IO v1.23_01;
IO::File v1.14;
IO::Handle v1.27;
IO::InnerFile v2.110;
IO::Lines v2.110;
IO::ScalarArray v2.110;
IO::Seekable v1.1;
IO::WrapTie v2.110;
IPC::Open2 v1.02;
IPC::Open3 v1.02;
IPC::Run v0.80;
List::Util v1.19;
Locale::Maketext v1.12;
Locale::Maketext::Fuzzy v0.02;
Locale::Maketext::Lexicon v0.66;
Locale::Maketext::Lexicon::Gettext v0.16;
Log::Dispatch v2.18;
Log::Dispatch::Base v1.09;
Log::Dispatch::Output v1.26;
Log::Dispatch::Screen v1.17;
Log::Dispatch::Syslog v1.18;
Mail::Address v2.03;
Mail::Field v2.03;
Mail::Field::AddrList v2.03;
Mail::Field::Date v2.03;
Mail::Field::Generic v2.03;
Mail::Header v2.03;
Mail::Internet v2.03;
Mail::Mailer v2.03;
Mail::Util v2.03;
MIME::Base64 v3.07_01;
MIME::Body v5.426;
MIME::Decoder v5.426;
MIME::Entity v5.426;
MIME::Field::ContDisp v5.426;
MIME::Field::ConTraEnc v5.426;
MIME::Field::ContType v5.426;
MIME::Field::ParamVal v5.426;
MIME::Head v5.426;
MIME::Parser v5.426;
MIME::QuotedPrint v3.07;
MIME::Tools v5.426;
MIME::Words v5.426;
Module::Versions::Report v1.05;
overload v1.06;
Params::Util v0.30;
Params::Validate v0.91;
POSIX v1.13;
re v0.08;
Regexp::Common v2.122;
Regexp::Common::delimited v2.106;
RT v3.8.1;
RT::Extension::Timeline v0.03;
RT::Interface::Email v2;
RT::Interface::Web::Request v0.30;
RTx::Calendar v0.06;
RTx::EmailCompletion v0.05;
Scalar::Util v1.19;
SelectSaver v1.01;
Set::Infinite v0.61;
Socket v1.80;
Storable v2.18;
strict v1.04;
Symbol v1.06;
Sys::Syslog v0.22;
Text::Template v1.44;
Text::Wrapper v1.02;
Tie::Hash v1.02;
Time::HiRes v1.9711;
Time::JulianDay v2003.1125;
Time::Local v1.18;
Time::ParseDate v2006.0814;
Time::Timezone v2006.0814;
Time::Zone v2.22;
UNIVERSAL v1.04;
UNIVERSAL::require v0.11;
URI v1.35;
URI::Escape v3.28;
utf8 v1.07;
vars v1.01;
version v0.74;
Want v0.18;
warnings v1.06;
warnings::register v1.01;
XSLoader v0.08;
RT Config
ActiveStatus new, open, stalled
Active_MakeClicky
AmbiguousDayInFuture 0
AmbiguousDayInPast 0
AutoLogoff 0
CanonicalizeOnCreate 0
CanonicalizeRedirectURLs 0
CommentAddress rt-comment at ftth-sfr.net
CorrespondAddress rt at ftth-sfr.net
CustomFieldValuesSources
DashboardAddress
DashboardSubject %s Dashboard: %s
DatabaseHost localhost
DatabaseName rt3
DatabasePassword Password not printed
DatabasePort
DatabaseRTHost localhost
DatabaseType Pg
DatabaseUser rt_user
DateDayBeforeMonth 1
DateTimeFormat DefaultFormat
DefaultSearchResultFormat '<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
'<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__Subject__</a></B>/TITLE:Subject',
Status, QueueName, OwnerName, Priority, '__NEWLINE__', '',
'<small>__Requestors__</small>', '<small>__CreatedRelative__</small>',
'<small>__ToldRelative__</small>',
'<small>__LastUpdatedRelative__</small>', '<small>__TimeLeft__</small>'
DefaultSummaryRows 10
DevelMode 0
EmailCompletionUnprivileged everybody
EmailFrequency Individual messages
EmailInputEncodings utf-8, iso-8859-1, us-ascii
EmailOutputEncoding utf-8
EnableReminders 1
ExtractSubjectTagMatch Regexp
ExtractSubjectTagNoMatch Regexp
ForwardFromUser 0
FriendlyFromLineFormat "%s via RT" <%s>
FriendlyToLineFormat "%s of rt.ftth-sfr.net Ticket #%s":;
GnuPG Enable, 0, AllowEncryptDataInDB, 0, OutgoingMessagesFormat, RFC
GnuPGOptions homedir, /var/cache/request-tracker3.8/data/gpg
HomepageComponents QuickCreate, Quicksearch, MyAdminQueues,
MySupportQueues, MyReminders, RefreshHomepage, Dashboards
InactiveStatus resolved, rejected, deleted
LexiconLanguages *
LinkTransactionsRun1Scrip 0
LogDir /var/log/request-tracker3.8
LogStackTraces
LogToFileNamed rt.log
LogToScreen info
LogToSyslog info
LogToSyslogConf
LogoURL /rt/NoAuth/images/sfr.jpg
LoopsToRTOwner 1
MailCommand sendmailpipe
MailParams
MasonParameters
MaxAttachmentSize 10000000
MaxInlineBody 12000
MessageBoxHeight 15
MessageBoxRichText 1
MessageBoxWidth 72
MessageBoxWrap HARD
MinimumPasswordLength 5
NetServerOptions
NotifyActor 0
OldestTransactionsFirst 1
Organization ftth-sfr.net
OwnerEmail root
PlainTextPre 0
Plugins RTx::Calendar, RTx::EmailCompletion, RT::Extension::Timeline
PreviewScripMessages 0
RTAddressRegexp ^rt\@example.com$
RecordOutgoingEmail 1
RedistributeAutoGeneratedMessages privileged
SMTPDebug 0
SelfServiceRegex Regexp
SendmailArguments -oi -t
SendmailBounceArguments -f "<>"
SendmailPath /usr/sbin/sendmail
ShowBccHeader 0
ShowTransactionImages 1
ShowUnreadMessageNotifications 1
StandaloneMaxServers 1
StandaloneMaxSpareServers 0
StandaloneMinServers 1
StandaloneMinSpareServers 0
StrictLinkACL 1
Timezone CET
UseFriendlyFromLine 1
UseFriendlyToLine 0
UseTransactionBatch 0
UsernameFormat concise
WebBaseURL http://rt.ftth-sfr.net
WebDefaultStylesheet web2
WebDomain localhost
WebFlushDbCacheEveryRequest 1
WebImagesURL /rt/NoAuth/images/
WebNoAuthRegex Regexp
WebPath /rt
WebPort 80
WebSecureCookies 0
WebURL http://rt.ftth-sfr.net/rt/
WikiImplicitLinks 0
rtname rt.ftth-sfr.net
RT Variables
RT::BasePath /usr/share/request-tracker3.8
RT::BinPath /usr/bin
RT::EtcPath /etc/request-tracker3.8
RT::LocalEtcPath /usr/local/share/request-tracker3.8/etc
RT::LocalLexiconPath /usr/local/share/request-tracker3.8/po
RT::LocalLibPath /usr/local/share/request-tracker3.8/lib
RT::LocalPath /usr/local/share/request-tracker3.8
RT::LocalPluginPath /usr/local/share/request-tracker3.8/plugins
RT::MasonComponentRoot /usr/share/request-tracker3.8/html
RT::MasonDataDir /var/cache/request-tracker3.8/mason_data
RT::MasonLocalComponentRoot /usr/local/share/request-tracker3.8/html
RT::MasonSessionDir /var/cache/request-tracker3.8/session_data
RT::SbinPath /usr/sbin
RT::VERSION 3.8.1
RT::VarPath /var/cache/request-tracker3.8
Perl configuration
Summary of my perl5 (revision 5 version 10 subversion 0) configuration:
Platform:
osname=linux, osvers=2.6.24-16-server,
archname=x86_64-linux-gnu-thread-multi
uname='linux yellow 2.6.24-16-server #1 smp thu apr 10 13:15:38 utc
2008 x86_64 gnulinux '
config_args='-Dusethreads -Duselargefiles -Dccflags=-DDEBIAN
-Dcccdlflags=-fPIC -Darchname=x86_64-linux-gnu -Dprefix=/usr
-Dprivlib=/usr/share/perl/5.10 -Darchlib=/usr/lib/perl/5.10
-Dvendorprefix=/usr -Dvendorlib=/usr/share/perl5
-Dvendorarch=/usr/lib/perl5 -Dsiteprefix=/usr/local
-Dsitelib=/usr/local/share/perl/5.10.0
-Dsitearch=/usr/local/lib/perl/5.10.0 -Dman1dir=/usr/share/man/man1
-Dman3dir=/usr/share/man/man3 -Dsiteman1dir=/usr/local/man/man1
-Dsiteman3dir=/usr/local/man/man3 -Dman1ext=1 -Dman3ext=3perl
-Dpager=/usr/bin/sensible-pager -Uafs -Ud_csh -Ud_ualarm -Uusesfio -Uusenm
-DDEBUGGING=-g -Doptimize=-O2 -Duseshrplib
-Dlibperl=libperl.so.5.10.0 -Dd_dosuid -des'
hint=recommended, useposix=true, d_sigaction=define
useithreads=define, usemultiplicity=define
useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef
use64bitint=define, use64bitall=define, uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='cc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DDEBIAN
-fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64',
optimize='-O2 -g',
cppflags='-D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fno-strict-aliasing
-pipe -I/usr/local/include'
ccversion='', gccversion='4.3.2', gccosandvers=''
intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=8, prototype=define
Linker and Libraries:
ld='cc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib /lib64 /usr/lib64
libs=-lgdbm -lgdbm_compat -ldb -ldl -lm -lpthread -lc -lcrypt
perllibs=-ldl -lm -lpthread -lc -lcrypt
libc=/lib/libc-2.8.90.so, so=so, useshrplib=true,
libperl=libperl.so.5.10.0
gnulibc_version='2.8.90'
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
cccdlflags='-fPIC', lddlflags='-shared -O2 -g -L/usr/local/lib'
Perl Include Paths (@INC)
/usr/local/share/request-tracker3.8/lib
/usr/share/request-tracker3.8/lib
/etc/perl
/usr/local/lib/perl/5.10.0
/usr/local/share/perl/5.10.0
/usr/lib/perl5
/usr/share/perl5
/usr/lib/perl/5.10
/usr/share/perl/5.10
/usr/local/lib/site_perl
.
--
Julien Tayon // digital craftsman // making things simpler (when possible)
Truth will out this morning. (Which may really mess things up.)
--
Julien Tayon // digital craftsman // making things simpler (when possible)
Martin was probably ripping them off. That's some family, isn't it?
Incest, prostitution, fanaticism, software.
-- Charles Willeford, "Miami Blues"
More information about the Rt-devel
mailing list