CiviCRM Community Forums (archive)

Installed civicRM on another site since my first one did not work. Thought i'd try it on a new one. This is the error it gave me in both - whether I tried the upgrade on the first or a brand new install on the second:
___

Cannot execute CREATE TABLE civicrm_option_value ( id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option ID', option_group_id int unsigned NOT NULL COMMENT 'Group which this option belongs to.', label varchar(255) NOT NULL COMMENT 'Option string as displayed to users - e.g. the label in an HTML OPTION tag.', value varchar(512) NOT NULL COMMENT 'The actual value stored (as a foreign key) in the data record. Functions which need lookup option_value.title should use civicrm_option_value.option_group_id plus civicrm_option_value.value as the key.', name varchar(255) COMMENT 'Stores a fixed (non-translated) name for this option value. Lookup functions should use the name as the key for the option value row.', grouping varchar(255) COMMENT 'Use to sort and/or set display properties for sub-set(s) of options within an option group. EXAMPLE: Use for college_interest field, to differentiate partners from non-partners.', filter int unsigned COMMENT 'Bitwise logic can be used to create subsets of options within an option_group for different uses.', is_default tinyint DEFAULT 0 COMMENT 'Is this the default option for the group?', weight int unsigned NOT NULL COMMENT 'Controls display sort order.', description text COMMENT 'Optional description.', is_optgroup tinyint DEFAULT 0 COMMENT 'Is this row simply a display header? Expected usage is to render these as OPTGROUP tags within a SELECT field list of options?', is_reserved tinyint DEFAULT 0 COMMENT 'Is this a predefined system object?', is_active tinyint DEFAULT 1 COMMENT 'Is this option active?', component_id int unsigned COMMENT 'Component that this option value belongs/caters to.', domain_id int unsigned COMMENT 'Which Domain is this option value for', visibility_id int unsigned DEFAULT NULL , PRIMARY KEY ( id ) , INDEX index_option_group_id_value( value , option_group_id ) , INDEX index_option_group_id_name( option_group_id , name ) , CONSTRAINT FK_civicrm_option_value_option_group_id FOREIGN KEY (option_group_id) REFERENCES civicrm_option_group(id) ON DELETE CASCADE, CONSTRAINT FK_civicrm_option_value_component_id FOREIGN KEY (component_id) REFERENCES civicrm_component(id) , CONSTRAINT FK_civicrm_option_value_domain_id FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci: DB Error: unknown error
__

Just an FYI... in the first, it was an upgrade so I uninstalled from Joomla then went to all the database and manually removed all civicrm tables. When I tried to reinstall for the upgrade, it gave me the error above.
In the new site, with a different domain and everything, I installed a brand new copy of civicrm and still got this same error.

Any ideas?
Thanks

Thanks for the reply. Here it is
Joomla: 1.5.22
CiviCRM: the newest 3.3.1 [that's when I started having problems. With the one before this version I was fine]
MySQL: 4.1.22
PHP: 3.3.8.1

I know the database is Mysiam and not innodb but in the earlier version it was fine and worked wonderfully. It is only when I removed it and tried to update that i got the problem. I therefore deleted the entire thing - with all related files and folders and removed civicrm completely from the db and tried to reinstall the 3.3.1 and it gave me exact same error.

Any ideas?
Thanks

Ah!! that's what!! but it worked on civicrm 3.2 I reinstalled 3.2 just now and it is working wonderfully! 

Yup. Thanks a million. The hosting co definitely needs to upgrade anyways if it is outdated and yes, for sure for future updates of civicrm.
What a drag!!
Thanks a billion for your responses.
 

I have the same error, but I think we're missing the real problem here.

If I exit the update and then delete to reinstall, the second install appears to work correctly, but I get an out-of-memory error.  After I uninstalled and deleted the civiCRM tables in the database, I ran into the same error mentioned in this post again.

When I look at the mySQL tables, the civicrm_option_value table is MISSING... so I tried to paste the SQL into myPHPAdmin to manually create the table.  It returned Error #1071, (Specified key was too long; max key length is 1000 bytes).  As it turns out, the key length with utf8 is causing some excessive key lengths. 

So, I think this clarifies the problem but doesn't really provide an answer since the install obviously works for many.

Barry

Yep... I missed something.

I thought my server had InnoDB enabled, but the database engine defaulted to MyISAM even though the SQL was asking for a different engine.  Once I enabled InnoDB, the install went perfectly and have no issues.

Barry