Product version: Plesk Onyx 17.0.17 Update #63
OS version: Ubuntu 12.04
Hi, I have a very old server, and since this morning I can't log in to the admin panel. When I tried to log in as admin I get this error:
What I've done so far (After each step I've tried to log in with the same result:
1. Repair plesk installation:
2. Repair plesk db:
3. Since the same error persisted and it mention wp-toolkit extension I've uninstalled it:
4. Rerun plesk repair installation:
As seen in the last step. no errors appear in the last repair installation command, yet the same error persists when I try login:
As far as I know, all the services (apache, nginx, postfix, etc) are running with no problem.
OS version: Ubuntu 12.04
Hi, I have a very old server, and since this morning I can't log in to the admin panel. When I tried to log in as admin I get this error:
Code:
ERROR: syntax error, unexpected '?' (Helper.php:569)
What I've done so far (After each step I've tried to log in with the same result:
1. Repair plesk installation:
Code:
[2024-05-13 09:22:09] ERR [extension/wp-toolkit] La ejecución de /opt/psa/admin/plib/modules/wp-toolkit/scripts/migration-run.php ha resultado fallida y se ha obtenido el código de salida 1 y la siguiente salida:
[2024-05-13 09:22:09] ERR [extension/wp-toolkit] SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: Instances.domainId, query was: INSERT INTO "Instances" ("domainId", "path", "isIgnored", "apsInstanceId") VALUES (?, ?, ?, ?)
[2024-05-13 09:22:09] ERR [panel] La ejecución de /opt/psa/admin/plib/modules/wp-toolkit/scripts/migration-run.php ha resultado fallida y se ha obtenido el código de salida 1 y la siguiente salida:
[2024-05-13 09:22:09] ERR [extension/wp-toolkit] SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: Instances.domainId, query was: INSERT INTO "Instances" ("domainId", "path", "isIgnored", "apsInstanceId") VALUES (?, ?, ?, ?):
0: /opt/psa/admin/plib/Extension/Package.php:606
Plesk\Extension\Package->_scriptExecute(string 'wp-toolkit', string '/opt/psa/admin/plib/modules/wp-toolkit/scripts/migration-run.php', array)
1: /opt/psa/admin/plib/Extension/Package.php:729
Plesk\Extension\Package->exec(string 'wp-toolkit', string 'migration-run.php', array)
2: /opt/psa/admin/plib/Upgrade/Task/17.0.15/2016-07-20-04-59-45_MigrateWordPress.php:25
Plesk\Upgrade\Task\MigrateWordPress->upgrade(object of type Plesk\Upgrade\Deferred)
3: /opt/psa/admin/plib/Upgrade/Executor/Sync.php:15
Plesk\Upgrade\Executor_Sync->upgrade(string '2016-07-20-04-59-45', object of type Plesk\Upgrade\TaskLoader, object of type Plesk\Upgrade\Deferred)
4: /opt/psa/admin/plib/Upgrade/Command/Task.php:46
Plesk\Upgrade\Command_Task->run(string '2016-07-20-04-59-45', string 'upgrade')
5: /opt/psa/admin/plib/Upgrade/upgrade.php:19
taskId=2016-07-20-04-59-45 step=upgrade result=1 message=ERROR: PleskUserException: La ejecución de /opt/psa/admin/plib/modules/wp-toolkit/scripts/migration-run.php ha resultado fallida y se ha obtenido el código de salida 1 y la siguiente salida:
[2024-05-13 09:22:09] ERR [extension/wp-toolkit] SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: Instances.domainId, query was: INSERT INTO "Instances" ("domainId", "path", "isIgnored", "apsInstanceId") VALUES (?, ?, ?, ?) (Package.php:606)
Some steps of upgrade failed. Run upgrade with option --repair to rerun failed steps.
Some steps of upgrade failed. Run upgrade with option --repair to rerun failed steps.
2. Repair plesk db:
Code:
Checking the Plesk database using the native database server tools .. [OK]
Checking the structure of the Plesk database
Extra table: WordpressInstanceProperties .......................... [WARNING]
Delete table 'WordpressInstanceProperties'? [Y/n] y
Creating a database dump ........................................ [OK]
A dump of the database was created before an attempt to repair the database: /var/lib/psa/dumps/mysql.preresolve.20240513-093837.dump.gz
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 = 105 ........................ [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
Creating a database dump ........................................ [OK]
A dump of the database was created before an attempt to repair the database: /var/lib/psa/dumps/mysql.preresolve.20240513-093756.dump.gz
Removing unnecessary rows ....................................... [FIXED]
Inconsistency in the table 'DomainServices' for the column dom_id:
No rows in the table 'domains' with = 129 ........................ [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]
Checking the consistency of the Plesk database ...................... [OK]
Error messages: 0; Warnings: 5; Errors resolved: 5
3. Since the same error persisted and it mention wp-toolkit extension I've uninstalled it:
Code:
plesk bin extension --uninstall wp-toolkit
4. Rerun plesk repair installation:
Code:
Reconfiguring the Plesk installation
Started bootstrapper repair procedure. This may take a while.
Certain actions may be skipped if not applicable.
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
Finishing up upgrade procedures and rerunning previously failed upgrade actions...
===> Cumulative APS controller database (apsc) upgrade and repair has been started.
===> Cumulative upgrade and repair of APS controller database has been completed.
===> Cumulative APS controller upgrade and repair (final stage) has been started.
===> Cumulative upgrade and repair of APS controller (final stage) has been completed.
===> Cumulative Plesk database upgrade and repair (revertable stage) has been started.
===> Preparing Plesk database upgrade (revertable stage).
===> Cumulative upgrade and repair of Plesk database (revertable stage) has been completed.
===> Plesk database scheme upgrade has been started.
Applying migrations from: /opt/psa/bootstrapper/pp17.0.17-bootstrapper/migrations/
===> Plesk database scheme upgrade has been completed.
===> Cumulative Plesk upgrade and repair (final stage) has been started.
===> Preparing Plesk upgrade (final stage).
===> Cumulative upgrade and repair of Plesk (final stage) has been completed.
System start/stop links for /etc/init.d/bind9 already exist.
Reconfiguring mail subsystem...
Reconfiguring Apache web server...
Reconfiguring ProFTPD FTP server...
===> Configuring ProFTPD server
Reconfiguring AWStats web statistics...
Reconfiguring WatchDog...
Restoring SELinux contexts...
System start/stop links for /etc/init.d/sw-cp-server already exist.
System start/stop links for /etc/init.d/sw-engine already exist.
System start/stop links for /etc/init.d/dovecot already exist.
System start/stop links for /etc/init.d/drwebd already exist.
System start/stop links for /etc/init.d/spamassassin already exist.
System start/stop links for /etc/init.d/pc-remote already exist.
System start/stop links for /etc/init.d/nginx already exist.
System start/stop links for /etc/init.d/psa already exist.
Reconfiguring SSL ciphers and protocols...
Regenerating web servers' configuration files...
Cleaning active Panel sessions...
Bootstrapper repair finished.
If problems persist, please check installer logs ('/var/log/plesk/install/plesk_17.0.17_repair.log' and '/var/log/plesk/install/plesk_17.0.17_repair_problems.log') for errors.
If you can't resolve the issue on your own, please address Parallels support.
As seen in the last step. no errors appear in the last repair installation command, yet the same error persists when I try login:
Code:
ERROR: syntax error, unexpected '?' (Helper.php:569)
As far as I know, all the services (apache, nginx, postfix, etc) are running with no problem.