When adding a Page/Tool with a title more than the allowed 99 chars

GENERAL

TESTING

GENERAL

TESTING

Description

When importing a CC, there are not many checks to ensure Page and Tool title’s don’t exceed the maximum chars.

13:06:20.565 WARN [http-nio2-8080-exec-1] o.s.d.i.BasicSqlService.dbWriteCount Sql.dbWrite(): error code: 1406 sql: insert into SAKAI_SITE_PAGE (PAGE_ID, SITE_ID, TITLE, LAYOUT, POPUP, SITE_ORDER) values (?,?,?,?,?,?) binds:  213d0b20-95b5-4141-b58e-d56df3bc8c62 03dd4825-9005-41>
java.sql.SQLSyntaxErrorException: (conn=382) Data too long for column 'TITLE' at row 1
        at org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:289) ~[mariadb-java-client-3.5.1.jar:?]
        at org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:378) ~[mariadb-java-client-3.5.1.jar:?]
        at org.mariadb.jdbc.message.ClientMessage.readPacket(ClientMessage.java:189) ~[mariadb-java-client-3.5.1.jar:?]
        at org.mariadb.jdbc.client.impl.StandardClient.readPacket(StandardClient.java:1246) ~[mariadb-java-client-3.5.1.jar:?]
        at org.mariadb.jdbc.client.impl.StandardClient.readResults(StandardClient.java:1185) ~[mariadb-java-client-3.5.1.jar:?]
        at org.mariadb.jdbc.client.impl.StandardClient.readResponse(StandardClient.java:1104) ~[mariadb-java-client-3.5.1.jar:?]
        at org.mariadb.jdbc.client.impl.StandardClient.execute(StandardClient.java:1028) ~[mariadb-java-client-3.5.1.jar:?]
        at org.mariadb.jdbc.ServerPreparedStatement.executeStandard(ServerPreparedStatement.java:151) ~[mariadb-java-client-3.5.1.jar:?]
        at org.mariadb.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:98) ~[mariadb-java-client-3.5.1.jar:?]
        at org.mariadb.jdbc.ServerPreparedStatement.executeLargeUpdate(ServerPreparedStatement.java:449) ~[mariadb-java-client-3.5.1.jar:?]
        at org.mariadb.jdbc.ServerPreparedStatement.executeUpdate(ServerPreparedStatement.java:426) ~[mariadb-java-client-3.5.1.jar:?]
        at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[HikariCP-6.0.0.jar:?]
        at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) ~[HikariCP-6.0.0.jar:?]
        at org.sakaiproject.db.impl.BasicSqlService.dbWriteCount(BasicSqlService.java:1280) [sakai-kernel-impl-25-SNAPSHOT.jar:?]
        at org.sakaiproject.db.impl.BasicSqlService.dbWriteCount(BasicSqlService.java:1146) [sakai-kernel-impl-25-SNAPSHOT.jar:?]
        at org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1131) [sakai-kernel-impl-25-SNAPSHOT.jar:?]
        at org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1060) [sakai-kernel-impl-25-SNAPSHOT.jar:?]
        at org.sakaiproject.site.impl.DbSiteService$DbStorage.saveTx(DbSiteService.java:334) [sakai-kernel-impl-25-SNAPSHOT.jar:?]
        at org.sakaiproject.site.impl.DbSiteService$DbStorage$1.run(DbSiteService.java:275) [sakai-kernel-impl-25-SNAPSHOT.jar:?]
        at org.sakaiproject.db.impl.BasicSqlService.transact(BasicSqlService.java:330) [sakai-kernel-impl-25-SNAPSHOT.jar:?]
        at org.sakaiproject.site.impl.DbSiteService$DbStorage.save(DbSiteService.java:271) [sakai-kernel-impl-25-SNAPSHOT.jar:?]
        at org.sakaiproject.site.impl.BaseSiteService.doSave(BaseSiteService.java:1021) [sakai-kernel-impl-25-SNAPSHOT.jar:?]
        at org.sakaiproject.site.impl.BaseSiteService.save(BaseSiteService.java:914) [sakai-kernel-impl-25-SNAPSHOT.jar:?]
        at org.sakaiproject.lessonbuildertool.tool.beans.SimplePageBean.addPage(SimplePageBean.java:5058) [classes/:?]
        at org.sakaiproject.lessonbuildertool.tool.beans.SimplePageBean.addPage(SimplePageBean.java:5024) [classes/:?]
        at org.sakaiproject.lessonbuildertool.cc.PrintHandler.startCCFolder(PrintHandler.java:267) [classes/:?]
        at org.sakaiproject.lessonbuildertool.cc.PrintHandler.setCCItemXml(PrintHandler.java:555) [classes/:?]
        at org.sakaiproject.lessonbuildertool.cc.Parser.processItem(Parser.java:305) [classes/:?]
        at org.sakaiproject.lessonbuildertool.cc.Parser.processItem(Parser.java:318) [classes/:?]
        at org.sakaiproject.lessonbuildertool.cc.Parser.processManifest(Parser.java:199) [classes/:?]
        at org.sakaiproject.lessonbuildertool.cc.Parser.parse(Parser.java:145) [classes/:?]
        at org.sakaiproject.lessonbuildertool.tool.beans.SimplePageBean.importCcFromStream(SimplePageBean.java:7180) [classes/:?]
        at org.sakaiproject.lessonbuildertool.tool.beans.SimplePageBean.importCc(SimplePageBean.java:7096) [classes/:?]

Activity

Show:

Automation for Jira February 14, 2025 at 6:28 PM

A pull request has been created, "SAK-51003 Kernel SiteService limit column title to a length of 99 chars", you can see it at https://github.com/sakaiproject/sakai/pull/13313