[rt-devel] Too many tables; MySQL can only use 61 tables in a join

[Henti Smith]

Good day all.

I did a RT upgrade from 3.8.4 to 4.0.7 over the weekend.

We did a POC to make sure everything works, and all seemed fine. No
problems we could see. After the upgrade we see this error.

Nov 19 12:13:44 violator RT: DBD::mysql::st execute failed: Too many
tables; MySQL can only use 61 tables in a join at
/usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder/Handle.pm line
587. (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder/Handle.pm:587)

Attached is an example from the rt.log file.

Any help would be appreciated.

Regards
Henti
-------------- next part --------------
A non-text attachment was scrubbed...
Name: rt.err
Type: application/octet-stream
Size: 20370 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-devel/attachments/20121119/c31a0806/attachment-0001.obj>