This question has been flagged
5 Replies
6901 Views

When I just finished installing Odoo 13 EE and try to open the page, it returned me an "Internal Server Error", so I checked the log and got the following error code:

2019-10-09 01:40:19,577 6344 ERROR db_maizhi odoo.sql_db: bad query: SELECT "website_rewrite".id FROM "website_rewrite" WHERE ((("website_rewrite"."active" = true) AND ("website_rewrite"."redirect_type" in ('308','404'))) AND ("website_rewrite"."website_id" IS NULL OR ("website_rewrite"."website_id" = 1))) ORDER BY "website_rewrite"."id"
ERROR:  relation "website_rewrite" doesn't exist
LINE 1: SELECT "website_rewrite".id FROM "website_rewrite" WHERE (((...
^

2019-10-09 01:40:19,582 6344 INFO db_maizhi werkzeug: 127.0.0.1 - - [09/Oct/2019 01:40:19] "GET / HTTP/1.1" 500 - 28 0.323 15.908
2019-10-09 01:40:19,599 6344 ERROR db_maizhi werkzeug: Error on request:
Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 13.0e\python\lib\site-packages\werkzeug\serving.py", line 270, in run_wsgi
execute(self.server.app)
File "C:\Program Files (x86)\Odoo 13.0e\python\lib\site-packages\werkzeug\serving.py", line 258, in execute
application_iter = app(environ, start_response)
File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\service\server.py", line 414, in app
return self.app(e, s)
File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\service\wsgi_server.py", line 142, in application
return application_unproxied(environ, start_response)
File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\service\wsgi_server.py", line 117, in application_unproxied
result = odoo.http.root(environ, start_response)
File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\http.py", line 1281, in __call__
return self.dispatch(environ, start_response)
File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\http.py", line 1251, in __call__
return self.app(environ, start_wrapped)
File "C:\Program Files (x86)\Odoo 13.0e\python\lib\site-packages\werkzeug\wsgi.py", line 766, in __call__
return self.app(environ, start_response)
File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\http.py", line 1450, in dispatch
result = ir_http._dispatch()
File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\website_sale\models\ir_http.py", line 15, in _dispatch
return super(IrHttp, cls)._dispatch()
File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\website\models\ir_http.py", line 168, in _dispatch
response = super(Http, cls)._dispatch()
File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\auth_signup\models\ir_http.py", line 19, in _dispatch
return super(Http, cls)._dispatch()
File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\web_editor\models\ir_http.py", line 22, in _dispatch
return super(IrHttp, cls)._dispatch()
File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\utm\models\ir_http.py", line 26, in _dispatch
response = super(IrHttp, cls)._dispatch()
File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\http_routing\models\ir_http.py", line 424, in _dispatch
rule, arguments = cls._match(request.httprequest.path)
File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\website\models\ir_http.py", line 84, in _match
return super(Http, cls)._match(path_info, key=key)
File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\ir_http.py", line 91, in _match
return cls.routing_map().bind_to_environ(request.httprequest.environ).match(path_info=path_info, return_rule=True)
File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\website\models\ir_http.py", line 66, in routing_map
return super(Http, cls).routing_map(key=key)
File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\ir_http.py", line 267, in routing_map
for url, endpoint, routing in cls._generate_routing_rules(mods, converters=cls._get_converters()):
File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\website\models\ir_http.py", line 92, in _generate_routing_rules
rewrites = dict([(x.url_from, x) for x in request.env['website.rewrite'].sudo().search(domain)])
File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\models.py", line 1556, in search
res = self._search(args, offset=offset, limit=limit, order=order, count=count)
File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\models.py", line 4285, in _search
self._cr.execute(query_str, where_clause_params)
File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\sql_db.py", line 163, in wrapper
return f(self, *args, **kwargs)
File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\sql_db.py", line 240, in execute
res = self._obj.execute(query, params)
psycopg2.ProgrammingError:  relation "website_rewrite" doesn't exist 

I also installed Odoo 12 EE on my computer on another port 8068, does it matter?   Or there is any safe and convinent way to upgrade 12 to 13?

So is there anyone who met this problem yet? Have any suggestions? Thanks.

Following is my environment:

OS: Windows Server 2019 Datacenter 1809

Avatar
Discard
Best Answer

Hi, please help me I have the same error I have checked the database and it does not exist so what i should do ?

Avatar
Discard
Best Answer

just had the same issue while installing odoo13CE. It got solved while i connected the DB when running
-d databasename

Avatar
Discard
Best Answer

Have you fixed this? Have the same error actual here. 

Avatar
Discard
Best Answer

make database with -d as odoo 13

Avatar
Discard
Best Answer

Please raise a ticket from your odoo account. You will get the further support from odoo team

Avatar
Discard