When an error occurs creating the user the list of errors is not displayed

Question

When an error occurs creating the user the list of errors is not displayed

Navigation

#1 by (1 votes)
#2 by (0 votes)

2

Something is wrong with the registration of new users.

Here I have an attempt to create a user in which I have incorrectly entered the password confirmation. That should return me to the creator of the new user with a message in red indicating my error. But instead I see myself with this message:

On the contrary, if the data is correct, I can log in correctly.

Here is the php code of the view:

@extends('layouts.app')
@section('content')
<div class="container">
    <div class="row">
        <div class="col-md-8 col-md-offset-2">
            <div class="panel panel-default">
                <div class="panel-heading">Nuevo usuario</div>

                <div class="panel-body">
                    <form class="form-horizontal" method="POST" action="{{ route('register') }}">
                        {{ csrf_field() }}

                        <div class="form-group{{ $errors->has('name') ? ' has-error' : '' }}">
                            <label for="name" class="col-md-4 control-label">Nombre</label>

                            <div class="col-md-6">
                                <input id="name" type="text" class="form-control" name="name" value="{{ old('name') }}" required autofocus>

                                @if ($errors->has('name'))
                                    <span class="help-block">
                                        <strong>{{ $errors->first('name') }}</strong>
                                    </span>
                                @endif
                            </div>
                        </div>

                        <div class="form-group{{ $errors->has('email') ? ' has-error' : '' }}">
                            <label for="email" class="col-md-4 control-label">Correo electronico</label>

                            <div class="col-md-6">
                                <input id="email" type="email" class="form-control" name="email" value="{{ old('email') }}" required>

                                @if ($errors->has('email'))
                                    <span class="help-block">
                                        <strong>{{ $errors->first('email') }}</strong>
                                    </span>
                                @endif
                            </div>
                        </div>

                        <div class="form-group{{ $errors->has('password') ? ' has-error' : '' }}">
                            <label for="password" class="col-md-4 control-label">Contraseña (mínimo seis caracteres)</label>

                            <div class="col-md-6">
                                <input id="password" type="password" class="form-control" name="password" required>

                                @if ($errors->has('password'))
                                    <span class="help-block">
                                        <strong>{{ $errors->first('password') }}</strong>
                                    </span>
                                @endif
                            </div>
                        </div>

                        <div class="form-group">
                            <label for="password-confirm" class="col-md-4 control-label">Confirmar Contraseña</label>

                            <div class="col-md-6">
                                <input id="password-confirm" type="password" class="form-control" name="password_confirmation" required>
                            </div>
                        </div>

                        <div class="form-group">
                            <div class="col-md-6 col-md-offset-4">
                                <button type="submit" class="btn btn-primary">
                                    Registrarse
                                </button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

Edit: I do not know if it will help, but I found a file called RegisterController.php:

<?php

namespace App\Http\Controllers\Auth;

use App\User;
use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\Validator;
use Illuminate\Foundation\Auth\RegistersUsers;

class RegisterController extends Controller
{
    /*
    |--------------------------------------------------------------------------
    | Register Controller
    |--------------------------------------------------------------------------
    |
    | This controller handles the registration of new users as well as their
    | validation and creation. By default this controller uses a trait to
    | provide this functionality without requiring any additional code.
    |
    */

    use RegistersUsers;

    /**
     * Where to redirect users after registration.
     *
     * @var string
     */
    protected $redirectTo = '/home';

    /**
     * Create a new controller instance.
     *
     * @return void
     */
    public function __construct()
    {
        $this->middleware('guest');
    }

    /**
     * Get a validator for an incoming registration request.
     *
     * @param  array  $data
     * @return \Illuminate\Contracts\Validation\Validator
     */
    protected function validator(array $data)
    {
        return Validator::make($data, [
            'name' => 'required|string|max:255',
            'email' => 'required|string|email|max:255|unique:users',
            'password' => 'required|string|min:6|confirmed',
        ]);
    }

    /**
     * Create a new user instance after a valid registration.
     *
     * @param  array  $data
     * @return \App\User
     */
    protected function create(array $data)
    {
        return User::create([
            'name' => $data['name'],
            'email' => $data['email'],
            'password' => bcrypt($data['password']),
        ]);
    }
}

See if this helps to find out where the bug is.

I will also leave several data on the User table in case it ends up serving to see where the error is.

User.php:

<?php

namespace App;

use Illuminate\Notifications\Notifiable;
use Illuminate\Foundation\Auth\User as Authenticatable;

class User extends Authenticatable{
    use Notifiable;

    protected $fillable = [
        'name', 'email', 'password', 'saldo', 'papel',
    ];

    protected $hidden = [
        'password', 'remember_token',
    ];

    public function comentarios(){
        return $this->hasMany(Comentario::class,'miembro');
    }

    public function tickets(){
        return $this->hasMany(Entrada::class,'persona');
    }
}

create_users_table.php:

<?php

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

