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

Prices over thousands are not allowed

7 Apr 2020 Edited
#1
This issue is marked as solved
New subscription and price entered as 1000:
inc/plugins/bankpipe.php:1507
/inc/db_mysqli.php:880 SQL Error: 1366 - Incorrect decimal value: '1,000.00' for column 'price' at row 1

@@sql_mode:
ONLY_FULL_GROUP_BY,
STRICT_TRANS_TABLES,
NO_ZERO_IN_DATE,
NO_ZERO_DATE,
ERROR_FOR_DIVISION_BY_ZERO,
NO_AUTO_CREATE_USER,
NO_ENGINE_SUBSTITUTION
Shade 7 Apr 2020
#2
Thanks for spotting this. The maximum price allowed at this time is 999. Despite I cannot reproduce the actual SQL error, the cap will be raised to infinity in the next release.
Kalju 7 Apr 2020
#3
Reproduce it by setting the sql_mode:

SET GLOBAL sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
Shade 7 Apr 2020
#4
That's a very particular setup, but this is going to be fixed anyway. PS: as stated in the setting, you DON'T want comas in the price to separate thousands.
Kalju 7 Apr 2020
#5
These commas get auto-generated.