Re: [xwiki-users] XAR Export fails - Invalid white space character (0x1) in text to output
Thanks everyone! The problem has been solved, and the odd characters are gone. The query didn't work without some modifications. I ended up using select xwd_fullname from xwikidoc where xwd_content like '%' || chr(1) || '%'; (concat() only takes two operands, so it was easier to use ||. My sqlplus tool didn't like "%" and char(1), so I had to use '%' and chr(1).) After this character was removed, I got complaints about 0xf. The page was identified with the equivalent query, but using chr(15). I also had to remove some of the old versions from the page history. Oddly enough, the queries still report that the odd characters are present in the database, but exporting the entire wiki works fine now, so the odd characters are no longer a problem. By the way, the text with the odd characters had entered the wiki when text had been copied an pasted from UNIX terminal windows. Agan, thanks everyone for your invaluable help! Peter ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] XAR Export fails - Invalid white space character (0x1) in text to output
Avoiding this problem in the future would be nice, but I already have this character in my wiki, and I need to get rid of it. I don't know how it got there, but more importantly, I need to find it, so I can remove it. With no XAR export, we can't do our planned transision from an Oracle to a PostgreSQL database. As for the discussion on markmail.org – I have registered there, but I can't find anything on the webpage that allows me to take part in the discussion. Cheers, Peter 2016-02-22 12:15 GMT+01:00 Thomas Mortagne <thomas.morta...@xwiki.com>: > Starting a discussion on this subject on > http://markmail.org/message/32vnzxchphr26phh. > > If you have more input on what is this character doing here please share > there. > > On Mon, Feb 22, 2016 at 11:55 AM, Thomas Mortagne > <thomas.morta...@xwiki.com> wrote: > > Actually I do know why it's writting XML 1.0, that's because we tell it > to... > > > > Did not know XML 1.0 was not supporting anything, I'm surprise we get > > this kind of report only know. > > > > Anyway thanks for the report, will take care of this. > > > > On Mon, Feb 22, 2016 at 11:31 AM, Thomas Mortagne > > <thomas.morta...@xwiki.com> wrote: > >> What I understand from the error message is that Woodstox think it's > >> writing XML 1.0 and looks like it's not possible to put anything you > >> want in XML 1.0 but not sure why exactly. You happen to have a > >> document containing some weird character (0x1) which is probably a > >> mistake but still we should be able to export anything (especially > >> when this anything can be stored in a String and in the database). > >> > >> In the meantime what you can try is to set the old exporter in > >> xwiki.cfg (look at xwiki.action.export.xar.usewikistream property). > >> Would be great if you could crate an issue on http://jira.xwiki.org > >> with all the information you can gather about this bug. > >> > >> > >> On Mon, Feb 22, 2016 at 10:18 AM, Peter John Acklam <pjack...@gmail.com> > wrote: > >>> I can no longer make a XAR export of our wiki. The essential error > message > >>> in catalina.out seems to be > >>> > >>> "Invalid white space character (0x1) in text to output (in xml 1.1, > could > >>> output as a character entity)" > >>> > >>> Alas, there is no information about which wiki page contains this > invalid > >>> character. I can, of course, export parts of the wiki and repeat the > >>> process until I find the offending page, but I suspect there has got > to be > >>> a more efficient way. > >>> > >>> The full, relevant section of catalina.out on our test server is > included > >>> below. > >>> > >>> Thanks in advance for any tips! > >>> > >>> Cheers, > >>> Peter John Acklam > >>> > >>> > >>> 2016-02-19 09:36:17,163 [ > >>> > http://wiki-test/xwiki/bin/export/XWiki/XWikiPreferences?editor=globaladmin=Export > ] > >>> WARN c.x.x.w.XWikiAction - Uncaught exception: Error number 11015 in > 11: > >>> Exception while exporting > >>> com.xpn.xwiki.XWikiException: Error number 11015 in 11: Exception while > >>> exporting > >>> at com.xpn.xwiki.web.ExportAction.render(ExportAction.java:84) > >>> ~[xwiki-platform-legacy-oldcore-7.4.1.jar:na] > >>> at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:417) > >>> [xwiki-platform-legacy-oldcore-7.4.1.jar:na] > >>> at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:184) > >>> [xwiki-platform-legacy-oldcore-7.4.1.jar:na] > >>> at > >>> > org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) > >>> [struts-core-1.3.10.jar:1.3.10] > >>> at > >>> > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) > >>> [struts-core-1.3.10.jar:1.3.10] > >>> at > org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) > >>> [struts-core-1.3.10.jar:1.3.10] > >>> at > org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) > >>> [struts-core-1.3.10.jar:1.3.10] > >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:648) > >>> [servlet-api.jar:na] > >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) > >>> [servlet-api.jar:na
[xwiki-users] XAR Export fails - Invalid white space character (0x1) in text to output
I can no longer make a XAR export of our wiki. The essential error message in catalina.out seems to be "Invalid white space character (0x1) in text to output (in xml 1.1, could output as a character entity)" Alas, there is no information about which wiki page contains this invalid character. I can, of course, export parts of the wiki and repeat the process until I find the offending page, but I suspect there has got to be a more efficient way. The full, relevant section of catalina.out on our test server is included below. Thanks in advance for any tips! Cheers, Peter John Acklam 2016-02-19 09:36:17,163 [ http://wiki-test/xwiki/bin/export/XWiki/XWikiPreferences?editor=globaladmin=Export] WARN c.x.x.w.XWikiAction - Uncaught exception: Error number 11015 in 11: Exception while exporting com.xpn.xwiki.XWikiException: Error number 11015 in 11: Exception while exporting at com.xpn.xwiki.web.ExportAction.render(ExportAction.java:84) ~[xwiki-platform-legacy-oldcore-7.4.1.jar:na] at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:417) [xwiki-platform-legacy-oldcore-7.4.1.jar:na] at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:184) [xwiki-platform-legacy-oldcore-7.4.1.jar:na] at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) [struts-core-1.3.10.jar:1.3.10] at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) [struts-core-1.3.10.jar:1.3.10] at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) [struts-core-1.3.10.jar:1.3.10] at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) [struts-core-1.3.10.jar:1.3.10] at javax.servlet.http.HttpServlet.service(HttpServlet.java:648) [servlet-api.jar:na] at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) [servlet-api.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291) [catalina.jar:8.0.30] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.30] at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:115) [xwiki-platform-legacy-oldcore-7.4.1.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.30] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.30] at org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127) [xwiki-platform-wysiwyg-server-7.4.1.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.30] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.30] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.0.30] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.30] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.30] at org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63) [xwiki-platform-container-servlet-7.4.1.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.30] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.30] at com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66) [xwiki-platform-webdav-server-7.4.1.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.30] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.30] at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) [xwiki-platform-container-servlet-7.4.1.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.30] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.30] at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) [xwiki-platform-container-servlet-7.4.1.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.30] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.30] at org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:137) [xwiki-platform-resource-servlet-7.4.1.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.
[xwiki-users] XWiki space partially deleted
I wanted a metawiki space, so as the Admin user, I created the XWiki space. Realizing that we already had a Wiki space, I deleted the XWiki space. The deletion to surprisinly long time, so I got suspicious and hit Cancel. I didn't think much of it until a few days later, when I was no longer able to log in as Admin. That was when I remembered that the XWiki space is special. I had deleted a lot more than just a newly created empty space. Now I am no longer allowed to log in as Admin or superadmin. Both accounts worked before, but now both give me the error message Invalid credentials. Apparently, all users can log in with their ordinary user account, but with no admin account I can no longer re-import the XWiki pages from the XAR file. The superadmin account was enabled when I upgraded to the current XWiki 5.2. It was tested and working, but not any longer. How on earth to I get around this? As as side note, I am very surprised that 1) I was able to create the XWiki space, just as any other space, and 2) that I was able to delete the XWiki space with no notification about this space being vital to XWiki. Any help or pointers are highly appreciated. Kind regards, Peter John Acklam ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