class CreateUsersTable extends Migration{
    public function up(){
        Schema::create('users', function (Blueprint $table){
            $table->increments('id');
            $table->string('name');
            $table->string('email')->unique();
            $table->string('password');
            $table->rememberToken();
            $table->timestamps();
        });

        Schema::table('users', function (Blueprint $table){
            $table->integer('saldo')->nullable();
            $table->string('rol')->nullable(); // Habra 2 opciones: Cliente o Administrador.
        });
    }

    public function down(){
        Schema::dropIfExists('users');
    }
}

UserController.php:

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\plantas;
use App\User;
use App\Comentario;
use App\Entrada;
use Illuminate\Support\Facades\Auth;

class UserController extends Controller{
    public function formulario(){
        return view('formularios.saldo');
    }

    public function store(Request $request){
        $normas=[
            'saldo' => 'required',
        ];

        $this->validate($request,$normas);

        if(empty(Auth::user()->saldo))
            Auth::user()->saldo=$request->saldo;
        else    
            Auth::user()->saldo+=$request->saldo;
        Auth::user()->save();
        return redirect('/')->with('message', ['success', __("Su ingreso se ha efectuado con exito.")]);
    }

    public function elegir(){
        return view('formularios.rolificacion');
    }

    public function acto(Request $request){
        $normas=[
            'rol' => 'required',
        ];

        $this->validate($request,$normas);

        $d=$request->rol;

        if($d=="administrador" && (is_null($request->clave) || $request->clave!='BaSuReRo2014')){
            Auth::user()->rol='botones';
            Auth::user()->save();
            return redirect('/')->with('message', ['danger', __("¡VEAMOS SI TE RIES AHORA!")]);
        }
        else{
            Auth::user()->rol=$d;
            Auth::user()->save();
            return redirect('/')->with('message', ['success', __("Rol seleccionado correctamente.")]);
        }
    }

    public function cliente(){
        $cliente=User::paginate(5);
        return view('vegetal.cliente', compact('cliente'));
    }

    public function eliminado(User $cliente){
        $comentario=$cliente->comentarios()->with('usuario')->paginate(5);
        foreach($comentario as $com)
            Comentario::destroy($com->id);

        $entrada=$cliente->tickets()->with('cliente')->paginate(5);
        foreach($entrada as $ent)
            Entrada::destroy($ent->id);

        User::destroy($cliente->id);
        return back()->with('message', ['success', __("El cliente elegido ha sido eliminado.")]);
    }
}

Another thing, I tried to go to .env and put APP_DEBUG = false. After this, I have done several tests in which I have caused errors in various forms and always end in this message:

Finally, here is this app / Exceptions / Handler.php:

<?php

namespace App\Exceptions;

use Exception;
use Illuminate\Foundation\Exceptions\Handler as ExceptionHandler;

class Handler extends ExceptionHandler{
    protected $dontReport = [
        //
    ];

    protected $dontFlash = [
        'password',
        'password_confirmation',
    ];

    protected function toIlluminateResponse($response, Exception $e)
    {
        $response = new Response($response->getContent(), $response->getStatusCode(), $response->headers->all());

        $response->exception = $e;

        return $response;
    }

    protected function convertValidationExceptionToResponse(ValidationException $e, $request){
        $response = parent::convertValidationExceptionToResponse($e, $request);
        if ($response instanceof JsonResponse) {
            $original = $response->getOriginalContent();
            $original['message'] = __($original['message']);
            $response->setContent(json_encode($original));
        }
        return $response;
    }

    public function report(Exception $exception){
        parent::report($exception);
    }

        public function render($request, Exception $e){
        if (config('app.debug')) {
            $whoops = new \Whoops\Run;
            $whoops->pushHandler(new \Whoops\Handler\PrettyPageHandler);
            return response()->make(
                $whoops->handleException($e),
                method_exists($e, 'getStatusCode') ? $e->getStatusCode() : 500,
                method_exists($e, 'getHeaders') ? $e->getHeaders() : []
            );
        }
        return parent::convertExceptionToResponse($e);
    }
}

Edit: I've already found an example in laravel.logs. It is when introducing a plant by form leaving the comment variable null.

