Re: [Wonder-disc] ERCoreBL1 migration issue:

[Ramsey G. <ram...@gm...>]

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