CiviCRM Community Forums (archive)

Joomla 2.5.10
Civi 4.3.1
MySql 5.1.67
PHP 5.3.3

I have not found this issue in the forums, so please excuse me if it has been addressed.

I had Civi 4.1 installed and working on this site, then the host experienced a server failure. The site was recovered intact, but Civi had a fractured table that could not be repaired.

I uninstalled Civi 4.1 and checked for remnant civi files and found none.

I used this as a guide to installing civi ver 4.3.1:
wiki.civicrm.org/confluence/display/CRMDOC43/Joomla+Installation+Guide+for+CiviCRM+4.3

and checked our versions for php, mysql, memory, innodb, etc. All are correct as per reqs for CiviCRM 4.3.1 according to this post: forum.civicrm.org/index.php?topic=24390.0

But i keep getting this error when I try to install civi 4.3.1 , from tmp directory. I've tried uploading and extracting both the  joomla and joomla_alt versions:

Cannot execute CREATE TABLE `civicrm_address_format` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Address Format Id', `format` text COMMENT 'The format of an address' , PRIMARY KEY ( `id` ) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci: DB Error: can not create

I have done the process of removing the remnant civi files after the install attempt failed, deleting the following:

httpdocs/administrator/components/com_civicrm
httpdocs/administrator/language/en-GB/en-GB.com_civicrm.ini
httpdocs/administrator/language/en-GB/en-GB.com_civicrm.sys.ini
httpdocs/components/com_civicrm
httpdocs/media/civicrm

Then tried the install process over again several times in the same way, getting the same error.

Thanks for any help!

P.S. I should note: I had a similar problem with another site on this same server that was damaged in a similar way and revived, and was successful uninstalling Civi 4.1 and installing 4.3.1 on that site.

Thanks for your quick response, Donald.

I was able to solve this issue by the following steps:

1. Created a new DB, imported current data; made new DB and USer Perms; repointed in configuration.php

2. Install Civi TWICE if menu fails to appear or etc on first install.[/li][/list]