Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

Home > Success Center > Web Help Desk (WHD) > WHD - Knowledgebase Articles > Error when upgrading WHD with a MySQL database

Error when upgrading WHD with a MySQL database

Updated January 11, 2018


When you upgrade Web Help Desk running a MySQL database, the following message displays:

Too many keys specified. Max 32 keys allowed


  • All WHD versions
  • MySQL 5.x


Duplicate indexes created in the JOB_TICKET table columns by a previous WHD updates.

MySQL allows a maximum of 64 indexes per table. When the database update attempts to add additional indexes, the total number is increased past 64, triggering the error.


Delete the duplicate indexes in the JOB_TICKET table.

The duplicate indexes  have a 2 at the end of their keyname. The following table shows what what the indexes should look like -- in this case using phpMyAdmin. You can use phpMyAdmin to delete the duplicates. 

You can also use the MySQL Command-Line tool and use show index from JOB_TICKET.  After you identify the duplicate index key names, delete the duplicate indexes using the drop index [index keyname] on JOB_TICKET. Repeat this procedure for each duplicate index.

When all of the duplicate indexes are removed, the database update should continue as normal.




Last modified