22 Apr Edited #1

Cleanup task giving error

Ultimate subscriber
Error

<error>
    <dateline>1587516336</dateline>
    <script></script>
    <line>0</line>
    <type>20</type>
    <friendly_type>MyBB SQL Error</friendly_type>
    <message>SQL Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
Query:
            UPDATE bankpipe_payments
            SET `sentnotification`='2' WHERE pid =
        </message>
    <back_trace>  errorHandler->log_error(20, SQL Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
Query:
            UPDATE bankpipe_payments
            SET `sentnotification`='2' WHERE pid =
        , , 0) called at [/home1/iwebsxk5/inc/class_error.php:189]
#1  errorHandler->error(20, Array ([error_no] => 1064,[error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2,[query] =>
            UPDATE bankpipe_payments
            SET `sentnotification`='2' WHERE pid =
        )) called at [/home1/iwebsxk5/inc/db_mysqli.php:597]
#2  DB_MySQLi->error(
            UPDATE bankpipe_payments
            SET `sentnotification`='2' WHERE pid =
        ) called at [/home1/iwebsxk5/inc/db_mysqli.php:337]
#3  DB_MySQLi->query(
            UPDATE bankpipe_payments
            SET `sentnotification`='2' WHERE pid =
        , 0, 1) called at [/home1/iwebsxk5/inc/db_mysqli.php:370]
#4  DB_MySQLi->write_query(
            UPDATE bankpipe_payments
            SET `sentnotification`='2' WHERE pid =
        ) called at [/home1/iwebsxk5/inc/db_mysqli.php:944]
Flyover 2.3  DB_MySQLi->update_query(bankpipe_payments, Array ([sentnotification] => 2), pid = ) called at [/home1/iwebsxk5/inc/tasks/bankpipe.php:277]
Drafts AutoSave 1.1  task_bankpipe(Array ([tid] => 30,[title] => BankPipe cleanup,[description] => Wipes expired items or those pending for too long, sends expiry notifications.,[file] => bankpipe,[minute] => 0,[hour] => 0,[day] => *,[month] => *,[weekday] => *,[nextrun] => 1587513600,[lastrun] => 1587256575,[enabled] => 1,[logging] => 1,[locked] => 1587427314)) called at [/home1/iwebsxk5/inc/functions_task.php:90]
ACP warning  run_task() called at [/home1/iwebsxk5/inc/functions.php:236]
Issues setting up Flyover  run_shutdown()
</back_trace>
</error>
Shade 22 Apr
#2
Thanks, will look into it. This is an issue with the clean-up task.