FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Today's Messages (off)  | Unread Messages (on) | Subscribed Forums (off) | Subscribed Topics (off) | Unanswered Messages (off)

Forum: FUDforum Installation Issues
 Topic: Installing with MySQL 8 fails - No MyISAM engine
Installing with MySQL 8 fails - No MyISAM engine [message #187925] Tue, 07 July 2020 10:49
interestinglyaverage@gmai is currently offline  interestinglyaverage@gmai   United States
Messages: 2
Registered: July 2020
Karma:
Junior Member
add to buddy list
ignore all messages by this user
Hi everyone, new to FUDforum after a client introduced it to me. I have tried to install it on Digital Ocean using MySQL 8 managed database, and the installation fails with various errors about not being able to drop tables. After investigating the installation script, the issue is in the table creations, where the installer forces the table to be MyISAM regardless of the default. Commenting this line out of the installer fixed the issue for me.

Is the use of MyISAM required for FUDforum to function correctly, or will the forum perform properly using InnoDB? This is the new default engine for MySQL, and would likely perform better for a high traffic forum as it is designed for more read/write as opposed to MyISAM which I understood to be more high read low write?
Re: Installing with MySQL 8 fails - No MyISAM engine [message #187926 is a reply to message #187925] Tue, 07 July 2020 11:42
naudefj is currently offline  naudefj   
Messages: 3732
Registered: December 2004
Karma:
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
MyISAM is not required Smile

I assume this is a relic of the past that needs to be expelled from the code.
Re: Installing with MySQL 8 fails - No MyISAM engine [message #187927 is a reply to message #187926] Tue, 07 July 2020 12:58
interestinglyaverage@gmai is currently offline  interestinglyaverage@gmai   United States
Messages: 2
Registered: July 2020
Karma:
Junior Member
add to buddy list
ignore all messages by this user
Awesome. I did get the forum up and running by commenting out line 452 in FUDforum/include/dbadmin.inc.

By the way, I am fairly new to FUDforum, but I have been working on rewriting part of it for a client project (enabling composer support, PSR-4 namespaces, moving the database operations to objects, creating a TWIG based template system, separating out the views from the code, reducing code duplication are all done or in progress, next will be trying to move away from globals and fix some SQL injection issues I've noticed). I don't know how open you might be to code from the community, but if you were interested, I'd be willing to share what I have as I complete it. Please let me know.
Re: Installing with MySQL 8 fails - No MyISAM engine [message #187928 is a reply to message #187927] Tue, 07 July 2020 14:53
naudefj is currently offline  naudefj   
Messages: 3732
Registered: December 2004
Karma:
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
Very open! If you can produce better code or improved functionality, while maintaining a clear upgrade path for exiting forum owners, you will be a hero around here.
[more unread messages]



Current Time: Wed Jul 15 00:11:17 EDT 2020

Total time taken to generate the page: 0.02068 seconds