symfony version: 3.1.3
due development reason app giving following error , believe can detected using error logs below.
login error : authentication request not processed due system problem.
the /var/logs/dev.log logs bellow , looking rid 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 username_1, t0.username_canonical username_canonical_2, t0.email email_3, t0.email_canonical email_canonical_4, t0.enabled enabled_5, t0.salt salt_6, t0.password password_7, t0.last_login last_login_8, t0.locked locked_9, t0.expired expired_10, t0.expires_at expires_at_11, t0.confirmation_token confirmation_token_12, t0.password_requested_at password_requested_at_13, t0.roles roles_14, t0.credentials_expired credentials_expired_15, t0.credentials_expire_at credentials_expire_at_16, t0.id id_17, t0.firstname firstname_18, t0.lastname lastname_19, t0.phonenumber phonenumber_20, t0.validationnumber validationnumber_21, t22.userid userid_23, t22.id id_24, t22.parentid parentid_25, t22.classid classid_26, t22.classid classid_27, t22.userid userid_28, t29.id id_30, t29.userid userid_31, t29.address address_32, t29.postcode postcode_33, t29.mobilenumber mobilenumber_34, t29.userid userid_35, t0.token token_36 users t0 left join student t22 on t22.userid = t0.id left join address t29 on t29.userid = t0.id 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): exception occurred while executing 'select t0.username username_1, t0.username_canonical username_canonical_2, t0.email email_3, t0.email_canonical email_canonical_4, t0.enabled enabled_5, t0.salt salt_6, t0.password password_7, t0.last_login last_login_8, t0.locked locked_9, t0.expired expired_10, t0.expires_at expires_at_11, t0.confirmation_token confirmation_token_12, t0.password_requested_at password_requested_at_13, t0.roles roles_14, t0.credentials_expired credentials_expired_15, t0.credentials_expire_at credentials_expire_at_16, t0.id id_17, t0.firstname firstname_18, t0.lastname lastname_19, t0.phonenumber phonenumber_20, t0.validationnumber validationnumber_21, t22.userid userid_23, t22.id id_24, t22.parentid parentid_25, t22.classid classid_26, t22.classid classid_27, t22.userid userid_28, t29.id id_30, t29.userid userid_31, t29.address address_32, t29.postcode postcode_33, t29.mobilenumber mobilenumber_34, t29.userid userid_35, t0.token token_36 users t0 left join student t22 on t22.userid = t0.id left join address t29 on t29.userid = t0.id t0.username_canonical = ? limit 1' params [\"adminuser\"]:\n\nsqlstate[42s02]: base table or view not found: 1146 table 'pie10.address' doesn't exist @ /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): exception occurred while executing 'select t0.username username_1, t0.username_canonical username_canonical_2, t0.email email_3, t0.email_canonical email_canonical_4, t0.enabled enabled_5, t0.salt salt_6, t0.password password_7, t0.last_login last_login_8, t0.locked locked_9, t0.expired expired_10, t0.expires_at expires_at_11, t0.confirmation_token confirmation_token_12, t0.password_requested_at password_requested_at_13, t0.roles roles_14, t0.credentials_expired credentials_expired_15, t0.credentials_expire_at credentials_expire_at_16, t0.id id_17, t0.firstname firstname_18, t0.lastname lastname_19, t0.phonenumber phonenumber_20, t0.validationnumber validationnumber_21, t22.userid userid_23, t22.id id_24, t22.parentid parentid_25, t22.classid classid_26, t22.classid classid_27, t22.userid userid_28, t29.id id_30, t29.userid userid_31, t29.address address_32, t29.postcode postcode_33, t29.mobilenumber mobilenumber_34, t29.userid userid_35, t0.token token_36 users t0 left join student t22 on t22.userid = t0.id left join address t29 on t29.userid = t0.id t0.username_canonical = ? limit 1' params [\"adminuser\"]:\n\nsqlstate[42s02]: base table or view not found: 1146 table 'pie10.address' doesn't exist @ /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 @ /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 @ /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 tokenstorage 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 other development or file related information needed
in 3rd row of log provided there's info:
sqlstate[42s02]: base table or view not found: 1146 table 'pie10.address' doesn't exist @ /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 database schema.
Comments
Post a Comment