cannot import account - name_cannot_be_more_than_12_char

[qtriangle]

I have  kloxo setup on old server, and a new Kloxo MR setup.
I want to export and individual account from Kloxo server and import to KloxoMR server.
The problem is that the client name is more than 12 characters long.
I am trying to manually create a new account on KloxoMR, then planning to run restore using the exported dump file, taken from old Kloxo.
But I am stuck at the first step.
On KloxoMR I am not able to create account since name is more than 12 chars long. I am getting error name_cannot_be_more_than_12_char
What is the solution to this?

[MRatWork]

It's about mysql only permit 16 chars database name. Because database name include client (with format clientname_) so Kloxo/Kloxo-MR only permit 12 chars for client name.

[qtriangle]

When I add a new client, kloxo permits long client account name(more than 12), but kloxo MR has limitation of 12.
Why that difference?

More importantly, how can i solve my problem?

[MRatWork]

You have a trouble if client name more then 12 chars because database name with format client_ (that mean database name max 13 chars for client name + _).

For 12 chars client name, database name will be 123456789012_123.

For your situation, try restore client with less then 12 chars client name first. For client name with more then 12 chars, need modified backup file and or KLoxo-MR code.

[nhp]

yes, this is an annoying bug to move from kloxo to kloxomr.

[MRatWork]

Hi,

Kloxo since 6.1.7 also limiting to 12 char but no warning.

[nhp]

yeah that's part of the problem, i was using kloxo for many years before the 12char limit, i'm not migrating over to kloxoMR

[MRatWork]

Kloxo will create mysql database name (as the same as database username) with limitation 16 chars.

Imagine, your client is 'client1' (7 chars) and your client database name (also their username) is 'client1_wordpress' (17 chars) and it's not permit. Possible as 'client1_wordpres' (16 chars; only with single 's').

Truely, in mysql, only database username with limiting to 16 chars. Database name able until 64 chars.

I have a plan to change mysql naming rule where database name able until 59 chars (because 4 chars as 'random alphanumeric' and 1 as '_') and database username is the same as client name (max 16 chars).

So, for 'client1', database name will be '1a6z_wordpress' and database username also as 'client1'.

[nhp]

it was a 1 liner to remove the 12 char limit, i've almost finished moving 80Gb worth of sites over using the backup and restore, only 1 tricky one and the was with resellers where i ended up recreating their structure and started importing at their client level, a bit shitty i know but seems to be working.

will set back the limit once i'm done