Re: [xwiki-users] Profile Pictures not displayed after upgrade
Gedetailleerde informatie: Error number 0 in 11: Uncaught exception com.xpn.xwiki.XWikiException: Error number 0 in 11: Uncaught exception at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:317) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:129) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449) at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:121) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:126) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:701) Caused by: java.lang.NoClassDefFoundError: Could not initialize class sun.awt.X11GraphicsEnvironment at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:190) at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:82) at java.awt.image.BufferedImage.createGraphics(BufferedImage.java:1182) at com.xpn.xwiki.internal.plugin.image.DefaultImageProcessor.scaleImage(DefaultImageProcessor.java:106) at com.xpn.xwiki.plugin.image.ImagePlugin.shrinkImage(ImagePlugin.java:328) at com.xpn.xwiki.plugin.image.ImagePlugin.downloadImageFromCache(ImagePlugin.java:284) at com.xpn.xwiki.plugin.image.ImagePlugin.downloadImage(ImagePlugin.java:247) at com.xpn.xwiki.plugin.image.ImagePlugin.downloadAttachment(ImagePlugin.java:220) at com.xpn.xwiki.plugin.XWikiPluginManager.downloadAttachment(XWikiPluginManager.java:292) at com.xpn.xwiki.web.DownloadAction.render(DownloadAction.java:111) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:294) ... 38 more -- View this message in context:
Re: [xwiki-users] Profile Pictures not displayed after upgrade
We also receive this error when we want to insert a picture. Looks like something went wrong when we upgraded from 4.0 to 5.4.2 How can we fix the pictures from the database? http://xwiki.475771.n2.nabble.com/file/n7589838/Insert_Image_error.png -- View this message in context: http://xwiki.475771.n2.nabble.com/Profile-Pictures-not-displayed-after-upgrade-tp7589809p7589838.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] skol
FTR I’ve updated http://myxwiki.org/xwiki/bin/view/Main/WebHome and added: It's your duty to keep your wiki healthy and to avoid having it use too many resources (CPU and memory). This means avoiding using costly scripts and properly securing your wiki to avoid spam users and spam comments. Your wiki may be closed if it's not abiding by this rule. Thanks -Vincent On 26 Mar 2014 at 18:56:10, Guillaume Fenollar (guillaume.fenol...@xwiki.com(mailto:guillaume.fenol...@xwiki.com)) wrote: Hello dmitry, I've reopened dafedin.myxwiki.org, but we would really appreciate that you clean your instance a bit, by : 1. Closing free registration. It can be done by unchecking the register right to Guest users, in the administration. 2. Cleaning the spam users. You can use this snippet for that : http://extensions.xwiki.org/xwiki/bin/view/Extension/Delete+Spam+Users If it is proved that your wiki brings too much load to the myxwiki.orgplatform due to again spam activity (you have 453 users ATM, mostly fakes), we would have to close your wiki again. Myxwiki.org farm is a pretty stable platform now, let's keep it like this. Guillaume Fenollar XWiki SAS 2014-03-26 14:30 GMT+01:00 Дмитрий Федин : please, reopen my xwiki: dafedin.myxwiki.org С уважением, Дмитрий Федин dafe...@mail.ru ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] need help for link checker trough a http proxy
A bug?
The table bin/view/XWiki/ExternalLinks can't be sorted even if I modify this
code:
#set($columnsProperties = {
'link' : { 'type' : 'text', 'sortable' : true, 'link' : 'field' },
'page' : { 'type' : 'text', 'sortable' : true, 'link' : 'field' },
'code' : { 'type' : 'text', 'sortable' : true },
'date' : { 'type' : 'text', 'sortable' : true }
})
NB: this code indicate ''description' : 'This table lists the states of all
external links found on this wiki. The columns can be sorted.'
De : Pascal BASTIEN pbasnews-xw...@yahoo.fr
À : XWiki Users users@xwiki.org
Envoyé le : Mercredi 26 mars 2014 11h06
Objet : [xwiki-users] need help for link checker trough a http proxy
Hello,
I use link checker functionnality to check the validity of external URL
http://extensions.xwiki.org/xwiki/bin/view/Extension/Link+Checker+Transformation
There are a way to indicate my proxy?
My web server is behind a proxy and the url checker can't verify trough it.
Internet URL aren't verified but intranet URL can be verified (because for the
moment my webserver don't need a proxy to see intranet site)
I launch my tomcat with:
JAVA_OPTS=x -Dhttp.proxyHost=my.http.proxy.fr -Dhttp.proxyPort=
I tested this extension to:
http://extensions.xwiki.org/xwiki/bin/view/Extension/All+Broken+Links
but the result speaking chinese: http://snag.gy/x2dZc.jpg
Thxs for your answers/tip.
Pascal BASTIEN
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
[xwiki-users] Attachments on new pages that contain 'Objects' of 'Class'.
XWiki has the nice feature of Class and Class related sheets and templates. I feel there is a annoying bug with regard to uploading attachments, although XWiki experts explain why it's happening. (they do not confirm it's a BUG!!) When you create a Class, Sheet and Template there is a moment to add a new-object on a page. In XWiki you could, like app-within-minutes, create a button: Create new record of something The user will then see a new-page in inline edit mode (a html form) and usually a few buttons: Save and View, Save and Continue and Cancel. I think the last one: 'Cancel' is why the 'In my opinion BUG' is happening. The new document and object are not yet saved... You are first considered to fill in the form and when you reconsider or not able to fill in all the required fields there is 'Cancel'; nothing saved and gentle exit (although sometimes you get: XWiki document does not exist, a smarter CANCEL that would redirect you to the page with the creation option...) But now about my BUG; If the form contains a option to upload a attachment (like the avatar image on XWikiUsers) we get very user unfriendly things. The explanation of the error is; you can not attach anything to a page not yet saved! But the results are quite dramatic; a page, sometimes two are created, but not containing any object (so all the data in the form is lost). The user is not informed about what happened... What coding can be done to prevent the above.. Why I consider it a BUG? The same problem occurs when you have a Large Text field with the wysywig editor. This editor has a button 'Image' or 'Attachment'. How can we then prevent the problem occurring? Gerritjan ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] need help for link checker trough a http proxy
On 27 Mar 2014 at 09:55:08, Pascal BASTIEN
(pbasnews-xw...@yahoo.fr(mailto:pbasnews-xw...@yahoo.fr)) wrote:
A bug?
The table bin/view/XWiki/ExternalLinks can't be sorted even if I modify this
code:
#set($columnsProperties = {
'link' : { 'type' : 'text', 'sortable' : true, 'link' : 'field' },
'page' : { 'type' : 'text', 'sortable' : true, 'link' : 'field' },
'code' : { 'type' : 'text', 'sortable' : true },
'date' : { 'type' : 'text', 'sortable' : true }
})
NB: this code indicate ''description' : 'This table lists the states of all
external links found on this wiki. The columns can be sorted.’
If you change the livetable to allow sorting then you also need to modify the
JSON to allow sorting :) Sorting is not a supported feature yet of the JSON.
Thanks
-Vincent
De : Pascal BASTIEN
À : XWiki Users
Envoyé le : Mercredi 26 mars 2014 11h06
Objet : [xwiki-users] need help for link checker trough a http proxy
Hello,
I use link checker functionnality to check the validity of external URL
http://extensions.xwiki.org/xwiki/bin/view/Extension/Link+Checker+Transformation
There are a way to indicate my proxy?
My web server is behind a proxy and the url checker can't verify trough it.
Internet URL aren't verified but intranet URL can be verified (because for the
moment my webserver don't need a proxy to see intranet site)
I launch my tomcat with:
JAVA_OPTS=x -Dhttp.proxyHost=my.http.proxy.fr -Dhttp.proxyPort=
I tested this extension to:
http://extensions.xwiki.org/xwiki/bin/view/Extension/All+Broken+Links
but the result speaking chinese: http://snag.gy/x2dZc.jpg
Thxs for your answers/tip.
Pascal BASTIEN
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Attachments on new pages that contain 'Objects' of 'Class'.
I would... ...let the users fill in the form ...let the users browse for attachments and store these vars Only when the user hits Apply (or Save and View), then... ...create the page (with the contents from the form) ...attach all the attachments from the stored vars If the user hits Cancel, then no page will be created and no attachments will be uploaded. -- View this message in context: http://xwiki.475771.n2.nabble.com/Attachments-on-new-pages-that-contain-Objects-of-Class-tp7589841p7589843.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Attachments on new pages that contain 'Objects' of 'Class'.
Hello, Personnally I would merely add some hints on concerned fields (wysiwyg, attachment chooser, ...) to warn users that they must first save the page one time THEN re-edit it to add this information, or you could update your Sheet in edit mode to not display those fields if object does not yet exist. That's what is done on xwiki org when you contribute an extension. BR, Jeremie 2014-03-27 10:16 GMT+01:00 Gerritjan Koekkoek gerritjankoekk...@gmail.com: XWiki has the nice feature of Class and Class related sheets and templates. I feel there is a annoying bug with regard to uploading attachments, although XWiki experts explain why it's happening. (they do not confirm it's a BUG!!) When you create a Class, Sheet and Template there is a moment to add a new-object on a page. In XWiki you could, like app-within-minutes, create a button: Create new record of something The user will then see a new-page in inline edit mode (a html form) and usually a few buttons: Save and View, Save and Continue and Cancel. I think the last one: 'Cancel' is why the 'In my opinion BUG' is happening. The new document and object are not yet saved... You are first considered to fill in the form and when you reconsider or not able to fill in all the required fields there is 'Cancel'; nothing saved and gentle exit (although sometimes you get: XWiki document does not exist, a smarter CANCEL that would redirect you to the page with the creation option...) But now about my BUG; If the form contains a option to upload a attachment (like the avatar image on XWikiUsers) we get very user unfriendly things. The explanation of the error is; you can not attach anything to a page not yet saved! But the results are quite dramatic; a page, sometimes two are created, but not containing any object (so all the data in the form is lost). The user is not informed about what happened... What coding can be done to prevent the above.. Why I consider it a BUG? The same problem occurs when you have a Large Text field with the wysywig editor. This editor has a button 'Image' or 'Attachment'. How can we then prevent the problem occurring? Gerritjan ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] skol
About this matter, could we deactivate users registration in the wiki template? Wiki owners will be able to activate it if needed, but most of them don't need that by default, and it's the #1 failure point of this platform. WDYT? Does it need a vote or something? Guillaume 2014-03-27 9:03 GMT+01:00 vinc...@massol.net vinc...@massol.net: FTR I’ve updated http://myxwiki.org/xwiki/bin/view/Main/WebHome and added: It's your duty to keep your wiki healthy and to avoid having it use too many resources (CPU and memory). This means avoiding using costly scripts and properly securing your wiki to avoid spam users and spam comments. Your wiki may be closed if it's not abiding by this rule. Thanks -Vincent On 26 Mar 2014 at 18:56:10, Guillaume Fenollar ( guillaume.fenol...@xwiki.com(mailto:guillaume.fenol...@xwiki.com)) wrote: Hello dmitry, I've reopened dafedin.myxwiki.org, but we would really appreciate that you clean your instance a bit, by : 1. Closing free registration. It can be done by unchecking the register right to Guest users, in the administration. 2. Cleaning the spam users. You can use this snippet for that : http://extensions.xwiki.org/xwiki/bin/view/Extension/Delete+Spam+Users If it is proved that your wiki brings too much load to the myxwiki.orgplatform due to again spam activity (you have 453 users ATM, mostly fakes), we would have to close your wiki again. Myxwiki.org farm is a pretty stable platform now, let's keep it like this. Guillaume Fenollar XWiki SAS 2014-03-26 14:30 GMT+01:00 Дмитрий Федин : please, reopen my xwiki: dafedin.myxwiki.org С уважением, Дмитрий Федин dafe...@mail.ru ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] skol
My bad, I see that it's already the case on myxwiki.org's template. Waiting for your feedback, Dmitry :) Guillaume 2014-03-27 12:13 GMT+01:00 Guillaume Fenollar guillaume.fenol...@xwiki.com : About this matter, could we deactivate users registration in the wiki template? Wiki owners will be able to activate it if needed, but most of them don't need that by default, and it's the #1 failure point of this platform. WDYT? Does it need a vote or something? Guillaume 2014-03-27 9:03 GMT+01:00 vinc...@massol.net vinc...@massol.net: FTR I’ve updated http://myxwiki.org/xwiki/bin/view/Main/WebHome and added: It's your duty to keep your wiki healthy and to avoid having it use too many resources (CPU and memory). This means avoiding using costly scripts and properly securing your wiki to avoid spam users and spam comments. Your wiki may be closed if it's not abiding by this rule. Thanks -Vincent On 26 Mar 2014 at 18:56:10, Guillaume Fenollar ( guillaume.fenol...@xwiki.com(mailto:guillaume.fenol...@xwiki.com)) wrote: Hello dmitry, I've reopened dafedin.myxwiki.org, but we would really appreciate that you clean your instance a bit, by : 1. Closing free registration. It can be done by unchecking the register right to Guest users, in the administration. 2. Cleaning the spam users. You can use this snippet for that : http://extensions.xwiki.org/xwiki/bin/view/Extension/Delete+Spam+Users If it is proved that your wiki brings too much load to the myxwiki.orgplatform due to again spam activity (you have 453 users ATM, mostly fakes), we would have to close your wiki again. Myxwiki.org farm is a pretty stable platform now, let's keep it like this. Guillaume Fenollar XWiki SAS 2014-03-26 14:30 GMT+01:00 Дмитрий Федин : please, reopen my xwiki: dafedin.myxwiki.org С уважением, Дмитрий Федин dafe...@mail.ru ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Profile Pictures not displayed after upgrade
On Thu, Mar 27, 2014 at 9:54 AM, Hamster teun...@hotmail.com wrote: Gedetailleerde informatie: Error number 0 in 11: Uncaught exception com.xpn.xwiki.XWikiException: Error number 0 in 11: Uncaught exception at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:317) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:129) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449) at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:121) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:126) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:701) Caused by: java.lang.NoClassDefFoundError: Could not initialize class sun.awt.X11GraphicsEnvironment https://www.google.com/#q=Could+not+initialize+class+%3E+sun.awt.X11GraphicsEnvironment This is just a sever configuration issue on your side. There's nothing wrong on the XWiki side. Hope this helps, Marius at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:190) at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:82) at java.awt.image.BufferedImage.createGraphics(BufferedImage.java:1182) at com.xpn.xwiki.internal.plugin.image.DefaultImageProcessor.scaleImage(DefaultImageProcessor.java:106) at com.xpn.xwiki.plugin.image.ImagePlugin.shrinkImage(ImagePlugin.java:328) at com.xpn.xwiki.plugin.image.ImagePlugin.downloadImageFromCache(ImagePlugin.java:284) at com.xpn.xwiki.plugin.image.ImagePlugin.downloadImage(ImagePlugin.java:247) at
Re: [xwiki-users] Profile Pictures not displayed after upgrade
Thanks Marius, We have made some more tweaks to the startup script, the pictures are working again. Thanks again for helping out! -- View this message in context: http://xwiki.475771.n2.nabble.com/Profile-Pictures-not-displayed-after-upgrade-tp7589809p7589849.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] XWQL : order by count ?
Hello, Seems every year I hit this problem (ORDER BY COUNT in XWQL causes a parser exception), so this time I decided to create an issue ... :) : http://jira.xwiki.org/browse/XWIKI-10189 BR, Jeremie 2012-05-24 15:13 GMT+02:00 Jeremie BOUSQUET jeremie.bousq...@gmail.com: Hello, Seems I'm back to this problem (XWiki 3.5), and I did not find a solution still ... For example this XWQL request : select topic.author, count(topic.author) from Document doc, doc.object(MailArchiveCode.MailTopicClass) as topic where doc.space'MailArchiveCode' group by topic.author order by count(topic.author) desc ... will throw this exception when executed : Caused by: org.xwiki.query.jpql.parser.ParserException: [1,165] expecting: id at org.xwiki.query.jpql.parser.Parser.parse(Parser.java:1247) at org.xwiki.query.jpql.internal.JPQLParser.parse(JPQLParser.java:46) at org.xwiki.query.xwql.internal.hql.XWQLtoHQLTranslator.translate(XWQLtoHQLTranslator.java:55) at org.xwiki.query.xwql.internal.XWQLQueryExecutor.execute(XWQLQueryExecutor.java:78) ... 123 more Column 165 refers to the count in the order by clause. This does not work better : select topic.author, count(topic.author) from Document doc, doc.object(MailArchiveCode.MailTopicClass) as topic where doc.space'MailArchiveCode' group by topic.author order by 2 desc It does not work with a MySQL nor HSQLDB default db. If I remove the order by clause, the query works correctly. I think it's strange because for me ORDER BY COUNT(column) is valid in JPQL ? As long as the expression is also present in the SELECT clause. Thanks, Jeremie 2011/10/18 jerem jeremie.bousq...@gmail.com Hi, I'm trying to use XWQL query language to select count of authors and would like to order this by descending order of this count. I ended up having this work fine : select count(myobject.author), myobject.author from Document as doc, doc.object(Space.MyClass) as myobject group by myobject.author But adding order by count(myobject.author) desc leads to an error for translating the query ... Adding AS in the select expression does not seem to work either. Is this possible in XWQL and how ? Thanks, Jeremie -- View this message in context: http://xwiki.475771.n2.nabble.com/XWQL-order-by-count-tp6904819p6904819.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
