Please help me fix this problem. I tried pasting the log output here, but I guess I don't have enough karma....
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- 客戶關係
- e-Commerce
- 會計
- 庫存
- PoS
- Project
- MRP
此問題已被標幟
2
回覆
1427
瀏覽次數
2023-12-25 05:33:59,824 4026 ERROR ready4rehab odoo.sql_db: bad query: SELECT "website"."id" as "id", "website"."name" as "name", "website"."sequence" as "sequence", "website"."domain" as "domain", "website"."company_id" as "company_id", "website"."default_lang_id" as "default_lang_id", "website"."auto_redirect_lang" as "auto_redirect_lang", "website"."cookies_bar" as "cookies_bar", "website"."configurator_done" as "configurator_done", "website"."social_twitter" as "social_twitter", "website"."social_facebook" as "social_facebook", "website"."social_github" as "social_github", "website"."social_linkedin" as "social_linkedin", "website"."social_youtube" as "social_youtube", "website"."social_instagram" as "social_instagram", "website"."has_social_default_image" as "has_social_default_image", "website"."google_analytics_key" as "google_analytics_key", "website"."google_management_client_id" as "google_management_client_id", "website"."google_management_client_secret" as "google_management_client_secret", "website"."google_search_console" as "google_search_console", "website"."google_maps_api_key" as "google_maps_api_key", "website"."user_id" as "user_id", "website"."cdn_activated" as "cdn_activated", "website"."cdn_url" as "cdn_url", "website"."cdn_filters" as "cdn_filters", "website"."homepage_id" as "homepage_id", "website"."custom_code_head" as "custom_code_head", "website"."custom_code_footer" as "custom_code_footer", "website"."robots_txt" as "robots_txt", "website"."theme_id" as "theme_id", "website"."specific_user_account" as "specific_user_account", "website"."auth_signup_uninvited" as "auth_signup_uninvited", "website"."create_uid" as "create_uid", "website"."create_date" as "create_date", "website"."write_uid" as "write_uid", "website"."write_date" as "write_date", "website"."crm_default_team_id" as "crm_default_team_id", "website"."crm_default_user_id" as "crm_default_user_id", "website"."ga4_debug_mode" as "ga4_debug_mode", "website"."ga4_tracking_key" as "ga4_tracking_key", "website"."channel_id" as "channel_id", "website"."karma_profile_min" as "karma_profile_min", "website"."forums_count" as "forums_count" FROM "website" WHERE "website".id IN (1)
ERROR: column website.ga4_debug_mode does not exist
LINE 1: ..."."crm_default_user_id" as "crm_default_user_id", "website"....
^
2023-12-25 05:33:59,831 4026 INFO ready4rehab werkzeug: 97.134.75.95 - - [25/Dec/2023 05:33:59] "[35m[1mGET /web/database/manager HTTP/1.0[0m" 500 - 4 0.002 0.011
2023-12-25 05:33:59,836 4026 ERROR ready4rehab werkzeug: Error on request:
Traceback (most recent call last):
File "/odoo/odoo-server/odoo/tools/cache.py", line 85, in lookup
r = d[key]
File "/odoo/odoo-server/odoo/tools/func.py", line 71, in wrapper
return func(self, *args, **kwargs)
File "/odoo/odoo-server/odoo/tools/lru.py", line 34, in __getitem__
a = self.d[obj]
KeyError: ('website', <function Website._get_current_website_id at 0x7f035adeee60>, 'ready4rehab.com', False, True)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/odoo/odoo-server/odoo/api.py", line 886, in get
return field_cache[record._ids[0]]
KeyError: 1
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/odoo/odoo-server/odoo/fields.py", line 1082, in __get__
value = env.cache.get(record, self)
File "/odoo/odoo-server/odoo/api.py", line 889, in get
raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: 'website(1,).domain'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/werkzeug/serving.py", line 319, in run_wsgi
execute(self.server.app)
File "/usr/local/lib/python3.10/dist-packages/werkzeug/serving.py", line 308, in execute
application_iter = app(environ, start_response)
File "/odoo/odoo-server/odoo/service/server.py", line 482, in app
return self.app(e, s)
File "/odoo/odoo-server/odoo/service/wsgi_server.py", line 110, in application
return ProxyFix(application_unproxied)(environ, start_response)
File "/usr/local/lib/python3.10/dist-packages/werkzeug/middleware/proxy_fix.py", line 187, in __call__
return self.app(environ, start_response)
File "/odoo/odoo-server/odoo/service/wsgi_server.py", line 87, in application_unproxied
result = odoo.http.root(environ, start_response)
File "/odoo/odoo-server/odoo/http.py", line 1305, in __call__
return self.dispatch(environ, start_response)
File "/odoo/odoo-server/odoo/http.py", line 1271, in __call__
return self.app(environ, start_wrapped)
File "/usr/local/lib/python3.10/dist-packages/werkzeug/middleware/shared_data.py", line 287, in __call__
return self.app(environ, start_response)
File "/odoo/odoo-server/odoo/http.py", line 1500, in dispatch
result = ir_http._dispatch()
File "/odoo/odoo-server/addons/website/models/ir_http.py", line 196, in _dispatch
request.website_routing = env['website'].get_current_website().id
File "/odoo/odoo-server/addons/website/models/website.py", line 978, in get_current_website
website_id = self._get_current_website_id(domain_name, country_id, fallback=fallback)
File "<decorator-gen-241>", line 2, in _get_current_website_id
File "/odoo/odoo-server/odoo/tools/cache.py", line 90, in lookup
value = d[key] = self.method(*args, **kwargs)
File "/odoo/odoo-server/addons/website/models/website.py", line 1037, in _get_current_website_id
websites = found_websites.filtered(lambda w: _filter_domain(w, domain_name))
File "/odoo/odoo-server/odoo/models.py", line 5518, in filtered
return self.browse([rec.id for rec in self if func(rec)])
File "/odoo/odoo-server/odoo/models.py", line 5518, in <listcomp>
return self.browse([rec.id for rec in self if func(rec)])
File "/odoo/odoo-server/addons/website/models/website.py", line 1037, in <lambda>
websites = found_websites.filtered(lambda w: _filter_domain(w, domain_name))
File "/odoo/odoo-server/addons/website/models/website.py", line 1026, in _filter_domain
website_domain = urls.url_parse(website._get_http_domain()).netloc
File "/odoo/odoo-server/addons/website/models/website.py", line 1349, in _get_http_domain
if not self.domain:
File "/odoo/odoo-server/odoo/fields.py", line 1108, in __get__
recs._fetch_field(self)
File "/odoo/odoo-server/odoo/models.py", line 3285, in _fetch_field
self._read(fnames)
File "/odoo/odoo-server/odoo/models.py", line 3352, in _read
cr.execute(query_str, params + [sub_ids])
File "<decorator-gen-3>", line 2, in execute
File "/odoo/odoo-server/odoo/sql_db.py", line 90, in check
return f(self, *args, **kwargs)
File "/odoo/odoo-server/odoo/sql_db.py", line 311, in execute
res = self._obj.execute(query, params)
psycopg2.errors.UndefinedColumn: column website.ga4_debug_mode does not exist
LINE 1: ..."."crm_default_user_id" as "crm_default_user_id", "website"....
^ - - -
2023-12-25 05:34:00,011 4026 ERROR ready4rehab odoo.sql_db: bad query: SELECT "website"."id" as "id", "website"."name" as "name", "website"."sequence" as "sequence", "website"."domain" as "domain", "website"."company_id" as "company_id", "website"."default_lang_id" as "default_lang_id", "website"."auto_redirect_lang" as "auto_redirect_lang", "website"."cookies_bar" as "cookies_bar", "website"."configurator_done" as "configurator_done", "website"."social_twitter" as "social_twitter", "website"."social_facebook" as "social_facebook", "website"."social_github" as "social_github", "website"."social_linkedin" as "social_linkedin", "website"."social_youtube" as "social_youtube", "website"."social_instagram" as "social_instagram", "website"."has_social_default_image" as "has_social_default_image", "website"."google_analytics_key" as "google_analytics_key", "website"."google_management_client_id" as "google_management_client_id", "website"."google_management_client_secret" as "google_management_client_secret", "website"."google_search_console" as "google_search_console", "website"."google_maps_api_key" as "google_maps_api_key", "website"."user_id" as "user_id", "website"."cdn_activated" as "cdn_activated", "website"."cdn_url" as "cdn_url", "website"."cdn_filters" as "cdn_filters", "website"."homepage_id" as "homepage_id", "website"."custom_code_head" as "custom_code_head", "website"."custom_code_footer" as "custom_code_footer", "website"."robots_txt" as "robots_txt", "website"."theme_id" as "theme_id", "website"."specific_user_account" as "specific_user_account", "website"."auth_signup_uninvited" as "auth_signup_uninvited", "website"."create_uid" as "create_uid", "website"."create_date" as "create_date", "website"."write_uid" as "write_uid", "website"."write_date" as "write_date", "website"."crm_default_team_id" as "crm_default_team_id", "website"."crm_default_user_id" as "crm_default_user_id", "website"."ga4_debug_mode" as "ga4_debug_mode", "website"."ga4_tracking_key" as "ga4_tracking_key", "website"."channel_id" as "channel_id", "website"."karma_profile_min" as "karma_profile_min", "website"."forums_count" as "forums_count" FROM "website" WHERE "website".id IN (1)
ERROR: column website.ga4_debug_mode does not exist
LINE 1: ..."."crm_default_user_id" as "crm_default_user_id", "website"....
^
2023-12-25 05:34:00,016 4026 INFO ready4rehab werkzeug: 97.134.75.95 - - [25/Dec/2023 05:34:00] "[35m[1mGET /favicon.ico HTTP/1.0[0m" 500 - 4 0.003 0.011
2023-12-25 05:34:00,023 4026 ERROR ready4rehab werkzeug: Error on request:
Traceback (most recent call last):
File "/odoo/odoo-server/odoo/tools/cache.py", line 85, in lookup
r = d[key]
File "/odoo/odoo-server/odoo/tools/func.py", line 71, in wrapper
return func(self, *args, **kwargs)
File "/odoo/odoo-server/odoo/tools/lru.py", line 34, in __getitem__
a = self.d[obj]
KeyError: ('website', <function Website._get_current_website_id at 0x7f035adeee60>, 'ready4rehab.com', False, True)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/odoo/odoo-server/odoo/api.py", line 886, in get
return field_cache[record._ids[0]]
KeyError: 1
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/odoo/odoo-server/odoo/fields.py", line 1082, in __get__
value = env.cache.get(record, self)
File "/odoo/odoo-server/odoo/api.py", line 889, in get
raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: 'website(1,).domain'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/werkzeug/serving.py", line 319, in run_wsgi
execute(self.server.app)
File "/usr/local/lib/python3.10/dist-packages/werkzeug/serving.py", line 308, in execute
application_iter = app(environ, start_response)
File "/odoo/odoo-server/odoo/service/server.py", line 482, in app
return self.app(e, s)
File "/odoo/odoo-server/odoo/service/wsgi_server.py", line 110, in application
return ProxyFix(application_unproxied)(environ, start_response)
File "/usr/local/lib/python3.10/dist-packages/werkzeug/middleware/proxy_fix.py", line 187, in __call__
return self.app(environ, start_response)
File "/odoo/odoo-server/odoo/service/wsgi_server.py", line 87, in application_unproxied
result = odoo.http.root(environ, start_response)
File "/odoo/odoo-server/odoo/http.py", line 1305, in __call__
return self.dispatch(environ, start_response)
File "/odoo/odoo-server/odoo/http.py", line 1271, in __call__
return self.app(environ, start_wrapped)
File "/usr/local/lib/python3.10/dist-packages/werkzeug/middleware/shared_data.py", line 287, in __call__
return self.app(environ, start_response)
File "/odoo/odoo-server/odoo/http.py", line 1500, in dispatch
result = ir_http._dispatch()
File "/odoo/odoo-server/addons/website/models/ir_http.py", line 196, in _dispatch
request.website_routing = env['website'].get_current_website().id
File "/odoo/odoo-server/addons/website/models/website.py", line 978, in get_current_website
website_id = self._get_current_website_id(domain_name, country_id, fallback=fallback)
File "<decorator-gen-241>", line 2, in _get_current_website_id
File "/odoo/odoo-server/odoo/tools/cache.py", line 90, in lookup
value = d[key] = self.method(*args, **kwargs)
File "/odoo/odoo-server/addons/website/models/website.py", line 1037, in _get_current_website_id
websites = found_websites.filtered(lambda w: _filter_domain(w, domain_name))
File "/odoo/odoo-server/odoo/models.py", line 5518, in filtered
return self.browse([rec.id for rec in self if func(rec)])
File "/odoo/odoo-server/odoo/models.py", line 5518, in <listcomp>
return self.browse([rec.id for rec in self if func(rec)])
File "/odoo/odoo-server/addons/website/models/website.py", line 1037, in <lambda>
websites = found_websites.filtered(lambda w: _filter_domain(w, domain_name))
File "/odoo/odoo-server/addons/website/models/website.py", line 1026, in _filter_domain
website_domain = urls.url_parse(website._get_http_domain()).netloc
File "/odoo/odoo-server/addons/website/models/website.py", line 1349, in _get_http_domain
if not self.domain:
File "/odoo/odoo-server/odoo/fields.py", line 1108, in __get__
recs._fetch_field(self)
File "/odoo/odoo-server/odoo/models.py", line 3285, in _fetch_field
self._read(fnames)
File "/odoo/odoo-server/odoo/models.py", line 3352, in _read
cr.execute(query_str, params + [sub_ids])
File "<decorator-gen-3>", line 2, in execute
File "/odoo/odoo-server/odoo/sql_db.py", line 90, in check
return f(self, *args, **kwargs)
File "/odoo/odoo-server/odoo/sql_db.py", line 311, in execute
res = self._obj.execute(query, params)
psycopg2.errors.UndefinedColumn: column website.ga4_debug_mode does not exist
LINE 1: ..."."crm_default_user_id" as "crm_default_user_id", "website"....
^ - - -
Why is this forem so difficult to use? I can't even post another question because This one is not validated yet... I already solved this problem, but I can't even mark it solved.... The Karma settings make this forum cumbersome to use.