ERCoreBL1 migration issue:
James Cicenia <[email protected]>
| Newsgroups | gmane.comp.web.webobjects.wonder-disc |
|---|---|
| Message-ID | <[email protected]> |
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