Re: [xwiki-users] Can't use IP as pagename, why?
Hi Florian, This is because dots are not currently allowed in page names since they are separators between space name and page name. -Vincent On Feb 19, 2008, at 11:13 AM, Rustedt, Florian wrote: Hello List, I wanted to edit a list with IP's and every listed IP is backlinked to a page with the IP as name. Wikicode-example (xwiki v1.2.2.7518): Page Main: * [192.168.1.1]: Blabla * [192.168.1.2]: Blabla * [192.168.1.3]: Blabla Now i look at Main and i see following: 168.1.1: Blabla 168.1.2: Blabla 168.1.3: Blabla In HTML: lispan class=wikilinka href=/xwiki/bin/view/192.168.1/1168.1.1/a/span:Blabla/li lispan class=wikilinka href=/xwiki/bin/view/192.168.1/2168.1.2/a/span:Blabla/li lispan class=wikilinka href=/xwiki/bin/view/192.168.1/3168.1.3/a/span:Blabla/li The URL behind the links are now: http://localhost:8080/xwiki/bin/view/192.168.1/1 http://localhost:8080/xwiki/bin/view/192.168.1/2 http://localhost:8080/xwiki/bin/view/192.168.1/3 Instead of linking pages, the wiki did add a complete webspace called 192.168.1?? And additionally, the 192. is gone??? How do i have to understand this behaviour? Kind regards, Florian ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Bulletin Board cannot display topic title and first post !?
Hi, I tried to reproduce your problem but didn't manage to... Can you provide more information about the steps you're following ? - is your user logged-in when he creates the topic ? - has you done anything special with your rights setup ? - has the page been saved once before you create the topic ? - what version of XWiki are you using ? - does it do this with every new topic you create ? - is there any other code on the page ? - etc... Basically I need to be able to reproduce your issue locally in order to find a solution :-) Guillaume On 19/02/2008, Ngo Thi Hong Nga [EMAIL PROTECTED] wrote: I have already entered a title and the first post for the new topic, then click Save and View and the result is what you see in the left of the screenshot. That's the reason why I post this problem here. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users -- http://wikibc.blogspot.com/ ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] MySQL Error invalid use of group function in Statistics application
Sergiu, I must admit that your solution is the more efficient and clean, even if I personally don't like it (you'd be surprised to know how painful it will be to ask my infra team to upgrade mysql version ...). For me it's clearly a MySQL bug not an hibernate one, let's say at least a break of compatibility in MySql not managed by hibernate. Typically what you would like an abstraction layer to take care of ... :/ Thanks for help, Jeremie -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sergiu Dumitriu Sent: mardi 19 février 2008 11:42 To: XWiki Users Subject: Re: [xwiki-users] MySQL Error invalid use of group function in Statistics application Marius Dumitru Florea wrote: A fourth option (someway similar to the second one) is to use the Native SQL Query feature of Hibernate. Instead of calling session.createQuery(hql) you can call session.createSQLQuery(sql). It works, using aliases. However, I tested it only on MySql and HSQLDB. WDYT? Is this a convenient solution. I would have to switch many of the hql queries from the Statistics Application to sql queries. Generally, we should stay away from pure SQL as much as possible. If the existing query works in all DBMSs except mysql 4.1, then leave it as it is. Marius Right.. but the error persists with the correction made. Not at the same level though. WARN util.JDBCExceptionReporter - SQL Error: 1054, SQLState: 42S22 ERROR util.JDBCExceptionReporter - Unknown column 'pageViewsCount' in 'order clause' The problem is with Hibernate. There is a bug (missing feature, for them) in the translation from HQL to SQL. The aliases from the Select clause are not resolved correctly in other clauses, including Order By. In this case they recommend us to duplicate the expressions from the Select clause, hoping that the RDBMS will take care of the optimization. See for yourself: http://opensource.atlassian.com/projects/hibernate/browse/HHH-892 http://opensource.atlassian.com/projects/hibernate/browse/HHH-1902 http://opensource.atlassian.com/projects/hibernate/browse/HHH-2390 http://forum.hibernate.org/viewtopic.php?t=966075postdays=0postorder=ascstart=0 So, using aliases breaks Hibernate and using expressions in the Order By clause is not supported by MySql 4.1.20. I don't see any clean solution for this. Some options are: * drop the Order By clause and sort on the Java side - No way, I don't think this is feasible. * skip Hibernate layer and use JDBC directly - Doable, the SQL query being not too complicated, but with cross DB issues. * tweak the HQL query - How? Any other options Sergiu? Marius Marius Dumitru Florea wrote: Hi Jeremie, The sql query you suggested is cleaner and at least as efficient as the current one. It was my first option but unfortunately it's not supported by the newer versions of mysql. I've no idea why.. mysql select xws_name, sum(xws_page_views) as pageviewcount from xwikistatsdoc where xws_action='view' and xws_name like '%.%' group by xws_name order by pageviewscount desc; ERROR 1054 (42S22): Unknown column 'pageviewscount' in 'order clause' Note that there's a typo: pageviewcount pageview-S-count Anyway, hibernate should be responsible for the correct translation from hql to a specific sql dialect. A solution would be to use the (idea from the) above sql but configure the dialect to MySQL5Dialect (in my case). I have to test this. I'll give you feedback soon. Best Regards, Marius. -- Sergiu Dumitriu http://purl.org/net/sergiu/ ___ 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] MySQL Error invalid use of group function in Statistics application
Marius Dumitru Florea wrote: Right.. but the error persists with the correction made. Not at the same level though. WARN util.JDBCExceptionReporter - SQL Error: 1054, SQLState: 42S22 ERROR util.JDBCExceptionReporter - Unknown column 'pageViewsCount' in 'order clause' The problem is with Hibernate. There is a bug (missing feature, for them) in the translation from HQL to SQL. The aliases from the Select clause are not resolved correctly in other clauses, including Order By. In this case they recommend us to duplicate the expressions from the Select clause, hoping that the RDBMS will take care of the optimization. See for yourself: http://opensource.atlassian.com/projects/hibernate/browse/HHH-892 http://opensource.atlassian.com/projects/hibernate/browse/HHH-1902 http://opensource.atlassian.com/projects/hibernate/browse/HHH-2390 http://forum.hibernate.org/viewtopic.php?t=966075postdays=0postorder=ascstart=0 So, using aliases breaks Hibernate and using expressions in the Order By clause is not supported by MySql 4.1.20. I don't see any clean solution for this. Some options are: * drop the Order By clause and sort on the Java side - No way, I don't think this is feasible. * skip Hibernate layer and use JDBC directly - Doable, the SQL query being not too complicated, but with cross DB issues. * tweak the HQL query - How? Any other options Sergiu? Yep. Say that mysql 5 is not supported. Frankly, I don't understand why people still use ancient versions. Version 4.1 has been EOL-d for some time, and version 7 is on its way already. Marius Marius Dumitru Florea wrote: Hi Jeremie, The sql query you suggested is cleaner and at least as efficient as the current one. It was my first option but unfortunately it's not supported by the newer versions of mysql. I've no idea why.. mysql select xws_name, sum(xws_page_views) as pageviewcount from xwikistatsdoc where xws_action='view' and xws_name like '%.%' group by xws_name order by pageviewscount desc; ERROR 1054 (42S22): Unknown column 'pageviewscount' in 'order clause' Note that there's a typo: pageviewcount pageview-S-count Anyway, hibernate should be responsible for the correct translation from hql to a specific sql dialect. A solution would be to use the (idea from the) above sql but configure the dialect to MySQL5Dialect (in my case). I have to test this. I'll give you feedback soon. Best Regards, Marius. -- Sergiu Dumitriu http://purl.org/net/sergiu/ -- Sergiu Dumitriu http://purl.org/net/sergiu/ ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] MySQL Error invalid use of group function in Statistics application
Right.. but the error persists with the correction made. Not at the same level though. WARN util.JDBCExceptionReporter - SQL Error: 1054, SQLState: 42S22 ERROR util.JDBCExceptionReporter - Unknown column 'pageViewsCount' in 'order clause' The problem is with Hibernate. There is a bug (missing feature, for them) in the translation from HQL to SQL. The aliases from the Select clause are not resolved correctly in other clauses, including Order By. In this case they recommend us to duplicate the expressions from the Select clause, hoping that the RDBMS will take care of the optimization. See for yourself: http://opensource.atlassian.com/projects/hibernate/browse/HHH-892 http://opensource.atlassian.com/projects/hibernate/browse/HHH-1902 http://opensource.atlassian.com/projects/hibernate/browse/HHH-2390 http://forum.hibernate.org/viewtopic.php?t=966075postdays=0postorder=ascstart=0 So, using aliases breaks Hibernate and using expressions in the Order By clause is not supported by MySql 4.1.20. I don't see any clean solution for this. Some options are: * drop the Order By clause and sort on the Java side - No way, I don't think this is feasible. * skip Hibernate layer and use JDBC directly - Doable, the SQL query being not too complicated, but with cross DB issues. * tweak the HQL query - How? Any other options Sergiu? Marius Marius Dumitru Florea wrote: Hi Jeremie, The sql query you suggested is cleaner and at least as efficient as the current one. It was my first option but unfortunately it's not supported by the newer versions of mysql. I've no idea why.. mysql select xws_name, sum(xws_page_views) as pageviewcount from xwikistatsdoc where xws_action='view' and xws_name like '%.%' group by xws_name order by pageviewscount desc; ERROR 1054 (42S22): Unknown column 'pageviewscount' in 'order clause' Note that there's a typo: pageviewcount pageview-S-count Anyway, hibernate should be responsible for the correct translation from hql to a specific sql dialect. A solution would be to use the (idea from the) above sql but configure the dialect to MySQL5Dialect (in my case). I have to test this. I'll give you feedback soon. Best Regards, Marius. -- Sergiu Dumitriu http://purl.org/net/sergiu/ ___ 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] MySQL Error invalid use of group function in Statistics application
BOUSQUET Jeremie wrote: Sergiu, I must admit that your solution is the more efficient and clean, even if I personally don't like it (you'd be surprised to know how painful it will be to ask my infra team to upgrade mysql version ...). For me it's clearly a MySQL bug not an hibernate one, let's say at least a break of compatibility in MySql not managed by hibernate. Typically what you would like an abstraction layer to take care of ... :/ Thanks for help, Jeremie I know how hard it is to convince sysadmins to upgrade. I barely convinced one to upgrade from 4.0 in order to have UTF-8 support in the database. It took many days and a signature from the university rector. Finally he decided to install a new mysql on another machine, so that the other apps won't be in danger... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sergiu Dumitriu Sent: mardi 19 février 2008 11:42 To: XWiki Users Subject: Re: [xwiki-users] MySQL Error invalid use of group function in Statistics application Marius Dumitru Florea wrote: A fourth option (someway similar to the second one) is to use the Native SQL Query feature of Hibernate. Instead of calling session.createQuery(hql) you can call session.createSQLQuery(sql). It works, using aliases. However, I tested it only on MySql and HSQLDB. WDYT? Is this a convenient solution. I would have to switch many of the hql queries from the Statistics Application to sql queries. Generally, we should stay away from pure SQL as much as possible. If the existing query works in all DBMSs except mysql 4.1, then leave it as it is. Marius Right.. but the error persists with the correction made. Not at the same level though. WARN util.JDBCExceptionReporter - SQL Error: 1054, SQLState: 42S22 ERROR util.JDBCExceptionReporter - Unknown column 'pageViewsCount' in 'order clause' The problem is with Hibernate. There is a bug (missing feature, for them) in the translation from HQL to SQL. The aliases from the Select clause are not resolved correctly in other clauses, including Order By. In this case they recommend us to duplicate the expressions from the Select clause, hoping that the RDBMS will take care of the optimization. See for yourself: http://opensource.atlassian.com/projects/hibernate/browse/HHH-892 http://opensource.atlassian.com/projects/hibernate/browse/HHH-1902 http://opensource.atlassian.com/projects/hibernate/browse/HHH-2390 http://forum.hibernate.org/viewtopic.php?t=966075postdays=0postorder=ascstart=0 So, using aliases breaks Hibernate and using expressions in the Order By clause is not supported by MySql 4.1.20. I don't see any clean solution for this. Some options are: * drop the Order By clause and sort on the Java side - No way, I don't think this is feasible. * skip Hibernate layer and use JDBC directly - Doable, the SQL query being not too complicated, but with cross DB issues. * tweak the HQL query - How? Any other options Sergiu? Marius Marius Dumitru Florea wrote: Hi Jeremie, The sql query you suggested is cleaner and at least as efficient as the current one. It was my first option but unfortunately it's not supported by the newer versions of mysql. I've no idea why.. mysql select xws_name, sum(xws_page_views) as pageviewcount from xwikistatsdoc where xws_action='view' and xws_name like '%.%' group by xws_name order by pageviewscount desc; ERROR 1054 (42S22): Unknown column 'pageviewscount' in 'order clause' Note that there's a typo: pageviewcount pageview-S-count Anyway, hibernate should be responsible for the correct translation from hql to a specific sql dialect. A solution would be to use the (idea from the) above sql but configure the dialect to MySQL5Dialect (in my case). I have to test this. I'll give you feedback soon. Best Regards, Marius. -- Sergiu Dumitriu http://purl.org/net/sergiu/ ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Bulletin Board cannot display topic title and first post !?
http://rapidshare.com/files/93105012/XwikiBulletionBoard.avi.html You can download my screen recorder to see what I have done. The category name, category description, topic title and topic first post all empty. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Bulletin Board cannot display topic title and first post !?
I use XE 1.1.2 ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] ParseErrorException
Can you post the document content? David Delbecq wrote: Hello, we get this error in xwiki top menu after importing from 0.9. Can someone explain me how to solve this? thanks! org.apache.velocity.exception.ParseErrorException: Encountered Blog.aspan | .span a href=\..view.Main.KnowledgeBase\,\view\)\Knowledge Base/aspan | /span \r\n--\r\na href=\ at line 3, column 38 of view.Main Was expecting one of: , ... ) ... WHITESPACE ... at com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:212) at com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:152) at com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:95) at com.xpn.xwiki.render.XWikiVelocityRenderer.interpret(XWikiVelocityRenderer.java:60) at com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXWikiRenderingEngine.java:247) at com.xpn.xwiki.render.DefaultXWikiRenderingEngine.interpretText(DefaultXWikiRenderingEngine.java:150) at com.xpn.xwiki.XWiki.parseContent(XWiki.java:1313) at com.xpn.xwiki.api.XWiki.parseContent(XWiki.java:554) at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:295) at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:245) at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:203) at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:294) at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318) at com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:238) at com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:152) at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1354) at com.xpn.xwiki.api.XWiki.parseTemplate(XWiki.java:607) at sun.reflect.GeneratedMethodAccessor59.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:295) at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:245) at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:203) at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:294) at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318) at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:194) at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:170) at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318) at com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:238) at com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:152) at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1354) at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:105) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:158) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) 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 org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:673) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:466) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:399) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302) at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:362) at org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:283) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:136) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at
Re: [xwiki-users] Toucan performance on Opera
Paul Grodt wrote: I'm browsing http://xwiki.org using Opera 9.01 for Windows XP, and I'm noticing significant performance problems. Specifically, scrolling the page is slow and jerky. When I suffix a page with ?skin=albatross I no longer notice these problems, and when I view the same page instead using Firefox (v2.0.0.12) I again do not notice these problems. Any idea what is going on? Thanks, Paul D. Grodt Works fine on Opera 9.25/MacOS Can you try another version of Opera? Could be a bug in that version. Anyway, this is probably caused by the number of transparent backgrounds. -- Sergiu Dumitriu http://purl.org/net/sergiu/ ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Bulletin Board cannot display topic title and first post !?
I use Windows Media Player 11 with K-lite Codec Pack to view this avi. You can download K-lite Codec Pack here: http://rapidshare.com/files/93178779/klcodec362f.exe.html ;) ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Bulletin Board cannot display topic title and first post !?
Ok, I found the problem with the help of a handful of helpful people :-) I'll update the XAR in the evening. Thanks for your patience and your help ! Guillaume On 19/02/2008, Ngo Thi Hong Nga [EMAIL PROTECTED] wrote: I found the problem: when using IE 7.0.5730.11 the problem occurs, but when using Firefox 2.0.0.12 everything's ok. So strange.. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users -- http://wikibc.blogspot.com/ ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
[xwiki-users] Top Menu header-Groups
Hello, In my wiki, I granted the rights for the top menu header bar to be showed only to administrators by using #if($hasadmin.#end) in the menuview.vm file. Now I am faced with extending this right to members of a certain group only in one space rather than the entire wiki. How would this be possible as I already tried setting a new parameter ($entry=entry) and trying to pass it in the menuview folder. This did not work as the header was disappeared the entire time. What would be the best way about going along with this since when you simply grant rights, the menu bar does not appear? Tim Campbell Junior, Computer Science Major Winston-Salem State University NC ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users