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: Peter Brawley
Date: June 29, 2019 12:12PM

A core Magento table violates a MySQL limit?

I believe Magento allows you to see which cols are to be used for FT indexes. Some backends may allow more than 16. MySQL does not. If Magento let you specify more than what MySQL allows, that's a Magento bug.

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
4615
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
3826
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
1650
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
2420
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
1723
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
2071
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
4113
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
1803
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
1616
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
1297
Peter Brawley
November 06, 2019 10:15AM


Sorry, you can't reply to this topic. It has been closed.

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.