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:
$users = DB::table("users")
But when i run above query using database query builder i got following error, as.....
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.
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:
npm install -g create-react-app
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.
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.....
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:
SQLSTATE: 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`)
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:
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:
BadMethodCallException in Builder.php line 2440: Call to undefined method
I did search a lo.....
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.....
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:
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 .....
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:
- 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 .....
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:
this merchant is not enabled for auth/settle
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.....
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:
fatal: unable to access 'https://firstname.lastname@example.org/hardik/setup_backend.git/':
Failed to connect to bitbucket.org port 443: Network is unreachable
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.....