How do I fix the "field doesn't have a default value" MySQL error?

If you are self-hosting Fresh Store Builder then you might see an error like this:

Field 'gaunique' doesn't have a default value(No Description) sql: INSERT INTO ga_users (ips) SELECT 'a:1:{i:0;s:14:\"\";}'

This is caused by MySQL having a strict mode set which won't allow INSERT or UPDATE commands with empty fields where the schema doesn't have a default value set.    
The solution is to disabled the STRICT_TRANS_TABLES MySQL setting.
If you don't know how to do this, please show this guide and this Fresh Store Builder requirements guide to your hosting or server support.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.