Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Travis with mySQL 5.7 + product sorting fix #10278

Merged

Conversation

Zales0123
Copy link
Member

Q A
Branch? 1.4
Bug fix? yes
New feature? yes
BC breaks? no
Deprecations? no
Related tickets fixes #10266, replaces #10274
License MIT

The bug from issue #10266 has not been detected on Travis CI, due to the lower mySQL version (without ONLY_FULL_GROUP_BY option set). So this PR bumps the mySQL version on the Travis to 5.7 and contains the fix for the products sorting from #10274 (thank @laSyntez for this one!).

As a proof that it didn't work without the fix, you can take a look at this build or check out our failing demo 🚀 🤣

We have also a PR with changing the ubuntu version on Travis to xenial (#10277), but it does not work for some reasons so bumping a mySQL version can be the first step 🖖

Zales0123 and others added 2 commits March 29, 2019 11:20
Updated the createShopListQueryBuilder method of ProductRepository to get rid of the SQL error that causes a 500 one when trying to sort products by price in the shop.
@Zales0123 Zales0123 added Potential Bug Potential bugs or bugfixes, that needs to be reproduced. Maintenance CI configurations, READMEs, releases, etc. labels Mar 29, 2019
@Zales0123 Zales0123 requested a review from a team as a code owner March 29, 2019 10:55
@lchrusciel lchrusciel merged commit 25dbd2f into Sylius:1.4 Mar 29, 2019
@lchrusciel
Copy link
Member

Thank you, Mateusz! 🥇

@Zales0123 Zales0123 deleted the travis-mysql-5.7-and-product-sorting-fix branch March 29, 2019 14:15
Zales0123 added a commit that referenced this pull request Apr 1, 2019
This PR was merged into the 1.3 branch.

Discussion
----------

| Q               | A
| --------------- | -----
| Branch?         | 1.3
| Bug fix?        | yes
| New feature?    | no
| BC breaks?      | no
| Deprecations?   | no
| Related tickets | 
| License         | MIT

Since merging #10278 Travis jobs takes up to 50 minutes and are closed due to reaching a public repository job time limit :/ I don't know is it an issue with the mySQL version for 100%, but I think we should give it a try (check out travis-ci/travis-ci#9948). I hope it will work, as 50 minutes-long jobs are really painful 🔪 💀 


Commits
-------

57f01f0 [Travis] Update mysql version to speed up builds
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Maintenance CI configurations, READMEs, releases, etc. Potential Bug Potential bugs or bugfixes, that needs to be reproduced.
Projects
None yet
Development

Successfully merging this pull request may close these issues.

3 participants