[xwiki-users] Delete Spaces with broken Umlauts

2012-12-13 Thread Ole Mollenhauer 
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%29.png

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
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Delete Spaces with broken Umlauts

2012-12-13 Thread Sergiu Dumitriu 
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%29.png
 
 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

Re: [xwiki-users] Delete Spaces with broken Umlauts

2012-12-13 Thread Ole Mollenhauer 
Hi Sergiu,

that's all set - from the beginning - nevertheless i do have the described
problem.

Ole


2012/12/13 Sergiu Dumitriu ser...@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%29.png
 
  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
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Delete Spaces with broken Umlauts

2012-12-13 Thread Sergiu Dumitriu 
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 ser...@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%29.png

 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

Re: [xwiki-users] Delete Spaces with broken Umlauts

2012-12-13 Thread Ole Mollenhauer 
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 ser...@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 ser...@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%29.png
 
  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
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users