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', ),
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.
