On Jan 30, 2007, at 9:45 AM, dandre.jvv@dariel.co.za wrote:

Well, I took MySQL and a clean version 0.9.840 of XWiki, made a few posts, etc. and it successfully ported to 1.0b3 (Yeah, I got beta 3 today).

So, is everything fine now? Did you have to do anything more than what is described on http:// www.xwiki.org/xwiki/bin/view/Main/ReleaseNotesXWiki10Beta3 (in the "Migration from 0.9.x versions" section)? If so could you please list what you have done so that we can improve the documentation? Thanks -Vincent

My other post doesn't show. Here is what I posted also yesterday: (forgive me, I'm a newby @ this mailing list ;) )

...

Thanks for your reply. I tried it but still didn't work.

I also discovered an extra exception that wasn't shown on the web- interface-exception-stack-trace:

Wrapped Exception:

org.postgresql.util.PSQLException: ERROR: column xwikidocum0_.xwd_title does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse (QueryExecutorImpl.java:1531) at org.postgresql.core.v3.QueryExecutorImpl.processResults (QueryExecutorImpl.java:1313) at org.postgresql.core.v3.QueryExecutorImpl.execute (QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute (AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags (AbstractJdbc2Statement.java:354) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery (AbstractJdbc2Statement.java:258) 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:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1669) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections (Loader.java:224) at org.hibernate.loader.Loader.loadEntity(Loader.java:1785) at org.hibernate.loader.entity.AbstractEntityLoader.load (AbstractEntityLoader.java:93) at org.hibernate.loader.entity.AbstractEntityLoader.load (AbstractEntityLoader.java:81) at org.hibernate.persister.entity.AbstractEntityPersister.load (AbstractEntityPersister.java:2730) at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource (DefaultLoadEventListener.java:365) at org.hibernate.event.def.DefaultLoadEventListener.doLoad (DefaultLoadEventListener.java:346) at org.hibernate.event.def.DefaultLoadEventListener.load (DefaultLoadEventListener.java:123) at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad (DefaultLoadEventListener.java:177) at org.hibernate.event.def.DefaultLoadEventListener.onLoad (DefaultLoadEventListener.java:87) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java: 891) at org.hibernate.impl.SessionImpl.load(SessionImpl.java:799) at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc (XWikiHibernateStore.java:346) at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc (XWikiCacheStore.java:156) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:786) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:817) at com.xpn.xwiki.XWiki.getPrefsClass(XWiki.java:1907) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:556) at com.xpn.xwiki.XWiki.<init>(XWiki.java:470) at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:214) at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:303) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:96) 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: 690) at javax.servlet.http.HttpServlet.service(HttpServlet.java: 803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:206) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter (SetCharacterEncodingFilter.java:121) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java:228) at org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service (CoyoteAdapter.java:212) at org.apache.coyote.http11.Http11Processor.process (Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol $Http11ConnectionHandler.process(Http11Protocol.java:634) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run (JIoEndpoint.java:445) at java.lang.Thread.run(Thread.java:595)

-- You receive this message as a subscriber of the xwiki- users@objectweb.org mailing list. To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/ wws

___________________________________________________________________________ Yahoo! Mail r�invente le mail ! D�couvrez le nouveau Yahoo! Mail et son interface r�volutionnaire. http://fr.mail.yahoo.com

On Jan 30, 2007, at 10:18 AM, dandre.jvv@dariel.co.za wrote:

Well, for MySQL it is fine but apparently my seniors want it to be in PostgreSQL. For the MySQL one to work, I went to the "old" site and did want they done there and it worked.

Could you give me the URL or even better could you review the instructions on the new and main site and let us know if anything is missing so that we can update the documentation. You shouldn't have to look at the old site to set up MySQL.

For postgres, however, it doesn't want to work. I was hoping that Beta 3 would work but did exactly the same as Beta 2. I think the problem lies with the JDBC connector or the hibernate thing. With my previous post you can see the PSQLException.

Postgres is not yet supported because nobody has reported success with it yet. Once someone does it'll be nice if they post the information on the xwiki.org web site, under the HSQL DB and MySQL instructions. Thanks -Vincent PS1: Please do not remove the original text in your replies as otherwise we're loosing the context. You can edit the original text to only leave the important part but you need to leave some original context info PS2: Your emails are being sent twice. Could you please fix that? ___________________________________________________________________________ Yahoo! Mail r�invente le mail ! D�couvrez le nouveau Yahoo! Mail et son interface r�volutionnaire. http://fr.mail.yahoo.com

I forgot to mention that taking the new Beta version and just connecting it with PostgreSQL does work! You just follow the instructions found on the old xwiki site (http://old.xwiki.org/xwiki/bin/view/AdminGuide/PostGres) and don't forget to import the XAR file. You don't have to import any db's to get it to work. It is only when you try to import from the older xwiki that it gives troubles.

Where do you think we should start to look? On which table can I "find" the missing column "xwikidocum0_.xwd_title"? (I know it sounds weird ;) ) I mean the wiki must know of that column in order to go looking for it. Maybe if we know to which table it belongs to we can work from there.