Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

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

Error when upgrading WHD with a MySQL database

Updated January 11, 2018

Overview

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

Too many keys specified. Max 32 keys allowed

Environment

  • All WHD versions
  • MySQL 5.x

Cause 

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.

Resolution

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

Tags

Classifications

Public