[rt-users] fail to upgrade with sql syntax error 'ARRAY()'
yashi at redhat.com
Tue Nov 3 22:23:10 EST 2015
make testdeps return everything is ok
my DBIx::SearchBuilder is 1.61
then I went through ./sbin/rt-test-dependencies, found that the required version should be 1.65.
thanks very much.
----- Original Message -----
> From: "Todd Wade" <todd at bestpractical.com>
> To: rt-users at lists.bestpractical.com
> Sent: Wednesday, November 4, 2015 4:28:45 AM
> Subject: Re: [rt-users] fail to upgrade with sql syntax error 'ARRAY()'
> This looks like make upgrade-database is being ran with an old
> DBIx::SearchBuilder. Perhaps recheck the output of 'make testdeps' and
> if it reports issues run 'make fixdeps'?
> On 11/1/15 11:51 PM, Yaobin Shi wrote:
> > We are using RT as one internal project, thanks for your good work.
> > when we are trying to upgrade 4.0.13 to 4.2.12 on rhel6, met one problem,
> > did not find useful solution in doc/wiki/maliing list archive.
> > part of the error msg below when execute 'make upgrade-database'
> > Processing 4.2.11
> > Now inserting data.
> >  [Fri Oct 23 09:58:16 2015] [warning]: DBD::mysql::st execute
> > failed: You have an error in your SQL syntax; check the manual that
> > corresponds to your MySQL server version for the right syntax to use near
> > ''ARRAY(0xe1a3128)')' at line 1 at
> > /usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Handle.pm line 617,
> > <$handle> line 1.
> > (/usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Handle.pm:617)
> >  [Fri Oct 23 09:58:16 2015] [warning]: RT::Handle=HASH(0xd1466c0)
> > couldn't execute the query, error: You have an error in your SQL syntax;
> > check the manual that corresponds to your MySQL server version for the
> > right syntax to use near ''ARRAY(0xe1a3128)')' at line 1, query: 'SELECT
> > count(main.id) FROM ACL main WHERE ( ( main.ObjectType = 'RT::System' AND
> > main.ObjectId = 1 ) ) AND (main.PrincipalId = '9' OR main.PrincipalId =
> > '8' OR main.PrincipalId = '6' OR main.PrincipalId = '7') AND
> > (main.RightName IN 'ARRAY(0xe1a3128)') ' at
> > /usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Handle.pm line 641,
> > <$handle> line 1.
> > DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0xd1466c0),
> > "SELECT count(main.id) FROM ACL main WHERE ( ( main.ObjectTyp"...)
> > called at /usr/share/perl5/vendor_perl/DBIx/SearchBuilder.pm line 291
> > seems that we are missing some dependencies, not sure, can not find the
> > root cause.
> > thanks in advance.
Red Hat Asia Pacific, Beijing-Raycom
CN ENG Engineering Services
IRC Account: yashi at #rpmdiff-dev #eng-china
More information about the rt-users