4.7.13 Beta 2 - 'cleanup' task locking up->getTimestamp()

[Nathan Explosion]

Just popped up on my local dev install...

DELETE FROM `core_contact_verify` WHERE verify_time<IPS\DateTime::__set_state(array(
   'date' => '2023-08-05 12:02:03.826529',
   'timezone_type' => 3,
   'timezone' => 'UTC',
))
IPS\Db\Exception: Truncated incorrect INTEGER value: '8/5/2023 12:02' (1292)
#0 C:\wamp64\www\dev\ips_47_dev_c\system\Db\Db.php(1297): IPS\_Db->preparedQuery('/*ips_47_dev_c:...', Array)
#1 C:\wamp64\www\dev\ips_47_dev_c\applications\core\tasks\cleanup.php(336): IPS\_Db->delete('core_contact_ve...', Array)
#2 C:\wamp64\www\dev\ips_47_dev_c\system\Task\Task.php(274): IPS\core\tasks\_cleanup->execute()
#3 C:\wamp64\www\dev\ips_47_dev_c\applications\core\modules\admin\settings\advanced.php(751): IPS\_Task->run()
#4 C:\wamp64\www\dev\ips_47_dev_c\system\Dispatcher\Controller.php(107): IPS\core\modules\admin\settings\_advanced->runTask()
#5 C:\wamp64\www\dev\ips_47_dev_c\applications\core\modules\admin\settings\advanced.php(38): IPS\Dispatcher\_Controller->execute()
#6 C:\wamp64\www\dev\ips_47_dev_c\system\Dispatcher\Dispatcher.php(153): IPS\core\modules\admin\settings\_advanced->execute()
#7 C:\wamp64\www\dev\ips_47_dev_c\admin\index.php(13): IPS\_Dispatcher->run()
#8 {main}

The task's last action is:

/* Delete Contact Us Verifications older than a month */
\IPS\Db::i()->delete( 'core_contact_verify', array( "verify_time<?", \IPS\DateTime::create()->sub( new \DateInterval( 'P30D' ) ) ) );

Needs a "->getTimestamp()"

 

[Stuart Silvester]

Thanks Nathan.

We'll make sure this gets fixed.