I've recently been working on a few of our older websites with newer MySQL installations and am coming across the following error: SQLSTATEHY000: General error: 1364 Field 'deliveryaddressid' doesn't have a default value 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. $ brew update && brew install mycli # Only on macOS or $ sudo apt-get install mycli # Only on debian or ubuntu Usage $ mycli -help Usage: mycli OPTIONS DATABASE A MySQL terminal client with auto-completion and syntax highlighting.
- MySQL Community on Slack; Install Windows. Building mysqlclient on Windows is very hard. But there are some binary wheels you can install easily. MacOS (Homebrew) Install MySQL and mysqlclient: # Assume you are activating Python 3 venv $ brew install mysql $ pip install mysqlclient If you don't want to install MySQL server, you can use mysql.
- DBngin provides a free, all-in-one database management tool that includes MySQL, PostgreSQL, and Redis. After DBngin has been installed, you can connect to your database at 127.0.0.1 using the root username and an empty string for the password.
- Git LFS Skip Smudge #. GitHub rate-limits the Git LFS requests during the git clone process. If you run into rate-limiting issues, you can skip fetching the git-lfs files during the initial git clone (equivalent to git lfs smudge -skip), and download these assets during the beforeinstall phase of your build.
By Andrew McCombe
June 22, 2015
I've recently been working on a few of our older websites with newer MySQL installations and am coming across the following error:
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.
There are a couple of fixes for this.
First 'fix' is to assign a default value to your schema. This can be done with a simple ALTER command:
However, this may need doing for many tables in your database schema which will become tedious very quickly. The second fix is to assign a default sql_mode on the mysql server.
If you are using a brew installed MySQL you should edit the my.cnf file in the MySQL directory at /usr/local/Cellar/mysql/<version>/my.cnf. Comment out or change the sql_mode at the bottom:
Save the file and restart Mysql:
NOTE: make sure you run the above as your usual user and not as root/sudo. I did this and MySQL refused to restart as I had caused it to break permissions somewhere.
Alternatively you can comment out the above line and add the sql_mode line to your system MySQL config at /etc/my.cnf:
Hope this helps someone out there!
Travis CI Build Configuration and Settings #
Builds on Travis CI are configured mostly through the build configurationstored in the file .travis.yml in your repository. This allows yourconfiguration to be version controlled and flexible.
For advanced use cases the main build configuration file .travis.yml canimport other, shared config sources using the Build Config Importsfeature.
Detailed information about Travis CI’s build config format can be found in ourTravis CI Build Config Reference. Additionalinformation about Travis CI’s use of YAML as a language to describe buildconfiguration can be found here.
Other features can be controlled through the repository’s settings eitherthrough the Travis CI UI, or the Travis CI command line client.
Build Timeouts #
It is very common for test suites or build scripts to hang.Travis CI has specific time limits for each job, and will stop the build and add an error message to the build log in the following situations:
- When a job produces no log output for 10 minutes.
- When a job on a public repository takes longer than 50 minutes.
- When a job on a private repository takes longer than 120 minutes.
Some common reasons why builds might hang:
- Waiting for keyboard input or other kind of human interaction
- Concurrency issues (deadlocks, livelocks and so on)
- Installation of native extensions that take very long time to compile
There is no timeout for a build; a build will run as long as needed to complete all the jobs, but will stop immediately if any job hits a timeout limit.
Build Lifecycle #
The Build Lifecycle documentation now has its own page.
Limiting Concurrent Jobs #
The maximum number of concurrent jobs depends on the total system load, butone situation in which you might want to set a particular limit is:
- if your build depends on an external resource and might run into a racecondition with concurrent jobs.
You can set the maximum number of concurrent jobs in the settings pane foreach repository.
Or using the command line client:
Building Only the Latest Commit #
If you are only interested in building the most recent commit on each branch you can use this new feature to automatically cancel older builds in the queue that are not yet running. Existing builds will be allowed to finish.
The Auto Cancellation Setting is in the Settings tab of each repository, and you can enable it separately to:
Auto cancel branch builds - cancels queued builds in your branch and appears in the Build History tab of your repository.
Auto cancel pull request builds - cancels queued builds for pull requests (the future merge result of your change/feature branch against its target) and appears in the Pull Requests tab of your repository.
For example, in the following screenshot, we pushed commit ca31c2b to the branch MdA-fix-notice while builds #226 and #227 were queued. With the auto cancellation feature on, the builds #226 and #227 were automatically cancelled:
Git Clone Depth #
Travis CI can clone repositories to a maximum depth of 50 commits, which is only really useful if you are performing git operations.
Please note that if you use a depth of 1 and have a queue of jobs, Travis CI won’t build commits that are in the queue when you push a new commit.
You can set the clone depth in .travis.yml:
You can also remove the --depth flag entirely with:
Some operations on the repository, such as common automated code review scripts (e.g. Pronto for Ruby), may fail due to the limited git clone depth, not being able to access all the objects in the repository. Removing the depth flag, or running git fetch --unshallow might solve the issue.
Git Clone Quiet #
Travis CI clones repositories without the quiet flag (-q) by default. Enabling the quiet flag can be useful if you’re trying to avoid log file size limits or even if you just don’t need to include it.
You can enable the quiet flag in .travis.yml:
Git Submodules #
Travis CI clones Git submodules by default. To avoid this set:
Git LFS #
Authentication with GitHub #
We recommend using a read-only GitHub OAuth token to authenticate when using Git LFS:
Brew Mysql Configuration
This authentication is required when connecting to private repositories, and prevents rate-limiting when connecting to open source repositories.
Deploy keys are not currently supported by LFS, so you should use a GitHub OAuth token to authenticate as in the example above.
Authentication with Bitbucket #
We recommend using a read-only Bitbucket OAuth token to authenticate when using Git LFS:
This authentication is required when connecting to private repositories, and prevents rate-limiting when connecting to open source repositories.
Deploy keys are not currently supported by LFS, so you should use a Bitbucket OAuth token to authenticate as in the example above.
Authentication with GitLab #
We recommend using a read-only GitLab OAuth token to authenticate when using Git LFS:
This authentication is required when connecting to private repositories, and prevents rate-limiting when connecting to open source repositories.
Deploy keys are not currently supported by LFS, so you should use a GitLab OAuth token to authenticate as in the example above.
Authentication with Assembla #
We recommend using a read-only Assembla OAuth token to authenticate when using Git LFS:
This authentication is required when connecting to private repositories, and prevents rate-limiting when connecting to open source repositories.
Deploy keys are not currently supported by LFS, so you should use a Assembla OAuth token to authenticate as in the example above.
Linux #
Git LFS is supported by default on our Ubuntu Trusty, Xenial and Bionic images.
macOS #
Installing git-lfs via brew is the recommended way to get Git LFS in macOS.
Git LFS Skip Smudge #
GitHub rate-limits the Git LFS requests during the git clone process. If you run into rate-limiting issues, you can skip fetching the git-lfs files during the initial git clone (equivalent to git lfs smudge --skip), and download these assets during the before_install phase of your build. To achieve this, you can use the following configuration in .travis.yml:
Git Sparse Checkout #
Travis CI supports git’s sparse checkoutcapability.
To clone your repository sparsely, add:
where skip-worktree-map-file is a path to the existing file in the current repository with data you’d like to put into $GIT_DIR/info/sparse-checkout file of format described in Git documentation.
Git End of Line Conversion Control #
Travis CI clones repositories with platform-dependent core.autocrlf behavior.This behavior can be modified via the autocrlf attribute in .travis.yml. Valid values are true, false and input.
To clone your repository without end of line conversion, add:
This is equivalent to git config --global core.autocrlf input prior to cloning the repository.
Disabling git clone #
In some workflows, like build stages, it might be beneficial to skip the automatic git clone step.
You can do this by adding:
Note that if you use this option, the TRAVIS_COMMIT_MESSAGE environment variable will not be defined.
Setting symlinks option #
In some cases when a repository is used for both Linux and Windows, it may be desirable to setcore.symlinks option.
To do this:
Building Specific Branches #
Travis CI uses the .travis.yml file from the branch containing the Git commit that triggers the build. Include branches using a safelist, or exclude them using a blocklist.
Note that you also need to take into account automatic Pull Request Builds when deciding to safelist or blocklist certain branches.
Safelisting or Blocklisting Branches #
Specify which branches to build using a safelist, or blocklist branches that you do not want to be built:
Note that safelisting also prevents tagged commits from being built. If you consistently tag your builds in the format v1.3 you can safelist them all with regular expressions, for example /^vd+.d+(.d+)?(-S*)?$/.
If you use both a safelist and a blocklist, the safelist takes precedence. By default, the gh-pages branch is not built unless you add it to the safelist.
To build all branches:
Note that for historical reasons .travis.yml needs to be present on all active branches of your project.
Using Regular Expressions #
You can use regular expressions to safelist or blocklist branches:
Any name surrounded with / in the list of branches is treated as a regular expression and can contain any quantifiers, anchors or character classes supported by Ruby regular expressions.
Options that are specified after the last / (e.g., i for case insensitive matching) are not supported but can be given inline instead. For example, /^(?i:deploy)-.*$/ matches Deploy-2014-06-01 and otherbranches and tags that start with deploy- in any combination of cases.
Skipping a Build #
If you don’t want to run a build for a particular commit for any reason, you may instruct Travis CIto skip building this commit via a command in the commit message.
The command should be one of the following forms:
or
where <KEYWORD> is either ci, travis, travis ci, travis-ci, or travisci.For example,
Note that in case multiple commits are pushed together, the skip command is effective only if present in the commit message of the HEAD commit.
Build matrix #
You can also define exclusions to the build matrix:
All build matrixes are currently limited to a maximum of 200 jobs for both private and public repositories. If you are on an open-source plan, please remember that Travis CI provides this service free of charge to the community. So please only specify the matrix you actually need.
Naming Jobs within Matrices #
You can define names for specific jobs within a matrix. We recommend unique job names, butdo not enforce it (though this may change in the future). Jobs defined in the matrix.includesection can be given a job name as follows:
Brew Mysql Config
Jobs that are generated by matrix expansion cannot be given name attributes.
Excluding Jobs #
If the jobs you want to exclude from the build matrix share the same matrixparameters, you can specify only those and omit the varying parts.
Suppose you have:
This results in a 3×3×4 build matrix. To exclude all jobs which have rvm value 2.0.0andgemfile value Gemfile, you can write:
Which is equivalent to:
Excluding Jobs with env Value #
When excluding jobs with env values, the value must matchexactly.
For example,
defines a 3×4 matrix, because the env value does not match withany job defined in the matrix.
To exclude all Ruby 1.9.3 jobs with DB=mongodb set, write:
Explicitly Including Jobs #
It is also possible to include entries into the matrix with matrix.include:
This adds a particular job to the build matrix which has already been populated.
This is useful if you want to only test the latest version of a dependency together with the latest version of the runtime.
You can use this method to create a build matrix containing only specific combinations.For example, the following creates a build matrix with 3 jobs, which runs a test suite for each version of Python:
Explicitly included jobs inherit the first value in the array #
The jobs which are explicitly included inherit the first value of the expansionkeys defined.
In this example with a 3-job Python build matrix, each job in matrix.includehas the python value set to '3.8'.You can explicitly set the python version for a specific entry:
Jobs That Are Allowed to Fail #
You can define jobs that are allowed to fail in the build matrix.
Allowed failures are jobs in your build matrix that are allowed to fail withoutcausing the entire build to fail. This lets you add in experimental andpreparatory builds, for example to test against runtime versions orconfigurations that you are not ready to officially support.
Define allowed failures in the build matrix as key/value pairs:
Conditionally Allowing Jobs to Fail #
Allowed failures can include a condition using the key if.
For example, the following would allow the job using rvm: 1.9.3 to failonly on the master branch:
Matching Jobs with allow_failures#
When matching jobs against the definitions given in allow_failures, allattributes specified on an entry in allow_failures must be met exactly, and allthe keys in allow_failures element must exist in the top level of the buildmatrix (i.e., not in matrix.include).
allow_failures Examples #
Consider
Here, no job is allowed to fail because no job has the env valueSECRET_VAR1=SECRET1 SECRET_VAR2=SECRET2.
Next,
Without the top-level env, no job will be allowed to fail.
Fast Finishing #
If some jobs in the build matrix are allowed to fail, the build won’t be marked as finished until they have completed.
To mark the build as finished as soon as possible, add fast_finish: true to the matrix section of your .travis.yml like this:
Now, the build result will be determined as soon as all the required jobs finish, based on these results, while the rest of the allow_failures jobs continue to run.
Installing a Second Programming Language #
If you need to install a second programming language in your current build environment, you can do so in the before_install stage of the build.
For example, you can use the following recipe to install a custom version of Ruby in a Python build:
Brew Mysql Setup
You can also install a custom PHP version in a Node.js build like this:
Brew Install Mysql_config
It’s also possible to use other language installation methods such as apt-get, pyenv for Python, nvm for Node.js, etc.
Implementing Complex Build Steps #
If you have a complex build environment that is hard to configure in the .travis.yml, consider moving the steps into a separate shell script.The script can be a part of your repository and can easily be called from the .travis.yml.
See Complex Build Commands for more information on how to do this.
Custom Hostnames #
If your build requires setting up custom hostnames, you can specify a single host or alist of them in your .travis.yml. Travis CI will automatically setup thehostnames in /etc/hosts for both IPv4 and IPv6.
What Repository Providers or Version Control Systems Can I Use? #
Build and test your open source and private repositories hosted on GitHub on travis-ci.com. Travis CI can also integrates with Atlassian Bitbucket, GitLab and Assembla (https://www.assembla.com/).
Travis CI currently does not support git repositories hosted on other version control systems such as Mercurial.
What YAML Version Can I Use in .travis.yml#
Travis CI uses the Ruby libYAML library, which means that your .travis.yml must be valid YAML 1.1.
Troubleshooting #
Check out the list of common build problems.