Comments (11)
Context- I'm attempting to build from the Digital Ocean LAMP 14.04 Droplet.
MySQL Version: 5.5.46-0ubuntu0.14.04.2
from hootdraft.
Stackoverflow seems to suggest an upgrade of MySQL or changing the engine to MyISAM:
http://stackoverflow.com/questions/20964269/1214-the-used-table-type-doesnt-support-fulltext-indexes
from hootdraft.
It looks like there's some MySQL 5.6 stuff in here. Maybe the README requirements should be updated.
from hootdraft.
I'd be willing to bet just removing the FULLTEXT
index from the Initialize script is a better way to go. It's something MyISAM provides but InnoDB does not.
I made the switch to InnoDB for version 2 for data integrity reasons, and there's still future work to do to allow Silex to leverage that capability fully.
EDIT: If you remove the FULLTEXT index from the Initialize script, and this then fixes the initialize script, feel free to open another PR with this fix (and reference this issue). Thanks!
from hootdraft.
Fair enough. I'll take another look at it to see if I can cobble together a script that works. I've been considering deployment to a couple different places in the cloud, including OpenShift, and all of those places seem to default to MySQL 5.5 as the de-facto starting environment. I'll try to remove the fulltext indexes and see if I can get everything to build. Since the the original attempt was on a DigitalOcean instance, I just nuked it from orbit when it didn't work, since those instances aren't free. I'll try this again on OpenShift and see if that makes anything easier.
from hootdraft.
I'd certainly be open to relaxing some database constraints in order to satisfy requirements for one minor version number lower of MySQL. When writing the docs I didn't think I had used anything crazy new for 5.6 (I think PHP Draft 1.3 ran fine on 5.3 and 5.4 but thats just a hunch), but 5.5 is not much older and shouldn't drastically change things much, so I'd be open to making it work for a platform like OpenShift.
from hootdraft.
Had a few minutes to look at this and there are a few other instances of breaking changes between 5.5 and 5.6 that I did not account for (other than the FULLTEXT instances). I'll take a look at it when I have more time and will try to patch this up so it can be run on an OpenShift instance - as I'd like to do the same myself.
from hootdraft.
Sweet. It's good to hear that we're have the same outlook on that.
from hootdraft.
@zo0o0ot so I just worked through the issues I had to get PHPDraft up and running on OpenShift. Since it's cloud-based, it's insanely fast (10x faster than my shared hosting, no surprise there). I'm going to eventually add another markdown file detailing instructions on how to install the app on OpenShift, because it's pretty easy. Here's what I found:
- All
FULLTEXT
indices need removed from tables using InnoDB. - The
users
table has a default value set forcreationTime
(aDATETIME
column). This was added in MySQL 5.6. I remove the default value, and explicitly set the value toUTC_TIMESTAMP()
in theLoginUserRepository
'sCreate
method. - (this one took me all night) The version of Silex I'm using with Composer is a dev version. Because of this, Composer actually pulls down the repo from Github. Not an issue when I publish releases per se, except when that code is being deployed via git as well. Git treats the Silex folder in
/vendor
as a submodule, so it won't actually publish those files. I had to monkey with OpenShift shell access in order to trace the logs and do some Googling to figure this out. So to resolve, delete the entire/vendor
folder, then tell Composer to install all dependencies with the--prefer-dist
flag as so:composer install --prefer-dist
- I also decided to bump the
appsettings
back into the root directory. This requirement was a pain in the ass, but I originally intended it to be increased security, but it wasn't worth it. I updated the.htaccess
andweb.config
to disallow access to the file. But with OpenShift, you don't get a subdirectory, so I had to do this.
The last one was a pain (thanks to http://stackoverflow.com/a/14921890/324527 for saving my sanity ), and I had to commit to delete the "submodule" first, then run the Composer install and re-commit the entire directory.
I'll be pushing these changes up as part of 2.0.1, but you're probably savvy enough to get it up and running.
from hootdraft.
I fixed Initialize.sql as well as a few minor fixes elsewhere in 2.0.1, and also added an install guide specific to OpenShift as I think this is a perfect solution for folks who want to run their own installs. Refer to OPENSHIFT_DEPLOYMENT.md for details, and let me know if you have any issues!
from hootdraft.
I think this is awesome. Technically, it could be possible to streamline the setup even more, but I'm not certain if it's worth the trouble.
I found openshift through an pretty snazzy auto-deploying Bolt CMS instance.
https://github.com/Atriedes/openshift-boltcms-quickstart
It's possible that this project may be able to borrow from that in order to streamline the process, but as long as I can get phpdraft on openshift and running, you won't be hearing any complaints from me.
I have a mandrill account set up for a different purpose, so I might end up using them for email delivery. If any directions need updating, I'll let you know. I might also use MySQL Workbench instead of phpMyAdmin. I was able to get that going through ssh by checking a couple different setup parameters in the MySQL Workbench local client, and I can share those setup instructions with an update of the Openshift deploy docs if I get things up and working. I'm probably going to give it a whirl tonight.
from hootdraft.
Related Issues (20)
- Draft Stats Not Generated
- Add Heroku installs
- Cleanup frontend build process HOT 2
- Drafting the last player in a draft with depth charts has an error and gets stuck on "working". HOT 5
- Replace Client Polling With Sockets
- Replace mcrypt with OpenSSL HOT 1
- Upgrade Library versions HOT 1
- Allow admin to invite new users
- Leagues by Commissioner broken HOT 1
- Best Player Available HOT 1
- gmail/g suite blocking signup verification? HOT 11
- Ncaa Basketball player list HOT 5
- command prompt error HOT 7
- Invalid security certificate for hootdraft.com? HOT 3
- zip and unzip unavailable HOT 1
- ../../phpdraft_settings required HOT 2
- Error when trying to access website after installation HOT 8
- Deploy error message HOT 2
- Deployment setup issue. Exit Code: 2(Misuse of shell builtins) PHPDraft 2.2.0 HOT 2
- Password not working
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from hootdraft.