• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Error trying to use query builder (version 4.04)

#1
I'm receiving this error:
  • Argument 1 passed to App\Models\PostModel::App\Models\{closure}() must be an instance of App\Models\BaseBuilder

When I try to use the "orWhereIn" method of the query builder like so:

$results = $this->select('id, body, timestamp, user_id')
                       ->where('user_id', $userID)
                       ->orWhereIn('id', function(BaseBuilder $subq) {
                               return $subq->select('followed_id')
                                                  ->from('followers')
                                                  ->where('follower_id', $userID);
                               })
                        ->orderBy('timestamp', 'DESC')
                        ->findAll();


The "$this" above is in context with the model I am in, so I am using the built-in query builder instance of the model. I have the initial table set up by a "protected $table" declaration (thus no from clause under the first select).

Not sure how to fix it - can anyone help?
Reply

#2
The builtin instance of the Query Build is $this->builder();
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply

#3
Thanks, but I tried that and am still getting the same error.  Huh

new code:

$builder = $this->builder();       
$builder->select('id, body, timestamp, user_id');
$builder->where('user_id', $userID);
$builder->orWhereIn('id', function(BaseBuilder $builder)
                          {
                              return $builder->select('followed_id')
                                              ->from('followers')
                                              ->where('follower_id', $userID);
                          });
$builder->orderBy('timestamp', 'DESC');
$results = $builder->get();
Reply

#4
This is strange, $this->builder is an instance of BaseBuilder.

You may have found a bug here, I would report it on GitHub.
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.