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 CREATE TABLE
Pages: [1]

Author Topic: Cannot execute CREATE TABLE  (Read 1874 times)

banderson

  • Guest
Cannot execute CREATE TABLE
December 01, 2009, 07:41:05 pm
Trying to install the latest stable build 3.0.2 of civicrm

running:
Joomla 1.5.10
MySQL Server version: 5.0.77mm0.1-log
MySQL client version: 4.1.22
PHP Version 5.2.9

Upload the civiCRM install files and run the install I get the following error:

Cannot execute CREATE TABLE civicrm_navigation ( id int unsigned NOT NULL AUTO_INCREMENT , domain_id int unsigned NOT NULL COMMENT 'Which Domain is this navigation item for', label varchar(255) COMMENT 'Navigation Title', name varchar(255) COMMENT 'Internal Name', url varchar(255) COMMENT 'url in case of custom navigation link', permission varchar(255) COMMENT 'Permission for menu item', permission_operator varchar(3) COMMENT 'Permission Operator', parent_id int unsigned COMMENT 'Parent navigation item, used for grouping', is_active tinyint COMMENT 'Is this navigation item active?', has_separator tinyint COMMENT 'If separator needs to be added after this menu item', weight int COMMENT 'Ordering of the navigation items in various blocks.' , PRIMARY KEY ( id ) , CONSTRAINT FK_civicrm_navigation_domain_id FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id) , CONSTRAINT FK_civicrm_navigation_parent_id FOREIGN KEY (parent_id) REFERENCES civicrm_navigation(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci: DB Error: can not create

If I refresh the browser after the error occurs it tells me the joomla install completed successfully, but the database is not finished. I have tried to manually install the sql scripts using phpadmin but no success.

Please HELP!!!!

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

This forum was archived on 2017-11-26.