- xwiki-devs@xwiki.org - lists.xwiki.org

[xwiki-devs] [vote] XWiki charset strategy
by Sergiu Dumitriu 16 Feb '08

16 Feb '08

Hi devs, We need to decide how to handle the charset/encoding in XWiki. We have 3 options: 1. Leave it as it is. The default is ISO-8859-1, and the admin has to make sure the JVM is started with the correct -Dfile.encoding param. If another encoding is needed, it has to be changed in 4 places (web.xml, xwiki.cfg, -Dfile.encoding, database charset+collation) 2. Force it to always be UTF-8, overriding the file.enconding setting. This ensures internationalization, as UTF-8 works with any language. And I think it is a safe move, as any modern system supports UTF-8 (given that XWiki requires java 5, we can assume it will be in a modern system). This has the advantage that the code will be simpler, as we don't have to check and switch encodings, but has the disadvantage that mysql has to be manually configured for UTF-8, as by default it comes in latin1. 3. Keep it configurable, but by only specifying it in one place (xwiki.cfg or web.xml), and enforcing that encoding in the JVM (by overriding file.encoding). The default should be UTF-8. Here's my +1 for option 2, -1 for option 1, and 0 for option 3. -- Sergiu Dumitriu http://purl.org/net/sergiu/

5 7

[xwiki-devs] How to monitor the user in xwiki
by Hans-Peter Zorn 15 Feb '08

15 Feb '08

Hi all, i am currently working on integrating a recommendation system into a xwiki installation. What I need to build a statistical model is to register every link to another wiki page a particular user clicks. e.g. zorn is on Main.WebHome and clicks on SandBox.WebHome After investigating this a little, I think one way to do this would be to extend the XWikiStats subsystem. I would prefer to write simple plugin however, if such hooks already exist, but I couldn't find any. Thanks, Hans-Peter

2 1

[xwiki-devs] [VOTE] Move the title field to the Document Information panel
by Vincent Massol 15 Feb '08

15 Feb '08

Hi, I'd like to propose moving the title field in edit mode to the side, in the information panel, just before the Parent field. We have already parent and tags there and the title would fit nicely there. The main reason for this is to clear up more space for the main content edition. It's also more consistent to put the page metadata together on the side (which has a lot of unused space). Here's my +1 Thanks -Vincent PS: It really helps in Toucan skin to have that title field on the side since a major theme of Toucan is to simplify the interface and provide more space for the content.

6 6

[xwiki-devs] towards a MathTran XWiki macro for TeX-based equations
by Paul Libbrecht 14 Feb '08

14 Feb '08

Hello, we started to approach the embedding of the MathTran service for XWiki embedding of formulae. A very very rudimentary version (based on velocity macros) is at http://i2geo.net/bin/Sandbox/Formulae Clearly, we'll make a macro instead of a velo-macro, so that syntax has some input freedom (you can't put \cdot currently!), and maybe even a plugin (so as to cache at the xwiki-server-side the resulting image. That'll work well, with baseline, for html-rendered pages. That will be somewhat ugly, however, for print (gross resolution, nothing vector). Having discussed with a MathTran developer we realized it would be easy to actually use the DVI to embed for print provided the fonts are installed on the XWiki server (they are freely available). This file is very small and is in the picture's metadata. The DVI format is basically a vector format that says where to place which characters. Is it possible to extend the print features for some islands so that it "draws on a Graphics2D" ? That would solve our approach without the requirement of any installation on the XWiki-server except for the fonts. thanks in advance paul

3 4

Re: [xwiki-devs] [xwiki-notifications] r7713 - xwiki-platform/xwiki-applications/trunk/panels/src/main/resources/Panels
by Vincent Massol 14 Feb '08

14 Feb '08

