Posted on Leave a comment

Fix SQL Error: GROUP BY incompatible with sql_mode=only_full_group_by

MySQL 5.7.5+ changed the GROUP BY behavior. So in this and future versions GROUP BY would not work in same way as it used to be before.

So to make GROUP BY feature working like before follow these details:

Note: First of all to follow these steps you must need to have root access to your server.

If you want to disable error sql_mode=only_full_group_by  permanently then do those steps:

  1. sudo nano /etc/mysql/my.cnf
    
  2. Add this to the end of the file
    [mysqld]
    sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
    
  3. sudo service mysql restart  to restart MySQL

This will disable ONLY_FULL_GROUP_BY for ALL users

Posted on Leave a comment

Best Websites to Learn Programming in Free

  1. https://frontendmasters.com/
  2. https://www.class-central.com
  3. http://www.udacity.com
  4. http://www.freecodeamp.com
  5. https://codecademy.com
  6. https://mva.microsoft.com/
  7. https://github.com/open-source-society/computer-science
  8. https://www.khanacademy.org
  9. https://www.safaribooksonline.com/ ( One Month Free Trial )
  10. http://edx.org
  11. http://coursera.org
  12. http://udemy.com
  13. https://www.skillshare.com/
  14. https://thenewboston.com/videos.php
  15. https://angularfirebase.com/
  16. http://w3schools.com
  17. https://www.airpair.com/
  18. https://egghead.io
  19. http://tutsplus.com
  20. https://www.pluralsight.com/browse/software-development ( 10 Days Free Trial )
  21. https://hackr.io
  22. https://academy.fossbytes.com/
  23. https://www.codeschool.com
  24. http://www.learnvern.com/
  25. http://www.lynda.com (10 Days Free Trial)
  26. https://www.datacamp.com
  27. https://alison.com/
  28. http://programming-motherfucker.com/become.html
  29. https://itpro.tv/PAID

  30. https://www.cbtnuggets.com
  31. https://linuxacademy.comAWS (Amazon Web Services)
  32. https://www.youtube.com/watch?v=BDBvHOaaKHo&list=PLv2a_5pNAko0Mijc6mnv04xeOut443Wnk
  33. https://linuxacademy.com/ (AWS and other cloud solutions )
  34. https://coursehunters.net/
  35. https://scrimba.com/