I can’t open project in Laravel

Question

I have a project in Laravel that after I formatted the computer I can no longer open it. The following steps have been performed:

1. Installation of XAMPP and change the default path to the project folder.
2. Installation of Composer and subsequently update thereof.
3. Creation of the project database on Mysql.
4. When rotating the command PHP artisan migrate and artisan serve appears the following error:

5. On the web page appears like this:

6. The file . env is configured this way. This key was there the same way before the machine was formatted. Running php Artisan key:generate gives error and cannot generate new key.

Code

APP_ENV=local
APP_NAME=SGP
APP_KEY=base64:eEtD6lSEsQGE/aDDVHgVHXKLpmaj1XzhMTtiFhOukqQ=
APP_DEBUG=true
APP_LOG_LEVEL=debug
APP_URL=http://sgp.patrimonio
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=sgpmehos_bd
DB_USERNAME=root
DB_PASSWORD=

BROADCAST_DRIVER=log
CACHE_DRIVER=file
SESSION_DRIVER=file
QUEUE_DRIVER=sync
REDIS_HOST=127.0.0.1
REDIS_PASSWORD=null
REDIS_PORT=6379
MAIL_DRIVER=smtp
MAIL_HOST=smtp.mailtrap.io
MAIL_PORT=2525
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ENCRYPTION=null
PUSHER_APP_ID=
PUSHER_APP_KEY=
PUSHER_APP_SECRET=

The Migration that is showing error is 2017_10_22_134724_create_permissions_table.php and the codes inserted in it are:

<?php

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

class CreatePermissionsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('permissions', function (Blueprint $table) {
            $table->increments('id');
            $table->string('nome', 50);
            $table->string('label', 200);
            $table->timestamps();
        });

        Schema::create('permission_role', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('permission_id')->unsigned();
            $table->foreign('permission_id')->references('id')->on('permissions')->onDelete('cascade');
            $table->integer('role_id')->unsigned();
            $table->foreign('role_id')->references('id')->on('roles')->onDelete('cascade');
        });
    }

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

Model: Permission.php

<?php

namespace App\Models\Acesso;

use Illuminate\Database\Eloquent\Model;

class Permission extends Model
{
    public function scopeSearch($query, $pesquisa){
        return $query->where('nome', 'like','%' .$pesquisa. '%' );
    }

    public function roles()
    {
        return $this->belongsToMany(\App\Models\Acesso\Role::class);
    }
}

Can you help me?

Answer 1

Following for what you reported:

Delete the database;

Restart the XAMP;

Create the database in hand again (Make sure the name has been typed correctly);

After that run the command "php Artisan dump-autoload"

Then: php Artisan migrate --force