Uploaded image for project: 'Offre de formation'
  1. Offre de formation
  2. ODF-1007

[Export SQL] : Export impossible à cause d'un commentaire mysql trop long

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.3.0
    • Fix Version/s: 2.3.0
    • Component/s: None
    • Labels:
      None

      Description

      testé sur mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1

      2015-03-31 09:59:28,034 INFO  [org.ametys.odf.export.ODFExportManager] (ODFExportEngine;/plugins/core/servercomm/messages.xml) CREATE TABLE odf_subprogram_enum_distanceLearning (key_enum VARCHAR(255) PRIMARY KEY NOT NULL COMMENT 'Clé de l\'enumerateur' , value_enum_distanceLearning TEXT) ENGINE=MYISAM COMMENT 'Table de l\'énumérateur distanceLearning liée à la table odf_subprogram'
      2015-03-31 09:59:28,035 ERROR [org.ametys.odf.export.ODFExportEngine] (ODFExportEngine;/plugins/core/servercomm/messages.xml) ODF export has failed
      java.sql.SQLException: Comment for table 'odf_subprogram_enum_distanceLearning' is too long (max = 64)
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
      	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
      	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
      	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
      	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
      	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:995)
      	at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
      	at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
      	at org.ametys.odf.export.ExportManager.executeSqlQueries(ExportManager.java:421)
      	at org.ametys.odf.export.ExportManager.export(ExportManager.java:209)
      	at org.ametys.odf.export.ODFExportEngine.export(ODFExportEngine.java:186)
      	at org.ametys.odf.export.ODFExportEngine.run(ODFExportEngine.java:104)
      	at java.lang.Thread.run(Thread.java:662)
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              lperier Laurence Perier
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: