SQL Error after upgrading to MyBB 1.8.23

24 Jul Edited
#1
This issue is marked as solved
Type: 20
File: (Line no. 0)
Message
SQL Error: 1366 - Incorrect integer value: '' for column 'date' at row 1
Query:
INSERT
INTO mybb_bankpipe_log (`uid`,`date`,`invoice`,`message`,`bids`)
VALUES ('21863','','5ebccef99128e','null','')

Back Trace:  errorHandler->email_error(20, SQL Error: 1366 - Incorrect integer value: '' for column 'date' at row 1
Query:
INSERT
INTO mybb_bankpipe_log (`uid`,`date`,`invoice`,`message`,`bids`)
VALUES ('21863','','5ebccef99128e','null','')
, , 0) called at [/var/www/forum/inc/class_error.php:195]
#1 errorHandler->error(20, Array ([error_no] => 1366,[error] => Incorrect integer value: '' for column 'date' at row 1,[query] =>
INSERT
INTO mybb_bankpipe_log (`uid`,`date`,`invoice`,`message`,`bids`)
VALUES ('21863','','5ebccef99128e','null','')
)) called at [/var/www/forum/inc/db_mysqli.php:597]
#2 DB_MySQLi->error(
INSERT
INTO mybb_bankpipe_log (`uid`,`date`,`invoice`,`message`,`bids`)
VALUES ('21863','','5ebccef99128e','null','')
) called at [/var/www/forum/inc/db_mysqli.php:337]
#3 DB_MySQLi->query(
INSERT
INTO mybb_bankpipe_log (`uid`,`date`,`invoice`,`message`,`bids`)
VALUES ('21863','','5ebccef99128e','null','')
, 0, 1) called at [/var/www/forum/inc/db_mysqli.php:370]
#4 DB_MySQLi->write_query(
INSERT
INTO mybb_bankpipe_log (`uid`,`date`,`invoice`,`message`,`bids`)
VALUES ('21863','','5ebccef99128e','null','')
) called at [/var/www/forum/inc/db_mysqli.php:830]
Flyover 2.3 DB_MySQLi->insert_query(bankpipe_log, Array ([uid] => '21863',[date] => '',[invoice] => '5ebccef99128e',[message] => 'null',[bids] => '')) called at [/var/www/forum/bankpipe/Logs/Handler.php:57]
Drafts AutoSave 1.1 BankPipe\Logs\Handler->save(Array ([message] => null,[bids] => Array ([0] => ),[invoice] => 5ebccef99128e,[uid] => 21863,[date] => )) called at [/var/www/forum/bankpipe/Gateway/PayPal.php:229]
ACP warning BankPipe\Gateway\PayPal->webhookListener() called at [/var/www/forum/bankpipe.php:79]
Shade 24 Jul
#2
Thanks for reporting, will have a look later.
Dr.Jeet 24 Jul
#3
I didnt get any error on upgrading from 1.8.22 to 1.8.23. Did you disable all plugin before upgrade?
Shade 24 Jul
#4
He's known to use a peculiar SQL configuration which may have changed with the update. I will have a look anyway.
Kalju 2 Aug Edited
#5
Type: 2
File: bankpipe/Gateway/Coinbase.php (Line no. 425)
Message
hash_equals(): Expected known_string to be a string, null given
Back Trace:  errorHandler->email_error(2, hash_equals(): Expected known_string to be a string, null given, bankpipe/Gateway/Coinbase.php, 425) called at [/var/www/forum/inc/class_error.php:195]
#1 errorHandler->error(2, hash_equals(): Expected known_string to be a string, null given, bankpipe/Gateway/Coinbase.php, 425, Array ([str1] => ,[str2] => 9488866fd69a3ea35cfe488c3e0cd6b4b683af3065a2ea82289f286a45a5b632))
#2 hash_equals(, 9488866fd69a3ea35cfe488c3e0cd6b4b683af3065a2ea82289f286a45a5b632) called at [/var/www/forum/bankpipe/Gateway/Coinbase.php:425]
#3 BankPipe\Gateway\Coinbase::hashEqual(, 9488866fd69a3ea35cfe488c3e0cd6b4b683af3065a2ea82289f286a45a5b632) called at [/var/www/forum/bankpipe/Gateway/Coinbase.php:122]
#4 BankPipe\Gateway\Coinbase->webhookListener() called at [/var/www/forum/bankpipe.php:79]
Shade 2 Aug
#6
Next time please open a thread for each issue you are having.

As for the first one, either PayPal has changed something in the webhook response, or sometimes it is not reliable. I will add a fallback for that anyway.

As for the second one, which should only be an harmless warning, I will add a fix; however, it does not affect BankPipe as the call fails the hash check and it is therefore a forged or invalid request from Coinbase.