migration toolkit - wrong sys_userid

Discussion in 'ISPConfig 3 Priority Support' started by pyte, Apr 19, 2023.

  1. pyte

    pyte Well-Known Member HowtoForge Supporter

    I'm back after some time off :), and run into a new issue that i don't seem to understand.

    I'm using the migration toolkit to copy over client data with
    Code:
    ./migrate --only=client --no-syncjobs
    However the script fails with the follow error in the log:
    Code:
    ...
    2023-04-19 08:36:21 - [ERROR] API call to client_add failed.
    2023-04-19 08:36:21 - [ERROR] JSON API REPLY ERROR: Incorrect integer value: '' for column `dbispconfig`.`client`.`sys_userid` at row 1 INSERT INTO `client` (`client_id`, `company_name`, `gender`, `contact_firstname`, `contact_name`, `customer_no`,
    ...
    Any ideas why the value for sys_userid is empty?

    The migration did run OK for the clients on another try, however now this:

    Now it happends while migrating a webserver. Same error for alot of domains. Any idea?

    Code:
    2023-04-19 09:03:09 - [ERROR] JSON API REPLY ERROR: Incorrect integer value: '' for column `dbispconfig`.`domain`.`sys_userid` at row 1 INSERT INTO `domain` (`domain_id`, `domain`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`) VALUES (232, 'redactedforprivacy.com', '', '', 'riud', 'riud', '') - Arguments sent were: array (
      'client_id' => '301',
      'params' =>
      array (
        'domain' => 'redactedforprivacy.com',
        'sys_perm_user' => 'riud',
        'sys_perm_group' => 'ru',
        'sys_perm_other' => '',
        '_ID_' => '232',
        '_migrate_status' => NULL,
        '_migrate_status_type' => NULL,
        '_migrate_status_dep' => NULL,
        '_primary_id' => '232',
      ),
    
     
    Last edited: Apr 19, 2023
  2. pyte

    pyte Well-Known Member HowtoForge Supporter

    Well guys remember to delete everything before attempting a migration. The target server still had the reseller for all customers left. Which resulted in these issues.
     
    Th0m and till like this.

Share This Page