Laravel 5中执行Model :: create时的QueryException-Java 学习之路

我是Laravel的新手 . 在我的项目中，有一个名为Student的模型和MySQL学生中的表 .

当我尝试使用Student :: create向数据库插入一些值时，它会给我以下错误 .

数据库表存在，我之前从另一个表中检索了一些值 .

我在控制器中的插入代码：

Student::create([
    'name' => Input::get('student_name'),
    'email' => Input::get('student_email',
    'contact' => Input::get('student_tel'),
    'reg_id' => Input::get('registration_no'),
    'password' => Hash::make(Input::get('password'))
]);

我的模型类：

<?php namespace App;

use Illuminate\Database\Eloquent\Model;

class Student extends Model {

    protected $table = 'student';
    protected $fillable = ['name', 'email', 'contact', 'username', 'password'];    
}

Complete Error for QueryException

Connection.php第620行中的QueryException：SQLSTATE [42S02]：未找到基表或视图：1146表'msc_project.tablename'不存在（SQL：选择count（*）作为tablename中的聚合，其中registration_no = asgfsag）

``**in Connection.php line 620
at Connection->runQueryCallback('select count(*) as aggregate from `tablename` where `registration_no` = ?', array('ffhfdh'), object(Closure)) in Connection.php line 576
at Connection->run('select count(*) as aggregate from `tablename` where `registration_no` = ?', array('ffhfdh'), object(Closure)) in Connection.php line 293
at Connection->select('select count(*) as aggregate from `tablename` where `registration_no` = ?', array('ffhfdh'), true) in Builder.php line 1377
at Builder->runSelect() in Builder.php line 1367
at Builder->getFresh(array('*')) in Builder.php line 1354
at Builder->get(array('*')) in Builder.php line 1636
at Builder->aggregate('count', array('*')) in Builder.php line 1574
at Builder->count() in DatabasePresenceVerifier.php line 57
at DatabasePresenceVerifier->getCount('tablename', 'registration_no', 'ffhfdh', null, null, array()) in Validator.php line 1057
at Validator->validateUnique('registration_no', 'ffhfdh', array('tablename'), object(Validator)) in Validator.php line 372
at Validator->validate('registration_no', 'unique:tablename') in Validator.php line 325
at Validator->passes() in Validator.php line 347
at Validator->fails() in StudentController.php line 56
at StudentController->doRegistration()
at call_user_func_array(array(object(StudentController), 'doRegistration'), array()) in Controller.php line 246
at Controller->callAction('doRegistration', array()) in ControllerDispatcher.php line 162
at ControllerDispatcher->call(object(StudentController), object(Route), 'doRegistration') in ControllerDispatcher.php line 107
at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101
at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 108
at ControllerDispatcher->callWithinStack(object(StudentController), object(Route), object(Request), 'doRegistration') in ControllerDispatcher.php line 67
at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\StudentController', 'doRegistration') in Route.php line 198
at Route->runWithCustomDispatcher(object(Request)) in Route.php line 131
at Route->run(object(Request)) in Router.php line 691
at Router->Illuminate\Routing\{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101
at Pipeline->then(object(Closure)) in Router.php line 693
at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 660
at Router->dispatchToRoute(object(Request)) in Router.php line 618
at Router->dispatch(object(Request)) in Kernel.php line 210
at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in VerifyCsrfToken.php line 43
at VerifyCsrfToken->handle(object(Request), object(Closure)) in VerifyCsrfToken.php line 17
at VerifyCsrfToken->handle(object(Request), object(Closure)) in Pipeline.php line 125
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in ShareErrorsFromSession.php line 55
at ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 125
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in StartSession.php line 61
at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 125
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 36
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 125
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in EncryptCookies.php line 40
at EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 125
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in CheckForMaintenanceMode.php line 42
at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 125
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101
at Pipeline->then(object(Closure)) in Kernel.php line 111
at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 84
at Kernel->handle(object(Request)) in index.php line 53
at require_once('/home/pranavaghanan/Documents/GitHub Projects/MScApp/public/index.php') in server.php line 21

Complete Error List for PDOException

Connection.php第288行中的PDOException：SQLSTATE [42S02]：未找到基表或视图：1146表'msc_project.tablename'不存在

in Connection.php line 288
at PDO->prepare('select count(*) as aggregate from `tablename` where `registration_no` = ?') in Connection.php line 288
at Connection->Illuminate\Database\{closure}(object(MySqlConnection), 'select count(*) as aggregate from `tablename` where `registration_no` = ?', array('ffhfdh')) in Connection.php line 612
at Connection->runQueryCallback('select count(*) as aggregate from `tablename` where `registration_no` = ?', array('ffhfdh'), object(Closure)) in Connection.php line 576
at Connection->run('select count(*) as aggregate from `tablename` where `registration_no` = ?', array('ffhfdh'), object(Closure)) in Connection.php line 293
at Connection->select('select count(*) as aggregate from `tablename` where `registration_no` = ?', array('ffhfdh'), true) in Builder.php line 1377
at Builder->runSelect() in Builder.php line 1367
at Builder->getFresh(array('*')) in Builder.php line 1354
at Builder->get(array('*')) in Builder.php line 1636
at Builder->aggregate('count', array('*')) in Builder.php line 1574
at Builder->count() in DatabasePresenceVerifier.php line 57
at DatabasePresenceVerifier->getCount('tablename', 'registration_no', 'ffhfdh', null, null, array()) in Validator.php line 1057
at Validator->validateUnique('registration_no', 'ffhfdh', array('tablename'), object(Validator)) in Validator.php line 372
at Validator->validate('registration_no', 'unique:tablename') in Validator.php line 325
at Validator->passes() in Validator.php line 347
at Validator->fails() in StudentController.php line 56
at StudentController->doRegistration()
at call_user_func_array(array(object(StudentController), 'doRegistration'), array()) in Controller.php line 246
at Controller->callAction('doRegistration', array()) in ControllerDispatcher.php line 162
at ControllerDispatcher->call(object(StudentController), object(Route), 'doRegistration') in ControllerDispatcher.php line 107
at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101
at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 108
at ControllerDispatcher->callWithinStack(object(StudentController), object(Route), object(Request), 'doRegistration') in ControllerDispatcher.php line 67
at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\StudentController', 'doRegistration') in Route.php line 198
at Route->runWithCustomDispatcher(object(Request)) in Route.php line 131
at Route->run(object(Request)) in Router.php line 691
at Router->Illuminate\Routing\{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101
at Pipeline->then(object(Closure)) in Router.php line 693
at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 660
at Router->dispatchToRoute(object(Request)) in Router.php line 618
at Router->dispatch(object(Request)) in Kernel.php line 210
at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in VerifyCsrfToken.php line 43
at VerifyCsrfToken->handle(object(Request), object(Closure)) in VerifyCsrfToken.php line 17
at VerifyCsrfToken->handle(object(Request), object(Closure)) in Pipeline.php line 125
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in ShareErrorsFromSession.php line 55
at ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 125
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in StartSession.php line 61
at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 125
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 36
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 125
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in EncryptCookies.php line 40
at EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 125
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in CheckForMaintenanceMode.php line 42
at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 125
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101
at Pipeline->then(object(Closure)) in Kernel.php line 111
at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 84
at Kernel->handle(object(Request)) in index.php line 53
at require_once('/home/pranavaghanan/Documents/GitHub Projects/MScApp/public/index.php') in server.php line 21

UPDATE :

我刚刚发现，当注释掉用于验证的代码时，数据会进入数据库 . 知道为什么这条线导致错误？

$validator = \Validator::make($postedData, $rules, $messages);
if ($validator->fails()) { 
    return Redirect::to('registration')->withInput()->withErrors($validator); 
}

如果我不使用\ Validator它也不接受该类 .

Laravel 5中执行Model :: create时的QueryException

相关问题