• Please be aware: Kaspersky Anti-Virus has been deprecated
    With the upgrade to Plesk Obsidian 18.0.64, "Kaspersky Anti-Virus for Servers" will be automatically removed from the servers it is installed on. We recommend that you migrate to Sophos Anti-Virus for Servers.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

Resolved Cannot create hosting, php_handler error..

tkalfaoglu

tkalfaoglu

Silver Pleskian
I created a new subscription and it defaulted to NO WEBSITE for some reason.
I clicked to change that, selected Website, filled out the form and was greeted with:

Error: DB query failed: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'php_handler_id' cannot be null, query was: replace hosting set `dom_id`='678', `sys_user_id`='612', `ssl`='false', `sslRedirect`='false', `ssi`='false', `php`='false', `php_handler_id`=NULL, `cgi`='false', `perl`='false', `python`='false', `fastcgi`='false', `asp`='false', `asp_dot_net`='false', `webstat`='none', `same_ssl`='true', `traffic_bandwidth`='-1', `max_connection`='-1', `www_root`='/var/www/vhosts/halukakgun.com/httpdocs', `certificate_id`='0'

Tried it twice using different ways (adding domain instead of subscription), and same problem..
Help, as usual it's urgent for the customer to create this hosting :(

-turgut
 
More Joy: When I go into Tools and Setttings -> PHP Settings, the list of handlers all show "this handler is corrupted" :


PHP Settings
Select the PHP handlers you want to make available. You can install additional handlers using the Plesk Installer.

7 items totalEntries per page: 10 25 100 All

Handler Domains
warning.png
5.3.29 FastCGI application 105
warning.png
5.4.45 by OS vendor FastCGI application 59
warning.png
5.4.45 by OS vendor FPM application 2
warning.png
5.4.45 by OS vendor mod_php 279
warning.png
5.5.38 FastCGI application 1
warning.png
5.6.34 FastCGI application 3
warning.png
7.1.15 FastCGI application 1
7 items totalEntries per page: 10 25 100 All
 
Many thanks Igor, I had no idea there was a such command :)


Checking the Plesk database using the native database server tools .. [OK]

Checking the structure of the Plesk database

Extra table: helix ................................................ [WARNING]
Delete table 'helix'? [Y/n] y
Creating a database dump ........................................ [OK]
A dump of the database was created before an attempt to repair the database: /home/backup/dumps/mysql.preresolve.20180316-113355.dump.gz
Deleting table 'helix' .......................................... [FIXED]

Extra table: helix_asuser ......................................... [WARNING]
Delete table 'helix_asuser'? [Y/n] y
Deleting table 'helix_asuser' ................................... [FIXED]

Extra table: WordpressInstanceProperties .......................... [WARNING]
Delete table 'WordpressInstanceProperties'? [Y/n] y
Deleting table 'WordpressInstanceProperties' .................... [FIXED]

Extra table: WordpressInstances ................................... [WARNING]
Delete table 'WordpressInstances'? [Y/n] y
Deleting table 'WordpressInstances' ............................. [FIXED]

Extra table: WordpressInstancesDomains ............................ [WARNING]
Delete table 'WordpressInstancesDomains'? [Y/n] y
Deleting table 'WordpressInstancesDomains' ...................... [FIXED]

Checking the consistency of the Plesk database

Inconsistency in the table 'DomainServices' for the column dom_id:
No rows in the table 'domains' with = 84 ......................... [WARNING]
To see more details, run the command in the verbose mode: plesk repair db -verbose
Remove unnecessary rows from the table 'DomainServices'? [Y/n] y
Removing unnecessary rows ....................................... [FIXED]

Inconsistency in the table 'DomainServices' for the column dom_id:
No rows in the table 'domains' with = 278 ........................ [WARNING]
To see more details, run the command in the verbose mode: plesk repair db -verbose
Remove unnecessary rows from the table 'DomainServices'? [Y/n] y
Removing unnecessary rows ....................................... [FIXED]

Inconsistency in the table 'DomainServices' for the column dom_id:
No rows in the table 'domains' with = 519 ........................ [WARNING]
To see more details, run the command in the verbose mode: plesk repair db -verbose
Remove unnecessary rows from the table 'DomainServices'? [Y/n] y
Removing unnecessary rows ....................................... [FIXED]

