RebornWebs Posted October 27, 2013 Report Share Posted October 27, 2013 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. Quote Link to comment Share on other sites More sharing options...
0 RebornWebs Posted October 29, 2013 Author Report Share Posted October 29, 2013 fixed it in the phpmyadmin but now they all getting id 45 instead. Quote Link to comment Share on other sites More sharing options...
0 Paul Posted October 29, 2013 Report Share Posted October 29, 2013 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? Quote Link to comment Share on other sites More sharing options...
0 RebornWebs Posted October 29, 2013 Author Report Share Posted October 29, 2013 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 Quote Link to comment Share on other sites More sharing options...
0 Tyson Posted October 29, 2013 Report Share Posted October 29, 2013 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? Michael 1 Quote Link to comment Share on other sites More sharing options...
0 RebornWebs Posted October 29, 2013 Author Report Share Posted October 29, 2013 The issue started around 19th of October when i had 3 users register and being doing it since then. Quote Link to comment Share on other sites More sharing options...
0 Tyson Posted October 29, 2013 Report Share Posted October 29, 2013 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? Quote Link to comment Share on other sites More sharing options...
0 RebornWebs Posted October 29, 2013 Author Report Share Posted October 29, 2013 Nothing has happened to cause this issue that i am aware of as everything else is working fine Quote Link to comment Share on other sites More sharing options...
0 Tyson Posted October 30, 2013 Report Share Posted October 30, 2013 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? Quote Link to comment Share on other sites More sharing options...
0 RebornWebs Posted October 30, 2013 Author Report Share Posted October 30, 2013 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 Quote Link to comment Share on other sites More sharing options...
0 RebornWebs Posted October 30, 2013 Author Report Share Posted October 30, 2013 Its as if on the 19 when clients joined something happened to cause the ids to mess up. Quote Link to comment Share on other sites More sharing options...
0 RebornWebs Posted November 3, 2013 Author Report Share Posted November 3, 2013 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 Quote Link to comment Share on other sites More sharing options...
0 Tyson Posted November 4, 2013 Report Share Posted November 4, 2013 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? Quote Link to comment Share on other sites More sharing options...
0 RebornWebs Posted November 7, 2013 Author Report Share Posted November 7, 2013 nope nothing has changed with the mysql so i dont know why. Quote Link to comment Share on other sites More sharing options...
0 Michael Posted November 7, 2013 Report Share Posted November 7, 2013 Time to do a fresh Install I think matthew. Quote Link to comment Share on other sites More sharing options...
0 Tyson Posted November 13, 2013 Report Share Posted November 13, 2013 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. Quote Link to comment Share on other sites More sharing options...
0 Michael Posted November 14, 2013 Report Share Posted November 14, 2013 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**. Quote Link to comment Share on other sites More sharing options...
0 pcfacility Posted November 28, 2013 Report Share Posted November 28, 2013 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? Quote Link to comment Share on other sites More sharing options...
0 Cody Posted November 28, 2013 Report Share Posted November 28, 2013 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? Quote Link to comment Share on other sites More sharing options...
0 pcfacility Posted November 28, 2013 Report Share Posted November 28, 2013 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 Quote Link to comment Share on other sites More sharing options...
0 Michael Posted November 28, 2013 Report Share Posted November 28, 2013 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. Quote Link to comment Share on other sites More sharing options...
0 pcfacility Posted November 29, 2013 Report Share Posted November 29, 2013 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 ? Quote Link to comment Share on other sites More sharing options...
0 Michael Posted November 29, 2013 Report Share Posted November 29, 2013 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. Quote Link to comment Share on other sites More sharing options...
Question
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.
Link to comment
Share on other sites
22 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.