I'm self-hosting on Mac OS X and run into problems during setup. Help!
When self-hosting on Mac OS X you'll need to keep in mind that there is a default setting in the my.cnf
configuration file for MySQL, which is not present in most (all?) of the shared hosting environments for which Armadillo was designed.
This default setting in the my.cnf
config file is as follows:
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
The effect of the second setting (STRICT_TRANS_TABLES
) is such that, in case the type of a submitted value is not strictly what it is "supposed" to be, the transaction will be aborted.
That particular setting affects Armadillo, preventing the creation of options in the database during the initial online setup.
In short, you'll need to remove that setting so that the sql_mode
is as follows:
sql_mode=NO_ENGINE_SUBSTITUTION
Once you've done that, Armadillo should function correctly and successfully complete online setup.
Tags: Troubleshooting