Hi, Sergiu Dumitriu wrote:
Update: I debugged it with the Curriki guys, and the problem was that while the setup should have been UTF-8, mysql was not configured properly, so xwikircs and xwikirecyclebin were created with latin1, so their problem was indeed pure XWIKI-1736, nothing else.
The problem Ricardo had was a bit more complex, xwikircs was created with a shorter length for the xwr_patch field than it is specified now in the mapping file, because the length released with 1.2M1 was not specified at all, so Hibernate selected a length on its own.
I am in our production server now. I think I have followed the steps we have done in the test box, but I am getting something new. After correcting xwr_patch and set up xwiki.cfg to force migration in all virtual wikis with the lines... xwiki.store.migration.databases=all xwiki.store.migration.force=com.xpn.xwiki.store.migration.hibernate.R6079XWIKI1878Migrator I get this... ***** HTTP Status 500 - type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3001 in 3: Cannot load class com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param xwiki.store.migration.manager.class Wrapped Exception: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: Could not create a DBCP pool 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:117) root cause com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3001 in 3: Cannot load class com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param xwiki.store.migration.manager.class Wrapped Exception: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: Could not create a DBCP pool com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:302) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:490) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:118) 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:117) note The full stack trace of the root cause is available in the Apache Tomcat/6.0.10 logs. Apache Tomcat/6.0.10 ***** All databases are 7351 now, BUT I am getting frequently Could not connect to MySQL instance at mire.environmentalchange.net. Error: Too many connections (code 1040) MySQL is now MySQL 5.0.24a via TCP/IP. Sorry if I am missing something obvious. Any hint? The problem is mostly related to MySQL and nothing to do with XWiki? I will wait for your feedback prior to try anything else... well, I've not many options on my own :-( Thank you for your help, Ricardo -- Ricardo RodrÃguez Your EPEC Network ICT Team