CiviCRM Community Forums (archive)

A post from the Dutch forum which I have now posted here:

Installed everything locally, worked great! Gotten into CiviCRM and liked it, now is the moment to install it on the webserver at my provider.

But I keep getting errors, can you help me?


--------------------------------------------------------------------------------------
Environment:

PHP build on: Linux server82.hosting2go.nl 2.6.27.29 #5 SMP Mon Sep 21 10:20:38 CEST 2009 i686
Databaseversion: 4.1.21-standard-log
Databasecollatie: utf8_general_ci
PHP-version: 5.2.4
Webserver: Apache/2.0.46 (CentOS)
Webserver to PHP-interface: cgi
Joomla! version: Joomla! 1.5.22 Stable [ senu takaa ama woi ] 04-November-2010 18:00 GMT
Userindentification: Mozilla/5.0 (Windows; U; Windows NT 6.1; nl; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13

Using: Civicrm-3.3.3-joomla-alt.zip

Procedure:
Fresh Joomla installation 5.22
Uploaded the unpacked com_civicrm to tmp

In Joomla:
Installation from directory tmp

Message:
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

Yes, I would say TwoMice is precisely correct--the issue is the MySQL version and probably also lack of InnoDB support.