{"action":"created","issue":{"url":"https://api.github.com/repos/odoo/odoo/issues/14160","repository_url":"https://api.github.com/repos/odoo/odoo","labels_url":"https://api.github.com/repos/odoo/odoo/issues/14160/labels{/name}","comments_url":"https://api.github.com/repos/odoo/odoo/issues/14160/comments","events_url":"https://api.github.com/repos/odoo/odoo/issues/14160/events","html_url":"https://github.com/odoo/odoo/issues/14160","id":187471267,"number":14160,"title":"[10.0 & PG 9.6] Create New Database with UI = Database creation error: column res_lang.active does not exist LINE 1: SELECT count(1) FROM \"res_lang\" WHERE (\"res_lang\".\"active\" =... ^","user":{"login":"lukebranch","id":2337666,"avatar_url":"https://avatars.githubusercontent.com/u/2337666?v=3","gravatar_id":"","url":"https://api.github.com/users/lukebranch","html_url":"https://github.com/lukebranch","followers_url":"https://api.github.com/users/lukebranch/followers","following_url":"https://api.github.com/users/lukebranch/following{/other_user}","gists_url":"https://api.github.com/users/lukebranch/gists{/gist_id}","starred_url":"https://api.github.com/users/lukebranch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lukebranch/subscriptions","organizations_url":"https://api.github.com/users/lukebranch/orgs","repos_url":"https://api.github.com/users/lukebranch/repos","events_url":"https://api.github.com/users/lukebranch/events{/privacy}","received_events_url":"https://api.github.com/users/lukebranch/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-11-05T02:23:38Z","updated_at":"2016-11-05T05:39:56Z","closed_at":null,"body":"<H1>Impacted versions:</H1>\r\nOdoo 10.0\r\n\r\n<H1>Environment:</H1>\r\n<ul>\r\n<li>Odoo 10.0 (Latest Pull as of 5th of November, 2016)</li>\r\n<li>PostgreSQL 9.6</li>\r\n<li>Ubuntu 14.04</li>\r\n</ul>\r\n<H1>Steps to reproduce:</H1>\r\nI have two versions of PostgreSQL running on my machine in order to do testing in a development environment. These are PostgreSQL 9.5 and PostgreSQL 9.6.\r\n\r\nI have thrown together a quick gist with an SH script (modified slightly from Yenthe's script for 10.0) to allow you to quickly/easily replicate the issue.\r\n\r\n<ul>\r\n<li>Install on a clean Ubuntu 14.04 server edition using sh script found here: <a href=\"https://gist.github.com/lukebranch/aeff913f554f3a2f8469965e8e82f2ea\">https://gist.github.com/lukebranch/aeff913f554f3a2f8469965e8e82f2ea</a></li>\r\n<li>Once you've installed create a single database using the Odoo /web/database/manager, this I initially had no issue with.</li>\r\n<li>Now create a second database</li>\r\n</ul>\r\n\r\n<H1>Current behaviour:</H1>\r\nRed dialog box in /web/database/manager with the following error message:\r\n\r\n```\r\nDatabase creation error: column res_lang.active does not exist LINE 1: SELECT count(1) FROM \"res_lang\" WHERE (\"res_lang\".\"active\" =... ^\r\n```\r\n\r\nThe full traceback in the logs is here:\r\n\r\n```\r\n2016-11-05 02:18:53,668 21666 ERROR WE123 odoo.modules.registry: Failed to load registry\r\nTraceback (most recent call last):\r\n  File \"/odoo10/odoo10-server/odoo/modules/registry.py\", line 78, in new\r\n    odoo.modules.load_modules(registry._db, force_demo, status, update_module)\r\n  File \"/odoo10/odoo10-server/odoo/modules/loading.py\", line 411, in load_modules\r\n    model._register_hook()\r\n  File \"/odoo10/odoo10-server/odoo/addons/base/res/res_lang.py\", line 80, in _register_hook\r\n    if not self.search_count([]):\r\n  File \"/odoo10/odoo10-server/odoo/models.py\", line 1481, in search_count\r\n    res = self.search(args, count=True)\r\n  File \"/odoo10/odoo10-server/odoo/models.py\", line 1504, in search\r\n    res = self._search(args, offset=offset, limit=limit, order=order, count=count)\r\n  File \"/odoo10/odoo10-server/odoo/models.py\", line 4202, in _search\r\n    self._cr.execute(query_str, where_clause_params)\r\n  File \"/odoo10/odoo10-server/odoo/sql_db.py\", line 141, in wrapper\r\n    return f(self, *args, **kwargs)\r\n  File \"/odoo10/odoo10-server/odoo/sql_db.py\", line 218, in execute\r\n    res = self._obj.execute(query, params)\r\nProgrammingError: column res_lang.active does not exist\r\nLINE 1: SELECT count(1) FROM \"res_lang\" WHERE (\"res_lang\".\"active\" =...\r\n                                               ^\r\n\r\n2016-11-05 02:18:53,670 21666 ERROR WE123 odoo.http: column res_lang.active does not exist\r\nLINE 1: SELECT count(1) FROM \"res_lang\" WHERE (\"res_lang\".\"active\" =...\r\n                                               ^\r\nTraceback (most recent call last):\r\n  File \"/odoo10/odoo10-server/odoo/http.py\", line 118, in dispatch_rpc\r\n    result = dispatch(method, params)\r\n  File \"/odoo10/odoo10-server/odoo/service/common.py\", line 57, in dispatch\r\n    return g[exp_method_name](*params)\r\n  File \"/odoo10/odoo10-server/odoo/service/common.py\", line 29, in exp_authenticate\r\n    res_users = odoo.registry(db)['res.users']\r\n  File \"/odoo10/odoo10-server/odoo/__init__.py\", line 55, in registry\r\n    return modules.registry.Registry(database_name)\r\n  File \"/odoo10/odoo10-server/odoo/modules/registry.py\", line 55, in __new__\r\n    return cls.new(db_name)\r\n  File \"/odoo10/odoo10-server/odoo/modules/registry.py\", line 78, in new\r\n    odoo.modules.load_modules(registry._db, force_demo, status, update_module)\r\n  File \"/odoo10/odoo10-server/odoo/modules/loading.py\", line 411, in load_modules\r\n    model._register_hook()\r\n  File \"/odoo10/odoo10-server/odoo/addons/base/res/res_lang.py\", line 80, in _register_hook\r\n    if not self.search_count([]):\r\n  File \"/odoo10/odoo10-server/odoo/models.py\", line 1481, in search_count\r\n    res = self.search(args, count=True)\r\n  File \"/odoo10/odoo10-server/odoo/models.py\", line 1504, in search\r\n    res = self._search(args, offset=offset, limit=limit, order=order, count=count)\r\n  File \"/odoo10/odoo10-server/odoo/models.py\", line 4202, in _search\r\n    self._cr.execute(query_str, where_clause_params)\r\n  File \"/odoo10/odoo10-server/odoo/sql_db.py\", line 141, in wrapper\r\n    return f(self, *args, **kwargs)\r\n  File \"/odoo10/odoo10-server/odoo/sql_db.py\", line 218, in execute\r\n    res = self._obj.execute(query, params)\r\nProgrammingError: column res_lang.active does not exist\r\nLINE 1: SELECT count(1) FROM \"res_lang\" WHERE (\"res_lang\".\"active\" =...\r\n                                               ^\r\n\r\n2016-11-05 02:18:53,732 21666 INFO WE123 werkzeug: 127.0.0.1 - - [05/Nov/2016 02:18:53] \"POST /web/database/create HTTP/1.0\" 200 -\r\n```\r\n\r\n<H1>Expected behaviour:</H1>\r\nCreate a new database with no error message.\r\n\r\n<H1>Video/Screenshot link (optional):</H1>\r\n<img src=\"https://cloud.githubusercontent.com/assets/2337666/20026973/dcb2819a-a341-11e6-8776-a3fdc1213897.gif\" />\r\n"},"comment":{"url":"https://api.github.com/repos/odoo/odoo/issues/comments/258592459","html_url":"https://github.com/odoo/odoo/issues/14160#issuecomment-258592459","issue_url":"https://api.github.com/repos/odoo/odoo/issues/14160","id":258592459,"user":{"login":"DipaliKhatri","id":22851027,"avatar_url":"https://avatars.githubusercontent.com/u/22851027?v=3","gravatar_id":"","url":"https://api.github.com/users/DipaliKhatri","html_url":"https://github.com/DipaliKhatri","followers_url":"https://api.github.com/users/DipaliKhatri/followers","following_url":"https://api.github.com/users/DipaliKhatri/following{/other_user}","gists_url":"https://api.github.com/users/DipaliKhatri/gists{/gist_id}","starred_url":"https://api.github.com/users/DipaliKhatri/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DipaliKhatri/subscriptions","organizations_url":"https://api.github.com/users/DipaliKhatri/orgs","repos_url":"https://api.github.com/users/DipaliKhatri/repos","events_url":"https://api.github.com/users/DipaliKhatri/events{/privacy}","received_events_url":"https://api.github.com/users/DipaliKhatri/received_events","type":"User","site_admin":false},"created_at":"2016-11-05T05:39:56Z","updated_at":"2016-11-05T05:39:56Z","body":"@lukebranch \r\nFirst checkout the branch in 10.0 than pull in that branch and than clear the cookies and than make a new DB."}}
{"actor":{"display_login":"DipaliKhatri"}}