Inconsistency in the table 'hosting' for the column dom_id: No rows
in the table 'domains' with = 278 ................................ [WARNING]
To see more details, run the command in the verbose mode: plesk repair db -verbose
Remove unnecessary rows from the table 'hosting'? [Y/n] y
Removing unnecessary rows ....................................... [FIXED]

Inconsistency in the table 'hosting' for the column dom_id: No rows
in the table 'domains' with = 519 ................................ [WARNING]
To see more details, run the command in the verbose mode: plesk repair db -verbose
Remove unnecessary rows from the table 'hosting'? [Y/n] y
Removing unnecessary rows ....................................... [FIXED]

Inconsistency in the table 'smb_users' for the column
subscriptionDomainId: No rows in the table 'domains' with = -1 (31
broken references) ................................................ [WARNING]
To see more details, run the command in the verbose mode: plesk repair db -verbose
Fix broken references in the table 'smb_users'? [Y/n] y
Fixing broken references ........................................ [FIXED]

Inconsistency in the table 'smb_users' for the column
subscriptionDomainId: No rows in the table 'domains' with = 48 ... [WARNING]
To see more details, run the command in the verbose mode: plesk repair db -verbose
Fix broken references in the table 'smb_users'? [Y/n] y
Fixing broken references ........................................ [FIXED]

Inconsistency in the table 'smb_users' for the column
subscriptionDomainId: No rows in the table 'domains' with = 58 (2
broken references) ................................................ [WARNING]
To see more details, run the command in the verbose mode: plesk repair db -verbose
Fix broken references in the table 'smb_users'? [Y/n] y
Fixing broken references ........................................ [FIXED]

Inconsistency in the table 'smb_users' for the column
subscriptionDomainId: No rows in the table 'domains' with = 94 (3
broken references) ................................................ [WARNING]
To see more details, run the command in the verbose mode: plesk repair db -verbose
Fix broken references in the table 'smb_users'? [Y/n] y
Fixing broken references ........................................ [FIXED]

Inconsistency in the table 'smb_users' for the column
subscriptionDomainId: No rows in the table 'domains' with = 371 (4
broken references) ................................................ [WARNING]
To see more details, run the command in the verbose mode: plesk repair db -verbose
Fix broken references in the table 'smb_users'? [Y/n] y
Fixing broken references ........................................ [FIXED]

Inconsistency in the table 'smb_users' for the column
subscriptionDomainId: No rows in the table 'domains' with = 479 .. [WARNING]
To see more details, run the command in the verbose mode: plesk repair db -verbose
Fix broken references in the table 'smb_users'? [Y/n] y
Fixing broken references ........................................ [FIXED]

Error messages: 0; Warnings: 16; Errors resolved: 16

BRB, I'll try to re-create that web site..
 
No luck. I just deleted the subscription, the domain and started over. I created a subscription, it created with no web hosting.
I changed it to hosting, and I got the same error..

Error: DB query failed: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'php_handler_id' cannot be null, query was: replace hosting set `dom_id`='680', `sys_user_id`='595', `ssl`='false', `sslRedirect`='false', `ssi`='false', `php`='false', `php_handler_id`=NULL, `cgi`='false', `perl`='false', `python`='false', `fastcgi`='false', `asp`='false', `asp_dot_net`='false', `webstat`='none', `same_ssl`='true', `traffic_bandwidth`='-1', `max_connection`='-1', `www_root`='/var/www/vhosts/halukakgun.com/httpdocs', `certificate_id`='0'
 
here is what mysql shows:

mysql> select id,name,displayName from domains where name like '%haluk%'\G;
*************************** 1. row ***************************
id: 680
name: halukakgun.com
displayName: halukakgun.com
1 row in set (0.00 sec)

ERROR:
No query specified

