Nathan Explosion Posted September 4, 2023 Share Posted September 4, 2023 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()" Link to comment Share on other sites More sharing options...
Stuart Silvester Posted September 4, 2023 Share Posted September 4, 2023 Thanks Nathan. We'll make sure this gets fixed. Nathan Explosion and Marc Stridgen 2 Link to comment Share on other sites More sharing options...
Recommended Posts