I don't like that. It means Panels can break the Panel Wizard... Also it means we'll get lots of user problems when people upgrade to 1.3M2 since they won't import the new panels... IMO this needs to be fixed in the Panel Wizard and the Panels should not be changed. -Vincent On Feb 13, 2008, at 11:25 PM, sdumitriu (SVN) wrote: > Author: sdumitriu > Date: 2008-02-13 23:25:58 +0100 (Wed, 13 Feb 2008) > New Revision: 7713 > > Modified: > xwiki-platform/xwiki-applications/trunk/panels/src/main/resources/ > Panels/Backlinks > xwiki-platform/xwiki-applications/trunk/panels/src/main/resources/ > Panels/EditTranslations > Log: > XAPANELS-42: Some panels break the panel wizard > Fixed. > > > Modified: xwiki-platform/xwiki-applications/trunk/panels/src/main/ > resources/Panels/Backlinks > =================================================================== > --- xwiki-platform/xwiki-applications/trunk/panels/src/main/ > resources/Panels/Backlinks 2008-02-13 22:18:02 UTC (rev 7712) > +++ xwiki-platform/xwiki-applications/trunk/panels/src/main/ > resources/Panels/Backlinks 2008-02-13 22:25:58 UTC (rev 7713) > @@ -136,7 +136,7 @@ > </property> > <property> > <content>#set($blinks = $doc.getBacklinks()) > -#if($blinks.size()>0) > +#if($blinks.size()>0 || $showEmptyPanels) > #panelheader('Backlinks') > #set($first = true) > #foreach($docname in $blinks) > > Modified: xwiki-platform/xwiki-applications/trunk/panels/src/main/ > resources/Panels/EditTranslations > =================================================================== > --- xwiki-platform/xwiki-applications/trunk/panels/src/main/ > resources/Panels/EditTranslations 2008-02-13 22:18:02 UTC (rev 7712) > +++ xwiki-platform/xwiki-applications/trunk/panels/src/main/ > resources/Panels/EditTranslations 2008-02-13 22:25:58 UTC (rev 7713) > @@ -99,7 +99,7 @@ > <category>Information</category> > </property> > <property> > -<content>#if($xwiki.isMultiLingual()==true) > +<content>#if($xwiki.isMultiLingual()==true || $showEmptyPanels) > #largepanelheader($msg.get("panels.translation.title")) > #if(($request.language)&&($request.language! > ="default")&&($doc.defaultLanguage!=$request.language)) > #set($forcetrans = $request.language) > > _______________________________________________ > notifications mailing list > notifications(a)xwiki.org > http://lists.xwiki.org/mailman/listinfo/notifications

2 1

[xwiki-devs] setUser admin
by raffovi 13 Feb '08

13 Feb '08

Hi all, how can I execute a procedure using Admin while I'm logged as another User? Tahnks Raffo -- View this message in context: http://www.nabble.com/setUser-admin-tp15461156p15461156.html Sent from the XWiki- Dev mailing list archive at Nabble.com.

2 1

[xwiki-devs] Re gistering user using a validation mail (problem)
by Sachin Mittal 13 Feb '08

13 Feb '08

