Customer ID and Customer No. differs

Discussion in 'ISPConfig 3 Priority Support' started by cmks, Nov 27, 2020.

  1. cmks

    cmks New Member HowtoForge Supporter

    Dear,
    for 55 or 56 customer records the customer ID and the customer No where euqal in the system. Beginning with ID 58 the No is one less. This is confusing. What I want to know:
    - Is there any service or function that depends on equality of ID and No ?
    - Why the two numbers running apart?
    - Is there an option to sync them (beginning with the nect customer) ?

    Thank you!

    Regards,
    cmks
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    No. These numbers may the same by coincidence, but they don't have to.

    The ID is the technical, always numeric ID (auto increment column) of the database while the customer number is a text string and counter which can be set or altered by the admin to match e.g. existing customer number schemes in other administrative software that you use in your company. So they can be different, depending on what you do as MySQL may reuse auto-increment keys under specific circumstances.

    You can set the next customer number under System > Interface > Main config > Misc
     

Share This Page