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

Problem with Flyover

6 May 2018
#1
This issue is marked as solved
Hello there, I'm new here

I'm having some problems with Flyover so first of all when I installed it I had the problems with the database, saying that X table creation can't have default values bla bla bla bla for example, text columns can't have not null + default values, so what I did is that I manually created the tables and then let the process continue by itself. Anyways, about the problems, the first problem that I have is with Facebook which doesn't let me log in because it says that I didn't set up the domain correctly (in the application) but I did, so I figured that I probably happen because facebook require strict uri, but I'm not sure. About Steam it redirects me to a blank page and nothing happens.
Shade 6 May 2018
#2
Hi, did you try downloading the new 1.4 version? It fixes the default values bug. To upgrade in your particular case, since you did everything manually, uninstall the plugin first, replace the old files with the new ones, and install.

If the above solution does not work, I'd ask you a temporary admin account and FTP credentials to your board (by PM). I will debug the issue and fix it as soon as possible.
Quinn Humphreys 6 May 2018
#3
I will try that now, thank you very much. BTW to uninstall just uninstall it from the admin panel and delete the database table, right?
Shade 6 May 2018 Edited
#4
Just click "Uninstall". It will delete all Flyover-associated database tables. The issue was located into the install routines, so you won't need to delete tables manually.
Quinn Humphreys 6 May 2018
#5
Keeps getting an error. Should I do it manually again?

Keeps getting an error. Should I just do it manually again????











MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1101 - BLOB, TEXT, GEOMETRY or JSON column 'provider' can't have a default value
Query:
CREATE TABLE mybb_flyover_settings ( sid INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, enabled TINYINT(1) NOT NULL, provider TEXT NOT NULL DEFAULT '', id VARCHAR(255) NOT NULL, secret VARCHAR(255) NOT NULL, key_token VARCHAR(255) NOT NULL, usergroup TINYINT(5), settings TEXT NOT NULL DEFAULT '' ) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
Shade 6 May 2018
#6
Weird. I’ll debug this when I’ll get home, or tomorrow.
Quinn Humphreys 6 May 2018
#7
K so should I just do it manually for now?
Shade 6 May 2018
#8
I can confirm there’s an issue with strict environments not wanting TEXT fields to hold a default value. A fix is coming, I just need to get home.
Quinn Humphreys 6 May 2018
#9
K I will just wait then
Shade 7 May 2018 Edited
#10
I have pushed the fix in the release thread (Flyover 2.4). I have not updated the version number since you were the only one who downloaded the bugged version. Uninstall your version first, then overwrite the old files and install again. Please let me know if there are other issues; if Steam keeps on hanging up, please provide me a temporary FTP and admin account so I can debug directly on your site.