• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Unable to find row with id in ScheduledTasks table

oim37

New Pleskian
Hello.

Plesk 12.5.30 #24

User can't add task
panel.log
[2016-03-10 16:41:10] ERR [1] Unable to find row with id in ScheduledTasks table.
[2016-03-10 16:41:13] ERR [panel] Db_Table_Exception: Unable to find row with id in ScheduledTasks table.
[2016-03-10 16:56:42] ERR [1] Unable to find row with id in ScheduledTasks table.
[2016-03-10 16:56:44] ERR [panel] Db_Table_Exception: Unable to find row with id in ScheduledTasks table.

Crontab -l work
after run
plesk repair installation
plesk repair db
same error

How to fix?
Thank's
 

Attachments

  • cron.png
    cron.png
    12 KB · Views: 8
Looks like database inconsistency. Fix it with

# plesk repair db
 
plesk repair db

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

Checking the structure of the Plesk database ........................ [OK]

Checking the consistency of the Plesk database ...................... [OK]

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

same error, may be need restart some daemon
help please
 
Make sure that your ScheduledTasks table has the same structure. Correct it if necessary.

mysql> show create table ScheduledTasks\G
*************************** 1. row ***************************
Table: ScheduledTasks
Create Table: CREATE TABLE `ScheduledTasks` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`hash` varchar(255) NOT NULL,
`serviceNodeId` int(10) unsigned NOT NULL,
`sysUserId` int(10) unsigned DEFAULT NULL,
`sysUserLogin` varchar(255) DEFAULT NULL,
`isActive` int(1) NOT NULL DEFAULT '0',
`type` enum('exec','http','php') NOT NULL DEFAULT 'exec',
`phpHandlerId` varchar(255) DEFAULT NULL,
`command` text NOT NULL,
`arguments` text,
`description` text,
`notify` enum('ignore','errors','always') NOT NULL DEFAULT 'ignore',
`emailType` enum('default','owner','custom') NOT NULL DEFAULT 'owner',
`email` text,
`minute` varchar(255) NOT NULL,
`hour` varchar(255) NOT NULL,
`dayOfMonth` varchar(255) NOT NULL,
`month` varchar(255) NOT NULL,
`dayOfWeek` varchar(255) NOT NULL,
`period` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `sysUserId` (`sysUserId`),
KEY `serviceNodeId` (`serviceNodeId`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
 
Look same
mysql> show create table ScheduledTasks\G
*************************** 1. row ***************************
Table: ScheduledTasks
Create Table: CREATE TABLE `ScheduledTasks` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`hash` varchar(255) NOT NULL,
`serviceNodeId` int(10) unsigned NOT NULL,
`sysUserId` int(10) unsigned DEFAULT NULL,
`sysUserLogin` varchar(255) DEFAULT NULL,
`isActive` int(1) NOT NULL DEFAULT '0',
`type` enum('exec','http','php') NOT NULL DEFAULT 'exec',
`phpHandlerId` varchar(255) DEFAULT NULL,
`command` text NOT NULL,
`arguments` text,
`description` text,
`notify` enum('ignore','errors','always') NOT NULL DEFAULT 'ignore',
`emailType` enum('default','owner','custom') NOT NULL DEFAULT 'owner',
`email` text,
`minute` varchar(255) NOT NULL,
`hour` varchar(255) NOT NULL,
`dayOfMonth` varchar(255) NOT NULL,
`month` varchar(255) NOT NULL,
`dayOfWeek` varchar(255) NOT NULL,
`period` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `serviceNodeId` (`serviceNodeId`),
KEY `sysUserId` (`sysUserId`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

mysql>

In :8443/admin/scheduler/tasks-list all ok, not working from client
 
Back
Top