Hi, There is a functionality in xwiki user registration module where we can send a validation key to the user account. For the xwiki registration tab as provided two settings: 1. from email address 2. smpt server address from which the mail is to be sent. Now most smtp server require some authentication on their machine, that would mostly be the user name/password of the from email address. There are no such settings provided under the registration tab. My question is are additional settings needed, if yes then how can one add the same. Currently i get the following error when trying to send the validation mail: com.xpn.xwiki.XWikiException: Error number 10006 in 10: Could not send mail to server 199.237.236.4 port 25 error code 530 (530 authentication required for relay (#5.7.1) ) at com.xpn.xwiki.XWiki.sendMessage(XWiki.java:2981) at com.xpn.xwiki.XWiki.sendMessage(XWiki.java:3015) at com.xpn.xwiki.XWiki.sendValidationEmail(XWiki.java:2924) at com.xpn.xwiki.XWiki.sendValidationEmail(XWiki.java:2883) at com.xpn.xwiki.XWiki.createUser(XWiki.java:2833) at com.xpn.xwiki.web.RegisterAction.action(RegisterAction.java:41) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:187) 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.doPost(ActionServlet.java:432) >From stack trace it does seem that authentication is required. So how can I get that done via xwiki. Please help. Thanks Sachin ----- http://www.assembla.com/wiki/show/sachin_mittal about me: -- View this message in context: http://www.nabble.com/Registering-user-using-a-validation-mail-%28problem%2… Sent from the XWiki- Dev mailing list archive at Nabble.com.

2 2

Re: [xwiki-devs] Problem loading Watch.Reader Application
by Colin Tay 13 Feb '08

13 Feb '08

To add on, I am using Oracle 10g R1 and hibernate 3.2.5ga. This problem seem to lie on the hibernate portion where it failed to resolve the alias in the GROUP BY clauses in WatchSheets.WebHome document.The code causing this problem is as follow: ..... #set($tagsQuery = "select elements(entry.tags), count(*) from XWiki.FeedEntryClass asentry, XWikiDocument as doc, BaseObject as obj wheredoc.fullName=obj.name and obj.id=entry.id and doc.web='${doc.space}' group bycol_0_0_) #set($tagList = $xwiki.search($tagsQuery)) How can i resolve this issue or else the watch application could not be used. Regards, Colin ----- Original Message ---- From: Colin Tay <lee_hyeok(a)yahoo.com.sg> To: XWiki Developers <devs(a)xwiki.org> Sent: Wednesday, 13 February 2008 8:55:02 Subject: [xwiki-devs] Problem loading Watch.Reader Application Hi all, I am using the Xwiki enterprise 1.2.1 with rev 7495. After importing the watch application successfully, i opened the http://localhost:8080/xwiki/bin/view/watch/reader url. An exception occured, may i know what causes this? The errors are as follows: Thanks in adv, Colin 2008-02-13 08:59:33,359 [http://localhost:8080/xwiki/XWikiService] [P1-17] WARN util.JDBCExceptionReporter - SQL Error: 932, SQLState: 42000 2008-02-13 08:59:33,359 [http://localhost:8080/xwiki/XWikiService] [P1-17] ERROR util.JDBCExceptionReporter - ORA-00932: inconsistent datatypes: expected - got CLOB 2008-02-13 08:59:33,359 [http://localhost:8080/xwiki/XWikiService] [P1-17] ERROR xwiki.XWiki - Unhandled exception on the server com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while searching documents with sql select entry.feedname, sum(1-coalesce(entry.read,0)) from XWiki.FeedEntryClass as entry, XWikiDocument as doc, BaseObject as obj where doc.fullName=obj.name and obj.id=entry.id and doc.web='Watch' group by entry.feedname Wrapped Exception: could not execute query at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1809) at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1746) at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1735) at com.xpn.xwiki.store.XWikiCacheStore.search(XWikiCacheStore.java:420) at com.xpn.xwiki.gwt.api.server.XWikiServiceImpl.customQuery(XWikiServiceImpl.java:740) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:281) at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:167) at javax.servlet.http.HttpServlet.service(HttpServlet.java:616) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at org.mortbay.http.HttpContext.handle(HttpContext.java:1565) at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633) at org.mortbay.http.HttpContext.handle(HttpContext.java:1517) at org.mortbay.http.HttpServer.service(HttpServer.java:954) at org.mortbay.http.HttpConnection.service(HttpConnection.java:816) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) Wrapped Exception: java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got CLOB at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:420) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:452) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2929) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2220) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1801) at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1746) at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1735) at com.xpn.xwiki.store.XWikiCacheStore.search(XWikiCacheStore.java:420) at com.xpn.xwiki.gwt.api.server.XWikiServiceImpl.customQuery(XWikiServiceImpl.java:740) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:281) at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:167) at javax.servlet.http.HttpServlet.service(HttpServlet.java:616) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at org.mortbay.http.HttpContext.handle(HttpContext.java:1565) at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633) at org.mortbay.http.HttpContext.handle(HttpContext.java:1517) at org.mortbay.http.HttpServer.service(HttpServer.java:954) at org.mortbay.http.HttpConnection.service(HttpConnection.java:816) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) 2008-02-13 08:59:33,718 [http://localhost:8080/xwiki/XWikiService] [P1-18] WARN util.JDBCExceptionReporter - SQL Error: 904, SQLState: 42000 2008-02-13 08:59:33,718 [http://localhost:8080/xwiki/XWikiService] [P1-18] ERROR util.JDBCExceptionReporter - ORA-00904: "COL_0_0_": invalid identifier 2008-02-13 08:59:33,718 [http://localhost:8080/xwiki/XWikiService] [P1-18] ERROR xwiki.XWiki - Unhandled exception on the server com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while searching documents with sql select elements(entry.tags), count(*) from XWiki.FeedEntryClass as entry, XWikiDocument as doc, BaseObject as obj where doc.fullName=obj.name and obj.id=entry.id and doc.web='Watch' group by col_0_0_ Wrapped Exception: could not execute query at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1809) at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1746) at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1735) at com.xpn.xwiki.store.XWikiCacheStore.search(XWikiCacheStore.java:420) at com.xpn.xwiki.gwt.api.server.XWikiServiceImpl.customQuery(XWikiServiceImpl.java:740) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:281) at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:167) at javax.servlet.http.HttpServlet.service(HttpServlet.java:616) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at org.mortbay.http.HttpContext.handle(HttpContext.java:1565) at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633) at org.mortbay.http.HttpContext.handle(HttpContext.java:1517) at org.mortbay.http.HttpServer.service(HttpServer.java:954) at org.mortbay.http.HttpConnection.service(HttpConnection.java:816) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) Wrapped Exception: java.sql.SQLException: ORA-00904: "COL_0_0_": invalid identifier at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:420) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:452) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2929) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2220) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1801) at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1746) at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1735) at com.xpn.xwiki.store.XWikiCacheStore.search(XWikiCacheStore.java:420) at com.xpn.xwiki.gwt.api.server.XWikiServiceImpl.customQuery(XWikiServiceImpl.java:740) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:281) at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:167) at javax.servlet.http.HttpServlet.service(HttpServlet.java:616) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at org.mortbay.http.HttpContext.handle(HttpContext.java:1565) at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633) at org.mortbay.http.HttpContext.handle(HttpContext.java:1517) at org.mortbay.http.HttpServer.service(HttpServer.java:954) at org.mortbay.http.HttpConnection.service(HttpConnection.java:816) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) Real people. Real questions. Real answers. Share what you know. -----Inline Attachment Follows----- _______________________________________________ devs mailing list devs(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/devs __________________________________________________________________ Yahoo! Singapore Answers Real people. Real questions. Real answers. Share what you know at http://answers.yahoo.com.sg

2 1

[xwiki-devs] Problem loading Watch.Reader Application
by Colin Tay 13 Feb '08

13 Feb '08

Hi all, I am using the Xwiki enterprise 1.2.1 with rev 7495. After importing the watch application successfully, i opened the http://localhost:8080/xwiki/bin/view/watch/reader url. An exception occured, may i know what causes this? The errors are as follows: Thanks in adv, Colin 2008-02-13 08:59:33,359 [http://localhost:8080/xwiki/XWikiService] [P1-17] WARN util.JDBCExceptionReporter - SQL Error: 932, SQLState: 42000 2008-02-13 08:59:33,359 [http://localhost:8080/xwiki/XWikiService] [P1-17] ERROR util.JDBCExceptionReporter - ORA-00932: inconsistent datatypes: expected - got CLOB 2008-02-13 08:59:33,359 [http://localhost:8080/xwiki/XWikiService] [P1-17] ERROR xwiki.XWiki - Unhandled exception on the server com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while searching documents with sql select entry.feedname, sum(1-coalesce(entry.read,0)) from XWiki.FeedEntryClass as entry, XWikiDocument as doc, BaseObject as obj where doc.fullName=obj.name and obj.id=entry.id and doc.web='Watch' group by entry.feedname Wrapped Exception: could not execute query at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1809) at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1746) at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1735) at com.xpn.xwiki.store.XWikiCacheStore.search(XWikiCacheStore.java:420) at com.xpn.xwiki.gwt.api.server.XWikiServiceImpl.customQuery(XWikiServiceImpl.java:740) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:281) at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:167) at javax.servlet.http.HttpServlet.service(HttpServlet.java:616) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at org.mortbay.http.HttpContext.handle(HttpContext.java:1565) at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633) at org.mortbay.http.HttpContext.handle(HttpContext.java:1517) at org.mortbay.http.HttpServer.service(HttpServer.java:954) at org.mortbay.http.HttpConnection.service(HttpConnection.java:816) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) Wrapped Exception: java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got CLOB at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:420) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:452) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2929) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2220) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1801) at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1746) at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1735) at com.xpn.xwiki.store.XWikiCacheStore.search(XWikiCacheStore.java:420) at com.xpn.xwiki.gwt.api.server.XWikiServiceImpl.customQuery(XWikiServiceImpl.java:740) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:281) at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:167) at javax.servlet.http.HttpServlet.service(HttpServlet.java:616) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at org.mortbay.http.HttpContext.handle(HttpContext.java:1565) at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633) at org.mortbay.http.HttpContext.handle(HttpContext.java:1517) at org.mortbay.http.HttpServer.service(HttpServer.java:954) at org.mortbay.http.HttpConnection.service(HttpConnection.java:816) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) 2008-02-13 08:59:33,718 [http://localhost:8080/xwiki/XWikiService] [P1-18] WARN util.JDBCExceptionReporter - SQL Error: 904, SQLState: 42000 2008-02-13 08:59:33,718 [http://localhost:8080/xwiki/XWikiService] [P1-18] ERROR util.JDBCExceptionReporter - ORA-00904: "COL_0_0_": invalid identifier 2008-02-13 08:59:33,718 [http://localhost:8080/xwiki/XWikiService] [P1-18] ERROR xwiki.XWiki - Unhandled exception on the server com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while searching documents with sql select elements(entry.tags), count(*) from XWiki.FeedEntryClass as entry, XWikiDocument as doc, BaseObject as obj where doc.fullName=obj.name and obj.id=entry.id and doc.web='Watch' group by col_0_0_ Wrapped Exception: could not execute query at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1809) at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1746) at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1735) at com.xpn.xwiki.store.XWikiCacheStore.search(XWikiCacheStore.java:420) at com.xpn.xwiki.gwt.api.server.XWikiServiceImpl.customQuery(XWikiServiceImpl.java:740) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:281) at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:167) at javax.servlet.http.HttpServlet.service(HttpServlet.java:616) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at org.mortbay.http.HttpContext.handle(HttpContext.java:1565) at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633) at org.mortbay.http.HttpContext.handle(HttpContext.java:1517) at org.mortbay.http.HttpServer.service(HttpServer.java:954) at org.mortbay.http.HttpConnection.service(HttpConnection.java:816) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) Wrapped Exception: java.sql.SQLException: ORA-00904: "COL_0_0_": invalid identifier at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:420) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:452) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2929) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2220) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1801) at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1746) at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1735) at com.xpn.xwiki.store.XWikiCacheStore.search(XWikiCacheStore.java:420) at com.xpn.xwiki.gwt.api.server.XWikiServiceImpl.customQuery(XWikiServiceImpl.java:740) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:281) at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:167) at javax.servlet.http.HttpServlet.service(HttpServlet.java:616) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at org.mortbay.http.HttpContext.handle(HttpContext.java:1565) at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633) at org.mortbay.http.HttpContext.handle(HttpContext.java:1517) at org.mortbay.http.HttpServer.service(HttpServer.java:954) at org.mortbay.http.HttpConnection.service(HttpConnection.java:816) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) ______________________________________________________________________ Search, browse and book your hotels and flights through Yahoo! Travel. http://sg.travel.yahoo.com

1 0

[xwiki-devs] [ANN] XWiki Enterprise 1.2.2 Released
by Vincent Massol 11 Feb '08

11 Feb '08

The XWiki development team is pleased to announce the release of XWiki Enterprise1.2.2. Go grab it at http://www.xwiki.org/xwiki/bin/view/Main/Download This is a bug fix release. Changes from 1.2.1: Bugs fixed * XWIKI-2052 - XWikiDocument.equals always returns false if a document is compared to itself * XWIKI-2064 - DBListClass and DBTreeListClass are building invalid SQL statements * XWIKI-2065 - XWikiHibernateStore.deleteWiki don't works * XWIKI-2066 - Migrator fails to upgrade sub wiki databases * XWIKI-2068 - Rights Manager does not clean deleted user/group in all wikis * XWIKI-2074 - Database Migration fails when migrating from 1.0 or older directly to 1.2 without going through a 1.1 upgrade * XWIKI-2076 - "Content is not allowed in prolog" error while migrating a database to 1.2 * XWIKI-2078 - Missing translation entry for the title of the Group Admin page * XWIKI-2079 - Fails to save document after migrating from a 1.0 or before database to 1.2 * XWIKI-2080 - Server hangs while rendering certain pages * XWIKI-2087 - Attached files that we can't delete or link in the Wiki pages * XWIKI-2090 - Attaching images with a name containing special characters (é & è à ...) generates bugs (image are not displayed) * XWIKI-2101 - XWiki.clearName strips dots when using ascii option even if stripDots option is set to false * XWIKI-2102 - Attachments should not contain non-alphanumeric characters in the file name Improvements * XWIKI-1980 - $doc.displayTooltip should support internationalized strings New Features * XWIKI-2088 - Add a method to retrieve the e-mail address of a user For more information see the Release notes at: http://www.xwiki.org/xwiki/bin/view/Main/ReleaseNotesXWikiEnterprise122 Thanks -The XWiki dev team

1 0