DB::raw() method does not work in laravel 10

@Nakov it still throws the same error SQLSTATE[42S22]: Column not found: 1054 Unknown column 'count(*)' in 'field list' (Connection: mysql, SQL: select count(*) as user_count, status from users where status <> 1 group by status)

@rajrajeevkarn what about if you add them in an array:

->selectRaw(['count(*) as user_count', 'status'])

@rajrajeevkarn btw, just installed Laravel 10 and tried similar query with DB raw, and everything works as expected.

Make sure you've got the correct database connection. And just try for example User::all(); and check if that will return any results.

@rajrajeevkarn

Also, try counting a field, here is an example of a count query:

        $quy = Powner::query()->leftJoin('dc_pets', 'dc_powners.ownerid', '=', 'dc_pets.ownerid')
                ->select('dc_powners.ownerid as oid', 'dc_powners.oname')//->distinct()
                ->selectRaw('count(dc_pets.petid) as CountOfpetid')
                ->groupby('dc_powners.ownerid')
                ->groupby('dc_powners.oname')
                ->orderby('dc_powners.oname')
                ->get();

Results basically give:

 oname, CountOfpetid

Like:

Bob|3
Greg|9
Rob|1

Just suggestion.

Or just use a regular GROUP BY query:

https://www.mysqltutorial.org/mysql-group-by.aspx

Edit:

The above is laravel 10.

@raveiga Hi, This thread was created by me. I got a solution that I want to share with you. Step 1: go to vendor/laravel/framework/src/Illuminate/Contracts/Database/Query/Expression.php Change line no. 15 public function getValue(Grammar $grammar); to public function getValue();

Step 2: go to vendor/laravel/framework/src/Illuminate/Database/Query/Expression.php

change the function public function getValue(Grammar $grammar) { return $this->value; } to public function getValue() { return $this->value; }

Step 3: In the same class (noted above in step: 2), add a new function public function __toString() { return (string) $this->getValue(); } It would solve your problem

Thank you: Rajeev

@rajrajeevkarn

Ok Thank you.

I will try your solution, but I'm going to try to modify my query first to the eloquent format.

Finally I could translate the query to eloquent format.

Thank you all.

Here it is, if it's useful for anyone:

               $tableA = DB::table("cpostales")
                    ->whereIn('provincia', function ($query) use ($delegado) {
                        $query->from('cpostal_asociados')
                            ->select('provincia')
                            ->where("user_id", "=", $delegado)
                            ->whereNotNull("provincia");
                    })
                    ->distinct()
                    ->select('cpostal')
                    ->orderBy('cpostal');

                $mergedWithTableA = DB::table("cpostales")
                    ->whereIn('area_sanitaria', function ($query) use ($delegado) {
                        $query->from('cpostal_asociados')
                            ->select('area_sanitaria')
                            ->distinct()
                            ->where("user_id", "=", $delegado)
                            ->whereNotNull("area_sanitaria");
                    })
                    ->distinct()
                    ->select('cpostal')
                    ->orderBy('cpostal')
                    ->union($tableA);

                $proveedoresRestoSpain = DB::table('ventas')
                    ->select('proveedor_id')
                    ->join('proveedores', 'ventas.proveedor_id', '=', 'proveedores.id')
                    ->where('proveedores.tipo', '=', 'P')
                    ->whereIn('ventas.codigo_postal', $mergedWithTableA)
                    ->orderBy('proveedores.nombre')
                    ->distinct('proveedor_id')
                    ->get();

@rajrajeevkarn Your post saved me. Ty!

@rajrajeevkarn Never change vendor code. This is not controlled by you, should not be committed to a repo and will be overwritten as soon as you update vendor package.

@felixpenrose Yes, you are correct. But sometimes when an older project has to upgrade to the latest version, it is very tedious to change the whole code of the project according to the new version. So, my solution is just like a quick remedy for those who have the same situation as I explained above.

@maurocecamore This is the most clever option.

@markomo This has absolutely nothing to do with the original question. You should ask this is a new thread, not revive a year-old, unrelated thread.