Hi everyone, i recently installed an extension on my wiki but this error appears on the main page of this extension. Does anyone know where is it from ?
Caused by: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column ‘xwiki.longproper1_.XWL_VALUE’ which is not in SELECT list; this is incompatible with DISTINCT
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
Depending on the database engine you use, you may or may not need to include in the SELECT clause every column you want to manipulate. I would assume this is a bug in the extension you installed and not in XWiki Standard, in any case you did not really give enough information to tell you more (which extension are you talking about, which version of XWiki, what you did to have this error, etc.).
Ok thank you, i’m talking about the application documentation GitHub - xwikisas/application-documentation: Allow to create a numbered, user-manual oriented documentation . I used this extension during 2 month on an XWiki Docker and there was non problem on install but now i need to deploy it on another wiki, i did the install the same way but this error came on the Documentation.WebHome page for the ToC display.
I’m using Xwiki on the 13.10.3 version