Re: [xwiki-users] 4-byte UTF and XWiki (MySQL utf8mb4 encoding)

[Sergiu Dumitriu]

It will be almost impossible to use utf8mb4 with XWiki, because of the
terrible way mysql is designed. Here's the reason why:

mysql imposes several hard limits on the maximum size of several things:
length of indexes, length of rows. These lengths, unfortunately, are not
computed as the maximum size of the actual data, but of the theoretical
data that could be placed in there. This means that the size of a
VARCHAR(255) isn't 255 bytes, but 255 chars * maximum number of bytes
that such a char could have (3 for utf8, 4 for utf8mb4).

You could make it work if you change the schema to reduce the length of
several fields, but you would do that at your own risk.

On 04/06/2016 08:58 PM, Debajit Adhikary wrote:
> Some more information:
> 
> On my Mac, when I try to set up XWiki with MySQL, I ran the following:
> 
> # Install mysql and start
> 
> brew update
> brew install mysql
> mysql.server start
> # Now I can connect as "mysql -uroot"
> 
> # Create a new MySQL database for XWiki
> # see http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL
> 
> mysql -u root -e "create database xwiki default character set utf8mb4
> collate utf8mb4_unicode_ci"
> 
> mysql -u root -e "grant all privileges on *.* to xwiki@localhost
> identified by 'xwiki'"
> 
> 
> # Configure hibernate.cfg.xml
> # This is only the mysql section
> 
> jdbc:mysql://localhost/xwiki
> xwiki
> xwiki
>  name="connection.driver_class">com.mysql.jdbc.Driver
>  name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect
> true
> UTF-8
> true
> 20
> 
> 
> 
> 
> 
> 
> Now when I start XWiki, I get the error:
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> Row size too large. The maximum row size for the used table type, not
> counting BLOBs, is 65535. This includes storage overhead, check the manual.
> You have to change some columns to TEXT or BLOBs
> 
> It looks like whatever creates the XWiki tables is not handling utf8mb4
> (see also https://mathiasbynens.be/notes/mysql-utf8mb4 ).
> 
> 
> 
> On Wed, Apr 6, 2016 at 5:17 PM, Debajit Adhikary 
> wrote:
> 
>> I have an XWiki installation, and I noticed that emoji's were not getting
>> saved correctly and were rendering as question marks in XWiki. This is
>> caused by MySQL's default encoding which is "utf8" and not "utf8mb4"
>> (4-byte UTF to store the full unicode character set)
>>
>> To fix this, I am in the process of converting all my MySQL database
>> tables into utf8mb4 encoding, which is turning out to be quite a lot of
>> manual work.
>>
>> When XWiki creates the database tables for MySQL, can it use utf8mb4
>> encoding by default? Is this something I could open a bug request for?
>>
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
> 


-- 
Sergiu Dumitriu
http://purl.org/net/sergiu/
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Nested pages livetable

[Mahomed Hussein]

This issue has kind of bitten us as well. The table format of listing all 
documents in a particular space is really useful (regardless of nested pages or 
not). Sadly the spaceIndex (which I think is slightly different but related to 
this) doesn't list the new type pages.


Kind regards,



Mahomed Hussein
Custodian Data Centre
Email: maho...@custodiandc.com
http://www.CustodianDC.com

-Original Message-
From: users [mailto:users-boun...@xwiki.org] On Behalf Of CarlJ
Sent: 24 March 2016 11:51
To: users@xwiki.org
Subject: Re: [xwiki-users] Nested pages livetable

Hi,

I hate to bug but is there no way to display the children of a page in a
livetable, because if there isn't I am going to have restore my wiki back to
before I upgraded from our backup.

Thanks and sorry to bug.
- Carl



--
View this message in context: 
http://xwiki.475771.n2.nabble.com/Nested-pages-livetable-tp7598571p7598627.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Section in include macro fails

[Marius Dumitru Florea]

On Thu, Apr 7, 2016 at 6:55 PM, Matthias Barmeier <
matthias.barme...@sourcepark.de> wrote:

> Hi,
>
> I try to embedd a table (in a section) from another wiki page. I tried to
> use the include macro in the following form:
>
> {{include reference="Synaptic.Technik.Konfigurationsdateien"}}
>
> The whole document is embedded as expected. After adding the section
> attribute:
>
>

> {{include reference="Synaptic.Technik.Konfigurationsdateien"
> section="HFSS.properties"/}}
>

Try with reference="Synaptic.Technik.Konfigurationsdateien.WebHome" . Does
it work? See http://jira.xwiki.org/browse/XWIKI-13066


>
> I get:
> Failed to execute the [include] macro. Cause: [Cannot find section
> [HFSS.properties] in document
> [produkte:Synaptic.Technik.Konfigurationsdateien]]. Click on this message
> for details.
>
> but the document contains the necessary heading.
>
> This link works perfect when added to the document:
>


>
> [[/etc/smd/config/FSS.properties>>Synaptic.Technik.Konfigurationsdateien||anchor="HFFS.properties"]]
>

The link reference is handled a bit differently (for the moment) than the
include reference. See
http://www.xwiki.org/xwiki/bin/view/ReleaseNotes/ReleaseNotesXWiki80#HLinksyntaximprovementsforNestedPages

Hope this helps,
Marius


> Can any body give me a hint what is wrong ?
>
> Thanks.
>
> Ciao
>
>  Matthias
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

[xwiki-users] Section in include macro fails

[Matthias Barmeier]

Hi,

I try to embedd a table (in a section) from another wiki page. I tried 
to use the include macro in the following form:


{{include reference="Synaptic.Technik.Konfigurationsdateien"}}

The whole document is embedded as expected. After adding the section 
attribute:


{{include reference="Synaptic.Technik.Konfigurationsdateien" 
section="HFSS.properties"/}}


I get:
Failed to execute the [include] macro. Cause: [Cannot find section 
[HFSS.properties] in document 
[produkte:Synaptic.Technik.Konfigurationsdateien]]. Click on this 
message for details.


but the document contains the necessary heading.

This link works perfect when added to the document:
[[/etc/smd/config/FSS.properties>>Synaptic.Technik.Konfigurationsdateien||anchor="HFFS.properties"]]

Can any body give me a hint what is wrong ?

Thanks.

Ciao

 Matthias
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Ansible playbook for installing XWiki Enterprise

[Thomas Mortagne]

That's great !

Thanks a lot for this contribution :)


