Re: ERCoreBL1 migration issue:
James Cicenia <[email protected]>
| Newsgroups | gmane.comp.web.webobjects.wonder-disc |
|---|---|
| Message-ID | <[email protected]> |
Hmmm, have to look at this migration stuff a bit more. On Dec 23, 2012, at 6:32 PM, [email protected] wrote: > partialPersonTable.existingColumnNamed("x").setWidthType(0, 0, null) > > > On 2012-12-23, at 4:25 PM, Ramsey Gurley <[email protected]> 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 >>> [email protected] >>> https://lists.sourceforge.net/lists/listinfo/wonder-disc >> >> ------------------------------------------------------------------------------ >> 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 >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/wonder-disc > ------------------------------------------------------------------------------ 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 [email protected] https://lists.sourceforge.net/lists/listinfo/wonder-disc