CiviCRM Community Forums (archive)

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!!!!