CiviCRM Community Forums (archive)

I use J 1.5.7 and the new CiviCRM 1.2.1.  I have two sites on the same server public_html/mysite.com/Joomla  with db1 and public_html/sandbox.com/Joomla with db2. Each site is unique and clone of the other and has it's own db.  I installed CiviCRM via zip on mysite.com/Joomla and all went well. It added numerous tables in the db1.  When I installed CiviCRM on the sandbox.com/Joomla via zip it reported successful install?  BUT! there are no CiviCRM tables on that sandbox.com/Joomla db2. It did place files in components and admin components on the sandbox site.  I have not done any config yet, because this seems WAY wrong to me?  Could you please review this problem and advise. Thanks much,
PapaLion

error msgs generated while doing the JoomlaPack kickstart

Error at the line 2: CREATE TABLE `civicrm_acl_cache` ( `id` int(10) unsigned NOT NULL auto_increment COMMENT 'Unique table ID', `contact_id` int(10) unsigned default NULL COMMENT 'Foreign Key to Contact', `acl_id` int(10) unsigned NOT NULL COMMENT 'Foreign Key to ACL', `modified_date` date default NULL COMMENT 'When was this cache entry last modified', PRIMARY KEY (`id`), KEY `index_acl_id` (`acl_id`), KEY `FK_civicrm_acl_cache_contact_id` (`contact_id`), CONSTRAINT `FK_civicrm_acl_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE, CONSTRAINT `FK_civicrm_acl_cache_acl_id` FOREIGN KEY (`acl_id`) REFERENCES `civicrm_acl` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Query:CREATE TABLE `civicrm_acl_cache` ( `id` int(10) unsigned NOT NULL auto_increment COMMENT 'Unique table ID', `contact_id` int(10) unsigned default NULL COMMENT 'Foreign Key to Contact', `acl_id` int(10) unsigned NOT NULL COMMENT 'Foreign Key to ACL', `modified_date` date default NULL COMMENT 'When was this cache entry last modified', PRIMARY KEY (`id`), KEY `index_acl_id` (`acl_id`), KEY `FK_civicrm_acl_cache_contact_id` (`contact_id`), CONSTRAINT `FK_civicrm_acl_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE, CONSTRAINT `FK_civicrm_acl_cache_acl_id` FOREIGN KEY (`acl_id`) REFERENCES `civicrm_acl` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

MySQL: Can't create table './almost8_jo152/civicrm_acl_cache.frm' (errno: 150)

Stopped on error

thank you Donald, ?  I now have mysite.com/Joomla db1 with CiviCRM 1.2.1 installed properly.  I have sandbox.com/Joomla with db2 and no CiviCRM atall.  It is a clean install.  They are both on the same server public_html.  IF? I now try to install CiviCRM via zip on this sandbox.com/Joomla I am finding it corrupts the mysite.com/Joomla apparently.  What I see is the components show CiviCRM on the sandbox.com administrator/components but? there are no tables in the db2...
So CAN it be done?  Can you install a second copy of CiviCRM on the same shared server/different URLS? or is this a  characteristic of the thing... one copy on one server?  I dunno.  Would appreciate that being cleared up and then yes, JoomlaPack is investigating the backup issues and I will share any info I get there.
thanks, Bret
PapaLion

So CAN it be done?  Can you install a second copy of CiviCRM on the same shared server/different URLS?

yes. make sure that it is two distinct installs. From the characteristics of your issues, i suspect the two installs share "some" settings and hence things got messed up (this is just a guess)

lobo