8-2 Table 'xiaohu.answers_user' doesn't exist
来源:

忧郁的风
2016-10-12
/*检查此用户是否在该问题下投过票*/
$vote = $answer
->users()
->newPivotStatement()
->where('user_id',session('user_id'))
->where('answer_id',rq('id'))
->first();
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xiaohu.answers_user' doesn't exist (SQL: select * from `answers_user` where `user_id` = 3 and `answers_id` = 1 limit 1)
这里 测试时 提示 answers_user 找不到。。 怎么是带s的 Migration
$table->increments('id');
$table->unsignedInteger('user_id');
$table->unsignedInteger('answer_id');
$table->unsignedSmallInteger('vote');
$table->timestamps();
$table->foreign('user_id')->references('id')->on('users');
$table->foreign('answer_id')->references('id')->on('answers');
$table->unique(['user_id','answer_id','vote']);
public function users()
{
return $this
->belongsToMany('App\User')
->withPivot('vote')
->withTimestamps();
}
严格按老师 的视频 敲得代码。。 操作系统 是 ubuntu+homestead laravel版本5.2.31
1回答
-
ArrayZoneYour
2016-10-14
你贴的代码不够啊,可能是你的Answer.php里的users方法的关联出了问题吧
012016-10-16
相似问题