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
4153
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
3658
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
1457
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
2187
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
1503
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
1855
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
3791
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
1636
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
1464
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
1133
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.