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 »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • Cannot execute DROP TABLE IF EXISTS civicrm_relationship: DB Error: constraint v
Pages: [1]

Author Topic: Cannot execute DROP TABLE IF EXISTS civicrm_relationship: DB Error: constraint v  (Read 5590 times)

ronthatiam

  • Guest
Cannot execute DROP TABLE IF EXISTS civicrm_relationship: DB Error: constraint v
April 01, 2008, 01:35:13 pm
Installed CiviCRM 2.0.1 on top of joomla.
Installation said: Components uploaded successfully. It did not say "Component successfully installed" message.
(Also, after starting installation, I had to step away. When I returned and hit Continue, I had to log back in.)
But it LOOKs like everything is installed. When I go to Components | CiviCRM | CiviCRMHome (or any other choice), I get this error message:
Cannot execute DROP TABLE IF EXISTS civicrm_relationship: DB Error: constraint violation

Hosted on a shared server at Verio.

I'll also say, I installed CiviCRM 1.9, it had problems, so uninstalled it and installed 2.0beta, and it had problems, so uninstalled that. Then removed joomla and everything from the web site. Installed joomla, and just now installed CiviCRM 2.0.1.
I wonder if I should have deleted all mysql tables when I removed joomla from the web site.
If so, is anyone able to tell me how/which tables to delete.

Thank you

lcdweb

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1620
  • Karma: 116
    • www.lcdservices.biz
  • CiviCRM version: many versions...
  • CMS version: Joomla/Drupal
  • MySQL version: 5.1+
  • PHP version: 5.2+
Re: Cannot execute DROP TABLE IF EXISTS civicrm_relationship: DB Error: constrai
April 01, 2008, 01:50:29 pm
If you first installed 1.9 and then moved to 2.0, then yes, you'll need to drop your tables before reinstalling, as the schema changed between those versions. Sounds like you're doing a new install -- no existing data. So I'd go through and drop all your civicrm tables, and then try a clean install. Actually, the first step I would do is to uninstall CiviCRM through Joomla just to make sure the files are cleaned out and the record of the component is removed from the Joomla tables. Then drop your civicrm tables (they all have a civicrm_ prefix) and then reinstall. Depending on what you're using to drop tables, you might have to cycle through them several times, as the relationship constraints won't let you drop some tables until their child tables are dropped. A bit of a pain, but there's no way around it.

-Brian
support CiviCRM through 'make it happen' initiatives!
http://civicrm.org/mih

montano

  • Guest
Re: Cannot execute DROP TABLE IF EXISTS civicrm_relationship: DB Error: constrai
April 07, 2008, 02:40:08 pm
I found it easier to empty the tables on the first round, then drop. 

businessbroker

  • Guest
Re: Cannot execute DROP TABLE IF EXISTS civicrm_relationship: DB Error: constraint v
August 15, 2008, 12:34:49 am
I have a very similar problem, but I solved it deleting tables, because drop tables of civicrm_dupe_match and civicrm_domain look to be impossible

Beernink

  • I’m new here
  • *
  • Posts: 1
  • Karma: 0
Re: Cannot execute DROP TABLE IF EXISTS civicrm_relationship: DB Error: constraint v
August 25, 2008, 01:01:46 pm
Hi, I'm totally new to CiviCRM and Joomla.  I experienced the same problem/error message.  And yes, probably due to an aborted first install of a the latest version of CiviCRM and then a reinstall of the stable version.  It appeared like I successfully ran the uninstall and the reinstall, but then got the DROP TABLE error.

Being a novice to this, what is the way to delete/remove the tables?  Note that I used XAMPP to install Apache, MySql, and PHP.

Ta
Ron

businessbroker

  • Guest
Re: Cannot execute DROP TABLE IF EXISTS civicrm_relationship: DB Error: constraint v
August 25, 2008, 01:08:04 pm
just go to phpmyadmin and delete or clean talbes, all data that you can delete is enough

cmdfa

  • Guest
Re: Cannot execute DROP TABLE IF EXISTS civicrm_relationship: DB Error: constraint v
January 18, 2010, 06:58:44 pm
Hi, I'm having this problem also and not sure how to get around it..

First I dumped a DB backup into PHPMyAdmin, then installed Joomla and CiviCRM 2.1.6 as this is the version the old DB is in. before any message of successful install/upload, the message showed up ('cannot execute' etc..). When I refresh the Joomla admin, the CiviCRM menus are there but the links don't work (http 500 internal server error)

I don't know what it means to cycle through the tables or what, if anything, to delete. Can someone help me understand a bit better? thanks..

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • Cannot execute DROP TABLE IF EXISTS civicrm_relationship: DB Error: constraint v

This forum was archived on 2017-11-26.