Error sys_userid and sys_group id

Discussion in 'Developers' Forum' started by wcdsantos, May 23, 2019.

  1. wcdsantos

    wcdsantos New Member

    Hello Dear,

    I would like to ask a question and help here in the forum.

    It happens that I am using the "client_get" function where I pass the client id and in the data return I realize that all clients within the db have the same sys_userid and sys_groupid.

    In the query of client sites using the function "client_get_sites_by_user" is passed exactly the sys_userid and sys_group id but if all have the same value in the client table of mysql how can I search the sites of a certain client, and in case of error in some configuration how could I fix it, because I believe that the data that should be in the client table in the above-mentioned field should be the id that appears in the sys_user table.

    If I am wrong, will they correct me otherwise I need to make some correction?
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    There is no error, just a misunderstanding what these fields are on your side. The sys_userid and sys_groupid define the owner of a record. The owner of the clients is the administrator, so they must have all the same user and groupid. Whereas the owner of a website is a client, then the website has the sys_groupid of the client group, see sys_group table.

Share This Page