{"action":"opened","issue":{"url":"https://api.github.com/repos/tonioo/modoboa/issues/752","labels_url":"https://api.github.com/repos/tonioo/modoboa/issues/752/labels{/name}","comments_url":"https://api.github.com/repos/tonioo/modoboa/issues/752/comments","events_url":"https://api.github.com/repos/tonioo/modoboa/issues/752/events","html_url":"https://github.com/tonioo/modoboa/issues/752","id":91215072,"number":752,"title":"Update 1.2.1 -> 1.3.3 issue: Aliases are not shown anymore","user":{"login":"phaf","id":2363575,"avatar_url":"https://avatars.githubusercontent.com/u/2363575?v=3","gravatar_id":"","url":"https://api.github.com/users/phaf","html_url":"https://github.com/phaf","followers_url":"https://api.github.com/users/phaf/followers","following_url":"https://api.github.com/users/phaf/following{/other_user}","gists_url":"https://api.github.com/users/phaf/gists{/gist_id}","starred_url":"https://api.github.com/users/phaf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/phaf/subscriptions","organizations_url":"https://api.github.com/users/phaf/orgs","repos_url":"https://api.github.com/users/phaf/repos","events_url":"https://api.github.com/users/phaf/events{/privacy}","received_events_url":"https://api.github.com/users/phaf/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-06-26T10:18:38Z","updated_at":"2015-06-26T10:18:38Z","closed_at":null,"body":"Hi all,\r\n\r\nafter upgrading from 1.2.1 to 1.3.3 everything works fine except all aliases and distribution lists which already existed before upgrade are not listed anymore and can not be found via search. \r\nNewly created aliases are listed and working as expected. \r\n\r\nI am using PostgreSQL and checked the SQL queries created by modoboa, this query seems to be executed to get the list of aliases\r\n\r\n```\r\nSELECT \"admin_alias\".\"id\", \"admin_alias\".\"dates_id\", \"admin_alias\".\"address\", \"admin_alias\".\"domain_id\", \"admin_alias\".\"extmboxes\", \"admin_alias\".\"enabled\", \"admin_objectdates\".\"id\", \"admin_objectdates\".\"creation\", \"admin_objectdates\".\"last_modification\", \"admin_domain\".\"id\", \"admin_domain\".\"dates_id\", \"admin_domain\".\"name\", \"admin_domain\".\"quota\", \"admin_domain\".\"enabled\", \"admin_domain\".\"type\", T4.\"id\", T4.\"creation\", T4.\"last_modification\"\r\n FROM \"admin_alias\" \r\nINNER JOIN \"admin_objectdates\" ON ( \"admin_alias\".\"dates_id\" = \"admin_objectdates\".\"id\" )\r\nINNER JOIN \"admin_domain\" ON ( \"admin_alias\".\"domain_id\" = \"admin_domain\".\"id\" ) \r\nINNER JOIN \"admin_objectdates\" T4 ON ( \"admin_domain\".\"dates_id\" = T4.\"id\" ) \r\nWHERE \"admin_alias\".\"id\" IN (SELECT U0.\"object_id\" FROM \"core_objectaccess\" U0 \r\nWHERE (U0.\"user_id\" = 1 AND U0.\"content_type_id\" = 42)) ORDER BY \"admin_domain\".\"name\" ASC, \"admin_alias\".\"address\" ASC\r\n```\r\nIt looks like all old aliases are not present in table core_objectaccess. Is it safe to add the missing entries to core_objectaccess? Should this table populated automatically during the upgrade process?\r\n\r\nThanks for watching on this issue! If there is anything I can do to help, please let me know.\r\n"}}