問題描述

因為我會說西班牙語，所以我用西班牙語寫了收入和支出的控制器和模型；而其余的都是英文的..我手動重命名和更改了路由、控制器、遷移甚至模型.當我運行 php artisan migrate:reset 這是我的錯誤.

Since i am a spanish speaker, i wrote the controllers and models of income and expense in spanish; while all the rest were on english.. I renamed and changed manually Routes, Controllers, Migrations and even Models. And when i run php artisan migrate:reset this is my error.

未定義表:7 錯誤:關系費用"不存在(SQL:更改表費用"刪除列location_id")**

Undefined table: 7 ERROR: relation "expenses" does not exist (SQL: alter table "expenses" drop column "location_id")**

我使用 psgql 和 laravel 5.3

I use psgql and laravel 5.3

這是我的代碼:

    <?php

    namespace App;

    use IlluminateDatabaseEloquentModel;

    class Expense extends Model
    {

        protected $fillable = ['id', 'description', 'quantity'];


        public function locations()
        {

            return $this->hasMany('AppLocation');

        }
        public function icons()
        {

            return $this->hasMany('AppIcon');
        }
        public function types()
        {

            return $this->hasMany('AppType');
        }
        public function stores()
        {

            return $this->hasMany('AppStore');
        }

    }

遷移:

    <?php

use IlluminateSupportFacadesSchema;
use IlluminateDatabaseSchemaBlueprint;
use IlluminateDatabaseMigrationsMigration;

class CreateExpensesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('expenses', function (Blueprint $table) {
            $table->increments('id');
            $table->float('quantity');
            $table->string('description');
            $table->integer('location_id')->unsigned();
            $table->integer('icon_id')->unsigned();
            $table->integer('type_id')->unsigned();
            $table->integer('store_id')->unsigned();
            $table->timestamps();
        });
    }

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

位置遷移:

<?php

use IlluminateSupportFacadesSchema;
use IlluminateDatabaseSchemaBlueprint;
use IlluminateDatabaseMigrationsMigration;

class CreateLocationsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('locations', function (Blueprint $table) {
            $table->increments('id');
            $table->string('address');
            $table->float('lat');
            $table->float('long');
            $table->integer('store_id')->unsigned();
            $table->timestamps();

            $table->foreign('store_id')->references('id')->on('stores')->onDelete('cascade');
        });

        Schema::table('expenses', function (Blueprint $table) {
            $table->foreign('location_id')->references('id')->on('locations')->onDelete('cascade');
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('expenses', function (Blueprint $table) {
            $table->dropColumn('location_id');
        });

        Schema::dropIfExists('locations');
    }
}

型號:

<?php

namespace App;

use IlluminateDatabaseEloquentModel;

class Location extends Model
{

    protected $fillable = ['id', 'address', 'lat', 'long'];


    public function expenses()
    {

        return $this->belongsTo('AppExpense');
    }

    public function stores()
    {

        return $this->hasOne('AppStore');
    }
}

希望你能幫助我.

推薦答案

當它說

relation "expenses" does not exist

通常發生在您的費用表必須在 migration:reset 回滾 CreateLocationsTable 之前被刪除時.

It usually happens when your expenses table must have been dropped before migration:reset rolled back CreateLocationsTable.

檢查遷移的執行順序.

當您嘗試重置時，現在要修復它，請打開您的數據庫，手動刪除所有表并再次執行 migrate.

As you were trying to reset, to fix it now, open your database, drop all tables manually and execute migrate again.

這篇關于未定義的表:7 錯誤:關系“費用"；不存在的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！