Clients Are Getting The Same Id

[RebornWebs]

When any new client joins our system they are all being given id 15 rather then 40 or 50 etc and now i have like 6 clients with client id 15.

 

Anyone know the issue.

[RebornWebs]

fixed it in the phpmyadmin but now they all getting id 45 instead.

[Paul]

That's pretty odd, we've never seen that happen before. Had you made any changes to the database prior to this? What version of MySQL and PHP are you running?

[RebornWebs]

php 5.4.21 and mysql 5.5.32-cll

 

I mainly blame our whmcs for this issue tro, but other people who have used the importer have not gotten this issue so im not sure

[Tyson]

What are the values of your company settings related to client start, format and increment values? i.e. "clients_start", "clients_format", and "clients_increment"

 

You can run the following query to check the values:

 SELECT * FROM `company_settings` WHERE `key` LIKE 'clients_%' AND `company_id` =1 LIMIT 0 , 30

And when did this issue start?

[RebornWebs]

The issue started around 19th of October when i had 3 users register and being doing it since then.

 

 

[Tyson]

The settings look correct.

 

What value is returned from the following query?:

SELECT CAST( LPAD( IFNULL( GREATEST( MAX( t1.id_value ) , '1500' ) + '1', '1500' ) , GREATEST( CHAR_LENGTH( IFNULL( MAX( t1.id_value ) + '1', '1500' ) ) , '0' ) , '0' ) AS CHAR( 10000 ) CHARACTER SET utf8 ) FROM `clients` AS `t1` INNER JOIN `client_groups` ON `client_groups`.`id` = `t1`.`client_group_id` WHERE `client_groups`.`company_id` = '1' AND `t1`.`id_format` = '{num}' LIMIT 0 , 30;

 

If your clients use the format {num} as your settings suggest (see `clients`.`id_format`), then the result of that query should be the next value to use for the client ID value. Considering yours is not working correctly, the result is probably 15.

 

But it sounds like something else had happened on or before October 19 that is causing this issue. Has anything else changed besides a few clients signing up?

[RebornWebs]

Nothing has happened to cause this issue that i am aware of as everything else is working fine

[Tyson]

Interesting. Before this happened, what were the client numbers? 1500, 1501, 1502...etc.? Then suddenly just 15? Which client was the last one not to be given an ID value of 15?

[RebornWebs]

Nop they have never started from 1500 its as if when the importer imported the client ids from whmcs to blesta they never updated.

 

i have noticed that any client who  joined before the 19th of this month did not get id 15

[RebornWebs]

Its as if on the 19 when  clients joined something happened to cause the ids to mess up.

[RebornWebs]

Sorry to bump / spam if this seems like it, but now i do recall a slight issue with cron jobs what was solved by our host

[Tyson]

I'm not sure how cron jobs could have affected the client ID calculation. Has MySQL changed on your server? What version of MySQL are you having this problem with?

[RebornWebs]

nope nothing has changed with the mysql so i dont know why.

[Michael]

Time to do a fresh Install I think matthew.

[Tyson]

You could try using a different version of MySQL to see if that may be the cause. But we haven't had any other reports of this problem that I'm aware of, so it seems like it would be a server issue.

[Michael]

You could try using a different version of MySQL to see if that may be the cause. But we haven't had any other reports of this problem that I'm aware of, so it seems like it would be a server issue.

 

We just re-installed blesta fresh and did the accounts manually haha  stupid WHM**.

[pcfacility]

Hello,

 

Today we are facing the same issue. New customers get the id 15.

 

whmcs 5.2.x -> blesta 3

 

How we can resolve this problem?

[Cody]

 

Hello,

 

Today we are facing the same issue. New customers get the id 15.

 

whmcs 5.2.x -> blesta 3

 

How we can resolve this problem?

 

 

Do you mean you imported clients from WHMCS and they all had customer ID 15? Or do you mean after importing clients from WHMCS all new clients have ID 15?

[pcfacility]

After importing client with from whmcs, all new account get the id15 (we use the version b7 of the importer)

 

Edit : We run the importer from a fresh install of blesta 3.0.5

[Michael]

After importing client with from whmcs, all new account get the id15 (we use the version b7 of the importer)

 

Edit : We run the importer from a fresh install of blesta 3.0.5

 

Must be a WHM** issue then, we did a fresh install (Moved the production in a dev folder and re-made the accounts.

 

Try upgrading to blesta 3.0.6 first.

[pcfacility]

Hello,

 

How can i export the invoice, transactions and services from my old blesta 3 to the fresh install ? And link them to my customers ?

[Michael]

Hello,

 

How can i export the invoice, transactions and services from my old blesta 3 to the fresh install ? And link them to my customers ?

 

That will have to be done manually, or start fresh with new invoices. I never had this issue myself because I imported from WHM** to Blesta 2.5 then to 3.0.0.b7 however you would loose more stuff and have to add domains yourself when you've moved to v3.0.6. My client had your issue but he was a small host, and just wanted to move so we just did the important bits like user account, new service, pay invoice if paid on the old one.