mysql> select type,host from dns_recs where host like "%haluk%";
+-------+-------------------------+
| type | host |
+-------+-------------------------+
| CNAME | www.halukakgun.com. |
| CNAME | lists.halukakgun.com. |
| A | halukakgun.com. |
| A | pop3.halukakgun.com. |
| TXT | _dmarc.halukakgun.com. |
| A | imap.halukakgun.com. |
| A | mail.halukakgun.com. |
| NS | halukakgun.com. |
| A | ipv4.halukakgun.com. |
| A | webmail.halukakgun.com. |
| MX | halukakgun.com. |
| CNAME | ftp.halukakgun.com. |
| A | ns.halukakgun.com. |
| TXT | halukakgun.com. |
| NS | halukakgun.com. |
| A | pop.halukakgun.com. |
| A | smtp.halukakgun.com. |
+-------+-------------------------+
17 rows in set (0.00 sec)

mysql>
 
GOT IT..
php_handlers_control --reread did the trick. (found it via google)

[root@pluto bin]# /usr/local/psa/bin/php_handler --list
id: display name: full version: version: type: cgi-bin: php-cli: php.ini: custom: status:
fastcgi 5.4.45 by OS vendor 5.4.45 5.4 fastcgi /usr/bin/php-cgi /usr/bin/php /etc/php.ini false broken
fpm 5.4.45 by OS vendor 5.4.45 5.4 fpm /usr/sbin/php-fpm /usr/bin/php /etc/php.ini false broken
module 5.4.45 by OS vendor 5.4.45 5.4 module /usr/bin/php-cgi /usr/bin/php /etc/php.ini false broken
plesk-php53-fastcgi 5.3.29 5.3.29 5.3 fastcgi /opt/plesk/php/5.3/bin/php-cgi /opt/plesk/php/5.3/bin/php /opt/plesk/php/5.3/etc/php.ini true broken
plesk-php55-fastcgi 5.5.38 5.5.38 5.5 fastcgi /opt/plesk/php/5.5/bin/php-cgi /opt/plesk/php/5.5/bin/php /opt/plesk/php/5.5/etc/php.ini true broken
plesk-php56-fastcgi 5.6.34 5.6.34 5.6 fastcgi /opt/plesk/php/5.6/bin/php-cgi /opt/plesk/php/5.6/bin/php /opt/plesk/php/5.6/etc/php.ini true broken
plesk-php71-fastcgi 7.1.15 7.1.15 7.1 fastcgi /opt/plesk/php/7.1/bin/php-cgi /opt/plesk/php/7.1/bin/php /opt/plesk/php/7.1/etc/php.ini true broken

[root@pluto bin]# /usr/local/psa/admin/bin/php_handlers_control --reread

