Resolved Scheduler Tasks : Internal Error

[Takis]

Hi,

When i go to Scheduler Tasks

i see this error message :

* the date (2017-08-01) it is always the date that i visit the Scheduler Tasks
crontab -l :

15 1 * * * /opt/psa/libexec/modules/watchdog/cp/pack-sysstats day
10 1 * * * /opt/psa/libexec/modules/watchdog/cp/clean-sysstats
20 1 * * * /opt/psa/libexec/modules/watchdog/cp/clean-events
0 1 * * 1 /opt/psa/libexec/modules/watchdog/cp/secur-check
0 1 * * 1 /opt/psa/libexec/modules/watchdog/cp/send-report weekly
15 1 1 * * /opt/psa/libexec/modules/watchdog/cp/pack-sysstats year
15 1 * * 1 /opt/psa/libexec/modules/watchdog/cp/pack-sysstats week
0 3 * * 7 /opt/psa/libexec/modules/watchdog/cp/clean-reports
15 1 1 * * /opt/psa/libexec/modules/watchdog/cp/pack-sysstats month
0 0 * * * /opt/psa/admin/bin/php -c '/opt/psa/admin/conf/php.ini' -dauto_prepend_file=sdk.php '/opt/psa/admin/plib/modules/servershield/scripts/servershield-version-check.php'
0 0 * * 0 /opt/psa/admin/bin/php -c '/opt/psa/admin/conf/php.ini' -dauto_prepend_file=sdk.php '/opt/psa/admin/plib/modules/servershield/scripts/update-servershield.php'
0 0 * * * /opt/psa/admin/bin/php -dauto_prepend_file=sdk.php '/opt/psa/admin/plib/modules/wp-toolkit/scripts/instances-auto-update.php'
0 0,4,8,12,16,20 * * * /opt/psa/admin/bin/php -dauto_prepend_file=sdk.php '/opt/psa/admin/plib/modules/wp-toolkit/scripts/maintenance.php'

What i have try so far :

Edit with crontab -e

Remove all cron jobs and save

After i go to


Plesk Scheduler Tasks

and unfortunately the error remain the same....

Any help appreciated.

Regards

 

[IgorG]

Strange format - 2017-08-01 0.12:0:40

It seems that this issue caused due to the inconsistency with the scheduled tasks in Plesk databases. In order to fix the issue try to remove orphaned scheduled tasks entries from the Plesk database. You can find them with

# plesk db
MariaDB [psa]> select * from ScheduledTasks;

 

[Takis]

Thank you for the reply,

i manage to access them using the command : plesk db "select * from ScheduledTasks"

I thing i found the problem,

one of the records has dot . and not comma ,

The issue now is how to edit to correct it?

Best regards

 

[UFHH01]

Hi Takis,

to delete entries from a Plesk database table, you could continue with:

Login as "root" over SSH and use the commands:

plesk db
select * from ScheduledTasks;

( IDENTIFY the IDs, which you would like to delete )

delete from ScheduledTasks where id=XXX;

( where XXX should be replaced with the desired ID - number! )

exit

( ... will CLOSE your MySQL - connection )​

 

[Takis]

Hi, finally.....

the command plesk db "delete from ScheduledTasks where id=4" without ; at the end , worked fine.

I delete some records with error and now worked perfect.

Thank you again.