Advertisement
Guest User

Untitled

a guest
Mar 27th, 2015
239
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.42 KB | None | 0 0
  1. ** [out :: demo-alpha-test.crowdcomputingsystems.com] ========== Applying: 20141201100039_Update_HitSubmissionDataItem#originalItemId_with_id_value.sql
  2. ** [out :: demo-alpha-test.crowdcomputingsystems.com] Error executing: -- Update HitSubmissionDataItem#originalItemId with id value
  3. ** [out :: demo-alpha-test.crowdcomputingsystems.com] -- Migration SQL that makes the change goes here.
  4. ** [out :: demo-alpha-test.crowdcomputingsystems.com] ALTER TABLE `HitSubmissionDataItem`
  5. ** [out :: demo-alpha-test.crowdcomputingsystems.com] DROP INDEX `IDX_HitSubmissionDataItem_originalItemId`;
  6. ** [out :: demo-alpha-test.crowdcomputingsystems.com]
  7. ** [out :: demo-alpha-test.crowdcomputingsystems.com] UPDATE HitSubmissionDataItem
  8. ** [out :: demo-alpha-test.crowdcomputingsystems.com] SET originalItemId = id
  9. ** [out :: demo-alpha-test.crowdcomputingsystems.com] WHERE originalItemId IS NULL;
  10. ** [out :: demo-alpha-test.crowdcomputingsystems.com]
  11. ** [out :: demo-alpha-test.crowdcomputingsystems.com] ALTER TABLE `HitSubmissionDataItem`
  12. ** [out :: demo-alpha-test.crowdcomputingsystems.com] ADD INDEX `IDX_HitSubmissionDataItem_originalItemId` (`originalItemId` ASC);
  13. ** [out :: demo-alpha-test.crowdcomputingsystems.com]
  14. ** [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