MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
Posted by: Lucas van Staden
Date: November 27, 2019 07:34AM

you need to change column types in indexer.xml from “searchable” to “filtrable” the ones you don’t want to participate in full text

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
4525
sanjb c
June 28, 2019 06:53AM
Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
3788
Peter Brawley
June 28, 2019 11:03AM
Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
1620
sanjb c
June 28, 2019 10:22PM
Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
2377
Peter Brawley
June 29, 2019 12:12PM
Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
1636
sanjb c
July 01, 2019 03:01AM
Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
2016
Peter Brawley
July 01, 2019 09:39AM
Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
4049
Lucas van Staden
November 27, 2019 07:14AM
Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
1765
Lucas van Staden
November 27, 2019 07:34AM
Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
1587
Efecan Bilge
November 05, 2019 10:43PM
Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
1266
Peter Brawley
November 06, 2019 10:15AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.