On Thu, Apr 7, 2016 at 12:59 PM, Andrea Russo  wrote:
> Dear all,
>
> I'm new to the list and I would like to enter this community with a
> little contribution from my side to thank you all for the very nice wiki
> platform XWiki is. We are using it for some weeks by now and we are
> finding it very nice and useful.
>
> To install and configure XWiki for a project, I developed this Ansible
> playbook:
>
> https://github.com/rastandy/xwiki-ansible-playbook
>
> I'm happily sharing it with you, hoping someone could find it useful.
>
> Thank you and happy wiking,
> Andrea.
>
> --
> Andrea Russo, Junior Research Associate
> Fondazione CMCC
> Centro Euro Mediterraneo sui Cambiamenti Climatici (http://www.cmcc.it)
> Address: via Augusto Imperatore, 16 - 73100 Lecce
> Phone: +39 0832 671064 - Fax: 0039 0832 671064
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users



-- 
Thomas Mortagne
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Display users that are not hidden

[Thomas Mortagne]

On Thu, Apr 7, 2016 at 2:16 PM, Mark Sack  wrote:
> Thanks for the pointer. The filter is a big improvement on what I had before.
> However, it only excludes hidden users if the logged in user has not chosen
> to display hidden documents. For this particular case, it would be
> preferable to always exclude hidden users from the output of the script. Is
> there a way to do that?

Indeed this filter is dynamic.

What you could do is the same thing than the filter: add "(doc.hidden
<> true or doc.hidden is null)" to your query.

