Comments in {checklist} macro can not contain special characters

{checklist:name=Design Status: | parent=3000 Design | checklabels=mypplus_abnahme, mypplus_changerequests, mypplus_release1 | comment-heading=Comments}

Cause:
org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Data truncation: Data truncated for column 'text_val' at row 1]; nested exception is java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:99)
caused by: java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1
at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:648)

Stack Trace: [hide]

org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Data truncation: Data truncated for column 'text_val' at row 1]; nested exception is java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1
java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1
at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:648)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2438)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2393)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261)
at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:472)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:397)
at com.atlassian.xwork.interceptors.XWorkTransactionInterceptor$1.beforeResult(XWorkTransactionInterceptor.java:89)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:181)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.util.LoggingContextInterceptor.intercept(LoggingContextInterceptor.java:48)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:47)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:114)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.spaces.actions.SpaceAwareInterceptor.intercept(SpaceAwareInterceptor.java:67)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.core.actions.LastModifiedInterceptor.intercept(LastModifiedInterceptor.java:39)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.xwork.interceptors.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:98)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115)
at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:229)
at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:199)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:117)
at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:137)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.atlassian.core.filters.ServletContextThreadLocalFilter.doFilter(ServletContextThreadLocalFilter.java:21)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.atlassian.confluence.util.LoggingContextFilter.doFilter(LoggingContextFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.atlassian.confluence.util.UserThreadLocalFilter.doFilter(UserThreadLocalFilter.java:44)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:182)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:159)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.atlassian.confluence.util.ClusterHeaderFilter.doFilter(ClusterHeaderFilter.java:35)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:172)
at com.atlassian.spring.filter.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:29)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:122)
at com.atlassian.core.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:27)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.atlassian.confluence.util.RequestCacheThreadLocalFilter.doFilter(RequestCacheThreadLocalFilter.java:25)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.atlassian.core.filters.gzip.GzipFilter.doFilter(GzipFilter.java:61)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:534)
Referer URL: http://wiki.namics.com/display/MYPPLUS/3000+Design

Build Information:
confluence.home: /home/confluence/data
system.uptime: 5 days, 7 hours, 47 minutes, 21 seconds
system.version: 2.5.4
build.number: 809

Server Information:
Application Server: Apache Tomcat/5.5.15
Servlet Version: 2.4
Database Dialect: com.atlassian.hibernate.dialect.MySQLDialect
Database Driver Name: com.mysql.jdbc.Driver
Database Driver Version: 3.1

Memory Information:
total.memory: 254 MB
free.memory: 105 MB
used.memory: 149 MB

System Information:
system.date: Wednesday, 26 Sep 2007
system.time: 15:53:06
system.favourite.colour: Myrtle
java.version: 1.4.2_10
java.vendor: Sun Microsystems Inc.
jvm.version: 1.0
jvm.vendor: Sun Microsystems Inc.
jvm.implementation.version: 1.4.2_10-b03
java.runtime: Java(TM) 2 Runtime Environment, Standard Edition
java.vm: Java HotSpot(TM) Client VM
user.name.word: root
user.timezone: Europe/Zurich
operating.system: Linux 2.6.9-5.0.5.ELsmp
os.architecture: i386
fs.encoding: UTF-8

Cluster Information:
Not clustered.

