{"action":"opened","issue":{"url":"https://api.github.com/repos/sonata-project/SonataUserBundle/issues/789","repository_url":"https://api.github.com/repos/sonata-project/SonataUserBundle","labels_url":"https://api.github.com/repos/sonata-project/SonataUserBundle/issues/789/labels{/name}","comments_url":"https://api.github.com/repos/sonata-project/SonataUserBundle/issues/789/comments","events_url":"https://api.github.com/repos/sonata-project/SonataUserBundle/issues/789/events","html_url":"https://github.com/sonata-project/SonataUserBundle/issues/789","id":176097244,"number":789,"title":"Unrecognized field: usernameCanonical","user":{"login":"Mentos93","id":16900286,"avatar_url":"https://avatars.githubusercontent.com/u/16900286?v=3","gravatar_id":"","url":"https://api.github.com/users/Mentos93","html_url":"https://github.com/Mentos93","followers_url":"https://api.github.com/users/Mentos93/followers","following_url":"https://api.github.com/users/Mentos93/following{/other_user}","gists_url":"https://api.github.com/users/Mentos93/gists{/gist_id}","starred_url":"https://api.github.com/users/Mentos93/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Mentos93/subscriptions","organizations_url":"https://api.github.com/users/Mentos93/orgs","repos_url":"https://api.github.com/users/Mentos93/repos","events_url":"https://api.github.com/users/Mentos93/events{/privacy}","received_events_url":"https://api.github.com/users/Mentos93/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-09-09T20:05:56Z","updated_at":"2016-09-09T20:05:56Z","closed_at":null,"body":"I have made a clean install of Symfony, SonataAdminBundle, and SonataUserBundle, and everything seem to work well. But when I try to log in, I get an error message: \"Unrecognized field: usernameCanonical\"\r\n\r\nAfter I installed Sonata I have created my database with this command: \"php app/console doctrine:database:create\", and created the tables: \"app/console doctrine:schema:update --force\". At this point it is obvious that I don't have a user to login. So I created a user with the command: \"app/console fos:user:create simon --super-admin\". Now when I try to log in I get the error mentioned above. I have checked in my database and there is a table called fos_user_user with a lot of field except for username, password, and those canonicals. Where is the official fos_user table? Why is it not created?\r\n\r\nThis is my configuration, exactly like the official guide explained;\r\n\r\n```\r\n# Doctrine Configuration\r\ndoctrine:\r\n    #...\r\n    orm:\r\n        auto_generate_proxy_classes: \"%kernel.debug%\"\r\n        entity_managers:\r\n            default:\r\n                mappings:\r\n                    ApplicationSonataUserBundle: ~\r\n                    SonataUserBundle: ~\r\n\r\nfos_user:\r\n    db_driver:      orm\r\n    firewall_name:  main\r\n    user_class:     Application\\Sonata\\UserBundle\\Entity\\User\r\n    group:\r\n        group_class:   Application\\Sonata\\UserBundle\\Entity\\Group\r\n        group_manager: sonata.user.orm.group_manager\r\n    service:\r\n        user_manager: sonata.user.orm.user_manager\r\n```\r\nand this is my security.yml (not that I think any problem would be here);\r\n\r\n```\r\nsecurity:            \r\n    encoders:\r\n        FOS\\UserBundle\\Model\\UserInterface: sha512\r\n\r\n    acl:\r\n        connection: default\r\n\r\n    role_hierarchy:\r\n        ROLE_ADMIN:       [ROLE_USER, ROLE_SONATA_ADMIN]\r\n        ROLE_SUPER_ADMIN: [ROLE_ADMIN, ROLE_ALLOWED_TO_SWITCH]\r\n        SONATA:\r\n            - ROLE_SONATA_PAGE_ADMIN_PAGE_EDIT  # if you are using acl then this line must be commented\r\n\r\n    providers:\r\n        fos_userbundle:\r\n            id: fos_user.user_manager\r\n\r\n    firewalls:\r\n        # Disabling the security for the web debug toolbar, the profiler and Assetic.\r\n        dev:\r\n            pattern:  ^/(_(profiler|wdt)|css|images|js)/\r\n            security: false\r\n\r\n        # -> custom firewall for the admin area of the URL\r\n        admin:\r\n            pattern:            /admin(.*)\r\n            context:            user\r\n            form_login:\r\n                provider:       fos_userbundle\r\n                login_path:     /admin/login\r\n                use_forward:    false\r\n                check_path:     /admin/login_check\r\n                failure_path:   null\r\n            logout:\r\n                path:           /admin/logout\r\n            anonymous:          true\r\n\r\n        # -> end custom configuration\r\n\r\n        # default login area for standard users\r\n\r\n        # This firewall is used to handle the public login area\r\n        # This part is handled by the FOS User Bundle\r\n        main:\r\n            pattern:             .*\r\n            context:             user\r\n            form_login:\r\n                provider:       fos_userbundle\r\n                login_path:     /login\r\n                use_forward:    false\r\n                check_path:     /login_check\r\n                failure_path:   null\r\n            logout:             true\r\n            anonymous:          true\r\n    \r\n    access_control:\r\n        # URL of FOSUserBundle which need to be available to anonymous users\r\n        - { path: ^/login$, role: IS_AUTHENTICATED_ANONYMOUSLY }\r\n        - { path: ^/register, role: IS_AUTHENTICATED_ANONYMOUSLY }\r\n        - { path: ^/resetting, role: IS_AUTHENTICATED_ANONYMOUSLY }\r\n\r\n        # Admin login page needs to be access without credential\r\n        - { path: ^/admin/login$, role: IS_AUTHENTICATED_ANONYMOUSLY }\r\n        - { path: ^/admin/logout$, role: IS_AUTHENTICATED_ANONYMOUSLY }\r\n        - { path: ^/admin/login_check$, role: IS_AUTHENTICATED_ANONYMOUSLY }\r\n\r\n        # Secured part of the site\r\n        # This config requires being logged for the whole site and having the admin role for the admin part.\r\n        # Change these rules to adapt them to your needs\r\n        - { path: ^/admin/, role: [ROLE_ADMIN, ROLE_SONATA_ADMIN] }\r\n        - { path: ^/.*, role: IS_AUTHENTICATED_ANONYMOUSLY }\r\n```\r\n\r\nI desperately need help, please!? "}}
{"actor":{"display_login":"Mentos93"}}