Click anywhere to close this dialog

Farewell

Great is the art of beginning, but greater is the art of ending
Henry Wadsworth Longfellow

I announce that I cease all development and activity in the programming universe indefinitely. My career has reached the turning point I was not expecting for at least another year, leaving me highly off guard and without laid-out plans for this hobby's continuity. I have begun a 5-year residency program in Neurosurgery which is clearly not compatible, time-wise, with programming.

I gave in all my passion for developing, and you gave me back your loyalty and trust, even when I did not deserve that much. Now it is the time for payback. I release all my present and past work as Open Source software, in the hope some talented developer will continue maintaining and expanding my vision of a modern, sleek forum software. The intrinsic flexibility of MyBB is the true hidden gem of an otherwise outdated codebase; I do hope the project can continue and be updated complying to the latest coding standards.

I hereby thank Euan, kawaii, andrewjs18, Ben, Matt, Omar G., effone, Eric J., Devilshakerz, Wildcard, JordanMussi and all the other team members I have had the opportunity to work with when I was a MyBB team member. I thank Tomm M, my mentor, who inspired me to pick up coding with his piece-of-art plugins. And finally, I thank all of you MyBBoost subscribers who have helped me getting through my toughest university years economically.

Yours sincerely, Filippo

SQL Error after upgrading to MyBB 1.8.23

24 Jul 2020 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.4 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 2020
#2
Thanks for reporting, will have a look later.
Dr.Jeet 24 Jul 2020
#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 2020
#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 2020 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 2020
#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.