[Rt-devel] 3.5.6 - Search Options under Preferences defaults to
Sort By AdminCC.EmailAddress
Ruslan Zakirov
ruslan.zakirov at gmail.com
Sat Jan 7 07:22:07 EST 2006
On 1/5/06, mark matyas <mark at library.ucsc.edu> wrote:
> Hello RT Developers,
> We started using 3.5.6 and we have a problem when a user, any user, even
> the superuser tries to modify anything in their Search Options in
> Preferences. What happens is that after they modify something like the
> Order By or add/remove columns, the Order By defaults to:
> AdminCC.EmailAddress, ASC.
> This cannot be changed in the Web UI. Attempts to modify the Order By
> are futile as it resets to the above admincc.emailaddress Order By no
> matter what you do.
> Although it is a minor problem, it forces the user to use the Query
> Builder which allows you to modify the default Display Options. If they
> have attempted to change their Search Options and proceed to use Simple
> Search (or use RT At A Glance), 0 tickets are always displayed because
> of the AdminCc.EmailAddress Order BY (using Query Builder shows all
> tickets).
> The only way I found to reset a user's Search Options was to manually
> delete their Search-Display tuple from the Attributes relation.
I've reproduced that.
>
> Anybody ever report something like this? I don't get any errors in the
> logs either... Could there have been an error during the upgrade? We
> were using 3.2 then we upgraded to 3.4.4. About a week after that I
> upgraded to 3.5.6 to fix the slow Query Builder problem. This is the
> first problem we've had with 3.5.6, i.e. everything else is working
> great (Well, apart from the harmless error messages that appear in the
> logs when a user logs out - I already created a thread about this in
> rt-users though). I'm appending our System Configuration generated by RT.
I've sent patch to rt-devel@ that fix that log out warnings.
>
> Thanks for any help,
>
> Mark Matyas
> UCSC University Library
>
>
>
>
> ______________________________________________________________________
>
>
> Perl v5.8.5 under linux Apache::Session v1.6;
> Apache::Session::Generate::MD5 v2.1; Apache::Session::Lock::MySQL
> v1.00; Apache::Session::MySQL v1.01;
> Apache::Session::Serialize::Storable v1.00; Apache::Session::Store::DBI
> v1.02; Apache::Session::Store::MySQL v1.04; AutoLoader v5.60; base
> v2.06; Benchmark v1.06; bytes v1.01; Cache::Simple::TimedExpiry
> v0.23; Carp v1.03; CGI v3.05; CGI::Cookie v1.24; CGI::Fast v1.05;
> CGI::Util v1.5; Class::Container v0.12; Class::Data::Inheritable
> v0.02; Class::ReturnValue v0.53; Clone v0.18; constant v1.04; Cwd
> v2.19; Data::Dumper v2.121; DBD::mysql v3.0002; DBI v1.48;
> DBIx::SearchBuilder v1.36; DBIx::SearchBuilder::Union v0;
> DBIx::SearchBuilder::Unique v0.01; Devel::StackTrace v1.11;
> Devel::StackTraceFrame v0.6; Digest::base v1.00; Digest::MD5 v2.33;
> DynaLoader v1.05; Encode v2.01; Encode::Alias v2.00; Encode::Config
> v2.00; Encode::Encoding v2.00; Encode::Guess v2.00; Encode::Unicode
> v2.00; Errno v1.09; Exception::Class v1.21; Exception::Class::Base
> v1.2; Exporter v5.58; Exporter::Heavy v5.58; FCGI v0.67; Fcntl
> v1.05; fields v2.03; File::Basename v2.73; File::Glob v1.03;
> File::Path v1.06; File::Spec v0.87; File::Spec::Unix v1.5; File::Temp
> v0.14; FileHandle v2.01; HTML::Entities v1.27; HTML::Mason v1.3101;
> 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.35; HTML::Scrubber v0.08; I18N::LangTags
> v0.33; I18N::LangTags::Detect v1.03; I18N::LangTags::List v0.29;
> integer v1.00; IO v1.21; IO::File v1.10; IO::Handle v1.24;
> IO::InnerFile v2.110; IO::Lines v2.110; IO::Scalar v2.110;
> IO::ScalarArray v2.110; IO::Seekable v1.09; IO::Wrap v2.110;
> IO::WrapTie v2.110; IPC::Open2 v1.01; IPC::Open3 v1.0106; lib
> v0.5565; List::Util v1.14; locale v1.00; Locale::Maketext v1.09;
> Locale::Maketext::Fuzzy v0.02; Locale::Maketext::Lexicon v0.49;
> Locale::Maketext::Lexicon::Gettext v0.14; Log::Dispatch v2.11;
> Log::Dispatch::Base v1.09; Log::Dispatch::File v1.22;
> Log::Dispatch::Output v1.26; Log::Dispatch::Screen v1.17;
> Log::Dispatch::Syslog v1.18; Mail::Address v1.67; Mail::Field v1.67;
> Mail::Field::AddrList v1.67; Mail::Header v1.67; Mail::Internet v1.67;
> MIME::Base64 v3.01; MIME::Body v5.417; MIME::Decoder v5.417;
> MIME::Decoder::Binary v5.417; MIME::Decoder::NBit v5.417; MIME::Entity
> v5.417; MIME::Field::ContDisp v5.417; MIME::Field::ConTraEnc v5.417;
> MIME::Field::ContType v5.417; MIME::Field::ParamVal v5.417; MIME::Head
> v5.417; MIME::Parser v5.417; MIME::QuotedPrint v3.01; MIME::Tools
> v5.417; MIME::Words v5.417; Module::Versions::Report v1.02; overload
> v1.01; Params::Validate v0.78; POSIX v1.08; re v0.04; Regexp::Common
> v2.120; Regexp::Common::_support v2.101; Regexp::Common::balanced
> v2.101; Regexp::Common::CC v2.100; Regexp::Common::comment v2.116;
> Regexp::Common::delimited v2.104; Regexp::Common::lingua v2.105;
> Regexp::Common::list v2.103; Regexp::Common::net v2.105;
> Regexp::Common::number v2.108; Regexp::Common::profanity v2.104;
> Regexp::Common::SEN v2.102; Regexp::Common::URI v2.108;
> Regexp::Common::URI::fax v2.100; Regexp::Common::URI::file v2.100;
> Regexp::Common::URI::ftp v2.101; Regexp::Common::URI::gopher v2.100;
> Regexp::Common::URI::http v2.101; Regexp::Common::URI::news v2.100;
> Regexp::Common::URI::pop v2.100; Regexp::Common::URI::prospero v2.100;
> Regexp::Common::URI::RFC1035 v2.100; Regexp::Common::URI::RFC1738
> v2.104; Regexp::Common::URI::RFC1808 v2.100;
> Regexp::Common::URI::RFC2384 v2.102; Regexp::Common::URI::RFC2396
> v2.100; Regexp::Common::URI::RFC2806 v2.100; Regexp::Common::URI::tel
> v2.100; Regexp::Common::URI::telnet v2.100; Regexp::Common::URI::tv
> v2.100; Regexp::Common::URI::wais v2.100; Regexp::Common::whitespace
> v2.103; Regexp::Common::zip v2.112; RT v3.5.6; RT::FM v2.2.0RC1;
> RT::Interface::Email v1.02; Scalar::Util v1.14; SelectSaver v1.00;
> Socket v1.77; Storable v2.13; strict v1.03; Symbol v1.05;
> Sys::Hostname v1.11; Sys::Syslog v0.05; Text::Autoformat v1.13;
> Text::Quoted v1.8; Text::Reform v1.11; Text::Tabs v98.112801;
> Text::Template v1.44; Text::Wrapper v1.000; Time::HiRes v1.55;
> Time::JulianDay v2003.1125; Time::Local v1.1; Time::ParseDate
> v2003.1126; Time::Timezone v2003.0211; Tree::Simple v1.15; URI v1.30;
> URI::Escape v3.22; URI::URL v5.03; URI::WithBase v2.19; utf8 v1.04;
> vars v1.01; warnings v1.03; warnings::register v1.00; XML::Parser
> v2.34; XML::Parser::Expat v2.34; XML::RSS v1.05; XSLoader v0.02;
>
> ________________________________________________________________________
>
>
> RT Variables
> RT::AmbiguousDayInPast 1
> RT::BasePath /opt/rt3
> RT::BinPath /opt/rt3/bin
> RT::CORE_CONFIG_FILE /opt/rt3/etc/RT_Config.pm
> RT::CanonicalizeEmailAddressMatch rt.library.ucsc.edu$
> RT::CanonicalizeEmailAddressReplace library.ucsc.edu
> RT::CommentAddress RT_CommentAddressNotSet
> RT::CorrespondAddress RT_CorrespondAddressNotSet
> RT::DatabaseHost localhost
> RT::DatabaseName rt3
> RT::DatabasePassword Password not printed
> RT::DatabaseRTHost localhost
> RT::DatabaseType mysql
> RT::DatabaseUser root
> RT::DateDayBeforeMonth 1
> RT::DefaultSearchResultFormat '<B><A
> HREF="/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#', '<B><A
> HREF="/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>'
> RT::DefaultSummaryRows 10
> RT::EmailOutputEncoding utf-8
> RT::EtcPath /opt/rt3/etc
> RT::FriendlyFromLineFormat "%s via RT" <%s>
> RT::FriendlyToLineFormat "%s of library.ucsc.edu Ticket #%s":;
> RT::LinkTransactionsRun1Scrip 1
> RT::LocalEtcPath /opt/rt3/local/etc
> RT::LocalLexiconPath /opt/rt3/local/po
> RT::LocalPath /opt/rt3/local
> RT::LogDir /opt/rt3/var/log
> RT::LogStackTraces 1
> RT::LogToFile error
> RT::LogToFileNamed rt.log
> RT::LogToScreen error
> RT::LogToSyslog debug
> RT::LogoURL /NoAuth/images/bplogo.gif
> RT::LoopsToRTOwner 1
> RT::MailCommand sendmailpipe
> RT::MasonComponentRoot /opt/rt3/share/html
> RT::MasonDataDir /opt/rt3/var/mason_data
> RT::MasonLocalComponentRoot /opt/rt3/local/html
> RT::MasonSessionDir /opt/rt3/var/session_data
> RT::MaxAttachmentSize 10000000
> RT::MaxInlineBody 13456
> RT::MessageBoxWidth 72
> RT::MessageBoxWrap HARD
> RT::MinimumPasswordLength 5
> RT::Organization rt.library.ucsc.edu
> RT::OwnerEmail root
> RT::RTAddressRegexp ^rt\@example.com$
> RT::RecordOutgoingEmail 1
> RT::RedistributeAutoGeneratedMessages privileged
> RT::SITE_CONFIG_FILE /opt/rt3/etc/RT_SiteConfig.pm
> RT::SendmailArguments -oi -t
> RT::SendmailBounceArguments -f "<>"
> RT::SendmailPath /usr/sbin/sendmail
> RT::Timezone US/Pacific
> RT::UseFriendlyFromLine 1
> RT::VERSION 3.5.6
> RT::VarPath /opt/rt3/var
> RT::WebBaseURL http://rt.library.ucsc.edu
> RT::WebDefaultStylesheet 3.5-default
> RT::WebFlushDbCacheEveryRequest 1
> RT::WebImagesURL /NoAuth/images/
> RT::WebPort 80
> RT::WebURL http://rt.library.ucsc.edu/
> RT::rtname library.ucsc.edu
>
> ______________________________________________________________________
>
> Perl configuration
> Summary of my perl5 (revision 5 version 8 subversion 5) configuration:
> Platform:
> osname=linux, osvers=2.4.21-27.0.2.elsmp,
> archname=i386-linux-thread-multi
> uname='linux decompose.build.redhat.com 2.4.21-27.0.2.elsmp #1 smp
> wed jan 12 23:35:44 est 2005 i686 i686 i386 gnulinux '
> config_args='-des -Doptimize=-O2 -g -pipe -m32 -march=i386
> -mtune=pentium4 -Dversion=5.8.5 -Dmyhostname=localhost
> -Dperladmin=root at localhost -Dcc=gcc -Dcf_by=Red Hat, Inc.
> -Dinstallprefix=/usr -Dprefix=/usr -Darchname=i386-linux
> -Dvendorprefix=/usr -Dsiteprefix=/usr -Duseshrplib -Dusethreads
> -Duseithreads -Duselargefiles -Dd_dosuid -Dd_semctl_semun -Di_db
> -Ui_ndbm -Di_gdbm -Di_shadow -Di_syslog -Dman3ext=3pm -Duseperlio
> -Dinstallusrbinperl -Ubincompat5005 -Uversiononly -Dpager=/usr/bin/less
> -isr -Dinc_version_list=5.8.4 5.8.3 5.8.2 5.8.1 5.8.0'
> hint=recommended, useposix=true, d_sigaction=define
> usethreads=define use5005threads=undef useithreads=define
> usemultiplicity=define
> useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
> use64bitint=undef use64bitall=undef uselongdouble=undef
> usemymalloc=n, bincompat5005=undef
> Compiler:
> cc='gcc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DDEBUGGING
> -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE
> -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm',
> optimize='-O2 -g -pipe -m32 -march=i386 -mtune=pentium4',
> cppflags='-D_REENTRANT -D_GNU_SOURCE -DDEBUGGING
> -fno-strict-aliasing -pipe -I/usr/local/include -I/usr/include/gdbm'
> ccversion='', gccversion='3.4.4 20050721 (Red Hat 3.4.4-2)',
> gccosandvers=''
> intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
> d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
> ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
> lseeksize=8
> alignbytes=4, prototype=define
> Linker and Libraries:
> ld='gcc', ldflags =' -L/usr/local/lib'
> libpth=/usr/local/lib /lib /usr/lib
> libs=-lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lpthread -lc
> perllibs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
> libc=/lib/libc-2.3.4.so, so=so, useshrplib=true, libperl=libperl.so
> gnulibc_version='2.3.4'
> Dynamic Linking:
> dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E
> -Wl,-rpath,/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE'
> cccdlflags='-fPIC', lddlflags='-shared -L/usr/local/lib'
>
> _______________________________________________
> Rt-devel mailing list
> Rt-devel at lists.bestpractical.com
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
>
--
Best regards, Ruslan.
More information about the Rt-devel
mailing list