Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Nathan Explosion Posted September 4, 2023 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()"
Stuart Silvester Posted September 4, 2023 Posted September 4, 2023 Thanks Nathan. We'll make sure this gets fixed. Nathan Explosion and Marc 2
Recommended Posts