29 Jan
2007
29 Jan
'07
10 a.m.
Hello everyone.
I am having a problem moving our wiki data from xWiki 0.9.840 to the new 1.0 beta 2 wiki.
I am using Tomcat and PostgreSQL 8.1
I receive the following error when going to:
http://localhost:8080/xwiki/bin/view/Main/WebHome
javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could
not initialize main XWiki context
Wrapped Exception: Error number 3202 in 3: Exception while reading document
XWiki.XWikiPreferences
Wrapped Exception: could not load an entity: [com.xpn.xwiki.doc.XWikiDocument#104408758]
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:121)
-- AND --
com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki
context
Wrapped Exception: Error number 3202 in 3: Exception while reading document
XWiki.XWikiPreferences
Wrapped Exception: could not load an entity: [com.xpn.xwiki.doc.XWikiDocument#104408758]
com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:223)
com.xpn.xwiki.XWiki.getXWiki(XWiki.java:303)
com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:96)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:121)
Clearly just pointing with the new XWiki to the old DB doesn't work. Thats basically
what I've done. Also for days now I've been trying different things and obviously
no luck. I am working on a dummy system to prepare the migration before doing the actual
thing. On my dummy system the old wiki works as the original.
Help would be appreciated!
Thanks
29 Jan
29 Jan
10:12 a.m.
New subject: [xwiki-users] Migrating from 0.9.840 to 1.0b2
Hi,
Could you try setting "xwiki.store.hibernate.updateschema=1" in
xwiki.cfg and start the server again (you should remove it afterwards).
Let us know if this works. If so I'll add it to the migration guide.
Thanks
-Vincent
On Jan 29, 2007, at 10:00 AM, dandre.jvv(a)dariel.co.za wrote:
Hello everyone.
I am having a problem moving our wiki data from xWiki 0.9.840 to
the new 1.0 beta 2 wiki.
I am using Tomcat and PostgreSQL 8.1
I receive the following error when going to: http://localhost:8080/
xwiki/bin/view/Main/WebHome
javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error
number 3 in 0: Could not initialize main XWiki context
Wrapped Exception: Error number 3202 in 3: Exception while reading
document XWiki.XWikiPreferences
Wrapped Exception: could not load an entity:
[com.xpn.xwiki.doc.XWikiDocument#104408758]
org.apache.struts.action.RequestProcessor.processException
(RequestProcessor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform
(RequestProcessor.java:433)
org.apache.struts.action.RequestProcessor.process
(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:
1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter
(SetCharacterEncodingFilter.java:121)
-- AND --
com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not
initialize main XWiki context
Wrapped Exception: Error number 3202 in 3: Exception while reading
document XWiki.XWikiPreferences
Wrapped Exception: could not load an entity:
[com.xpn.xwiki.doc.XWikiDocument#104408758]
com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:223)
com.xpn.xwiki.XWiki.getXWiki(XWiki.java:303)
com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:96)
org.apache.struts.action.RequestProcessor.processActionPerform
(RequestProcessor.java:431)
org.apache.struts.action.RequestProcessor.process
(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:
1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter
(SetCharacterEncodingFilter.java:121)
Clearly just pointing with the new XWiki to the old DB doesn't
work. Thats basically what I've done. Also for days now I've been
trying different things and obviously no luck. I am working on a
dummy system to prepare the migration before doing the actual
thing. On my dummy system the old wiki works as the original.
Help would be appreciated!
Thanks
___________________________________________________________________________
Yahoo! Mail r�invente le mail ! D�couvrez le nouveau Yahoo! Mail et son interface
r�volutionnaire.
http://fr.mail.yahoo.com
30 Jan
30 Jan
9:45 a.m.
New subject: [xwiki-users] Migrating from 0.9.840 to 1.0b2
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).
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)
10 a.m.
New subject: [xwiki-users] Migrating from 0.9.840 to 1.0b2
On Jan 30, 2007, at 9:45 AM, dandre.jvv(a)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 ;) )
___________________________________________________________________________
Yahoo! Mail r�invente le mail ! D�couvrez le nouveau Yahoo! Mail et son interface
r�volutionnaire.
http://fr.mail.yahoo.com
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(a)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
10:18 a.m.
New subject: [xwiki-users] Migrating from 0.9.840 to 1.0b2
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.
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.
11:01 a.m.
New subject: [xwiki-users] Migrating from 0.9.840 to 1.0b2
On Jan 30, 2007, at 10:18 AM, dandre.jvv(a)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
11:11 a.m.
New subject: [xwiki-users] Migrating from 0.9.840 to 1.0b2
"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?"
The reason the second one was like that was because I received a "Rejected mail"
message, so I tried sending it again and now to my surprise it popped up here. I already
removed the 2nd one.
"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."
I didn't setup XWiki B2 with the old site instructions, I'm not sure why I said
that. I was doing something else too at that time, must have gotten mixed up :)
"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."
Only with the porting stage, it isn't ;p
10:53 a.m.
New subject: [xwiki-users] Migrating from 0.9.840 to 1.0b2
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.
11:27 a.m.
New subject: [xwiki-users] Migrating from 0.9.840 to 1.0b2
On Jan 30, 2007, at 10:53 AM, dandre.jvv(a)dariel.co.za wrote:
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.
Ok I've added the documentation here: http://www.xwiki.org/xwiki/bin/
view/AdminGuide/InstallationPostgreSQL
We still need to resolve the import stage. If it's not working it
probably means the configuration stage is not correct.
Thanks
-Vincent
___________________________________________________________________________
Yahoo! Mail r�invente le mail ! D�couvrez le nouveau Yahoo! Mail et son interface
r�volutionnaire.
http://fr.mail.yahoo.com
11:37 a.m.
New subject: [xwiki-users] Migrating from 0.9.840 to 1.0b2
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.
6677
days inactive
6678
days old
9 comments
2 participants
participants (2)
-
dandre.jvv＠dariel.co.za -
Vincent Massol