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: sanjb c
Date: June 28, 2019 10:22PM

Hi Peter,

Thanks for your reply.

I know in my case there more than 16 columns in full text index.

Since I'm using Magento 2.3.1 and the table given above is a magento core table so there is no option for me to remove those indexes.

Please let me know how to increase these limit of the key parts.

Regards
Sanjib

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
4672
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
3837
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
1660
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
2451
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
1749
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
2086
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
4139
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
1818
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
1625
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
1308
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.