CiviCRM Community Forums (archive)

During a clean install after an all-green prerequisites check screen, the process begins to run then dies, throwing a long PHP PEAR error to screen (listed at the bottom here).

Worpress is a fresh install. No other plugins added.  Earlier attempt of WP 3.5 produced the same results. 

Installing for development on OSX 10.8.2, MySQL 5.6.9, WP 3.4.2, PHP 5.3.15
I have twice installed this same set of files (!) on two Ubuntu 14 systems. 

The civicrm.settings.php file is not written.

These are the tables created, which seems odd, after the error below gets raised.


mysql> show tables;
+---------------------------------+
| Tables_in_wordpress             |
+---------------------------------+
| civicrm_acl                     |
| civicrm_acl_contact_cache       |
| civicrm_acl_entity_role         |
| civicrm_action_mapping          |
| civicrm_address_format          |
| civicrm_batch                   |
| civicrm_cache                   |
| civicrm_campaign                |
| civicrm_campaign_group          |
| civicrm_case                    |
| civicrm_case_contact            |
| civicrm_component               |
| civicrm_contact                 |
| civicrm_contact_type            |
| civicrm_contribution_type       |
| civicrm_country                 |
| civicrm_currency                |
| civicrm_custom_field            |
| civicrm_custom_group            |
| civicrm_dashboard               |
| civicrm_dedupe_exception        |
| civicrm_dedupe_rule             |
| civicrm_dedupe_rule_group       |
| civicrm_domain                  |
| civicrm_email                   |
| civicrm_entity_batch            |
| civicrm_entity_file             |
| civicrm_entity_financial_trxn   |
| civicrm_event_carts             |
| civicrm_extension               |
| civicrm_file                    |
| civicrm_financial_account       |
| civicrm_financial_trxn          |
| civicrm_grant                   |
| civicrm_im                      |
| civicrm_job                     |
| civicrm_job_log                 |
| civicrm_location_type           |
| civicrm_log                     |
| civicrm_mail_settings           |
| civicrm_mailing_bounce_pattern  |
| civicrm_mailing_bounce_type     |
| civicrm_mailing_component       |
| civicrm_managed                 |
| civicrm_mapping                 |
| civicrm_mapping_field           |
| civicrm_membership_status       |
| civicrm_menu                    |
| civicrm_navigation              |
| civicrm_note                    |
| civicrm_option_group            |
| civicrm_option_value            |
| civicrm_participant_status_type |
| civicrm_payment_processor       |
| civicrm_payment_processor_type  |
| civicrm_pcp                     |
| civicrm_persistent              |
| civicrm_pledge_block            |
| civicrm_preferences_date        |
| civicrm_premiums                |
| civicrm_premiums_product        |
| civicrm_prevnext_cache          |
| civicrm_price_set               |
| civicrm_price_set_entity        |
| civicrm_product                 |
| civicrm_project                 |
| civicrm_queue_item              |
| civicrm_relationship_type       |
| civicrm_report_instance         |
| civicrm_saved_search            |
| civicrm_sms_provider            |
| civicrm_survey                  |
| civicrm_task                    |
| civicrm_task_status             |
| civicrm_tell_friend             |
| civicrm_worldregion             |
| wp_commentmeta                  |
| wp_comments                     |
| wp_links                        |
| wp_options                      |
| wp_postmeta                     |
| wp_posts                        |
| wp_term_relationships           |
| wp_term_taxonomy                |
| wp_terms                        |
| wp_usermeta                     |
| wp_users                        |
+---------------------------------+
87 rows in set (0.00 sec)



---  First Error block (of several) ---
Full error text attached.

[nativecode=1071 ** Specified key was too long; max key length
is 767 bytes] [backtrace] => Array (

• => Array ( [file] =>/Users/erik/Sites/dev.roaringsky.ca/wp-content/plugins/civicrm/civicrm/packages/DB.php

[line] => 968 [function] => PEAR_Error [class] => PEAR_Error [type] => -> [args]
=> Array (

• => DB Error: unknown error [1] => -1 [2] => 1 [3] => 1024 (followed by full text of table create statement).

Happened installing CiviCRM 4.2.8 on MySQL.com stock OSX.

Here's the fix I applied - https://gist.github.com/xurizaemon/5194768 - this constrains the size of the key CiviCRM tries to generate. No specific reason to choose 200, I just wanted to get past the error really

civicrm.mysql is autogenerated, and the index code looks *really* autogenerated, proper fix will be elsewhere in option_value definition

http://issues.civicrm.org/jira/browse/CRM-12151