L. Hagen
Basic Pleskian
Today I planned to migrate some sites to my new server (as already done in the past) with Plesk Migration.
The source system is an Ubuntu 16, Plesk Obsidian
The destination system is an Ubuntu 20, Plesk Obsidian
But I received the following error code:Failed to fetch basic information about resellers, clients and domains data from source servers
Furthermore I started a diagnostic with
I'm not a real admin and I'm just using Plesk to host and manage my Webprojects.
Please can somebody tell me what I'm doing wrong or better: how I can fix this issue to start my migration?
Thx and best regards,
Lars
The source system is an Ubuntu 16, Plesk Obsidian
The destination system is an Ubuntu 20, Plesk Obsidian
But I received the following error code:Failed to fetch basic information about resellers, clients and domains data from source servers
I'm logged in as "root". So I tried to find out something withCause: Failed to execute SQL query on Plesk database: failed to parse JSON returned by SQL script.
Query:
SELECT Subscriptions.id as subscription_id, clients.id, login, pname
FROM clients
LEFT JOIN Subscriptions ON
Subscriptions.object_id = clients.id
AND Subscriptions.object_type = 'client'
WHERE clients.type = 'reseller'
...
...
Command's stderr: [14783]: 2021-11-08 14:28:09.433 DEBUG New connection: mysql DBI connection. db psa, user admin, host localhost
[14783]: 2021-11-08 14:28:09.434 TRACE SQL:
SELECT Subscriptions.id as subscription_id, clients.id, login, pname
FROM clients
LEFT JOIN Subscriptions ON
Subscriptions.object_id = clients.id
AND Subscriptions.object_type = 'client'
WHERE clients.type = 'reseller'
: Params:
That is a critical error, migration was stopped.
The MySQL select statement returns no errors, justplesk db
as expected, because I don't have any resellers.Empty set (0.00 sec)
Furthermore I started a diagnostic with
but there are also no problems.plesk repair all -n
I'm not a real admin and I'm just using Plesk to host and manage my Webprojects.
Please can somebody tell me what I'm doing wrong or better: how I can fix this issue to start my migration?
Thx and best regards,
Lars