[root@pluto bin]# /usr/local/psa/bin/php_handler --list
id: display name: full version: version: type: cgi-bin: php-cli: php.ini: custom: status:
plesk-php56-fpm 5.6.34 5.6.34 5.6 fpm /opt/plesk/php/5.6/sbin/php-fpm /opt/plesk/php/5.6/bin/php /opt/plesk/php/5.6/etc/php.ini true enabled
plesk-php55-fpm 5.5.38 5.5.38 5.5 fpm /opt/plesk/php/5.5/sbin/php-fpm /opt/plesk/php/5.5/bin/php /opt/plesk/php/5.5/etc/php.ini true enabled
plesk-php54-fastcgi 5.4.45 5.4.45 5.4 fastcgi /opt/plesk/php/5.4/bin/php-cgi /opt/plesk/php/5.4/bin/php /opt/plesk/php/5.4/etc/php.ini true enabled
plesk-php70-cgi 7.0.28 7.0.28 7.0 cgi /opt/plesk/php/7.0/bin/php-cgi /opt/plesk/php/7.0/bin/php /opt/plesk/php/7.0/etc/php.ini true disabled
cgi 5.4.45 by OS vendor 5.4.45 5.4 cgi /usr/bin/php-cgi /usr/bin/php /etc/php.ini false disabled
plesk-php71-fpm 7.1.15 7.1.15 7.1 fpm /opt/plesk/php/7.1/sbin/php-fpm /opt/plesk/php/7.1/bin/php /opt/plesk/php/7.1/etc/php.ini true enabled
plesk-php70-fpm 7.0.28 7.0.28 7.0 fpm /opt/plesk/php/7.0/sbin/php-fpm /opt/plesk/php/7.0/bin/php /opt/plesk/php/7.0/etc/php.ini true enabled
plesk-php56-fastcgi 5.6.34 5.6.34 5.6 fastcgi /opt/plesk/php/5.6/bin/php-cgi /opt/plesk/php/5.6/bin/php /opt/plesk/php/5.6/etc/php.ini true enabled
fpm 5.4.45 by OS vendor 5.4.45 5.4 fpm /usr/sbin/php-fpm /usr/bin/php /etc/php.ini false enabled
plesk-php52-cgi 5.2.17 5.2.17 5 cgi /opt/plesk/php/5.2/bin/php-cgi /opt/plesk/php/5.2/bin/php /opt/plesk/php/5.2/etc/php.ini true disabled
plesk-php71-fastcgi 7.1.15 7.1.15 7.1 fastcgi /opt/plesk/php/7.1/bin/php-cgi /opt/plesk/php/7.1/bin/php /opt/plesk/php/7.1/etc/php.ini true enabled
plesk-php53-cgi 5.3.29 5.3.29 5.3 cgi /opt/plesk/php/5.3/bin/php-cgi /opt/plesk/php/5.3/bin/php /opt/plesk/php/5.3/etc/php.ini true disabled
plesk-php53-fastcgi 5.3.29 5.3.29 5.3 fastcgi /opt/plesk/php/5.3/bin/php-cgi /opt/plesk/php/5.3/bin/php /opt/plesk/php/5.3/etc/php.ini true enabled
fastcgi 5.4.45 by OS vendor 5.4.45 5.4 fastcgi /usr/bin/php-cgi /usr/bin/php /etc/php.ini false enabled
plesk-php55-cgi 5.5.38 5.5.38 5.5 cgi /opt/plesk/php/5.5/bin/php-cgi /opt/plesk/php/5.5/bin/php /opt/plesk/php/5.5/etc/php.ini true disabled
plesk-php55-fastcgi 5.5.38 5.5.38 5.5 fastcgi /opt/plesk/php/5.5/bin/php-cgi /opt/plesk/php/5.5/bin/php /opt/plesk/php/5.5/etc/php.ini true enabled
plesk-php71-cgi 7.1.15 7.1.15 7.1 cgi /opt/plesk/php/7.1/bin/php-cgi /opt/plesk/php/7.1/bin/php /opt/plesk/php/7.1/etc/php.ini true disabled
plesk-php70-fastcgi 7.0.28 7.0.28 7.0 fastcgi /opt/plesk/php/7.0/bin/php-cgi /opt/plesk/php/7.0/bin/php /opt/plesk/php/7.0/etc/php.ini true enabled
plesk-php54-cgi 5.4.45 5.4.45 5.4 cgi /opt/plesk/php/5.4/bin/php-cgi /opt/plesk/php/5.4/bin/php /opt/plesk/php/5.4/etc/php.ini true disabled
module 5.4.45 by OS vendor 5.4.45 5.4 module /usr/bin/php-cgi /usr/bin/php /etc/php.ini false enabled
plesk-php54-fpm 5.4.45 5.4.45 5.4 fpm /opt/plesk/php/5.4/sbin/php-fpm /opt/plesk/php/5.4/bin/php /opt/plesk/php/5.4/etc/php.ini true enabled
plesk-php52-fastcgi 5.2.17 5.2.17 5 fastcgi /opt/plesk/php/5.2/bin/php-cgi /opt/plesk/php/5.2/bin/php /opt/plesk/php/5.2/etc/php.ini true enabled
plesk-php56-cgi 5.6.34 5.6.34 5.6 cgi /opt/plesk/php/5.6/bin/php-cgi /opt/plesk/php/5.6/bin/php /opt/plesk/php/5.6/etc/php.ini true disabled
[root@pluto bin]#
 
You must log in or register to reply here.

Similar threads

T
Resolved plesk 12.5 to Onyx upgrade failure
Replies
4
Views
3K
UFHH01
U
A
Can't Sync Subscription
Replies
0
Views
2K
AnyiZ
A
Back
Top