Tag : Solve



Laravel 5.5 group by doesn't work - fixed

Someday ago i just installed laravel 5.5 application and i was checking new feature and making some examples. But i was working on database query builder example one by one, i got following error when i used group by on single column. My query was like as bellow example, so you can see on database query i simple get all users and group by with name. So, let's simply see how it is: <strong>DB Query:</strong> <pre> $users = DB::table("users") ->groupBy("name") ->get(); dd($users); </pre> But when i run above query using database query builder i got following error, as.....

By Hardik Savani | September 22, 2017 | | 1115 Viewer | Category : PHP Laravel
READ MORE

Magento 2 - How to solve one or more indexers are invalid by command line?

When i was starting to work on my magento project from scratch, i installed successfully but when i added two or three products but it was not displaying on homepage or category page. I though what will be issue. after search i found it was issue because i require to reindex of product. I again found how to reindex, i though it re-index from admin panel, but i couldn't find any option in admin panel. At Last i found i can solve "one or more indexers are invalid solved" error from command line, i open my terminal and go on root directory. I run bellow command on my root directory. <strong>Re-i.....

By Hardik Savani | March 10, 2017 | | 1362 Viewer | Category : Magento
READ MORE

Solved Issue - "/usr/bin/env: ‘node’: No such file or directory"

<br/> In this post i want to share one issue that i fetch. When i started working on my react js project first time on my ubuntu 16.04, i installed npm and then after i run bellow command: <pre> npm install -g create-react-app </pre> this way i installed create-react-app then after i created new command using create-react-app commands, so i run bellow command for create new app of reactjs. <pre> create-react-app hello-world </pre> But when i run above command i found one error <strong>"/usr/bin/env: ‘node’: No such file or directory"</strong>. I thought what will be issue, i searched on go.....

By Hardik Savani | February 24, 2017 | | 4343 Viewer | Category : Installation Ubuntu Node JS React JS
READ MORE

Laravel 5 - "syntax error or access violation 1055 in group by" Solved

Yesterday i was working on my Laravel 5.4 application and when i use group by statement in query builder I found error like as bellow: <br/> <strong> SQLSTATE[42000]: Syntax error or access violation: 1055 'admin.products.name' isn't in GROUP BY (SQL: select `products`.*, SUM(products_stock.stock) from `products` inner join `products_stock` on `products_stock`.`product_id` = `products`.`id` group by `products`.`id`) </strong> I was thinking what will be error and why it comes. i thought maybe it comes from mysql. i just add following query using laravel builder as like bellow: <strong>Laravel.....

By Hardik Savani | February 15, 2017 | | 3706 Viewer | Category : Laravel
READ MORE

Laravel 5.3 - Call to undefined method Illuminate\Database\Query\Builder::lists() Solved

Today i want to tell you about error "Call to undefined method Illuminate\Database\Query\Builder::lists()" and how to solve this error in Laravel 5.3. When i was working on my Laravel 5.3 application, at that time i require to get lists of email and id of users table for select drop-down. But when i use lists() with DB table i found error "Call to undefined method Illuminate\Database\Query\Builder::lists()". Error was like bellow preview: <pre> BadMethodCallException in Builder.php line 2440: Call to undefined method <br/> Illuminate\Database\Query\Builder::lists() </pre> I did search a lo.....

By Hardik Savani | September 24, 2016 | | 10612 Viewer | Category : Laravel
READ MORE

Solved - Access Not Configured. Google+ API (truncated...) on google console developer

When i was working on my Laravel 5.3 application with socialite google API. I fetched one issue when redirect on my application. I had successfully created my project on google console with site URL and redirect back URL too. But when it was redirect back on path i found one error like "403 Forbidden - Access Not Configured. Google+ API (truncated...)". I did try my self but i can't solve this error. It was always return error on my screen like this way: <strong>"ClientException in RequestException.php line 107: Client error: `GET https://www.googleapis.com/plus/v1/people/me?prettyPrint=fal.....

By Hardik Savani | September 13, 2016 | | 18428 Viewer | Category : PHP Laravel Installation Codeigniter Google API
READ MORE

How to git ignore file permissions changes for commit?

When i was working on my PHP Laravel project and i clone project from git repository. I just composer install and then change storage folder permission. then i just run bellow command: <pre> git status </pre> I found list files of storage folder even i didn't changes on that file. I was thinking why there are several files on git status. But i understand this is because of permissions. I search google and other, at last i found bellow command that way we can ignore or remove or undo file permissions changes from git status. So, you can run bellow command in your repo. <pre class="prettyprint .....

By Hardik Savani | September 1, 2016 | | 1096 Viewer | Category : Git
READ MORE

Solve - Installation request for guzzle/guzzle in laravel

When i was working on my updated ubuntu version, i did fetch this problem. I had ubuntu 14.04 then i updated ubuntu 16.04, at that time i think PHP version also updated PHP 5 from PHP 7. Ubuntu 16 updated successfully but when i was trying to composer install or update on my project i was found guzzle package error and to enable extensions php 7 extensions as like bellow: <strong>Error</strong> <pre> Problem 1 - Installation request for guzzle/guzzle v3.8.1 -> satisfiable by guzzle/guzzle[v3.8.1]. - guzzle/guzzle v3.8.1 requires ext-curl * -> the requested PHP extension curl is missing from .....

By Hardik Savani | August 15, 2016 | | 2686 Viewer | Category : Laravel Ubuntu
READ MORE

Solved - opencart this merchant is not enabled for auth/settle

When i was learning opencart and i was trying to setup paypal integration with sand box then i fetch one error. Every thing was working proper but when i try to pay money i found error like as bellow: <pre> this merchant is not enabled for auth/settle </pre> I did also try to change my buyer account and try but same, I also did try with different way but same result. At last i found that i used <strong class="path">Personal</strong> account on opencart module setting, we require to use <strong class="path">Business</strong> Account. So when you create new user then select Business in account.....

By Hardik Savani | July 25, 2016 | | 1338 Viewer | Category : PHP Opencart
READ MORE

Solved - fatal: Failed to connect to bitbucket.org port 443: Network is unreachable

When i was working on my project repository i found error "fatal: unable to access 'myrepo' Failed to connect to bitbucket.org port 443: Network is unreachable" few day ago. when i going to just git pull command i found error like as bellow: <pre> fatal: unable to access 'https://hardik@bitbucket.org/hardik/setup_backend.git/': Failed to connect to bitbucket.org port 443: Network is unreachable </pre> But i try to solve it but nothing, at last i found solution i was use <strong class="path">HTTPS</strong> for clone repo. But i need use <strong class="path">SSH</strong> for git repo. So i chan.....

By Hardik Savani | July 21, 2016 | | 9843 Viewer | Category : Git Bitbucket
READ MORE

    How to make read more link from string in PHP?

    How to make read more link from string in PHP?

    Open Post

    Jquery - Show hide password in Password textbox using checkbox.

    Jquery - Show hide password in Password textbox using checkbox.

    Open Post

    How to delete multiple records using checkbox in Laravel 5 ?

    How to delete multiple records using checkbox in Laravel 5 ?

    Open Post

    How to create Laravel Resource Controller example?

    How to create Laravel Resource Controller example?

    Open Post

    Paytm payment gateway integration example in Laravel 5

    Paytm payment gateway integration example in Laravel 5

    Open Post

    Laravel 5.5 Create Custom Middleware example

    Laravel 5.5 Create Custom Middleware example

    Open Post