Error when execute complex query builder with relation in laravel 5

Question

I have complex query builder to get all image from images relation with images_tags table

$tags = [1, 2, 3];
$items = ImagesTable::with(['images_tags' => function ($query) use ($tags) {
   $tags = $query->select('image_id', ImageTag::raw('count(tag_id) as total'))
          ->whereIn('tag_id', $tags)
          ->groupBy('image_id')
          ->having(['total', 3])
          ->get();
      return $tags;
    }])->get();

And two table

(images)-(images_tags)  1-n
images (
  id int  
  title varchar(255) 
)
images_tags (
  id int  
  image_id,  
  tag_id int 
  constraints fk foreign key('image_id') on images('id')
)

But i get error

ErrorException in Grammar.php line 58:
strtolower() expects parameter 1 to be string, object given

And i found this line code cause error

ImageTag::raw('count(tag_id) as total')

And i don't know why is this?

Can you try using \DB instead of ImageTag. Or Try using \ before your ImageTag like \ImageTag. Try like these \ImageTag::raw('count(tag_id) as total') OR \DB::raw('count(tag_id) as total') — manian
– manian, Commented May 14, 2017 at 8:12

Mai Minh · Accepted Answer · 2017-05-14 09:50:44Z

1

[SOLVED] This question is solved!
I replaced ImageTag with \DB and it works.

answered May 14, 2017 at 9:50

Mai Minh

1973 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error when execute complex query builder with relation in laravel 5

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related