>
> I had thought about using the 'active' property in the user profile (I'm not
> sure what is its intended function within the Xwiki application). But if I
> add it in for editing, then the users can set themselves as active/inactive.
> In our situation, this would be exclusively an administrative function.
>
> Regards
> Mark
>
>
>
> --
> View this message in context: 
> http://xwiki.475771.n2.nabble.com/Display-users-that-are-not-hidden-tp7598831p7598850.html
> Sent from the XWiki- Users mailing list archive at Nabble.com.
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users



-- 
Thomas Mortagne
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] How can I unregister from mail list?

[Vincent Massol]

Hi,

> On 07 Apr 2016, at 15:01, Giordano Ninonà  wrote:
> 
> Hi users,
> 
> I would like to unsign from this mailing list and also from the one of
> developers :)

Sad to see you leaving :) I hope you’re still using XWiki! 

Go to http://dev.xwiki.org/xwiki/bin/view/Community/MailingLists
(there’s a link to all lists admin)

For example for users list:
http://lists.xwiki.org/mailman/listinfo/users

Thanks
-Vincent

> Giordano.

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

[xwiki-users] How can I unregister from mail list?

[Giordano Ninonà]

Hi users,

I would like to unsign from this mailing list and also from the one of
developers :)

Giordano.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Display users that are not hidden

[Mark Sack]

Thanks for the pointer. The filter is a big improvement on what I had before.
However, it only excludes hidden users if the logged in user has not chosen
to display hidden documents. For this particular case, it would be
preferable to always exclude hidden users from the output of the script. Is
there a way to do that?

I had thought about using the 'active' property in the user profile (I'm not
sure what is its intended function within the Xwiki application). But if I
add it in for editing, then the users can set themselves as active/inactive.
In our situation, this would be exclusively an administrative function.

Regards
Mark



--
View this message in context: 
http://xwiki.475771.n2.nabble.com/Display-users-that-are-not-hidden-tp7598831p7598850.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

[xwiki-users] Ansible playbook for installing XWiki Enterprise

[Andrea Russo]

Dear all,

I'm new to the list and I would like to enter this community with a
little contribution from my side to thank you all for the very nice wiki
platform XWiki is. We are using it for some weeks by now and we are
finding it very nice and useful.

To install and configure XWiki for a project, I developed this Ansible
playbook:

https://github.com/rastandy/xwiki-ansible-playbook

I'm happily sharing it with you, hoping someone could find it useful.

Thank you and happy wiking,
Andrea.

