[rt-users] fail to upgrade with sql syntax error 'ARRAY()'

[Todd Wade]

Hello,

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'?

Regards,

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.
> [20433] [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)
> [20433] [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.