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 »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Error on install for Drupal
Pages: [1]

Author Topic: Error on install for Drupal  (Read 1327 times)

mikeweezer

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
Error on install for Drupal
September 02, 2010, 03:48:53 pm
Hello,

I am trying to install CiviCRM 3.2.2 onto Drupal 6.16.  After entering all of my db information on the install page, I get 'greens' for all fields.  When I hit install, I get this error:

Installing CiviCRM...

I am now running through the installation steps (this should take a few minutes)

If you receive a fatal error, refresh this page to continue the installation

Building database schema and setup files...
Cannot execute CREATE TABLE `civicrm_value_constituent_information_1` (`id` int(10) unsigned NOT NULL auto_increment, `entity_id` int(10) unsigned NOT NULL, `most_important_issue_1` varchar(255) default NULL, `marital_status_2` varchar(255) default NULL, `marriage_date_3` datetime default NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_entity_id` (`entity_id`), INDEX `INDEX_most_important_issue_1` (`most_important_issue_1`), INDEX `INDEX_marital_status_2` (`marital_status_2`), INDEX `INDEX_marriage_date_3` (`marriage_date_3`), CONSTRAINT `FK_civicrm_value_constituent_information_1_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;: DB Error: already exists

Any ideas?  Also, I've tried to reinstall by deleting out the civicrm.settings from /sites/default.  Is there a better method than this?

Thanks for your help!
Mike

ThePayIsLousy

  • Guest
Re: Error on install for Drupal
September 02, 2010, 06:48:20 pm
Hey, Mike,

Maybe someone more knowledgeable than me will reply.  But, I'll take a crack...

Is this a fresh installation?  If so, then you have nothing to lose by blowing up the CiviCRM sql db and creating an empty one.  Given that you recv'd an sql error that implies that a CiviCRM table already exists, seems like 60 seconds worth of work to start fresh is a good investment of your time...

If anything strange happens and the install script seems to remember stuff from your first try, delete all of your browser's session cookies.

Good luck!

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Error on install for Drupal
September 03, 2010, 01:40:12 am
Yes, that's what I would suggest also. Either use a fresh, empty DB. Or if you must use the same DB as Drupal, be sure to remove all tables that begin with civicrm_

Then try the install again.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

mikeweezer

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
Re: Error on install for Drupal
September 03, 2010, 10:10:40 am
Hello,

Yes - I tried a few different methods.  First I was trying to install it into the same DB as Drupal (error same as above).  I then had the webhost make an entirely new db just for CiviCRM, but I still received errors on the install.

That said, all I did to try a reinstall in the blank db was remove the settings file from Sites/Default.  Do I need to do more than this to remove CiviCRM and try again?

Thanks,
Mike

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Error on install for Drupal
September 04, 2010, 01:33:48 pm
> Do I need to do more than this to remove CiviCRM and try again?

Yes, you should remove all the files from sites/default/files/civicrm
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

himmler123

  • Guest
Re: Error on install for Drupal
September 06, 2010, 11:19:18 pm
I was facing the exact same error. It's sorted now thanks a lot  ;D
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Error on install for Drupal

This forum was archived on 2017-11-26.