| Newsgroups |
gmane.comp.web.webobjects.wonder-disc |
| Message-ID |
<[email protected]> |
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