in Education by
Symfony version: 3.1.3 Due to development reason suddenly my app giving the following error and I believe this can be detected using the error logs as below. Login error : Authentication request could not be processed due to a system problem. the /var/logs/dev.log logs it as bellow and looking to get rid this error [2016-09-02 12:40:05] request.INFO: Matched route "{route}". {"route":"fos_user_security_check","route_parameters":{"_controller":"FOS\\UserBundle\\Controller\\SecurityController::checkAction","_route":"fos_user_security_check"},"request_uri":"http://localhost/pie10-api/api/web/app_dev.php/login_check","method":"POST"} [] [2016-09-02 12:40:05] doctrine.DEBUG: SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.locked AS locked_9, t0.expired AS expired_10, t0.expires_at AS expires_at_11, t0.confirmation_token AS confirmation_token_12, t0.password_requested_at AS password_requested_at_13, t0.roles AS roles_14, t0.credentials_expired AS credentials_expired_15, t0.credentials_expire_at AS credentials_expire_at_16, t0.id AS id_17, t0.firstname AS firstname_18, t0.lastname AS lastname_19, t0.phoneNumber AS phoneNumber_20, t0.validationNumber AS validationNumber_21, t22.userId AS userId_23, t22.id AS id_24, t22.parentId AS parentId_25, t22.classId AS classId_26, t22.classId AS classId_27, t22.userId AS userId_28, t29.id AS id_30, t29.userId AS userId_31, t29.address AS address_32, t29.postCode AS postCode_33, t29.mobileNumber AS mobileNumber_34, t29.UserId AS UserId_35, t0.token AS token_36 FROM users t0 LEFT JOIN student t22 ON t22.userId = t0.id LEFT JOIN address t29 ON t29.UserId = t0.id WHERE t0.username_canonical = ? LIMIT 1 ["adminuser"] [] [2016-09-02 12:40:05] security.INFO: Authentication request failed. {"exception":"[object] (Symfony\\Component\\Security\\Core\\Exception\\AuthenticationServiceException(code: 0): An exception occurred while executing 'SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.locked AS locked_9, t0.expired AS expired_10, t0.expires_at AS expires_at_11, t0.confirmation_token AS confirmation_token_12, t0.password_requested_at AS password_requested_at_13, t0.roles AS roles_14, t0.credentials_expired AS credentials_expired_15, t0.credentials_expire_at AS credentials_expire_at_16, t0.id AS id_17, t0.firstname AS firstname_18, t0.lastname AS lastname_19, t0.phoneNumber AS phoneNumber_20, t0.validationNumber AS validationNumber_21, t22.userId AS userId_23, t22.id AS id_24, t22.parentId AS parentId_25, t22.classId AS classId_26, t22.classId AS classId_27, t22.userId AS userId_28, t29.id AS id_30, t29.userId AS userId_31, t29.address AS address_32, t29.postCode AS postCode_33, t29.mobileNumber AS mobileNumber_34, t29.UserId AS UserId_35, t0.token AS token_36 FROM users t0 LEFT JOIN student t22 ON t22.userId = t0.id LEFT JOIN address t29 ON t29.UserId = t0.id WHERE t0.username_canonical = ? LIMIT 1' with params [\"adminuser\"]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'pie10.address' doesn't exist at /var/www/html/pie10-api/api/vendor/symfony/symfony/src/Symfony/Component/Security/Core/Authentication/Provider/DaoAuthenticationProvider.php:94, Doctrine\\DBAL\\Exception\\TableNotFoundException(code: 0): An exception occurred while executing 'SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.locked AS locked_9, t0.expired AS expired_10, t0.expires_at AS expires_at_11, t0.confirmation_token AS confirmation_token_12, t0.password_requested_at AS password_requested_at_13, t0.roles AS roles_14, t0.credentials_expired AS credentials_expired_15, t0.credentials_expire_at AS credentials_expire_at_16, t0.id AS id_17, t0.firstname AS firstname_18, t0.lastname AS lastname_19, t0.phoneNumber AS phoneNumber_20, t0.validationNumber AS validationNumber_21, t22.userId AS userId_23, t22.id AS id_24, t22.parentId AS parentId_25, t22.classId AS classId_26, t22.classId AS classId_27, t22.userId AS userId_28, t29.id AS id_30, t29.userId AS userId_31, t29.address AS address_32, t29.postCode AS postCode_33, t29.mobileNumber AS mobileNumber_34, t29.UserId AS UserId_35, t0.token AS token_36 FROM users t0 LEFT JOIN student t22 ON t22.userId = t0.id LEFT JOIN address t29 ON t29.UserId = t0.id WHERE t0.username_canonical = ? LIMIT 1' with params [\"adminuser\"]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'pie10.address' doesn't exist at /var/www/html/pie10-api/api/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:53, Doctrine\\DBAL\\Driver\\PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pie10.address' doesn't exist at /var/www/html/pie10-api/api/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pie10.address' doesn't exist at /var/www/html/pie10-api/api/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} [] [2016-09-02 12:40:05] security.DEBUG: Authentication failure, redirect triggered. {"failure_path":"fos_user_security_login"} [] [2016-09-02 12:40:05] request.INFO: Matched route "{route}". {"route":"fos_user_security_login","route_parameters":{"_controller":"FOS\\UserBundle\\Controller\\SecurityController::loginAction","_route":"fos_user_security_login"},"request_uri":"http://localhost/pie10-api/api/web/app_dev.php/login","method":"GET"} [] [2016-09-02 12:40:05] security.INFO: Populated the TokenStorage with an anonymous Token. [] [] [2016-09-02 12:40:05] request.INFO: Matched route "{route}". {"route":"_wdt","route_parameters":{"_controller":"web_profiler.controller.profiler:toolbarAction","token":"c2f5ea","_route":"_wdt"},"request_uri":"http://localhost/pie10-api/api/web/app_dev.php/_wdt/c2f5ea","method":"GET"} [] and please let me know need any other development or file related information is needed JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

1 Answer

0 votes
by
In 3rd row of the log you provided there's info: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pie10.address' doesn't exist at /var/www/html/pie10-api/api/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:53, Doctrine\DBAL\Driver\PDOException(code: 42S02): Run Symfony's command: php app/console doctrine:schema:update --force to update your database schema.

Related questions

0 votes
    Registering members and allowing them to login (updating tables etc) all worked fine up until I made this change recently. ... , make the UserLevel 'Member'? Code for signing up:...
asked Apr 24, 2022 in Education by JackTerrance
0 votes
    I am beginner of JAVA and JSP. I am doing semester project on appengine. I have deployed project and ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jan 14, 2022 in Education by JackTerrance
0 votes
    I have multiple tables like make, model and year etc and using joins. I would like to search from ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jul 26, 2022 in Education by JackTerrance
0 votes
    I have multiple tables like make, model and year etc and using joins. I would like to search from ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jul 20, 2022 in Education by JackTerrance
0 votes
    Hello! Like in title. There is code example. Result is: Nulla eu aliquet sapien. Sed in sagittis ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 7, 2022 in Education by JackTerrance
0 votes
    Hello! Like in title. There is code example. Result is: Nulla eu aliquet sapien. Sed in sagittis ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 7, 2022 in Education by JackTerrance
0 votes
    I do know that PDO does not support multiple queries getting executed in one statement. I've been Googleing ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 1, 2022 in Education by JackTerrance
0 votes
    why it's not working.. i want to update my table in database this is my code. for ($i=0; ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 17, 2022 in Education by JackTerrance
0 votes
    I am looking to get row count to check if same email is already in database or not. i have tried ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 2, 2022 in Education by JackTerrance
0 votes
    I'm getting an error with this function: Controller $data['carSubwoofers'] = $this->db->get_where(" ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 24, 2022 in Education by JackTerrance
0 votes
    I'm pretty new at laravel, in fact and I'm trying to create my very first project. for some ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 27, 2022 in Education by JackTerrance
0 votes
    I need to create JWT token authentication, but I don't know how, could you explain me how to do ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 17, 2022 in Education by JackTerrance
0 votes
    When I try to open the Plesk Login Page via :8443 I get the Error: ERROR: Uncaught Error: Class ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 10, 2022 in Education by JackTerrance
0 votes
    I've got a Facebook application, but there is a problem with new users. When using the direct URL ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 2, 2022 in Education by JackTerrance
0 votes
    I get "Login failed error" with the Facebook Android SDK while running on the device. I have done ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 21, 2022 in Education by JackTerrance
...