[rt-users] a configuration manager/plugin for RT

[Rémi]

In addition to the "pivatekey" errors for the users, I've also this error
concerning the templates :

[10040] [Wed Jul 16 12:07:07 2014] [warning]: DBD::Pg::st execute failed:
ERREUR:  la fonction lower(integer) n'existe pas
LIGNE 1 : SELECT  * FROM Templates WHERE LOWER(Id) = LOWER($1)
                                         ^
ASTUCE : Aucune fonction ne correspond au nom donné et aux types
d'arguments.
Vous devez ajouter des conversions explicites de type. at
/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 589.
(/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm:589)
[10040] [Wed Jul 16 12:07:07 2014] [warning]: RT::Handle=HASH(0xfe55e0)
couldn't execute the query 'SELECT  * FROM Templates WHERE LOWER(Id) =
LOWER(?)' at /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line
602.
        DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0xfe55e0),
"SELECT  * FROM Templates WHERE LOWER(Id) = LOWER(?)", "Admin Comment in
HTML") called at /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Record.pm
line 1234

DBIx::SearchBuilder::Record::_LoadFromSQL(RT::Template=HASH(0x7186be8),
"SELECT  * FROM Templates WHERE LOWER(Id) = LOWER(?)", "Admin Comment in
HTML") called at /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Record.pm
line 1153

DBIx::SearchBuilder::Record::LoadByCols(RT::Template=HASH(0x7186be8),
"LOWER(Id)", HASH(0x7144b68)) called at
/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Record/Cachable.pm line 120

DBIx::SearchBuilder::Record::Cachable::LoadByCols(RT::Template=HASH(0x7186be8),
"LOWER(Id)", HASH(0x7144b68)) called at /opt/rt4/sbin/../lib/RT/Record.pm
line 417
        RT::Record::LoadByCols(RT::Template=HASH(0x7186be8), "Id", "Admin
Comment in HTML") called at /opt/rt4/sbin/rt-dump-metadata line 175
(/usr/local/share/perl/5.14.2/Carp.pm:169)

I'm using a pg database, mysql may be more permissive with the function
lower().

And to be complete I also have some warnings complaining about deprecating
functions

[10373] [Wed Jul 16 12:11:34 2014] [warning]: The function RT::Group::Type
is deprecated, and will be removed in RT 4.4.  You should use Name
instead.  Call stack:
        RT::Group::Type(RT::Group=HASH(0x6f92e48)) called at
/opt/rt4/sbin/rt-dump-metadata line 236 (/opt/rt4/sbin/../lib/RT.pm:955)
[10373] [Wed Jul 16 12:11:34 2014] [warning]: The function
RT::CustomField::AppliedTo is deprecated, and will be removed in RT 4.4.
You should use AddedTo instead.  Call stack:
        RT::CustomField::AppliedTo(RT::CustomField=HASH(0x6f161f0)) called
at /opt/rt4/sbin/rt-dump-metadata line 197 (/opt/rt4/sbin/../lib/RT.pm:955)


Regards,
Rémi







2014-07-16 11:18 GMT+02:00 Christian Loos <cloos at netcologne.de>:

> Am 16.07.2014 11:00, schrieb Joop:
> > On 16-7-2014 4:23, Alex Peters wrote:
> >>
> >> Please report these errors and warnings, because anything that ships
> >> directly with RT 4.2 should definitely be fully supported by RT 4.2.
> >>
> > Don't know if I'm seeing the same errors but here are mine which
> > suprised me quite a bit when running rt-dump-metadata
> > [22390] [Wed Jul 16 08:52:21 2014] [warning]: DBD::Pg::st execute
> > failed: ERROR:  column "privatekey" does not exist
> > LINE 1: SELECT privatekey FROM Users WHERE id = $1
> >                ^ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line
> > 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
> > [22390] [Wed Jul 16 08:52:21 2014] [warning]: RT::Handle=HASH(0x2d51f68)
> > couldn't execute the query 'SELECT privatekey FROM Users WHERE id = ?'
> > at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522.
> >         DBIx::SearchBuilder::Handle::SimpleQuery() called at
> > /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 714
> >         DBIx::SearchBuilder::Record::__Value() called at
> > /opt/rt4/sbin/../lib/RT/Record.pm line 644
> >         RT::Record::__Value() called at ./sbin/rt-dump-metadata line 174
> > (/usr/local/share/perl/5.10.1/Carp.pm:103)
> >
> > I haven't the faintest idea where 'privatekey' is coming from. It
> > certainly isn't in my users table (pgpkey is). I'm running rt-4.0.20 and
> > rt-4.2.5 and both have the same problem only when invoked with the '-a'
> > flag.
> > Running it without any parameters seems to produce valid output but also
> > those warnings.
> >
> > Joop
> >
>
> There is already a bug report open for this [1] and a branch with only
> one commit [2] which needs review.
>
> Chris
>
> [1] http://issues.bestpractical.com/Ticket/Display.html?id=22465
> [2]
>
> https://github.com/bestpractical/rt/commit/51ebb3affde6195fa3ce00e7a1343ba7e7971385
> --
> RT Training - Boston, September 9-10
> http://bestpractical.com/training
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140716/f5683dfc/attachment.htm>