not possible webhosting

[Steffen_Nowack]

Hi,

i have a "little" problem. I can not change the hosting type for a domain.
There is the error:
"Internal error.
ERROR: Call to a member function getRootPath() on a non-object (Abstract.php:141)"

What am I doing wrong?

regards
Steffen

 

[IgorG]

It is database inconsistency due to missing value entry in the table "ServiceInstanceProperties". If you are familiar with SQL you can restore this record by yourself or contact Support Team.

 

[Richard_Price]

Hi - I too am having this problem with a fresh install of Plesk 12 on a CentOS 6.6 web server. I can see the table called ServiceInstanceProperties is empty but what do I need to populate in this table?

ServiceInstanceId, name, value:

ServiceInstanceId = Is this auto generated?
name = is this the domain name from the 'domains' table?
value = what goes in here?

Thanks

Richard

 

[Mark12345]

I am having this same issue. I created a support ticket (quite a long process!). It would be better for everyone if a good solution could be posted in the forums. This link describes a resolution http://kb.odin.com/en/125171 but I don't know how to execute this. I understand that you to phpmyadmin and access the mysql table from there, but the commands didn't work (not even sure if I did them correctly). step by step instructions are required.

plesk version 12.0.x

 

[Mark12345]

Support was able to fix the problem. here is what they did: (note, you will need to change XXXXXXX.onlinehome-server.com to you domain and root@XXXXXX to root@your-user-name.).

"Thank you for contacting Odin Technical Support.

It was nice talking to you over the phone. I am glad to inform you that the issue has been resolved by correcting the database inconsistency in the psa database. I have added some missing table entries to resolve this case. Please check the following snippet for more details.
+++===

[root@XXXXXX ~]# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa

mysql> insert into ServiceInstanceProperties values (1, "root", "/var/www/vhosts/XXXXXXX.onlinehome-server.com");

Query OK, 1 row affected (0.06 sec)

mysql> select * from ServiceInstanceProperties;

+-------------------+------+-------------------------------------------------+

| serviceInstanceId | name | value |

+-------------------+------+-------------------------------------------------+

| 1 | root | /var/www/vhosts/XXXXXX.onlinehome-server.com |

+-------------------+------+-------------------------------------------------+

1 row in set (0.00 sec)


mysql> select * from ServiceInstances;

Empty set (0.00 sec)

mysql> insert into ServiceInstances values (1,2,1,'',1,1);

Query OK, 1 row affected (0.05 sec)


mysql> insert into ServiceInstances values (2,1,1,'',1,1);

Query OK, 1 row affected (0.07 sec)

++====
Now I am able to change the hosting type without any problems. Please verify the same from your end. If you need any further help, feel free to get back to us. I will be glad to assist you further."