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.

Unable to find an answer?

Looking for anything specific article which resides in general queries? Just browse the various relevant folders and categories and then you will find the desired article.

Contact Us