• Hi, Pleskians! We are running a UX testing of our upcoming product intended for server management and monitoring.
    We would like to invite you to have a call with us and have some fun checking our prototype. The agenda is pretty simple - we bring new design and some scenarios that you need to walk through and succeed. We will be watching and taking insights for further development of the design.
    If you would like to participate, please use this link to book a meeting. We will sent the link to the clickable prototype at the meeting.
  • (Plesk for Windows):
    MySQL Connector/ODBC 3.51, 5.1, and 5.3 are no longer shipped with Plesk because they have reached end of life. MariaDB Connector/ODBC 64-bit 3.2.4 is now used instead.
  • 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.

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: 10
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