nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Content survey and reporting - 500 Error

Richard Scorgie

Just installed the new updated Confluence 4.0 ready version of this plugin and it looks great right up until I click the results link and I get a 500 Error.

Ideas?

Accepted answers

All comments

Jeremy Largman

I'm not able to replicate this. What version of Confluence are you using? Also, do you have access to your atlassian-confluence.log, where you can spot the error?

Richard Scorgie

Hi Jeezer, Thanks for the quick reply.

I'm using Confluence 4.0.3 with Theme Builder on top of that. I'll check the log file as well.

Richard Scorgie

Here is what the log file says:
2011-12-09 14:44:57,279 INFO [TP-Processor3] [atlassian.confluence.status.SystemErrorInformationLogger] writeToLog
Request Unique ID : 7fc3c6f2-1eae-499d-bcb8-fe1e56b4e99b
--------------------------
JVM Stats
--------------------------
allocatedHeap = 496697344
availablePermGen = 112843776
usedMemory = 301986568
totalMemory = 496697344
freeMemory = 194710776
maxPermGen = 268435456
usedPermGen = 155591680
freeMemoryInMegabytes = 185
freeAllocatedHeap = 194710776
availableHeap = 194710776
usedMemoryInMegabytes = 287
maxHeap = 496697344
usedHeap = 301986568
totalMemoryInMegabytes = 473
--------------------------
Request Information
--------------------------
URL: http://cait-km-wiki-stg.ca.nam.example.com/500page.jsp
Scheme: http
Server: cait-km-wiki-stg.internal.com
Port: 80
URI: /500page.jsp
Context Path:
Servlet Path: /500page.jsp
Path Info: null
Query String: key=Wiki
key : Wiki
caused by: org.springframework.jdbc.BadSqlGrammarException: Hibernate operation; bad SQL grammar []; nested exception is java.sql.SQLException: Incorrect syntax near 'LIMIT'.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97)
caused by: java.sql.SQLException: Incorrect syntax near 'LIMIT'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)

Jeremy Largman

I think it's this:

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

I hope to fix it over the holidays. Please stay tuned to that bug report and I'll update there.

Richard Scorgie

Any update on the MS-SQL fix?

Jeremy Largman

I've posted a fix. Sorry for the delay!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

survey

content-survey-and-reporting