[xwiki-users] XWiki upgrade from 1.0 to 1.2

Hi everyone, I want to upgrade XWiki to the latest version, using the war package. Indeed, my XWiki's encoding, as the MySQL database, are latin1 (ISO-8859-1) and with version 1.0, when I display any previous version of a page using the "History" function, accents and all special entities are displayed as "?" (I didn't find any JIRA issue matching this :) So I can't rollback any page whitout losing accents, and it's the main reason for this upgrade. Starting from http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation, i've read http://www.xwiki.org/xwiki/bin/view/Main/ReleaseNotesXWikiEnterprise12 wich leads to http://www.xwiki.org/xwiki/bin/view/Main/ReleaseNotesXWikiEnterprise112 in my case. Here what I did on a test server with its own Tomcat and MySQL containers : 1- copy from the production server the whole $webapp directory and dump the xwiki database change hibernate.cfg.xml that it talks to the copied test database restart all and check i've the same wiki 2 - delete all the content of $webapp. unjar xwiki-web-standard-1.1.2.war in this empty directory. edit /WEB-INF/xwiki.cfg (adding the xwiki.upload.tempdir line), /WEB-INF/hibernate.cfg.xml (changing the mysql connection) and /skins/albatross/global.vm (there is a little change in order to restrict registration with a password). restart all the stuff (apache, tomcat) --> I find my wiki as with the 1.0 install, but the bug is still here 3 - import the FixRCS.xar as written on the 1.1.2 release note : http://www.xwiki.org/xwiki/bin/download/Main/ReleaseNotesXWikiEnterprise11M… trying to run it --> the catalina log tells me something like that : 16:39:58,581 WARN TP-Processor7 http://xwiki.pps.jussieu.fr/xwiki/bin/view/XWiki/FixRCS?force JDBCExceptionReporter:logExceptions:71 - SQL Error: 1062, SQLState: 23000 16:39:58,583 ERROR TP-Processor7 http://xwiki.pps.jussieu.fr/xwiki/bin/view/XWiki/FixRCS?force JDBCExceptionReporter:logExceptions:72 - Duplicate entry '-492041200-Panels.' for key 1 16:39:58,586 ERROR TP-Processor7 http://xwiki.pps.jussieu.fr/xwiki/bin/view/XWiki/FixRCS?force AbstractFlushingEventListener:performExecutions:299 - Could not synchronize database state with session org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update ... Caused by: java.sql.BatchUpdateException: Duplicate entry '-492041200-Panels.' for key 1 ... 16:40:00,209 ERROR TP-Processor7 http://xwiki.pps.jussieu.fr/xwiki/bin/view/XWiki/FixRCS?force SimpleLog4JLogSystem:logVelocityMessage:154 - Method getRenderedContent threw exception for reference $cdoc in t emplate at [7,1] Caused by: java.lang.StackOverflowError at java.util.regex.Pattern.atom(Pattern.java:1863) at java.util.regex.Pattern.sequence(Pattern.java:1743) at java.util.regex.Pattern.expr(Pattern.java:1687) at java.util.regex.Pattern.compile(Pattern.java:1397) at java.util.regex.Pattern.<init>(Pattern.java:1124) at java.util.regex.Pattern.compile(Pattern.java:817) at java.lang.String.replaceAll(String.java:2000) at org.codehaus.groovy.runtime.Invoker.format(Invoker.java:699) at org.codehaus.groovy.runtime.Invoker.format(Invoker.java:673) at org.codehaus.groovy.runtime.Invoker.format(Invoker.java:675) ... 4 - from this point, updating this 1.1.2 install with xwiki-enterprise-web-1.2.war and the same process --> I can't even access to the previous versions of any documents, it shows me an exception. Sorry for writing a lot, now my questions :) 1 - Did I understand well the upgrade process ? Do I have to upgrade first from 1.0 to 1.1.2 and then from 1.1.2 to 1.2 ? Why running the FixRCS.xar content doesn't work after 1.1.2 upgrade ? Is that the reason why I can't update to 1.2 after, or why the bug is still there ? 2 - In which XWiki version this "special entities not displayed in old revisions with ISO-8859-1 encoding" bug is fixed ? 3 - Has someone tried the same upgrade ? Did U succeed ? Thanks, -- Julien Oix - Université Paris Diderot Paris 7 Office location : Laboratoire PPS - bureau 5C01 175 rue du Chevaleret 75013 PARIS Tel : +33 144 278 504 Fax : (+33) 1 44 27 86 54 Mobile : +33 664 392 207 --------------------------------------------- http://www.gnu.org/philosophy/no-word-attachments.html