Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-8141

Allow longer picture caption/headline on MySQL

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.4
    • Fix Version/s: 5.5
    • Component/s: Image Management

      Description

      When using MySQL and picture with a long caption or headline, saving a document fails with:

      org.nuxeo.ecm.core.api.ClientException: Failed to save session
	at org.nuxeo.ecm.core.api.AbstractSession.save(AbstractSession.java:1872)
	...
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: org.nuxeo.ecm.core.api.DocumentException. message: org.nuxeo.ecm.core.storage.StorageException: Could not insert: INSERT INTO `picture` (`id`, `headline`, `genre`, `typage`, `origin`, `slugline`, `caption`, `dateline`, `byline`, `source`, `cropcoords`, `language`, `credit`, `subheadline`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
	...
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: com.mysql.jdbc.MysqlDataTruncation. message: Data truncation: Data too long for column 'caption' at row 1
	...

        Attachments

          Activity

            People

            • Assignee:
              fguillaume Florent Guillaume
              Reporter:
              fguillaume Florent Guillaume
              Participants:
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: