Issue Archives - Onlinecode

Please provide a valid cache path. laravel error fixed In this post we will give you information about Please provide a valid cache path. laravel error fixed. Hear we will give you detail about Please provide a valid cache path. laravel error fixedAnd how to use it also give you demo for it if it …

Please provide a valid cache path. laravel error fixed Read More »

How to resolve Laravel blank page on server?

How to set multiple selected value in Chosen Jquery Plugin?

Laravel 5.5 group by doesn’t work – fixed
In this post we will give you information about Laravel 5.5 group by doesn’t work – fixed. Hear we will give you detail about Laravel 5.5 group by doesn’t work – fixedAnd how to use it also give you demo for it if it is necessary.

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:
DB Query:
$users = DB::table("users")
->groupBy("name")
->get();
dd($users);
But when i run above query using database query builder i got following error, as you can see:

**SQLSTATE[42000]: Syntax error or access violation: 1055 ‘laravel_test.users.id’ isn’t in GROUP BY (SQL: select * from ‘users’ group by ‘name’)

I was thinking what is the issue because without group by it was working, but at last i found it how to solve it So we have to simply “strict” mode make it true into false in database.php file. So let’s do it as bellow:
config/database.php
Also see:Laravel 5 – create quick backend admin panel tutorial
...
'strict' => true,

To

'strict' => false,
....
After that i hope you found your solution.
Thank you…
Hope this code and post will helped you for implement Laravel 5.5 group by doesn’t work – fixed. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs
For More Info See :: laravel And github**

Leave a Comment / Solve / By onlinecode

Laravel 5.5 group by doesn’t work – fixed In this post we will give you information about Laravel 5.5 group by doesn’t work – fixed. Hear we will give you detail about Laravel 5.5 group by doesn’t work – fixedAnd how to use it also give you demo for it if it is necessary. Someday …

Laravel 5.5 group by doesn’t work – fixed

In this post we will give you information about Laravel 5.5 group by doesn’t work – fixed. Hear we will give you detail about Laravel 5.5 group by doesn’t work – fixedAnd how to use it also give you demo for it if it is necessary.

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:

DB Query:

$users = DB::table("users")
            ->groupBy("name")
            ->get();
dd($users);

But when i run above query using database query builder i got following error, as you can see:

SQLSTATE[42000]: Syntax error or access violation: 1055 ‘laravel_test.users.id’ isn’t in GROUP BY (SQL: select * from ‘users’ group by ‘name’)

I was thinking what is the issue because without group by it was working, but at last i found it how to solve it So we have to simply “strict” mode make it true into false in database.php file. So let’s do it as bellow:

config/database.php

Also see:Laravel 5 – create quick backend admin panel tutorial

...
'strict' => true,

To

'strict' => false,
....

After that i hope you found your solution.

Thank you…

Hope this code and post will helped you for implement Laravel 5.5 group by doesn’t work – fixed. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs

For More Info See :: laravel And github

Read More »

Laravel Query Builder Where Exists Example

Leave a Comment / php / By onlinecode

Laravel Query Builder Where Exists Example Read More »

How to solve – This cache store does not support tagging?

Leave a Comment / Solve / By onlinecode

How to solve – This cache store does not support tagging? In this post we will give you information about How to solve – This cache store does not support tagging?. Hear we will give you detail about How to solve – This cache store does not support tagging?And how to use it also give …

How to solve – This cache store does not support tagging? Read More »

Laravel 5.5 group by doesn’t work – fixed
In this post we will give you information about Laravel 5.5 group by doesn’t work – fixed. Hear we will give you detail about Laravel 5.5 group by doesn’t work – fixedAnd how to use it also give you demo for it if it is necessary.

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:
DB Query:
$users = DB::table("users")
->groupBy("name")
->get();
dd($users);
But when i run above query using database query builder i got following error, as you can see:

**SQLSTATE[42000]: Syntax error or access violation: 1055 ‘laravel_test.users.id’ isn’t in GROUP BY (SQL: select * from ‘users’ group by ‘name’)

I was thinking what is the issue because without group by it was working, but at last i found it how to solve it So we have to simply “strict” mode make it true into false in database.php file. So let’s do it as bellow:
config/database.php
Also see:Laravel 5 – create quick backend admin panel tutorial
...
'strict' => true,

To

'strict' => false,
....
After that i hope you found your solution.
Thank you…
Hope this code and post will helped you for implement Laravel 5.5 group by doesn’t work – fixed. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs
For More Info See :: laravel And github**

Leave a Comment / Solve / By onlinecode

Laravel 5.5 group by doesn’t work – fixed

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:

DB Query:

$users = DB::table("users")
            ->groupBy("name")
            ->get();
dd($users);

But when i run above query using database query builder i got following error, as you can see:

SQLSTATE[42000]: Syntax error or access violation: 1055 ‘laravel_test.users.id’ isn’t in GROUP BY (SQL: select * from ‘users’ group by ‘name’)

config/database.php

Also see:Laravel 5 – create quick backend admin panel tutorial

...
'strict' => true,

To

'strict' => false,
....

After that i hope you found your solution.

Thank you…

For More Info See :: laravel And github

Read More »

How to solve ‘There are no commands defined in the “cashier” namespace’ in Laravel 5
In this post we will give you information about How to solve ‘There are no commands defined in the “cashier” namespace’ in Laravel 5. Hear we will give you detail about How to solve ‘There are no commands defined in the “cashier” namespace’ in Laravel 5And how to use it also give you demo for it if it is necessary.

When i did start to learn “Laravel Cashier” and i was following step by step of laravel official document, but i run bellow command :
php artisan cashier:table users
At that time i found following error on my terminal:
[SymfonyComponentConsoleExceptionCommandNotFoundException]
There are no commands defined in the "cashier" namespace.
I try to solve this error, i also clear all cache and add service provider, it means i try totally and i can’t found solution for this error, but you can also add migration like this way if you want it is a same like we did bellow command. so first run command for create migration:
php artisan make:migration add_cashier_table_fields
ok, now put bellow content on following file :
Migration:
use IlluminateDatabaseSchemaBlueprint;
use IlluminateDatabaseMigrationsMigration;
class AddBillTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('users', function ($table) {
$table->string('stripe_id')->nullable();
$table->string('card_brand')->nullable();
$table->string('card_last_four')->nullable();
$table->timestamp('trial_ends_at')->nullable();
});
Schema::create('subscriptions', function ($table) {
$table->increments('id');
$table->integer('user_id');
$table->string('name');
$table->string('stripe_id');
$table->string('stripe_plan');
$table->integer('quantity');
$table->timestamp('trial_ends_at')->nullable();
$table->timestamp('ends_at')->nullable();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{

}
}
Hope this code and post will helped you for implement How to solve ‘There are no commands defined in the “cashier” namespace’ in Laravel 5. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs
For More Info See :: laravel And github

Leave a Comment / Namespace / By onlinecode

How to solve ‘There are no commands defined in the “cashier” namespace’ in Laravel 5

In this post we will give you information about How to solve ‘There are no commands defined in the “cashier” namespace’ in Laravel 5. Hear we will give you detail about How to solve ‘There are no commands defined in the “cashier” namespace’ in Laravel 5And how to use it also give you demo for it if it is necessary.

When i did start to learn “Laravel Cashier” and i was following step by step of laravel official document, but i run bellow command :

php artisan cashier:table users

At that time i found following error on my terminal:

[SymfonyComponentConsoleExceptionCommandNotFoundException]    There are no commands defined in the "cashier" namespace.

I try to solve this error, i also clear all cache and add service provider, it means i try totally and i can’t found solution for this error, but you can also add migration like this way if you want it is a same like we did bellow command. so first run command for create migration:

php artisan make:migration add_cashier_table_fields

ok, now put bellow content on following file :

Migration:

use IlluminateDatabaseSchemaBlueprint;
use IlluminateDatabaseMigrationsMigration;
class AddBillTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('users', function ($table) {
            $table->string('stripe_id')->nullable();
            $table->string('card_brand')->nullable();
            $table->string('card_last_four')->nullable();
            $table->timestamp('trial_ends_at')->nullable();
        });
        Schema::create('subscriptions', function ($table) {
            $table->increments('id');
            $table->integer('user_id');
            $table->string('name');
            $table->string('stripe_id');
            $table->string('stripe_plan');
            $table->integer('quantity');
            $table->timestamp('trial_ends_at')->nullable();
            $table->timestamp('ends_at')->nullable();
            $table->timestamps();
        });
    }
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {

    }
}

Hope this code and post will helped you for implement How to solve ‘There are no commands defined in the “cashier” namespace’ in Laravel 5. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs

For More Info See :: laravel And github

Read More »