voyager: laravel 5.4 install error

If any body facing same problem, Please follow the below steps to fix the issue:

1. Update the “config/database.php” for ‘mysql’

‘engine’ => null,

with

‘engine’ => ‘InnoDB ROW_FORMAT=DYNAMIC’,

++++++++++++++++++++++++++++++++++++++++++++

2. Update the “app/Providers/AppServiceProvider.php” with

<?php

namespace App\Providers;

use Illuminate\Support\ServiceProvider;
use Illuminate\Support\Facades\Schema;

class AppServiceProvider extends ServiceProvider
{
    /**
     * Bootstrap any application services.
     *
     * @return void
     */
    public function boot()
    {
        // Specified key was too long error, Laravel News post:
        Schema::defaultStringLength(191);
    }

    /**
     * Register any application services.
     *
     * @return void
     */
    public function register()
    {
        //
    }
}

++++++++++++++++++++++++++++++++++++++++++++

3. Execute Command:

php artisan cache:clear php artisan config:clear php artisan voyager:install --with-dummy

Now, everything works! 😃

@vanloc0301

DYNAMIC and COMPRESSED Row Formats:

When a table is created with ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED, InnoDB can store long variable-length column values (for VARCHAR, VARBINARY, and BLOB and TEXT types) fully off-page, with the clustered index record containing only a 20-byte pointer to the overflow page. InnoDB also encodes fixed-length fields greater than or equal to 768 bytes in length as variable-length fields. For example, a CHAR(255) column can exceed 768 bytes if the maximum byte length of the character set is greater than 3, as it is with utf8mb4.

UTF8MB4:

Laravel 5.4 uses the utf8mb4 character set by default, which includes support for storing “emojis” in the database. If you are upgrading your application from Laravel 5.3, you are not required to switch to this character set.

More : MySQL reference

@zanjs I have same issues like you.

I resolved my problem, from @marktopper in Slack:

Can you please try modifying the migration and replace.

$table->increments('id');

$table->string('table_name', 64);
$table->string('column_name', 64);
$table->integer('foreign_key')->unsigned();
$table->string('locale', 2);

$table->text('value');

$table->unique(['table_name', 'column_name', 'foreign_key', 'locale']);

$table->timestamps();

Great explain from @marktopper 👍

I will do some more calculations and figure out the best possible setup of that migrations. I just hate this kind of calculations. The thing is, that the unique key has the max length of 1000 (in your case, this differs upon database driver and version). The key is calculated by summing up the maximum possible key length of all the related columns. In this case this is table_name, column_name, foreign_key and locale. Before the column length of those was 255, 255, 11 and 255 (taken from the order above). The key length of those are the column length multiplied by the amount of bits available per character. For normal emoji support, it would be 3, to support all emojis it would be 4, this is defined by the charset and collation. And that is how to calculate the length of a unique key 🙂

@neerajsinghsonu Can you explain why using 'engine' => 'InnoDB ROW_FORMAT=DYNAMIC',?

Have only some people meet this issues?

Thanks.

I’ve done following to get rid of the issue-

Drop the tables in the database [every one, including the migration table]

1. composer dump-autoload -o
2. php artisan migrate

After some searching I found below solution and want to share it with you 1- set default string size in “app/Providers/AppServiceProvider.php” by adding \Schema::defaultStringLength(191); boot method Schema::defaultStringLength(191);

2- change charset and engine in “config/database.php” by replacing 'mysql' => [ 'driver' => 'mysql', 'host' => env('DB_HOST', '127.0.0.1'), 'port' => env('DB_PORT', '3306'), 'database' => env('DB_DATABASE', 'forge'), 'username' => env('DB_USERNAME', 'forge'), 'password' => env('DB_PASSWORD', ''), 'unix_socket' => env('DB_SOCKET', ''), 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'strict' => true, 'engine' => null, ], To
'mysql' => [ 'driver' => 'mysql', 'host' => env('DB_HOST', '127.0.0.1'), 'port' => env('DB_PORT', '3306'), 'database' => env('DB_DATABASE', 'forge'), 'username' => env('DB_USERNAME', 'forge'), 'password' => env('DB_PASSWORD', ''), 'unix_socket' => env('DB_SOCKET', ''), 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', 'strict' => true, 'engine' => 'InnoDB ROW_FORMAT=DYNAMIC', ],