Error when changing subscription's subscriber

[martijnpeek]

When changing the subscriber of migrated (or new subscriptions) from a normal customer to another normal customer or reseller customer I sometimes get the following message:

Reassigning Selected Subscriptions
ERROR: PleskFatalException
Picker not supported

When going back to the subscription overview I get the following error message:

Error: External exception. SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s)

There are related forum entries:

• Does not apply, vendor_id is never null: http://forum.parallels.com/showthread.php?245946-10-4-4-Fatal-Error-Changing-subscription-owners
• Does not apply, it was a Plesk 11 > 11 migration: http://forum.parallels.com/showthread.php?284004-Error-changing-subscription-owner-after-migration

Could you help me fix this problem?

 

[IgorG]

It is database inconsistency. Check output of following SQL query:

select * from dom_param where dom_id=xxx;

where xxx is id of domain.

 

[martijnpeek]

This is what I get, is there something that is not right?

mysql> select * from dom_param where dom_id = 13
    -> ;
+--------+---------------------+---------------------------+
| dom_id | param               | val                       |
+--------+---------------------+---------------------------+
|     13 | cgi_bin_mode        | webspace                  |
|     13 | gl_filter           | on                        |
|     13 | ipv6_addr_id        | 5                         |
|     13 | ip_addr_id          | 1                         |
|     13 | lastVisitTime       | 2014-05-15T14:28:28+02:00 |
|     13 | last_update_time    | 2014-06-06T03:45:48+02:00 |
|     13 | quickStartBar       | true                      |
|     13 | stat_ttl            | 3                         |
|     13 | webmail             | horde                     |
|     13 | webServerSettingsId | 7                         |
|     13 | wu_script           | true                      |
+--------+---------------------+---------------------------+
11 rows in set (0.00 sec)

 

[IgorG]

Usually this error related to missed ip_addr_id parameter in dom_param table. But as you can see this parameter is there.
So there are may be other reasons. I suggest you contact Support Team for checking and fixing this database inconsistency directly on your server.

 

[martijnpeek]

Thanks for your reply.

Seems it were migrated 'No Hosting' subscriptions that were giving problems. By giving it hosting, changing the subscriber and then removing the hosting I was able to move the subscriptions.
For now this is ok, if I encounter it again I will contact the support team.