Laravel 5.2 Connection.php第669行出现QueryException


Laravel 5.2 QueryException in Connection.php line 669

我正在开发一个API,但当我创建关系(多对多)并想在index函数中显示时,我得到了一个错误QueryException in Connection.php line 669错误显示:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'CTL_Tags.id' in 'on clause' (SQL: select `CTL_Tags`.*, `CTL_Resource_has_Tags`.`idResource` as `pivot_idResource`, `CTL_Resource_has_Tags`.`idTag` as `pivot_idTag` from `CTL_Tags` inner join `CTL_Resource_has_Tags` on `CTL_Tags`.`id` = `CTL_Resource_has_Tags`.`idTag` where `CTL_Resource_has_Tags`.`idResource` is null)

我相信我的错误在我的模型中,因为它在CTL_Tags表中查找id,而我在该表中的id名称是idTag

这是我的CTL_Resource型号

<?php
namespace Knotion;
use Illuminate'Database'Eloquent'Model;
class CTL_Resource extends Model  {
    public $timestamps = false;
    protected $table = "CTL_Resource";
    protected $hidden = [
      'coachVisibility', 'thumbnail', 'tags', 'relatedTo',
      'studentVisibility', 'isHTML','studentIndex', 'coachIndex',
      'isURL', 'source', 'path', 'status', 'updateTime', 'isfolder',
      'parentResource', 'idModifierUser'
    ];
    protected $fillable = ['idResourceType','productionKey', 'tags', 'idCreatorUser', 'idModifierUser', 'idCreationCountry', 'title', 'description', 'URL', 'fileName', 'extension', 'quicktag', 'minimumAge', 'maximumAge', 'productionKey'];
    public function creatorUser() {
      return $this->belongsTo('Knotion'OPR_User', 'idCreatorUser');
    }
    public function creationCountry() {
      return $this->belongsTo('Knotion'CTL_Country', 'idCreationCountry');
    }
    public function resourceType()  {
      return $this->belongsTo('Knotion'CTL_ResourceType', 'idResourceType');
    }
    public function quickTags() {
      return $this->belongsToMany('Knotion'CTL_QuickTag', 'CTL_Resource_has_QuickTags', 'idResource', 'idQuickTag');
    }
    public function tags() {
      return $this->belongsToMany('Knotion'CTL_Tag','CTL_Resource_has_Tags', 'idResource', 'idTag');
    }
    public function relatedTo() {
      return $this->belongsToMany('Knotion'CTL_RelatedTo', 'CTL_Resource_has_RelatedTo', 'idResource', 'idRelatedTo');
    }
}

我只会给你看一个关系的代码

<?php
namespace Knotion;
use Illuminate'Database'Eloquent'Model;
class CTL_QuickTag extends Model  {
    protected $table = "CTL_QuickTags";
    protected $fillable = ['name'];
    protected $hidden = ['status', 'createTime', 'updateTime'];
    public function resources() {
      return $this->belongsToMany('Knotion'CTL_Resource', 'CTL_Resource_has_QuickTags', 'idResource', 'idQuickTag');
    }
}

这是我的控制器

<?php
namespace Knotion'Http'Controllers;
use Illuminate'Http'Request;
use Knotion'Http'Requests;
use Knotion'Http'Requests'ResourcesRequest;
use Knotion'CTL_Resource;
use Knotion'CTL_Tag;
use Knotion'CTL_QuickTag;
use Knotion'CTL_RelatedTo;
use Knotion'CTL_ResourceType;

class ResourcesController extends Controller  {
    public function index(Request $request)    {
        $resources = CTL_Resource::paginate(10);
        $resources->each(function($resources) {
          $resources->tags;
          $resources->quickTags;
          $resources->relatedTo;
        });
        return response()->json(
          $resources
      );

任何人能帮助我,我都会非常感激。非常感谢。

尝试定义

$primaryKey

在您的模型中,使用正确的列名

https://laravel.com/docs/5.2/eloquent#defining-型号