php - 未找到 Laravel 基表或 View

Question

我很困惑，我试图找出问题所在，但我没有找到..

我的迁移文件:

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;

class CreateClientProjectTable extends Migration {

    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('client_project', function(Blueprint $table)
        {
            $table->increments('id');
            $table->integer('client_id');
            $table->integer('project_id');
            $table->timestamps();
        });
    }


    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::drop('client_project');
    }

}

首先，我检查表是否已创建，它是。

然后调用controller的route是这样的:(前缀是admin)

Route::post('projectsclients/postUpload', ['uses' => 'AdminController@storeProjectsClients', 'as' => 'admin.projectsclients.store']); 

函数如下所示:

$client_project = new Client_Project();
$client_project->client_id = DB::table('clients')->orderby('id','DESC')->take(1)->get();
$client_project->project_id = DB::table('projects')->orderby('id','DESC')->take(1)->get();
$client_project->save();

错误:

Base table or view not found: 1146 Table 'web.client__projects' doesn't exist

问题是我的表是 client_project 而不是 client__projects。

我必须在哪里解决这个问题？

非常感谢，我们将不胜感激。

Answer 1

你不应该用 _ 来分解类名。它应该命名为 ClientProject。通常，如果表格有问题，您将编辑模态并添加一个

客户端工程.php

public $table = 'client_project';