I'm trying to change the data type (from string to boolean) of 5 columns in my database, but it's showing an error that i have no idea what is the meaning. My migration is this:
<?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class ChangeFieldDataType extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::table('users', function (Blueprint $table) { $table->boolean('categoria_pneu')->change(); $table->boolean('categoria_dicas')->change(); $table->boolean('categoria_servicos')->change(); $table->boolean('categoria_dicas_gerais')->change(); $table->boolean('categoria_variados')->change(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('users', function (Blueprint $table) { $table->dropColumn('categoria_pneu'); $table->dropColumn('categoria_dicas'); $table->dropColumn('categoria_servicos'); $table->dropColumn('categoria_dicas_gerais'); $table->dropColumn('categoria_variados'); }); } } The erros that's showing, is this: 
I don't know what is the meaning of the error, since i'm trying to change the type to BOOLEAN and not TINYINT (i don't actually know if it's the same...)
booleanandtinyintare the same (assuming this is MySQL from the error). Is the database empty when running this migration? Also, what datatype are the columns changing from?TRUNCATED incorrect integer value '',''isn't a valid value for atinyintcolumn. You might need to add an extra column, write a script to map the old values to this new column/type, then a migration to drop the old column (or similar). Or, if the values don't need to map over, empty them first (UPDATE column SET value = NULLfor all 5 columns, then run the migration)