Enabled Plugins:
Checklists Macros (com.comalatech.checklists, Version: 1.2)
Basic Macros (confluence.macros.basic, Version: 1.3)
Confluence Usage Stats (com.atlassian.confluence.ext.usage, Version: 0.7.2)
Chart Plugin (confluence.extra.chart, Version: 1.8)
User Listener (confluence.extra.userlister, Version: 1.2)
Global Labels Sections (confluence.sections.labels, Version: 1.0)
Information Macros (confluence.extra.information, Version: 0.2)
Page Operations (confluence.sections.page.operations, Version: 1.0)
Task List Macros V2 (confluence.extra.tasklistv2, Version: 2.0.1)
WebDAV Plugin (confluence.extra.webdav, Version: 1.1)
Profile Tabs (confluence.sections.profile, Version: 1.0)
Confluence Remote API (confluence.extra.confluencerpc, Version: 1.4)
Core Startup and Shutdown (confluence.lifecycle.core, Version: 1)
Admin Sections (confluence.sections.admin, Version: 1.0)
Table of Contents Plugin (org.randombits.confluence.toc, Version: 2.3.2)
TinyMCE Editor Plugin (com.atlassian.confluence.extra.tinymceplugin, Version: 1.12)
Space Pages Sections (confluence.sections.space.pages, Version: 1.0)
News Tabs (confluence.sections.news, Version: 1.0)
Space Advanced Sections (confluence.sections.space.advanced, Version: 1.0)
Confluence Contributors Plugin (com.atlassian.confluence.contributors, Version: 1.1)
Attachments Macros (confluence.extra.attachments, Version: 1.4)
IM Presence Macros (confluence.extra.impresence, Version: 0.1)
Space Actions Sections (confluence.sections.space.actions, Version: 1.0)
Task List Macros (confluence.extra.tasklist, Version: 1.3)
Redirection Macros (org.randombits.confluence.redirection, Version: 2.2)
Space Labels Sections (confluence.sections.space.labels, Version: 1.0)
Dynamic Task List Macros (confluence.extra.dynamictasklist, Version: 1.5)
Core Extractors (confluence.extractors.core, Version: 1.4)
Compatibility Macros (confluence.macros.compatibility, Version: 1.3)
Page Tabs (confluence.sections.page, Version: 1.0)
Core Listeners (confluence.listeners.core, Version: 1.3)
Dashboard Macros (confluence.macros.dashboard, Version: 1.3)
Live Search Macros (confluence.extra.livesearch, Version: 1.6)
Page View Links (confluence.sections.page.actions, Version: 1.0)
JIRA Macros (confluence.extra.jira, Version: 1.6)
Clickr Theme (com.atlassian.confluence.themes.clickr, Version: 0.9.1)
Layout Macros (confluence.extra.layout, Version: 0.2)
Excel Plugin (org.swift.confluence.excel, Version: 3.1)
Tabular Metadata (confluence.extra.masterdetail, Version: 1.0)
Space Admin Sections (confluence.sections.space.admin, Version: 1.0)
Mail Page Plugin (com.atlassian.confluence.ext.mailpage, Version: 1.2)
Calendar Plugin (confluence.extra.calendar, Version: 2.3)
Testplan Plugins (com.pantero.confluence.plugins.testplans, Version: 1.1)
Advanced Macros (confluence.macros.advanced, Version: 1.3)
IM Presence NG Plugin (confluence.extra.impresence2, Version: 2.0-rc2)
Atlassian Plugin Repository (confluence.repository.client, Version: 2.0.4)
Edit Profile Sections (confluence.sections.profile.edit, Version: 1.0)
Attachment Extractors (confluence.extractors.attachments, Version: 1.4)
Left Navigation Theme (com.atlassian.confluence.themes.leftnavigation, Version: 1.0)
BloggingRPC (com.atlassian.confluence.plugins.xmlrpc.bloggingrpc, Version: 1.2.1)
Space Item Tabs (confluence.sections.space, Version: 1.0)
Code Macro (confluence.macros.code, Version: 1.4)

Request
Information:
URL: http://wiki.namics.com/500page.jsp

• Scheme: http
• Server: wiki.namics.com
• Port: 80
• URI: /500page.jsp
• - Context Path:
• - Servlet Path: /500page.jsp
• - Path Info: null
• - Query String: entityId=4497&columnKey=Comments&cellId=DesignStatus_8332_537771500&pageId=8332&checklistId=DesignStatus&rows=5&cols=50&storeInRows=true&value=Besprochene%20%C3%84nderungen%20m%EF%BF%BDssen%20noch%20gemacht%20werden.

Attributes:

• javax.servlet.forward.request_uri : /plugins/checklists/setWikiInput.action
• javax.servlet.forward.context_path :
• javax.servlet.forward.servlet_path : /plugins/checklists/setWikiInput.action
• javax.servlet.forward.path_info : /500page.jsp
• javax.servlet.forward.query_string : entityId=4497&columnKey=Comments&cellId=DesignStatus_8332_537771500&pageId=8332&checklistId=DesignStatus&rows=5&cols=50&storeInRows=true&value=Besprochene%20%C3%84nderungen%20m%EF%BF%BDssen%20noch%20gemacht%20werden.
• javax.servlet.error.exception : org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Data truncation: Data truncated for column 'text_val' at row 1]; nested exception is java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1
• javax.servlet.error.message :
• os_securityfilter_already_filtered : true
• com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true
• _sitemesh_using_stream : false
• javax.servlet.error.request_uri : /plugins/checklists/setWikiInput.action
• javax.servlet.error.status_code : 500
• _sitemesh_filterapplied : true
• javax.servlet.error.servlet_name : action
• webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@164109d
• loginfilter.already.filtered : true
• atlassian.core.seraph.original.url : /plugins/checklists/setWikiInput.action?entityId=4497&columnKey=Comments&cellId=DesignStatus_8332_537771500&pageId=8332&checklistId=DesignStatus&rows=5&cols=50&storeInRows=true&value=Besprochene%20%C3%84nderungen%20m%EF%BF%BDssen%20noch%20gemacht%20werden.
• javax.servlet.jsp.jspException : org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Data truncation: Data truncated for column 'text_val' at row 1]; nested exception is java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1
• sessioninview.FILTERED : true
• com.atlassian.core.filters.gzip.GzipFilter_already_filtered : true

Parameters:

• cols = 50
• value = Besprochene Änderungen müssen noch gemacht werden.
• rows = 5
• checklistId = DesignStatus
• storeInRows = true
• columnKey = Comments
• cellId = DesignStatus_8332_537771500
• entityId = 4497
• pageId = 8332
  Confluence User:
• anonymous

Logging:
0 log statements generated by this request.