Skip to content

Instantly share code, notes, and snippets.

@lancespeelmon
Last active August 29, 2015 14:11
Show Gist options
  • Save lancespeelmon/178250f2986a1cdebef7 to your computer and use it in GitHub Desktop.
Save lancespeelmon/178250f2986a1cdebef7 to your computer and use it in GitHub Desktop.
KC6_master MySQL 5.6 SQL errors
mysql < rice/KR_RICE_01_2.3.5-2.4.0_2014-01-09_B000.sql
ERROR 1832 (HY000) at line 21: Cannot change column 'attr_defn_id': used in a foreign key constraint 'krms_typ_attr_fk1'
mysql < rice/KR_RICE_02_2.3.5-2.4.0_2014-03-20_B000.sql
mysql < rice/KR_RICE_03_2.3.5-2.4.0_2014-04-09_B000.sql
mysql < rice/KR_RICE_04_2.3.5-2.4.0_2014-04-09_B000.sql
mysql < rice/KR_RICE_05_2.3.5-2.4.0_2014-04-09_B000.sql
mysql < rice/KR_RICE_06_2.3.5-2.4.0_2014-04-09_B000.sql
mysql < rice/KR_RICE_08_2.4.0-2.5.0_2014-05-10_KULRICE-10653_B000.sql
mysql < rice/KR_RICE_09_2.4.0-2.5.0_2014-05-22_KULRICE-6281_B000.sql
mysql < rice/KR_RICE_10_2.4.0-2.5.0_2014-06-02_KULRICE-12767_B000.sql
mysql < rice/KR_RICE_11_2.4.0-2.5.0_2014-06-27_KULRICE-12893_B000.sql
mysql < rice/KR_RICE_12_2.4.0-2.5.0_2014-08-22_KULRICE-12691_B000.sql
mysql < rice/KR_RICE_13_2.4.0-2.5.0_2014-08-26_KULRICE-9109_B000.sql
mysql < rice/KRC_RICE_01_2.3.5-2.4.0_2014-04-09_B000.sql
mysql < sequences/KC_SEQ_DOCUMENT_ACCESS_ID.sql
mysql < sequences/KC_SEQ_EPS_PROP_PERSON_ROLE.sql
mysql < sequences/KC_SEQ_S2S_ERROR_ID.sql
mysql < sequences/SEQ_COMMITTEE_SCHEDULE_ATTACHMENT_ID.sql
mysql < tables/KC_TBL_AWARD_BUDGET_EXT.sql
mysql < tables/KC_TBL_AWARD_PERSONS.sql
mysql < tables/KC_TBL_BUDGET.sql
mysql < tables/KC_TBL_BUDGET_SUB_AWARDS.sql
mysql < tables/KC_TBL_DOCUMENT_ACCESS.sql
mysql < tables/KC_TBL_DOCUMENT_NEXTVALUE.sql
mysql < tables/KC_TBL_EPS_PROP_CONG_DISTRICT.sql
mysql < tables/KC_TBL_EPS_PROP_PERSON.sql
mysql < tables/KC_TBL_EPS_PROP_PERSON_EXT.sql
mysql < tables/KC_TBL_EPS_PROP_PERSON_ROLE.sql
mysql < tables/KC_TBL_EPS_PROPOSAL.sql
mysql < tables/KC_TBL_EPS_PROPOSAL_BUDGET_EXT.sql
mysql < tables/KC_TBL_PROPOSAL_PERSONS.sql
mysql < tables/KC_TBL_PROPOSAL_RESPONSE.sql
mysql < tables/KC_TBL_S2S_ERROR.sql
mysql < dml/KC_DML_01_KRACOEUS-6956_B000.sql
mysql < dml/KC_DML_01_KRACOEUS-7014_B000.sql
mysql < dml/KC_DML_01_KRACOEUS-7089_B000.sql
mysql < dml/KC_DML_01_KRACOEUS-7109_B000.sql
mysql < dml/KC_DML_01_KRACOEUS-7120_BTSD.sql
mysql < dml/KC_DML_01_KRACOEUS-7356_0TSD.sql
mysql < dml/KC_DML_01_KRACOEUS-7516_B000.sql
mysql < dml/KC_DML_01_KRACOEUS-7659_00SD.sql
mysql < dml/KC_DML_01_KRACOEUS-7722_B000.sql
mysql < dml/KC_DML_01_KRACOEUS-7889_B000.sql
mysql < dml/KC_DML_01_KRACOEUS-7922_B000.sql
mysql < dml/KC_DML_01_KRACOEUS-8027_B000.sql
mysql < dml/KC_DML_01_KRACOEUS-8159_B000.sql
mysql < dml/KC_DML_01_KRACOEUS-8411_B000.sql
mysql < dml/KC_DML_01_KRACOEUS-8417_B000.sql
mysql < dml/KC_DML_02_KCINFR-979_B000.sql
ERROR 1062 (23000) at line 26: Duplicate entry '/GrantApplication/Forms/RR_PerformanceSite/OtherSite/Address/Cou' for key 'UQ_S2S_ERROR'
mysql < dml/KR_DML_01_KCINFR-979_B000.sql
mysql < dml/KR_DML_01_KRACOEUS-6294_B000.sql
mysql < dml/KR_DML_01_KRACOEUS-6954_B000.sql
mysql < dml/KR_DML_01_KRACOEUS-6956_B000.sql
mysql < dml/KR_DML_01_KRACOEUS-7109_B000.sql
mysql < dml/KR_DML_01_KRACOEUS-7110_B000.sql
mysql < dml/KR_DML_01_KRACOEUS-7274_B000.sql
mysql < dml/KR_DML_01_KRACOEUS-7336_B000.sql
mysql < dml/KR_DML_01_KRACOEUS-7492_B000.sql
mysql < dml/KR_DML_01_KRACOEUS-7512_B000.sql
mysql < dml/KR_DML_01_KRACOEUS-7589_B000.sql
mysql < dml/KR_DML_01_KRACOEUS-7856_B000.sql
mysql < dml/KR_DML_01_KRACOEUS-8001_B000.sql
mysql < dml/KR_DML_01_KRACOEUS-8181_B000.sql
mysql < dml/KR_DML_01_KRACOEUS-8300_B000.sql
mysql < dml/KR_DML_01_KRACOEUS-8380_B000.sql
mysql < dml/KR_DML_02_KRACOEUS-6294_B000.sql
mysql < dml/KR_DML_02_KRACOEUS-8181_00S0.sql
mysql < dml/KR_DML_03_KCINFR-979_B000.sql
mysql < dml/KR_DML_03_KRACOEUS-7014_B000.sql
ERROR 1146 (42S02) at line 2: Table 'coeus.krim_perm_id_bs_s' doesn't exist
mysql < dml/KR_DML_03_KRACOEUS-8105_B000.sql
mysql < dml/KR_DML_04_KRACOEUS-8105_B000.sql
mysql < constraints/KC_FK1_BUDGET_SUB_AWARD_ATT.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment