“Existing tables were detected in your database” error

 

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

4 of 11 people found this page helpful

Add a comment

You need to log in before you can submit a comment.

Need a password reminder?