rendered paste body am now running through the installation steps (this should take a few minutes)
If you receive a fatal error, refresh this page to continue the installation
# Building database schema and setup files...
Cannot execute INSERT INTO `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`) VALUES (@option_group_id_pcm, 'Phone', 1, NULL, NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL), (@option_group_id_pcm, 'Email', 2, NULL, NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL), (@option_group_id_pcm, 'Postal Mail', 3, NULL, NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL), (@option_group_id_pcm, 'SMS', 4, NULL, NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL), (@option_group_id_pcm, 'Fax', 5, NULL, NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL), (@option_group_id_act, 'Meeting', 1, 'Meeting', NULL, 0, NULL, 1, NULL, 0, 1, 1, NULL), (@option_group_id_act, 'Phone Call', 2, 'Phone Call', NULL, 0, NULL, 2, NULL, 0, 1, 1, NULL), (@option_group_id_act, 'Email', 3, 'Email', NULL, 1, NULL, 3, 'Email sent.', 0, 1, 1, NULL), (@option_group_id_act, 'Text Message (SMS)', 4, 'SMS', NULL, 1, NULL, 4, 'Text message (SMS) sent.', 0, 1, 1, NULL), (@option_group_id_act, 'Event Registration', 5, 'Event Registration', NULL, 1, NULL, 5, 'Online or offline event registration.', 0, 1, 1, 1), (@option_group_id_act, 'Contribution', 6, 'Contribution', NULL, 1, NULL, 6, 'Online or offline contribution.', 0, 1, 1, 2), (@option_group_id_act, 'Membership Signup', 7, 'Membership Signup', NULL, 1, NULL, 7, 'Online or offline membership signup.', 0, 1, 1, 3), (@option_group_id_act, 'Membership Renewal', 8, 'Membership Renewal', NULL, 1, NULL, 8, 'Online or offline membership renewal.', 0, 1, 1, 3), (@option_group_id_act, 'Tell a Friend', 9, 'Tell a Friend', NULL, 1, NULL, 9, 'Send information about a contribution campaign or event to a friend.', 0, 1, 1, NULL), (@option_group_id_gender, 'Female', 1, 'Female', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL), (@option_group_id_gender, 'Male', 2, 'Male', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL), (@option_group_id_gender, 'Transgender', 3, 'Transgender', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL), (@option_group_id_IMProvider, 'Yahoo', 1, 'Yahoo', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL), (@option_group_id_IMProvider, 'MSN', 2, 'Msn', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL), (@option_group_id_IMProvider, 'AIM', 3, 'Aim', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL), (@option_group_id_IMProvider, 'GTalk', 4, 'Gtalk', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL), (@option_group_id_IMProvider, 'Jabber',5, 'Jabber',NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL), (@option_group_id_IMProvider, 'Skype', 6, 'Skype', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL), (@option_group_id_mobileProvider, 'Sprint' , 1, 'Sprint' , NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL), (@option_group_id_mobileProvider, 'Verizon' , 2, 'Verizon' , NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL), (@option_group_id_mobileProvider, 'Cingular', 3, 'Cingular', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL), (@option_group_id_prefix, 'Mrs', 1, 'Mrs', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL), (@option_group_id_prefix, 'Ms', 2, 'Ms', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL), (@option_group_id_prefix, 'Mr', 3, 'Mr', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL), (@option_group_id_prefix, 'Dr', 4, 'Dr', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL), (@option_group_id_suffix, 'Jr', 1, 'Jr', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL), (@option_group_id_suffix, 'Sr', 2, 'Sr', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL), (@option_group_id_suffix, 'II', 3, 'II', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL), (@option_group_id_suffix, 'III', 4, 'III', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL), (@option_group_id_suffix, 'IV', 5, 'IV', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL), (@option_group_id_suffix, 'V', 6, 'V', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL), (@option_group_id_suffix, 'VI', 7, 'VI', NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL), (@option_group_id_suffix, 'VII', 8, 'VII', NULL, 0, NULL, 8, NULL, 0, 0, 1, NULL), (@option_group_id_aclRole, 'Administrator', 1, 'Admin', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL), (@option_group_id_aclRole, 'Authenticated', 2, 'Auth' , NULL, 0, NULL, 2, NULL, 0, 1, 1, NULL), (@option_group_id_acc, 'Visa' , 1, 'Visa' , NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL), (@option_group_id_acc, 'MasterCard', 2, 'MasterCard', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL), (@option_group_id_acc, 'Amex' , 3, 'Amex' , NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL), (@option_group_id_acc, 'Discover' , 4, 'Discover' , NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL), (@option_group_id_pi, 'Credit Card', 1, 'Credit Card', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL), (@option_group_id_pi, 'Debit Card', 2, 'Debit Card', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL), (@option_group_id_pi, 'Cash', 3, 'Cash', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL), (@option_group_id_pi, 'Check', 4, 'Check', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL), (@option_group_id_pi, 'EFT', 5, 'EFT', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL), (@option_group_id_cs, 'Completed' , 1, 'Completed' , NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL), (@option_group_id_cs, 'Pending' , 2, 'Pending' , NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL), (@option_group_id_cs, 'Cancelled' , 3, 'Cancelled' , NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL), (@option_group_id_cs, 'Failed' , 4, 'Failed' , NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL), (@option_group_id_cs, 'In Progress', 5, 'In Progress', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL), (@option_group_id_ps, 'Registered', 1, 'Registered', NULL, 0, NULL, 1, NULL, 0, 1, 1, NULL), (@option_group_id_ps, 'Attended', 2, 'Attended', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL), (@option_group_id_ps, 'No-show', 3, 'No-show', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL), (@option_group_id_ps, 'Cancelled', 4, 'Cancelled', NULL, 0, NULL, 4, NULL, 0, 1, 1, NULL), (@option_group_id_ps, 'Pending' , 5, 'Pending', NULL, 0, NULL, 5, NULL, 0, 1, 1, NULL), (@option_group_id_pRole, 'Attendee', 1, 'Attendee', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL), (@option_group_id_pRole, 'Volunteer', 2, 'Volunteer', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL), (@option_group_id_pRole, 'Host', 3, 'Host', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL), (@option_group_id_pRole, 'Speaker', 4, 'Speaker', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL), (@option_group_id_etype, 'Conference', 1, 'Conference', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL), (@option_group_id_etype, 'Exhibition', 2, 'Exhibition', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL), (@option_group_id_etype, 'Fundraiser', 3, 'Fundraiser', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL), (@option_group_id_etype, 'Meeting', 4, 'Meeting', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL), (@option_group_id_etype, 'Performance',5, 'Performance', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL), (@option_group_id_etype, 'Workshop', 6, 'Workshop', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL), -- they are used for display only in the prefernces field settings (@option_group_id_cvOpt, 'Activities' , 1, NULL, NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL), (@option_group_id_cvOpt, 'Relationships', 2, NULL, NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL), (@option_group_id_cvOpt, 'Groups' , 3, NULL, NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL), (@option_group_id_cvOpt, 'Notes' , 4, NULL, NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL), (@option_group_id_cvOpt, 'Tags' , 5, NULL, NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL), (@option_group_id_cvOpt, 'Change Log' , 6, NULL, NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL), (@option_group_id_cvOpt, 'Contributions', 7, NULL, NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL), (@option_group_id_cvOpt, 'Memberships' , 8, NULL, NULL, 0, NULL, 8, NULL, 0, 0, 1, NULL), (@option_group_id_cvOpt, 'Events' , 9, NULL, NULL, 0, NULL, 9, NULL, 0, 0, 1, NULL), (@option_group_id_cvOpt, 'Cases' , 10, NULL, NULL, 0, NULL, 10,NULL, 0, 0, 1, NULL), (@option_group_id_ceOpt, 'Communication Preferences', 1, NULL, NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL), (@option_group_id_ceOpt, 'Demographics' , 2, NULL, NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL), (@option_group_id_ceOpt, 'Tags and Groups' , 3, NULL, NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL), (@option_group_id_ceOpt, 'Notes' , 4, NULL, NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL), (@option_group_id_asOpt, 'Address Fields' , 1, NULL, NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL), (@option_group_id_asOpt, 'Custom Fields' , 2, NULL, NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL), (@option_group_id_asOpt, 'Activities' , 3, NULL, NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL), (@option_group_id_asOpt, 'Relationships' , 4, NULL, NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL), (@option_group_id_asOpt, 'Notes' , 5, NULL, NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL), (@option_group_id_asOpt, 'Change Log' , 6, NULL, NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL), (@option_group_id_asOpt, 'Contributions' , 7, NULL, NULL, 0, NULL, 8, NULL, 0, 0, 1, NULL), (@option_group_id_asOpt, 'Memberships' , 8, NULL, NULL, 0, NULL, 9, NULL, 0, 0, 1, NULL), (@option_group_id_asOpt, 'Events' , 9, NULL, NULL, 0, NULL, 10, NULL, 0, 0, 1, NULL), (@option_group_id_asOpt, 'Cases' , 10, NULL, NULL, 0, NULL, 11, NULL, 0, 0, 1, NULL), (@option_group_id_udOpt, 'Groups' , 1, NULL, NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL), (@option_group_id_udOpt, 'Contributions', 2, NULL, NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL), (@option_group_id_udOpt, 'Memberships' , 3, NULL, NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL), (@option_group_id_udOpt, 'Events' , 4, NULL, NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL), (@option_group_id_adOpt, 'Street Address' , 1, NULL, NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL), (@option_group_id_adOpt, 'Addt\'l Address 1' , 2, NULL, NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL), (@option_group_id_adOpt, 'Addt\'l Address 2' , 3, NULL, NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL), (@option_group_id_adOpt, 'City' , 4, NULL, NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL), (@option_group_id_adOpt, 'Zip / Postal Code' , 5, NULL, NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL), (@option_group_id_adOpt, 'Postal Code Suffix', 6, NULL, NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL), (@option_group_id_adOpt, 'County' , 7, NULL, NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL), (@option_group_id_adOpt, 'State / Province' , 8, NULL, NULL, 0, NULL, 8, NULL, 0, 0, 1, NULL), (@option_group_id_adOpt, 'Country' , 9, NULL, NULL, 0, NULL, 9, NULL, 0, 0, 1, NULL), (@option_group_id_adOpt, 'Latitude' , 10, NULL, NULL, 0, NULL, 10, NULL, 0, 0, 1, NULL), (@option_group_id_adOpt, 'Longitude' , 11, NULL, NULL, 0, NULL, 11, NULL, 0, 0, 1, NULL), (@option_group_id_gType, 'Access Control' , 1, NULL, NULL, 0, NULL, 1, NULL, 0, 1, 1, NULL), (@option_group_id_gType, 'Mailing List' , 2, NULL, NULL, 0, NULL, 2, NULL, 0, 1, 1, NULL), (@option_group_id_grantSt, 'Pending', 1, 'Pending', NULL, 0, 1, 1, NULL, 0, 0, 1, NULL), (@option_group_id_grantSt, 'Granted', 2, 'Granted', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL), (@option_group_id_grantSt, 'Rejected', 3, 'Rejected', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL), (@option_group_id_grantTyp, 'Emergency' , 1, 'Emergency' , NULL, 0, 1, 1, NULL, 0, 0, 1, NULL), (@option_group_id_grantTyp, 'Family Support' , 2, 'Family Support' , NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL), (@option_group_id_grantTyp, 'General Protection' , 3, 'General Protection', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL), (@option_group_id_grantTyp, 'Impunity' , 4, 'Impunity' , NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL), (@option_group_id_honorTyp, 'In Honor of' , 1, 'In Honor of' , NULL, 0, 1, 1, NULL, 0, 0, 1, NULL), (@option_group_id_honorTyp, 'In Memory of' , 2, 'In Memory of' , NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL), (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_Sample' , 1, 'CRM/Contact/Form/Search/Custom/Sample.php' , NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL), (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_ContributionAggregate', 2, 'CRM/Contact/Form/Search/Custom/ContributionAggregate.php', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL), (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_Basic' , 3, 'CRM/Contact/Form/Search/Custom/Basic.php' , NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL), (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_Group' , 4, 'CRM/Contact/Form/Search/Custom/Group.php' , NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL), (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_PostalMailing' , 5, 'CRM/Contact/Form/Search/Custom/PostalMailing.php', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL), (@option_group_id_acs, 'Scheduled', 1, 'Scheduled', NULL, 0, 1, 1, NULL, 0, 1, 1, NULL), (@option_group_id_acs, 'Completed', 2, 'Completed', NULL, 0, NULL, 2, NULL, 0, 1, 1, NULL), (@option_group_id_acs, 'Cancelled', 3, 'Cancelled', NULL, 0, NULL, 3, NULL, 0, 1, 1, NULL), (@option_group_id_acs, 'Left Message', 4, 'Left Message', NULL, 0, NULL, 4, NULL, 0, 1, 1, NULL), (@option_group_id_acs, 'Unreachable', 5, 'Unreachable', NULL, 0, NULL, 5, NULL, 0, 1, 1, NULL), (@option_group_id_ct, 'Civil & Political', 1, 'Civil & Political', NULL, 0, 1, 1, NULL, 0, 0, 1, NULL), (@option_group_id_ct, 'Economic, Social & Cultural', 2, 'Economic, Social & Cultural', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL), (@option_group_id_ct, 'Gender Issues', 3, 'Gender Issues', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL), (@option_group_id_cas, 'Ongoing' , 1, 'Ongoing' , NULL, 0, 1, 1, NULL, 0, 1, 1, NULL), (@option_group_id_cas, 'Resolved', 2, 'Resolved', NULL, 0, NULL, 2, NULL, 0, 1, 1, NULL), (@option_group_id_pl, 'Name Only' , 1, 'Name Only' , NULL, 0, 0, 1, NULL, 0, 1, 1, NULL), (@option_group_id_pl, 'Name and Email', 2, 'Name and Email', NULL, 0, 0, 2, NULL, 0, 1, 1, NULL), (@option_group_id_sfe, 'jpg' , 1, NULL , NULL, 0, 0, 1, NULL, 0, 0, 1, NULL), (@option_group_id_sfe, 'jpeg' , 2, NULL , NULL, 0, 0, 2, NULL, 0, 0, 1, NULL), (@option_group_id_sfe, 'png' , 3, NULL , NULL, 0, 0, 3, NULL, 0, 0, 1, NULL), (@option_group_id_sfe, 'gif' , 4, NULL , NULL, 0, 0, 4, NULL, 0, 0, 1, NULL), (@option_group_id_sfe, 'txt' , 5, NULL , NULL, 0, 0, 5, NULL, 0, 0, 1, NULL), (@option_group_id_sfe, 'html' , 6, NULL , NULL, 0, 0, 6, NULL, 0, 0, 1, NULL), (@option_group_id_sfe, 'htm' , 7, NULL , NULL, 0, 0, 7, NULL, 0, 0, 1, NULL), (@option_group_id_sfe, 'pdf' , 8, NULL , NULL, 0, 0, 8, NULL, 0, 0, 1, NULL), (@option_group_id_sfe, 'doc' , 9, NULL , NULL, 0, 0, 9, NULL, 0, 0, 1, NULL), (@option_group_id_sfe, 'xls' , 10, NULL , NULL, 0, 0, 10, NULL, 0, 0, 1, NULL), (@option_group_id_sfe, 'rtf' , 11, NULL , NULL, 0, 0, 11, NULL, 0, 0, 1, NULL), (@option_group_id_sfe, 'csv' , 12, NULL , NULL, 0, 0, 12, NULL, 0, 0, 1, NULL), (@option_group_id_sfe, 'ppt' , 13, NULL , NULL, 0, 0, 13, NULL, 0, 0, 1, NULL), (@option_group_id_sfe, 'doc' , 14, NULL , NULL, 0, 0, 14, NULL, 0, 0, 1, NULL): DB Error: unknown error