1050 Table '"openchurch_test"."variable"' already exists error when installing openchurch [#2349197]

I have an existing 7.x-1.14 Openchurch installation on localhost (with an identical copy on a remote server) and am trying to create another copy on localhost so I can use the Backup and Migrate tool to establish a copy of my site to then allow me to test upgrading the site to 7.x-2.0-beta1 without affecting the existing localhost and remote copies. I have downloaded the install archive for 7.x-1.14, created a separate empty database and set up a new user with appropriate access privileges for the database.

The installer runs and takes me to the page where I enter the database name and login details. A few seconds after clicking "Save and Continue", the page reloads and an error is displayed:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table '"openchurch_test"."variable"' already exists

I have tried deleting and re-creating the database on several occasions, but get the same error each time even though the database is confirmed as empty each time before I run the installer. I also tried installing the basic Drupal 7.31 without openchurch but again get exactly the same error. I have never seen this error before and as I am not a sql expert, I have no idea how to resolve this?

Comments

Comment #1

drupalninja99 CreditAttribution: drupalninja99 commented 4 October 2014 at 13:08

Hi there, that is not what you would want to do to upgrade. You would go to update.php to upgrade your database. Be sure read the upgrade instructions carefully here and let me know if you still have problems:
http://www.openchurchsite.com/content/upgrading-2x

Comment #2

GreenhillYT CreditAttribution: GreenhillYT commented 4 October 2014 at 20:21

Hi,

I think you have misunderstood my post. I have two copies of my site. One is on localhost and I use it to test security and theme updates to ensure they do not break the site. The other copy is the live site, which is on a remote server and gets updates once I have tested them on the localhost copy.

I am not trying to upgrade my existing localhost site (yet) - what I am doing is creating a separate installation of Openchurch on localhost that has its own database. I have backed up my existing localhost site using the "Backup and Migrate" tool and intend to import this archive into the seperate Openchurch installation so that I then have two identical local copies of my site running on seperate databases. I will then use upgrade.php on the newly created installation to upgrade to 7.x-2.0 while retaining an identical but seperate local copy running 7.x-1.14. If the upgraded site breaks, I can continue to test security updates on my original localhost site before deploying them to the remote server while working out how to fix the upgraded copy. When the upgraded copy has been fixed, I would then upgrade the original site (with fixes) on both localhost and the remote server and delete the seperate local copy. It sounds more complicated than it is in practice - I like to be really careful as I have had site breaking problems in the past on Joomla where I upgraded the local copy and could not revert the changes after it broke, forcing a complete local reinstall.

The error message appears when I try to install this seperate copy of Openchurch. Any assistance on how to get the second site installed so I can then import the backup archive would be gratefully received.