Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

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

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