[2018-02-23 14:22:43] local.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'comentario' cannot be null (SQL: insert into 'comentarios' ('planta', 'comentario', 'miembro', 'updated_at', 'created_at') values (3, , 6, 2018-02-23 14:22:43, 2018-02-23 14:22:43)) {"userId":6,"email":"[email protected]","exception":"[object] (Illuminate\Database\QueryException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'comentario' cannot be null (SQL: insert into 'comentarios' ('planta', 'comentario', 'miembro', 'updated_at', 'created_at') values (3, , 6, 2018-02-23 14:22:43, 2018-02-23 14:22:43)) at C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Database\Connection.php:664, PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'comentario' cannot be null at C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Database\Connection.php:458)
[stacktrace]
#0 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Database\Connection.php(624): Illuminate\Database\Connection->runQueryCallback('insert into 'co...', Array, Object(Closure))
#1 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Database\Connection.php(459): Illuminate\Database\Connection->run('insert into 'co...', Array, Object(Closure))
#2 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Database\Connection.php(411): Illuminate\Database\Connection->statement('insert into 'co...', Array)
#3 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Database\Query\Processors\Processor.php(32): Illuminate\Database\Connection->insert('insert into 'co...', Array)
#4 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2147): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into 'co...', Array, 'id')
#5 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(1281): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#6 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(722): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#7 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(687): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#8 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(550): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#9 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(753): Illuminate\Database\Eloquent\Model->save()
#10 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Support\helpers.php(1038): Illuminate\Database\Eloquent\Builder->Illuminate\Database\Eloquent\{closure}(Object(App\Comentario))
#11 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(754): tap(Object(App\Comentario), Object(Closure))
#12 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(1470): Illuminate\Database\Eloquent\Builder->create(Array)
#13 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(1482): Illuminate\Database\Eloquent\Model->__call('create', Array)
#14 C:\xampp\htdocs\flora\app\Http\Controllers\ComentarioController.php(16): Illuminate\Database\Eloquent\Model::__callStatic('create', Array)
#15 [internal function]: App\Http\Controllers\ComentarioController->store(Object(Illuminate\Http\Request))
#16 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Controller.php(54): call_user_func_array(Array, Array)
#17 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction('store', Array)
#18 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Route.php(212): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\ComentarioController), 'store')
#19 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Route.php(169): Illuminate\Routing\Route->runController()
#20 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Router.php(658): Illuminate\Routing\Route->run()
#21 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#22 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Middleware\SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#23 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#24 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#25 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\VerifyCsrfToken.php(67): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#26 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#27 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#28 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\View\Middleware\ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#29 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#30 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#31 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php(63): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#32 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#33 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#34 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#35 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#36 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#37 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#38 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#39 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#40 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#41 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Router.php(660): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#42 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Router.php(635): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#43 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Router.php(601): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route))
#44 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Router.php(590): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#45 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(176): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#46 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#47 C:\xampp\htdocs\flora\vendor\barryvdh\laravel-debugbar\src\Middleware\InjectDebugbar.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#48 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Barryvdh\Debugbar\Middleware\InjectDebugbar->handle(Object(Illuminate\Http\Request), Object(Closure))
#49 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#50 C:\xampp\htdocs\flora\vendor\fideloper\proxy\src\TrustProxies.php(56): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#51 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
#52 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#53 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#54 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#55 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#56 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#57 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#58 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#59 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\ValidatePostSize.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#60 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure))
#61 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#62 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#63 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#64 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#65 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#66 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#67 C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#68 C:\xampp\htdocs\flora\public\index.php(55): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#69 {main}
"}

php laravel laravel-5

asked by Miguel Alparez 22.02.2018 в 21:20

source

2 answers

Obtain object with Linq with its references How to compile pug (before jade) to php with gulp?

score 1 · Answer 1

Laravel by default delivers exceptions when there is "any" type of error, in this case it is a validation error, unless otherwise specified.

In this case, in the app / Exceptions / Handler.php file you have a protected property used to include the types of exceptions that should not generate responses or reports:

protected $dontReport = [
    //
];

In every project, the types of exceptions that do not want to be reported are usually defined, a typical example is this, based on the same Laravel code:

protected $dontReport = [
    AuthenticationException::class,
    AuthorizationException::class,
    HttpException::class,
    HttpResponseException::class,
    ModelNotFoundException::class,
    TokenMismatchException::class,
    ValidationException::class,
];

There you can see the type of exception ValidationException , which is what concerns us.

score 0 · Answer 2

In response to:

Edit: I've already found an example in laravel.logs. It is when introducing one plant per form leaving the null comment variable.

and the error:

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'comentario' cannot be null (SQL: insert into 'comentarios' ('planta', 'comentario', 'miembro', 'updated_at', 'created_at') values (3, , 6, 2018-02-23 14:22:43, 2018-02-23 14:22:43)) {"userId":6,"email":"[email protected]","exception":"[object] (Illuminate\Database\QueryException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'comentario' cannot be null (SQL: insert into 'comentarios' ('planta', 'comentario', 'miembro', 'updated_at', 'created_at') values (3, , 6, 2018-02-23 14:22:43, 2018-02-23 14:22:43)) at C:\xampp\htdocs\flora\vendor\laravel\framework\src\Illuminate\Database\Connection.php:664

As it appears at the beginning of the error message, you are violating a condition (or restriction) established in your data model, you can not create / update a record in the "comments" table with a null value for the "comment" field ", you have to load an acceptable value according to the" design of the table ". Although I do not see that you have put related code in the question you should, the solution would be to check the entry, so that this condition is fulfilled before trying to insert / update the DB, or deal with the error situation otherwise, for example by returning to the data entry form with a feedback message to the user.

Greetings.