-- 
Andrea Russo, Junior Research Associate
Fondazione CMCC
Centro Euro Mediterraneo sui Cambiamenti Climatici (http://www.cmcc.it)
Address: via Augusto Imperatore, 16 - 73100 Lecce
Phone: +39 0832 671064 - Fax: 0039 0832 671064
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Numbered headings

[Pascal BASTIEN]

or another concurrent SSX object? => You can check wich SSX object is applied 
with firebug


En date de : Jeu 7.4.16, Pascal BASTIEN  a écrit :

 Objet: Re: [xwiki-users] Numbered headings
 À: "XWiki Users" 
 Date: Jeudi 7 avril 2016, 11h22
 
 Hi,
 Me too, macro working well on xwiki 7.0.1
 May be Ctrl+F5 needed because you just apply it on all
 wiki?
 
 Pascal B
 
 
 En date de : Jeu 7.4.16, Marius Dumitru Florea 
 a écrit :
 
  Objet: Re: [xwiki-users] Numbered headings
  À: "XWiki Users" 
  Date: Jeudi 7 avril 2016, 9h56
  
  Hi Dan,
  
  This extension works fine for
  me. I just installed it on XWiki 8.1M1, I
  edited Sandbox home page, put
  {{numberedheadings/}} at the start then
  saved. The headings were correctly numbered.
  
  Hope this helps,
  Marius
  
  On Wed,
  Apr 6, 2016 at 7:28 PM, dullfig 
  wrote:
  
  > hello:
  >
  > We are using the wiki
  to write procedures for our company. It is an
  > aerospace environment, so customers are
  used to seeing procedures with
  > numbered
  headings like "paragraph 1.1.2" etc.
  >
  > Has anyone used the
  "numbered headings" macro? I installed the
  extension
  > but
  > the
  headings don't increment. they all come out "0.1
  x". I need this to
  > work.
  >
  > Dan
  >
  >
  >
  > --
  > View this message in context:
  > http://xwiki.475771.n2.nabble.com/Numbered-headings-tp7598833.html
  > Sent from the XWiki- Users mailing list
  archive at Nabble.com.
  >
  ___
  > users mailing list
  > users@xwiki.org
  > http://lists.xwiki.org/mailman/listinfo/users
  >
  ___
  users mailing list
  users@xwiki.org
  http://lists.xwiki.org/mailman/listinfo/users
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Numbered headings

[Pascal BASTIEN]

Hi,
Me too, macro working well on xwiki 7.0.1
May be Ctrl+F5 needed because you just apply it on all wiki?

Pascal B


En date de : Jeu 7.4.16, Marius Dumitru Florea  
a écrit :

 Objet: Re: [xwiki-users] Numbered headings
 À: "XWiki Users" 
 Date: Jeudi 7 avril 2016, 9h56
 
 Hi Dan,
 
 This extension works fine for
 me. I just installed it on XWiki 8.1M1, I
 edited Sandbox home page, put
 {{numberedheadings/}} at the start then
 saved. The headings were correctly numbered.
 
 Hope this helps,
 Marius
 
 On Wed,
 Apr 6, 2016 at 7:28 PM, dullfig 
 wrote:
 
 > hello:
 >
 > We are using the wiki
 to write procedures for our company. It is an
 > aerospace environment, so customers are
 used to seeing procedures with
 > numbered
 headings like "paragraph 1.1.2" etc.
 >
 > Has anyone used the
 "numbered headings" macro? I installed the
 extension
 > but
 > the
 headings don't increment. they all come out "0.1
 x". I need this to
 > work.
 >
 > Dan
 >
 >
 >
 > --
 > View this message in context:
 > http://xwiki.475771.n2.nabble.com/Numbered-headings-tp7598833.html
 > Sent from the XWiki- Users mailing list
 archive at Nabble.com.
 >
 ___
 > users mailing list
 > users@xwiki.org
 > http://lists.xwiki.org/mailman/listinfo/users
 >
 ___
 users mailing list
 users@xwiki.org
 http://lists.xwiki.org/mailman/listinfo/users
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Numbered headings

[Marius Dumitru Florea]

Hi Dan,

This extension works fine for me. I just installed it on XWiki 8.1M1, I
edited Sandbox home page, put {{numberedheadings/}} at the start then
saved. The headings were correctly numbered.

Hope this helps,
Marius

On Wed, Apr 6, 2016 at 7:28 PM, dullfig  wrote:

> hello:
>
> We are using the wiki to write procedures for our company. It is an
> aerospace environment, so customers are used to seeing procedures with
> numbered headings like "paragraph 1.1.2" etc.
>
> Has anyone used the "numbered headings" macro? I installed the extension
> but
> the headings don't increment. they all come out "0.1 x". I need this to
> work.
>
> Dan
>
>
>
> --
> View this message in context:
> http://xwiki.475771.n2.nabble.com/Numbered-headings-tp7598833.html
> Sent from the XWiki- Users mailing list archive at Nabble.com.
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] 4-byte UTF and XWiki (MySQL utf8mb4 encoding)

[Thomas Mortagne]

XWiki use utf8_bin for subwikis (and recommend it for main wiki in the
documentation) right now.

Since we use than in the hope it support everything you should
definitely open a jira issue.

On Thu, Apr 7, 2016 at 2:17 AM, Debajit Adhikary  wrote:
> I have an XWiki installation, and I noticed that emoji's were not getting
> saved correctly and were rendering as question marks in XWiki. This is
> caused by MySQL's default encoding which is "utf8" and not "utf8mb4"
> (4-byte UTF to store the full unicode character set)
>
> To fix this, I am in the process of converting all my MySQL database tables
> into utf8mb4 encoding, which is turning out to be quite a lot of manual
> work.
>
> When XWiki creates the database tables for MySQL, can it use utf8mb4
> encoding by default? Is this something I could open a bug request for?
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users



-- 
Thomas Mortagne
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users