Whoops, looks like something went wrong. 3/3 QueryException in Connection.php line 770: SQLSTATE[HY000]: General error: 1364 Field 'login' doesn't have a default value (SQL: insert into `users` (`name`, `email`, `password`, `updated_at`, `created_at`) values (BOSSPROGRAMMIST2, BOSSPROGRAMMIST2@com.com, $2y$10$.8ohtip5i8RR7naEZw4bUeOVJk6vvBZp7YnIEcLz9V8h/itO86wmi, 2021-02-26 09:40:52, 2021-02-26 09:40:52)) in Connection.php line 770 at Connection->runQueryCallback('insert into `users` (`name`, `email`, `password`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?)', array('BOSSPROGRAMMIST2', 'BOSSPROGRAMMIST2@com.com', '$2y$10$.8ohtip5i8RR7naEZw4bUeOVJk6vvBZp7YnIEcLz9V8h/itO86wmi', '2021-02-26 09:40:52', '2021-02-26 09:40:52'), object(Closure)) in Connection.php line 726 at Connection->run('insert into `users` (`name`, `email`, `password`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?)', array('BOSSPROGRAMMIST2', 'BOSSPROGRAMMIST2@com.com', '$2y$10$.8ohtip5i8RR7naEZw4bUeOVJk6vvBZp7YnIEcLz9V8h/itO86wmi', '2021-02-26 09:40:52', '2021-02-26 09:40:52'), object(Closure)) in Connection.php line 481 at Connection->statement('insert into `users` (`name`, `email`, `password`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?)', array('BOSSPROGRAMMIST2', 'BOSSPROGRAMMIST2@com.com', '$2y$10$.8ohtip5i8RR7naEZw4bUeOVJk6vvBZp7YnIEcLz9V8h/itO86wmi', '2021-02-26 09:40:52', '2021-02-26 09:40:52')) in Connection.php line 435 at Connection->insert('insert into `users` (`name`, `email`, `password`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?)', array('BOSSPROGRAMMIST2', 'BOSSPROGRAMMIST2@com.com', '$2y$10$.8ohtip5i8RR7naEZw4bUeOVJk6vvBZp7YnIEcLz9V8h/itO86wmi', '2021-02-26 09:40:52', '2021-02-26 09:40:52')) in Processor.php line 32 at Processor->processInsertGetId(object(Builder), 'insert into `users` (`name`, `email`, `password`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?)', array('BOSSPROGRAMMIST2', 'BOSSPROGRAMMIST2@com.com', '$2y$10$.8ohtip5i8RR7naEZw4bUeOVJk6vvBZp7YnIEcLz9V8h/itO86wmi', '2021-02-26 09:40:52', '2021-02-26 09:40:52'), 'id') in Builder.php line 2154 at Builder->insertGetId(array('BOSSPROGRAMMIST2', 'BOSSPROGRAMMIST2@com.com', '$2y$10$.8ohtip5i8RR7naEZw4bUeOVJk6vvBZp7YnIEcLz9V8h/itO86wmi', '2021-02-26 09:40:52', '2021-02-26 09:40:52'), 'id') in Builder.php line 1470 at Builder->__call('insertGetId', array(array('name' => 'BOSSPROGRAMMIST2', 'email' => 'BOSSPROGRAMMIST2@com.com', 'password' => '$2y$10$.8ohtip5i8RR7naEZw4bUeOVJk6vvBZp7YnIEcLz9V8h/itO86wmi', 'updated_at' => '2021-02-26 09:40:52', 'created_at' => '2021-02-26 09:40:52'), 'id')) in Model.php line 1609 at Model->insertAndSetId(object(Builder), array('name' => 'BOSSPROGRAMMIST2', 'email' => 'BOSSPROGRAMMIST2@com.com', 'password' => '$2y$10$.8ohtip5i8RR7naEZw4bUeOVJk6vvBZp7YnIEcLz9V8h/itO86wmi', 'updated_at' => '2021-02-26 09:40:52', 'created_at' => '2021-02-26 09:40:52')) in Model.php line 1574 at Model->performInsert(object(Builder)) in Model.php line 1471 at Model->save() in Model.php line 561 at Model::create(array('name' => 'BOSSPROGRAMMIST2', 'login' => 'BOSSPROGRAMMIST2', 'email' => 'BOSSPROGRAMMIST2@com.com', 'password' => '$2y$10$.8ohtip5i8RR7naEZw4bUeOVJk6vvBZp7YnIEcLz9V8h/itO86wmi')) in RegisterController.php line 71 at RegisterController->create(array('_token' => '5zwGbHg3OggVnEamWcMkbALAoUhJLpnZBTjwQLv4', 'name' => 'BOSSPROGRAMMIST2', 'login' => 'BOSSPROGRAMMIST2', 'email' => 'BOSSPROGRAMMIST2@com.com', 'password' => 'BOSSPROGRAMMIST2', 'password_confirmation' => 'BOSSPROGRAMMIST2')) in RegistersUsers.php line 33 at RegisterController->register(object(Request)) at call_user_func_array(array(object(RegisterController), 'register'), array(object(Request))) in Controller.php line 55 at Controller->callAction('register', array(object(Request))) in ControllerDispatcher.php line 44 at ControllerDispatcher->dispatch(object(Route), object(RegisterController), 'register') in Route.php line 189 at Route->runController() in Route.php line 144 --- Добавлено --- at Route->run(object(Request)) in Router.php line 653 at Router->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 53 at Pipeline->Illuminate\Routing\{closure}(object(Request)) in RedirectIfAuthenticated.php line 24 at RedirectIfAuthenticated->handle(object(Request), object(Closure)) in Pipeline.php line 137 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33 at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Mymiddleware.php line 29 at Mymiddleware->handle(object(Request), object(Closure)) in Pipeline.php line 137 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33 at Pipeline->Illuminate\Routing\{closure}(object(Request)) in SubstituteBindings.php line 41 at SubstituteBindings->handle(object(Request), object(Closure)) in Pipeline.php line 137 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33 at Pipeline->Illuminate\Routing\{closure}(object(Request)) in VerifyCsrfToken.php line 65 at VerifyCsrfToken->handle(object(Request), object(Closure)) in Pipeline.php line 137 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33 at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ShareErrorsFromSession.php line 49 at ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 137 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33 at Pipeline->Illuminate\Routing\{closure}(object(Request)) in StartSession.php line 64 at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 137 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33 at Pipeline->Illuminate\Routing\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37 at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 137 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33 at Pipeline->Illuminate\Routing\{closure}(object(Request)) in EncryptCookies.php line 59 at EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 137 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33 at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 104 at Pipeline->then(object(Closure)) in Router.php line 655 at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 629 at Router->dispatchToRoute(object(Request)) in Router.php line 607 at Router->dispatch(object(Request)) in Kernel.php line 268 at Kernel->Illuminate\Foundation\Http\{closure}(object(Request)) in Pipeline.php line 53 at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckForMaintenanceMode.php line 46 at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 137 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33 at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 104 at Pipeline->then(object(Closure)) in Kernel.php line 150 at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 117 at Kernel->handle(object(Request)) in index.php line 53
Ругается на то, что у поля 'login' в таблице, которую пытаетесь добавить запись, нет значения по-умолчанию и наверняка оно не может иметь значение null. Найдите в этом перечислении полей, которым задаются явные значения в операторе вставки поле 'login':
я указал , но тогда ошибка другая Sorry, the page you are looking for could not be found. 1/1 NotFoundHttpException in RouteCollection.php line 161: in RouteCollection.php line 161 at RouteCollection->match(object(Request)) in Router.php line 766 at Router->findRoute(object(Request)) in Router.php line 621 at Router->dispatchToRoute(object(Request)) in Router.php line 607 at Router->dispatch(object(Request)) in Kernel.php line 268 at Kernel->Illuminate\Foundation\Http\{closure}(object(Request)) in Pipeline.php line 53 at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckForMaintenanceMode.php line 46 at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 137 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33 at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 104 at Pipeline->then(object(Closure)) in Kernel.php line 150 at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 117 at Kernel->handle(object(Request)) in index.php line 53
Где указал? --- Добавлено --- @boss1, посмотри трассировку в первом сообщении. Если для (п.12) Model::create login присутствует, то при выполненнии (п.9) Model->insertAndSetId уже нет. Потерялся где-то И надо ли выполнять performInsert() после Model->save()?
PHP: <?php namespace App; use Illuminate\Notifications\Notifiable; use Illuminate\Foundation\Auth\User as Authenticatable; use App\Country; use App\Role; class User extends Authenticatable { use Notifiable; /** * The attributes that are mass assignable. * * @var array */ protected $fillable = [ 'name', 'email', 'password','login' ]; /** * The attributes that should be hidden for arrays. * * @var array */ protected $hidden = [ 'password', 'remember_token', ]; public function country() { return $this->hasOne('App\Country','user_id','id');// user_id } public function articles() { return $this->hasMany('App\Article'); } public function roles() { return $this->belongsToMany('App\Role'); } } здесь --- Добавлено --- PHP: protected $fillable = [ 'name', 'email', 'password','login' ];
Так-то речь идёт о регистрации пользователя (раз уж вставляем записи в таблицу users), а не об аутентификации (проверке существования пользователя с указанными логином/е-мэйлом/другим_уникальным_идентификатором и паролем_2ФА) и авторизации (предоставлении доступа к объекту/данным/и_прочему_подобному).
для начала - основы PHP потом основы Laravel ну и какой то минимум английского или гуглопереводчик - обязательно Если перевести ошибку, и понимать как устроен роутинг в Ларавель - то становится понятно, что ошибка где в роутах конкретнее ошибка не покажет тут пишите - какой роут пытаетесь посетить, покажите ваши роуты итд
основы PHP - учил --- Добавлено --- PHP: <?php /* |-------------------------------------------------------------------------- | Web Routes |-------------------------------------------------------------------------- | | Here is where you can register web routes for your application. These | routes are loaded by the RouteServiceProvider within a group which | contains the "web" middleware group. Now create something great! | */ //Route::get('/', function () { // return view('welcome'); //}); Route::get('/', ['as'=>'home','uses'=>'Admin\IndexController@show']); Route::get('/about',['uses'=>'Admin\AboutController@show','as'=>'about']); Route::get('/articles',['uses'=>'Admin\Core@getArticles','as'=>'articles']); //Route::get('/article/{id}',[/*'middleware'=>'mymiddle:home',*/'uses'=>'Admin\Core@getArticle','as'=>'article'])/*->middleware(['mymiddle'])*/; Route::get('/article/{id}',['uses'=>'Admin\Core@getArticle','as'=>'article']); //Route::match(['get','post'],'/contact/{name?}',['uses'=>'Admin\ContactController@show','as'=>'contact']); Route::get('/contact',['middleware' => ['auth'],'uses'=>'Admin\ContactController@show','as'=>'contact']); Route::post('/contact',['uses'=>'Admin\ContactController@store']); //Route::auth(); Route::group(['prefix'=>'admin','middleware'=>['web']],function() { // admin/ Route::get('/',['uses'=>'Admin\AdminController@show','as'=>'admin_index']); Route::get('/add/post',['uses'=>'Admin\AdminPostController@create','as'=>'admin_add_post']); }); //Route::match(['get','post'],'/contact/{name?}',['uses'=>'Admin\ContactController@show','as'=>'contact']); //Route::match(['get','post'],'/contact/{id?}',['uses'=>'Admin\ContactController@show','as'=>'contact']); //Route::get('/about/{id}','FirstController@show'); //Route::get('/about','FirstController@show'); //Route::get('/articles',['uses'=>'Admin\Core@getArticles','as'=>'articles']); //Route::get('/article/{id}',['uses'=>'Admin\Core@getArticle','as'=>'article']); //list pages //Route::resource('/pages','Admin\CoreResource');//pages.index pages.store //Route::resource('/pages','Admin\CoreResource',['except'=>['index','show']]);//pages.index pages.store //Route::get('pages/add','Admin\CoreResource@add'); //Route::resource('/pages','Admin\CoreResource',['except'=>['index','show']]);//pages.index pages.store //Route::controller('/pages','PagesController'); //Route::controller('/pages','PagesController',['getCreate'=>'pages.create']); // // //Route::get('/article/{page}',['middleware'=>'mymiddle:home','uses'=>'Admin\Core@getArticle','as'=>'article'])/*->middleware(['mymiddle'])*/; // //Route::get('/pages', [PagesController::class, 'getIndex']); Route::auth(); // admin/edit/post Route::group(['prefix'=>'admin','middleware'=>['web']],function() { // admin/ Route::get('/',['uses'=>'Admin\AdminController@show','as'=>'admin_index']); Route::get('/add/post',['uses'=>'Admin\AdminPostController@create','as'=>'admin_add_post']); }); //Route::group(['middleware' => 'web'], function () { // Route::auth(); // // Route::get('/home', 'HomeController@index'); //}); // //Auth::routes(); // //Route::get('/home', 'HomeController@index'); мои роуты --- Добавлено --- Это на странице регистрации пользователя
блин.. каменты стандартные и закоментированные строки зачем нам? Ну а вы какой роут вызываете? Имхо - рано вам лишь с основами в Ларавель лезть
И что - яснее не стало? Ведь у вас нет этого роута, ну нету!!! // Комментирует строку... Php не видит ее, даже редактор тут серым подсвечивает
Route::get('/',['uses'=>'Admin\AdminController@show','as'=>'admin_index']); Это не он? --- Добавлено --- спасибо кэп получилось PHP: Route::group(['middleware' => 'web'], function () { Route::auth(); Route::get('/home', 'HomeController@index'); });