ERPNext Foundation ERPNext Cloud User Manual Blog Discuss Frappé* Donate

Too many keys specified


#1

Hi everyone am facing this too many keys specified error on bench update is there any solution…?


#2

@arokia This is because the table has used up the maximum key limit. Every new index creates multiple keys based on the number of fields it is based on. It’s likely that you have multiple duplicate keys and indexes. Remove them and you should be fine.


#3

@netchampfaris how to remove duplicate keys and indexes…?


#4

To understand the problem this for example may help Too many keys specified; max 64 keys allowed


#5

@clarkej have tried creating new site but no solution yet…!