You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2018-12-04 16:38:51

stoatwblr
Member
Registered: 2014-04-13
Posts: 118

Error: Too many tables; MariaDB can only use 61 tables in a join

This shows up when searching all fields in tickets for text

It's a hard limit in mysql/maria and has cropped up in their support pages before:

The suggestion there is to partition the search and/or use UNION instead of JOIN.

Offline

#2 2018-12-05 15:47:23

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,278

Re: Error: Too many tables; MariaDB can only use 61 tables in a join


CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

Offline

Board footer

Powered by FluxBB