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:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
2
Replies
1814
Views
The solution was to add the missing field into the table using PgAdmin to connect to the database.
Hello Fash,
Can you share the error log so we can trying to help you.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up
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.