Jump to content

Recommended Posts

Posted

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()"

 

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...