Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ** [out :: demo-alpha-test.crowdcomputingsystems.com] ========== Applying: 20141201100039_Update_HitSubmissionDataItem#originalItemId_with_id_value.sql
- ** [out :: demo-alpha-test.crowdcomputingsystems.com] Error executing: -- Update HitSubmissionDataItem#originalItemId with id value
- ** [out :: demo-alpha-test.crowdcomputingsystems.com] -- Migration SQL that makes the change goes here.
- ** [out :: demo-alpha-test.crowdcomputingsystems.com] ALTER TABLE `HitSubmissionDataItem`
- ** [out :: demo-alpha-test.crowdcomputingsystems.com] DROP INDEX `IDX_HitSubmissionDataItem_originalItemId`;
- ** [out :: demo-alpha-test.crowdcomputingsystems.com]
- ** [out :: demo-alpha-test.crowdcomputingsystems.com] UPDATE HitSubmissionDataItem
- ** [out :: demo-alpha-test.crowdcomputingsystems.com] SET originalItemId = id
- ** [out :: demo-alpha-test.crowdcomputingsystems.com] WHERE originalItemId IS NULL;
- ** [out :: demo-alpha-test.crowdcomputingsystems.com]
- ** [out :: demo-alpha-test.crowdcomputingsystems.com] ALTER TABLE `HitSubmissionDataItem`
- ** [out :: demo-alpha-test.crowdcomputingsystems.com] ADD INDEX `IDX_HitSubmissionDataItem_originalItemId` (`originalItemId` ASC);
- ** [out :: demo-alpha-test.crowdcomputingsystems.com]
- ** [out :: demo-alpha-test.crowdcomputingsystems.com] . Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'IDX_HitSubmissionDataItem_originalItemId'; check that column/key exists
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement