Mysql 5.7 GROUP BY error incompatible with sql_mode=only_full_group_by

In mysql 5.7 sql mode ONLY_FULL_GROUP_BY is enabled by default. Which means that, your select list must be in your aggregate(GROUP BY/ Having) function. See the details from here https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html Recently i faced this types of problem, my sql was exactly SELECT * FROM `users` GROUP BY `user_level_id` The problem on this query is that, 

Continue Reading…

PHPMYADMIN with PHP 7.2 “Warning in ./libraries/sql.lib.php#613 count(): Parameter must be an array or an object that implements Countable”

phpmyadmin v4.6.6 isn’t fully compatible with PHP 7.2, have an warning issue. On phpmyadmin v4.8 fixes this compatibility issue with php 7.2 To run phpmyadmin v4.6.6 with php 7.2 you will found this below warning Warning in ./libraries/sql.lib.php#613 count(): Parameter must be an array or an object that implements Countable Backtrace ./libraries/sql.lib.php#2128: PMA_isRememberSortingOrder(array) ./libraries/sql.lib.php#2079: PMA_executeQueryAndGetQueryResponse( 

Continue Reading…

What is docker?

“Hey,man it’s working on my local machine,i don’t know why it’s not working on live” It’s a common word to hear in development.Docker is an open source platform for deployment an application.It’s platform that helps developer to deploy their application for application dependency in a container. Docker Containers Docker separates each individual processes running on 

Continue Reading…

PHPStorm launcher as terminal command on homestead

PHPStorm is a great IDE for PHP.This IDE support few major framework like Symfony, Drupal, WordPress, Zend Framework, Laravel, Magento, Joomla!, CakePHP, Yii etc.It provides the best code completion, refactorings, on-the-fly error prevention, and more.Today we know how can we access PHPStorm from our local ubuntu machine using a terminal command.First we will see how 

Continue Reading…

Beanstalkd and Supervisor With Laravel Queue

Beanstalkd Beanstalk is a simple, fast work queue.Its interface is generic,but was originally designed for reducing the latency of page views in high-volume web applications by running time-consuming tasks asynchronously.chronously. Supervisor Supervisor is a client/server system that allows its users to monitor and control a number of processes on UNIX-like operating systems. Laravel Queue Laravel 

Continue Reading…

elasticsearch

What is Elasticsearch?

What is elasticsearch?It’s a great question,different people describe this in different ways.A recent video where people are confused to describe elasticsearch What is elasticsearch?.As i know in single word,elasticsearch is a open source search engine.But more often it’s readily-scalable,distributed,full text search engine with RESTful HTTP interface and powerful fast searches data,works on schema free json 

Continue Reading…