Framework: Migrations error There is no column with name '{column_name}' on table '{table_name}'.

Created on 29 Mar 2017 · 15Comments · Source: laravel/framework

Laravel Version: 5.4.*
PHP Version: 7.1.1
Database Driver & Version: pgsql - 9.6.2

Description:

I have created a alter table migration for change the string length of a column and default value but when I run php artisan:migrate I got this error:

[Doctrine\DBAL\Schema\SchemaException] There is no column with name 'logo' on table 'empresa'.

Steps To Reproduce:

Schema empresa table:

php artisan make:migration create_empresa_table --create=table

<?php

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

class CreateEmpresaTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('empresa', function (Blueprint $table) {
            $table->increments('id');

            $table->string('nombre_comercial', 200);
            $table->string('nombre_legal', 200);
            $table->string('nit', 20);
            $table->string('telefono', 10);
            $table->string('direccion', 200);
            $table->string('correo', 100);

            $table->integer('tipo_sociedad_id')->unsigned();

            $table->integer('tipo_regimen_id')->unsigned();

            $table->string('codigo_ciuu', 40);

            $table->integer('tipo_contribuyente_id')->unsigned();

            $table->enum('responsable_iva', ['Si', 'No']);
            $table->enum('retencion_fuente', ['Si', 'No']);
            $table->enum('gran_contribuyente', ['Si', 'No']);
            $table->enum('auto_retenedor', ['Si', 'No']);
            $table->smallInteger('numero_empleados');
            $table->string('logo', 20);

            $table->integer('user_id')->unsigned();

            $table->timestamps();
            $table->softDeletes();
        });
    }

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

Schema to alter table field

alter_edit_logo_default_value_on_empresa_table --table=empresa

<?php

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

class AlterEditLogoDefaultValueOnEmpresaTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('empresa', function (Blueprint $table) {
            $table->string('logo', 100)->default('public/empresa/logo/default.png')->change();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('empresa', function (Blueprint $table) {
            $table->string('logo', 20)->change();
        });
    }
}

Source

cesarcruzc

👍1

Most helpful comment

Hi, facing the same issue, any hint?

meinder-a on 31 Jul 2019

👍8

All 15 comments

I have to do this for the moment:

alter_edit_logo_default_value_on_empresa_table.php

<?php

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

class AlterEditLogoDefaultValueOnEmpresaTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {

        Schema::table('empresa', function (Blueprint $table) {

//            $table->string('logo', 100)->defaults('public/empresa/logo/default.png')->change();

            if (env('DB_CONNECTION') === 'mysql'){
                // Mysql
                DB::statement("ALTER TABLE empresa CHANGE COLUMN logo logo varchar(100) NOT NULL DEFAULT 'public/empresa/logo/default.png'");
            } else if (env('DB_CONNECTION') === 'pgsql'){
                // PostgreSQL
                DB::statement("ALTER TABLE empresa ALTER COLUMN logo TYPE varchar(100), ALTER COLUMN logo SET DEFAULT 'public/empresa/logo/default.png'");
            }
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('empresa', function (Blueprint $table) {

//            $table->string('logo', 20)->change();

            if (env('DB_CONNECTION') === 'mysql'){
                // Mysql
                DB::statement("ALTER TABLE empresa CHANGE COLUMN logo logo varchar(20)");

            } else if (env('DB_CONNECTION') === 'pgsql'){
                // PostgreSQL
                DB::statement("ALTER TABLE empresa ALTER COLUMN logo TYPE varchar(20)");
            }

        });
    }
}

cesarcruzc on 29 Mar 2017

If you're adding a new column, don't call the method change()

deleugpn on 30 Mar 2017

@deleugpn I am changing the length and the defaults value for the column logo on table empresa.

cesarcruzc on 31 Mar 2017

Did you install doctrine?

deleugpn on 31 Mar 2017

yes, I have installed doctrine/dbal
composer require doctrine/dbal

cesarcruzc on 31 Mar 2017

Try adding the create & table callbacks in the same file. I think this should work.

srmklive on 3 Apr 2017

Closing for lack of activity.

themsaid on 13 Apr 2017

I have the exact same problem. I installed doctrine/dbal, I'm changing a string column length. When I use change() it says "no column with name" and when I leave out the change() call, it tries to add my column and says "Duplicate column name". Any help would be appreciated!