CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Cannot execute DROP TABLE IF EXISTS civicrm_state_province
Pages: [1]

Author Topic: Cannot execute DROP TABLE IF EXISTS civicrm_state_province  (Read 2588 times)

gb_jones

  • I’m new here
  • *
  • Posts: 11
  • Karma: 0
Cannot execute DROP TABLE IF EXISTS civicrm_state_province
March 23, 2009, 12:10:52 pm
When upgrading to version 2.2.0 of CiviCRM, after uninstalling the component in Joomla 1.5.9, during the installation of the new component I receive the following error message: Cannot execute DROP TABLE IF EXISTS civicrm_state_province: DB Error: constraint violation

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Cannot execute DROP TABLE IF EXISTS civicrm_state_province
March 25, 2009, 09:30:47 pm
Strange worked fine for me. I guess you will have to manually drop civicrm_* tables from your database using phpmyadmin or command line interface.

Kurund
Found this reply helpful? Support CiviCRM

bcobin

  • I post frequently
  • ***
  • Posts: 337
  • Karma: 9
    • InterCreative Media
  • CiviCRM version: 4.3.3
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.9
  • PHP version: 5.3
Re: Cannot execute DROP TABLE IF EXISTS civicrm_state_province
April 08, 2009, 07:49:47 am
I have this same problem in moving from a development to a production install; something I have yet to be able to do successfully. I always need to do a fresh install and end up copying data manually.

Clearly, dropping tables wouldn't work if there's a significant amount of data that needs to be imported.

In my case, this is not a version issue; I'm going from 2.2 to 2.2. Any ideas? Thanks!

Deepak Srivastava

  • Moderator
  • Ask me questions
  • *****
  • Posts: 677
  • Karma: 65
Re: Cannot execute DROP TABLE IF EXISTS civicrm_state_province
April 08, 2009, 06:58:25 pm
Quote
during the installation of the new component I receive the following error message: Cannot execute DROP TABLE IF EXISTS civicrm_state_province: DB Error: constraint violation
Try using a latest tarball (currently v2.2.2), since there was some issue with v2.2.0 that uninstall would also try to uninstall db, which is what looks to be happening in your case.

Quote
I'm going from 2.2 to 2.2. Any ideas? Thanks!
Didn't quite get it. Which version you upgrading from 2.2(.betaX)/2.1 ?
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Cannot execute DROP TABLE IF EXISTS civicrm_state_province

This forum was archived on 2017-11-26.