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) »
  • SOLVED: Cannot execute CREATE TABLE... error when installing Civi
Pages: [1]

Author Topic: SOLVED: Cannot execute CREATE TABLE... error when installing Civi  (Read 2154 times)

sbusch

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4.3.1
  • CMS version: Joomla 2.5.10
  • MySQL version: 5.1.67
  • PHP version: 5.3.3
SOLVED: Cannot execute CREATE TABLE... error when installing Civi
April 26, 2013, 02:32:08 pm
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.
« Last Edit: May 01, 2013, 11:03:02 am by sbusch »

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Cannot execute CREATE TABLE... error when installing Civi
April 27, 2013, 05:12:56 pm

can u try cutting and pasting the CREATE TABLE sql statement in mysql shell and see what happens

not sure why its giving a "cannot create error message'

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

sbusch

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4.3.1
  • CMS version: Joomla 2.5.10
  • MySQL version: 5.1.67
  • PHP version: 5.3.3
Re: Cannot execute CREATE TABLE... error when installing Civi
May 01, 2013, 11:00:45 am
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]

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • SOLVED: Cannot execute CREATE TABLE... error when installing Civi

This forum was archived on 2017-11-26.