From: James C. <ja...@ji...> - 2012-12-24 00:33:31
|
I set it at a 1000 for now. I will reset it back manually. :-) I guess you can just use pure sql to alter the column. Luckily for now I am just doing a lot of model work and am editing my zero each time I make some changes. On Dec 23, 2012, at 6:25 PM, Ramsey Gurley <ram...@gm...> wrote: > D'oh. It's supposed to be 100, but my manual migration is obviously imperfect. Evidently, MySQL can't unique on a CLOB but Postgresql doesn't mind. It seems the only way to fix that is to update migration 1. > > Out of curiosity though, does anyone know if it is possible to update the width of a column in migrations? > > Ramsey > > On Dec 23, 2012, at 12:56 PM, James Cicenia wrote: > >> How long is messageID ? >> >> >> Caused by: java.lang.RuntimeException: Failed to execute 'ALTER TABLE `ERCMailMessage` ADD UNIQUE `ERCMailMessage_messageID_idx` (`messageID`)'. >> at er.extensions.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:666) >> at er.extensions.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:603) >> at er.extensions.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:585) >> at er.extensions.migration.ERXMigrationTable.addUniqueIndex(ERXMigrationTable.java:1106) >> at er.extensions.migration.ERXMigrationTable.addUniqueIndex(ERXMigrationTable.java:1088) >> at er.extensions.migration.ERXMigrationTable.addUniqueIndex(ERXMigrationTable.java:1077) >> at er.extensions.migration.ERXMigrationTable.addUniqueIndex(ERXMigrationTable.java:1053) >> at er.corebl.migrations.ERCoreBL1.upgrade(ERCoreBL1.java:33) >> at er.extensions.migration.ERXMigrationDatabase$Migration.upgrade(ERXMigrationDatabase.java:440) >> at er.extensions.migration.ERXMigrator$ERXMigrationAction.doPerform(ERXMigrator.java:473) >> ... 16 more >> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: BLOB/TEXT column 'messageID' used in key specification without a key length >> >> >> >> >> >> James Cicenia >> cell: 773.398.4649 >> >> >> >> ------------------------------------------------------------------------------ >> LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial >> Remotely access PCs and mobile devices and provide instant support >> Improve your efficiency, and focus on delivering more value-add services >> Discover what IT Professionals Know. Rescue delivers >> http://p.sf.net/sfu/logmein_12329d2d_______________________________________________ >> Wonder-disc mailing list >> Won...@li... >> https://lists.sourceforge.net/lists/listinfo/wonder-disc > |