4.0.5: Content Survey and Reporting Plugin - Display Results not working? (MSSQL)

[Sven]

Hello,

I'll get this error (see below) when clicking on

• Knowledge Base Survey
  • Survey Results

What's going wrong?

Thanks in advance for any suggestion!

Bye

Sven

-----------------------------

-- url: /plugins/macrobrowser/browse-macros.action | userName: Sven | referer: http://srvwiki/display/test/Home | action: browse-macros
2011-12-09 07:29:41,269 ERROR [TP-Processor5] [atlassian.confluence.servlet.ConfluenceServletDispatcher] sendError Could not execute action
-- url: /knowledgebase/kbresults.action | userName: Sven | referer: http://srvwiki/spaces/editspace.action?key=test<br< a=""> />org.springframework.jdbc.BadSqlGrammarException: Hibernate operation; bad SQL grammar []; nested exception is java.sql.SQLException: Falsche Syntax in der Nähe von 'LIMIT'.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org...


































































































































































































































http://srvwiki/500page.jsp<br< a=""> />Scheme: http
Server: srvwiki
Port: 80
URI: /500page.jsp
Context Path:
Servlet Path: /500page.jsp
Path Info: null
Query String: key=test
--------------------------
Attributes
--------------------------
javax.servlet.forward.request_uri: /knowledgebase/kbresults.action
javax.servlet.forward.context_path:
javax.servlet.forward.servlet_path: /knowledgebase/kbresults.action
javax.servlet.forward.path_info: /500page.jsp
javax.servlet.forward.query_string: key=test
os_securityf...




























http://srvwiki/spaces/editspace.action?key=test<br< a=""> />org.springframework.jdbc.BadSqlGrammarException: Hibernate operation; bad SQL grammar []; nested exception is java.sql.SQLException: Falsche Syntax in der Nähe von 'LIMIT'.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org...


































































































































































































































http://srvwiki/500page.jsp<br< a=""> />Scheme: http
Server: srvwiki
Port: 80
URI: /500page.jsp
Context Path:
Servlet Path: /500page.jsp
Path Info: null
Query String: key=test
--------------------------
Attributes
--------------------------
javax.servlet.forward.request_uri: /knowledgebase/kbresults.action
javax.servlet.forward.context_path:
javax.servlet.forward.servlet_path: /knowledgebase/kbresults.action
javax.servlet.forward.path_info: /500page.jsp
javax.servlet.forward.query_string: key=test
os_securityf...

[Jeremy Largman]

Hi Sven,

I think you're hitting this bug:

https://studio.plugins.atlassian.com/browse/CKBSP-22

I really need to fix it! Sorry about this. Hopefully I can get to it over the holidays, that's my plan.

[Sven]

thanks for the answer! hope you will be able to fix it, soon!

PS: There is no workaround? Can I patch something somewhere?