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

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 2.3.0
    • 2.3.0
    • None
    • None

      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)
      

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

              Created:
              Updated:
              Resolved: