[xwiki-users] Delete Spaces with broken Umlauts
Hi everyone, somehow I created Spaces with broken Umlauts like: Gesch�������¤ftsf�������¼hrung or Gesch�¤ftsf�¼hrung see screenshot: https://dl.dropbox.com/u/10128532/Schnappschuss%20%282012-12-13%2013.29.05%2... I cannot delete those. They are empty but after deleting from the spaces menu they still stay in the Spaces-Lists (i.e. on the Dashboard). Is there any way to get rid of them manually (Using Tomcat/MySQL) Thanks a lot! Ole
On 12/13/2012 07:40 AM, Ole Mollenhauer wrote:
Hi everyone,
somehow I created Spaces with broken Umlauts like: Gesch�������¤ftsf�������¼hrung or Gesch�¤ftsf�¼hrung see screenshot: https://dl.dropbox.com/u/10128532/Schnappschuss%20%282012-12-13%2013.29.05%2...
I cannot delete those. They are empty but after deleting from the spaces menu they still stay in the Spaces-Lists (i.e. on the Dashboard).
Is there any way to get rid of them manually (Using Tomcat/MySQL)
For Tomcat, you should follow this guide: http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat Very important step:
Edit your conf/server.xml to set UTF-8 encoding: <Connector port="8080" ... URIEncoding="UTF-8"/>
(if you're using mod_proxy_ajp in front of it, then set URIEncoding for the 8009 connector as well) -- Sergiu Dumitriu http://purl.org/net/sergiu/
Hi Sergiu, that's all set - from the beginning - nevertheless i do have the described problem. Ole 2012/12/13 Sergiu Dumitriu <sergiu@xwiki.org>
On 12/13/2012 07:40 AM, Ole Mollenhauer wrote:
Hi everyone,
somehow I created Spaces with broken Umlauts like: Gesch�������¤ftsf�������¼hrung or Gesch�¤ftsf�¼hrung see screenshot:
https://dl.dropbox.com/u/10128532/Schnappschuss%20%282012-12-13%2013.29.05%2...
I cannot delete those. They are empty but after deleting from the spaces menu they still stay in the Spaces-Lists (i.e. on the Dashboard).
Is there any way to get rid of them manually (Using Tomcat/MySQL)
For Tomcat, you should follow this guide: http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat
Very important step:
Edit your conf/server.xml to set UTF-8 encoding: <Connector port="8080" ... URIEncoding="UTF-8"/>
(if you're using mod_proxy_ajp in front of it, then set URIEncoding for the 8009 connector as well)
-- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
-- Ole Mollenhauer - Digitale Kommunikation Northeimer Str. 32 28215 Bremen 0177-5558931 http://www.olemollenhauer.de
On 12/13/2012 08:36 AM, Ole Mollenhauer wrote:
Hi Sergiu,
that's all set - from the beginning - nevertheless i do have the described problem.
OK, so if the connector encoding is not the problem, you could try and delete those documents with a script. First, you have to find out what's the real document name. Use something like this: {{velocity}} #foreach ($d in $xwiki.searchDocuments("where doc.space like 'Gesch%'")) #set ($d = $xwiki.getDocument($d)) | $d.space | $d.fullName #end {{/velocity}} Once you get the right name for the bad documents, you have to delete them from another script: {{velocity}} #xwiki.getDocument('fullName copied from the list above').delete() {{/velocity}} There is still the question of how those documents came into existence... Make sure all the settings on the encoding guide http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Encoding are correct.
2012/12/13 Sergiu Dumitriu <sergiu@xwiki.org>
On 12/13/2012 07:40 AM, Ole Mollenhauer wrote:
Hi everyone,
somehow I created Spaces with broken Umlauts like: Gesch�������¤ftsf�������¼hrung or Gesch�¤ftsf�¼hrung see screenshot:
https://dl.dropbox.com/u/10128532/Schnappschuss%20%282012-12-13%2013.29.05%2...
I cannot delete those. They are empty but after deleting from the spaces menu they still stay in the Spaces-Lists (i.e. on the Dashboard).
Is there any way to get rid of them manually (Using Tomcat/MySQL)
For Tomcat, you should follow this guide: http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat
Very important step:
Edit your conf/server.xml to set UTF-8 encoding: <Connector port="8080" ... URIEncoding="UTF-8"/>
(if you're using mod_proxy_ajp in front of it, then set URIEncoding for the 8009 connector as well)
-- Sergiu Dumitriu http://purl.org/net/sergiu/
Thanks a lot! I think I've found the error - a wrong jdbc-connection URL in hibernate.cfg Nevertheless it's not possible to delete the existent Spaces with broken Umlauts (neither with your script nor with the "delete Spaces"-Function from the top-Menu - and though it is visible in the recycle bin). Is it possible to delete them directly from the database? Ole 2012/12/13 Sergiu Dumitriu <sergiu@xwiki.org>
On 12/13/2012 08:36 AM, Ole Mollenhauer wrote:
Hi Sergiu,
that's all set - from the beginning - nevertheless i do have the described problem.
OK, so if the connector encoding is not the problem, you could try and delete those documents with a script.
First, you have to find out what's the real document name. Use something like this:
{{velocity}} #foreach ($d in $xwiki.searchDocuments("where doc.space like 'Gesch%'")) #set ($d = $xwiki.getDocument($d)) | $d.space | $d.fullName #end {{/velocity}}
Once you get the right name for the bad documents, you have to delete them from another script:
{{velocity}} #xwiki.getDocument('fullName copied from the list above').delete() {{/velocity}}
There is still the question of how those documents came into existence... Make sure all the settings on the encoding guide http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Encoding are correct.
2012/12/13 Sergiu Dumitriu <sergiu@xwiki.org>
On 12/13/2012 07:40 AM, Ole Mollenhauer wrote:
Hi everyone,
somehow I created Spaces with broken Umlauts like: Gesch�������¤ftsf�������¼hrung or Gesch�¤ftsf�¼hrung see screenshot:
https://dl.dropbox.com/u/10128532/Schnappschuss%20%282012-12-13%2013.29.05%2...
I cannot delete those. They are empty but after deleting from the
spaces
menu they still stay in the Spaces-Lists (i.e. on the Dashboard).
Is there any way to get rid of them manually (Using Tomcat/MySQL)
For Tomcat, you should follow this guide: http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat
Very important step:
Edit your conf/server.xml to set UTF-8 encoding: <Connector port="8080" ... URIEncoding="UTF-8"/>
(if you're using mod_proxy_ajp in front of it, then set URIEncoding for the 8009 connector as well)
-- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
-- Ole Mollenhauer - Digitale Kommunikation Northeimer Str. 32 28215 Bremen 0177-5558931 http://www.olemollenhauer.de
Hi Ole, I was faced to a similar problem this days. Umlauts have blocked the removement via the web interface. I've tryed the scripts from Sergiu Dumitriu without luck, too. But with these little mods they run fine: *Change "BEGIN UMLAUTS TITLED SPACE%" in that way that you get only the ones with the wrong space title back* {{velocity}} #foreach ($d in $xwiki.searchDocuments("where doc.space like 'BEGIN UMLAUTS TITLED SPACE%'")) #set ($d = $xwiki.getDocument($d)) $d.fullName #end {{/velocity}} Then exchange *$d.fullName* by *$d.delete()* and run the script again. This removes all Spaces like 'BEGIN UMLAUTS TITLED SPACE%' without confirmation and success message. {{velocity}} #foreach ($d in $xwiki.searchDocuments("where doc.space like 'BEGIN UMLAUTS TITLED SPACE%'")) #set ($d = $xwiki.getDocument($d)) $d.delete() #end {{/velocity}} Thank you Sergiu Dumitriu for sharing. -- View this message in context: http://xwiki.475771.n2.nabble.com/Delete-Spaces-with-broken-Umlauts-tp758286... Sent from the XWiki- Users mailing list archive at Nabble.com.
participants (3)
-
Ole Mollenhauer -
Sergiu Dumitriu -
zzeroo