Re: [xwiki-users] upgrade from 0.984 to 1.0B3

1 Feb 2007

      Hi Sergiu,

I just did that, running on Tomcat 5.5 against a MySQL 5.0.21 server.
I loaded the database dump from the old xwiki app.
Unfortunately, still the same error, see below.

Thanks for your response,
- Lukas

-----------------------------------------------------------------------

com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize
main XWiki context
Wrapped Exception: Error number 3201 in 3: Exception while saving
document XWiki.XWikiPreferences
Wrapped Exception: Could not execute JDBC batch update
	com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:266)
	com.xpn.xwiki.XWiki.getXWiki(XWiki.java:346)
	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:689)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:121)

Sergiu Dumitriu wrote:
...
Hi,
The 4.0 version is not recommended (supported) anymore. Among other
things, the hibernate version we use causes a deadlock, and character
sets are not supported.
I think this was specified somewhere on the wiki...
However, the update should not be a problem. Please try to update using
a newer version of mysql, and tell us if it works, so that we can update
the installation instructions to emphasize this issue.
Sergiu Dumitriu, developer.
On 2/1/07, *teh stu* <[email protected] <mailto:[email protected]>> wrote:
OK, thanks!
Is there a chance that a developer will respond on this list?
    Or.. maybe you are, I don't know.. :)
But it seems to me nobody knows how to do this properly.
    Do you know who might know?
Thanks,
    - Lukas
Fabian Gorsler wrote:
    > Hi Lukas,
    >
    > On Do, 2007-02-01 at 15:18 +0100, teh stu wrote:
    >> I'm using MySQL 4.0.22 on Windows.
    >
    > it seems you're usign InnoDB tables which handle references
    correctly.
    > But I don't know much about MySQL. In fact the only thing I know about
    > MySQL which is interesting in this situation, that only InnoDB serves
    > referential integrity.
    >
    >> Do you think it could help to try the new XWiki on a MySQL 5
    server ?
    >
    > AFAIK the update works with MySQL 5, but I'm not sure. Until
    yesterday I
    > did read much mails on this list.
    >
    >> I didn't quite follow you about the referential integrity
    problems in
    >> dumps. Is it something than can perhaps be fixed manually or with
    a script?
    >
    > While the database layout from 0.9.840 is updated to the new layout of
    > 1.0b3 there seem to be some data sets which are referenced in other
    > tables and because of that the new layout can't be applied.
    >
    > Perhaps it is possible to do the update when those data sets are
    > deleted, but I don't know whether these data sets are only of
    temporary
    > interest (session stuff, locks, ...) or if they are needed
    permanently.
    > If they are needed, deleting them would be harmful.
    >
    > Best regards,
    > Fabian.
    >
    >
    >
    ------------------------------------------------------------------------
>
    >
    > --
    > You receive this message as a subscriber of the
    [email protected] <mailto:[email protected]> mailing
    list.
    > To unsubscribe: mailto: [email protected]
    <mailto:[email protected]>
    > For general help: mailto:[email protected]
    <mailto:[email protected]>?subject=help
    > ObjectWeb mailing lists service home page:
    http://www.objectweb.org/wws
--
    You receive this message as a subscriber of the
    [email protected] <mailto:[email protected]> mailing
    list.
    To unsubscribe: mailto: [email protected]
    <mailto:[email protected]>
    For general help: mailto:[email protected]
    <mailto:[email protected]>?subject=help
    ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
-- 
http://purl.org/net/sergiu
------------------------------------------------------------------------
--
You receive this message as a subscriber of the [email protected] mailing list.
To unsubscribe: mailto:[email protected]
For general help: mailto:[email protected]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws