Skip to main content

“Existing tables were detected in your database” error - Knowledgebase / Deskpro Legacy - Deskpro Support

WARNING: You're browsing documentation for an older version of Deskpro. Consider upgrading to Deskpro Horizon

“Existing tables were detected in your database” error

Authors list

 

Question

I'm getting an error from the install wizard saying “Existing tables were detected in your database”. How do I resolve this?

 

Answer

The Deskpro installer creates a ‘deskpro’ database within MySQL. If this is not empty (for example, you partly installed Deskpro before, or you are trying to install a production version over your old test helpdesk), the installation cannot proceed.

The easiest solution is to connect to MySQL and create a new empty database, e.g.

 

mysql> CREATE DATABASE deskpro-live;

 

Then in config.php, edit this line:

 

define('DP_DATABASE_NAME', 'deskpro');

 

replacing 'deskpro' with the new database name e.g. 'deskpro-live'.

Deskpro will now use the new, blank database for installation, but you will still have the old database for reference until you choose to delete it.

Helpful Unhelpful

30 of 71 people found this page helpful

Add a comment

Please log in or register to submit a comment.

Need a password reminder?