Opened 6 years ago
Last modified 4 years ago
#1246 open defect
Syndie: java.sql.SQLDataException: data exception: string data, right truncation
Reported by: | killyourtv | Owned by: | |
---|---|---|---|
Priority: | minor | Milestone: | |
Component: | apps/syndie | Version: | |
Keywords: | Cc: | ||
Parent Tickets: | Sensitive: | no |
Description
Pulling from an archive, I received several instances in the log:
java.sql.SQLDataException: data exception: string data, right truncation; table: MESSAGEATTACHMENT column: NAME at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source) at syndie.db.ImportPost.insertAttachment(ImportPost.java:1077) at syndie.db.ImportPost.setMessageAttachments(ImportPost.java:1041) at syndie.db.ImportPost.importMessageBody(ImportPost.java:553) at syndie.db.ImportPost.importMessage(ImportPost.java:535) at syndie.db.ImportPost.process(ImportPost.java:489) at syndie.db.Importer.importPost(Importer.java:325) at syndie.db.Importer.processMessage(Importer.java:225) at syndie.db.Importer.processMessage(Importer.java:178) at syndie.db.SyncInboundFetcher.importData(SyncInboundFetcher.java:537) at syndie.db.SyncInboundFetcher.access$600(SyncInboundFetcher.java:26) at syndie.db.SyncInboundFetcher$DataImporter.run(SyncInboundFetcher.java:526) at java.lang.Thread.run(Thread.java:744) Caused by: org.hsqldb.HsqlException: data exception: string data, right truncation; table: MESSAGEATTACHMENT column: NAME at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.Table.enforceTypeLimits(Unknown Source) at org.hsqldb.Table.insertSingleRow(Unknown Source) at org.hsqldb.StatementDML.insertSingleRow(Unknown Source) at org.hsqldb.StatementInsert.getResult(Unknown Source) at org.hsqldb.StatementDMQL.execute(Unknown Source) at org.hsqldb.Session.executeCompiledStatement(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) ... 14 more Caused by: org.hsqldb.HsqlException: data exception: string data, right truncation at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.types.CharacterType.convertToTypeLimits(Unknown Source) ... 21 more
Subtickets
Change History (2)
comment:1 Changed 6 years ago by
comment:2 Changed 4 years ago by
Status: | new → open |
---|
Note: See
TracTickets for help on using
tickets.
Also reported by hummingbird in Syndie