Hi guys,
I'm trying to manually uninstall live chat module, could someone please help me with the correct name for live chat module? and where it is located in ir_module_module?
Within PSQL I also saw this:
public | im_livechat_channel | table | odoo public | im_livechat_channel_country_rel | table | odoo
public | im_livechat_channel_id_seq | sequence | odoo public | im_livechat_channel_im_user | table | odoo
public | im_livechat_channel_rule | table | odoo public | im_livechat_channel_rule_id_seq | sequence | odoo
public | im_livechat_report_channel | view | odoo public | im_livechat_report_operator | view | odoo
I have tried to use these:
DELETE FROM ir_model AS ir WHERE ir.model = 'live_chat';
DELETE FROM ir_model_data AS ird WHERE ird.module = 'live_chat'
DELETE FROM ir_model_fields AS irf WHERE irf.model = 'live_chat'
and this
update ir_module_module set state='to remove' where name='live_chat' and state='installed';
all return with 0.
Many thanks
26 02:36:02,187 1 [1;32m[1;49mINFO[0m ? odoo: Odoo version 10.0-20170207
26 02:36:02,187 1 [1;32m[1;49mINFO[0m ? odoo: Using configuration file at /etc/odoo/odoo.conf
26 02:36:02,187 1 [1;32m[1;49mINFO[0m ? odoo: addons paths: ['/var/lib/odoo/addons/10.0', u'/mnt/extra-addons', u'/usr/lib/python2.7/dist-packages/odoo/addons']
26 02:36:02,187 1 [1;32m[1;49mINFO[0m ? odoo: database: odoo@172.17.0.8:5432
26 02:36:02,200 1 [1;32m[1;49mINFO[0m ? odoo.service.server: HTTP service (werkzeug) running on 0.0.0.0:8069
26 02:36:05,574 1 [1;32m[1;49mINFO[0m ? odoo.addons.bus.models.bus: Bus.loop listen imbus on db postgres
26 02:36:05,994 1 [1;32m[1;49mINFO[0m ? odoo.addons.report.models.report: Will use the Wkhtmltopdf binary at /usr/local/bin/wkhtmltopdf
26 02:36:06,262 1 [1;32m[1;49mINFO[0m ? odoo.http: HTTP Configuring static files
26 02:36:06,271 1 [1;32m[1;49mINFO[0m edh_vietnam odoo.modules.loading: loading 1 modules...
26 02:36:06,285 1 [1;32m[1;49mINFO[0m edh_vietnam odoo.modules.loading: 1 modules loaded in 0.01s, 0 queries
26 02:36:06,302 1 [1;32m[1;49mINFO[0m edh_vietnam odoo.modules.loading: loading 46 modules...
26 02:36:06,411 1 [1;32m[1;49mINFO[0m edh_vietnam odoo.modules.loading: 46 modules loaded in 0.11s, 0 queries
26 02:36:06,611 1 [1;32m[1;49mINFO[0m edh_vietnam odoo.modules.loading: Modules loaded.
26 02:36:06,614 1 [1;32m[1;49mINFO[0m edh_vietnam odoo.addons.base.ir.ir_http: Generating routing map
26 02:36:06,699 1 [1;32m[1;49mINFO[0m edh_vietnam odoo.sql_db: bad query: SELECT "website"."user_id" as "user_id","website"."cdn_activated" as "cdn_activated","website"."social_linkedin" as "social_linkedin","website"."compress_html" as "compress_html","website"."google_analytics_key" as "google_analytics_key","website"."create_uid" as "create_uid","website"."company_id" as "company_id","website"."default_lang_id" as "default_lang_id","website"."website_form_enable_metadata" as "website_form_enable_metadata","website"."cdn_filters" as "cdn_filters","website"."name" as "name","website"."write_uid" as "write_uid","website"."social_youtube" as "social_youtube","website"."channel_id" as "channel_id","website"."social_twitter" as "social_twitter","website"."id" as "id","website"."social_facebook" as "social_facebook","website"."cdn_url" as "cdn_url","website"."create_date" as "create_date","website"."social_github" as "social_github","website"."default_lang_code" as "default_lang_code","website"."write_date" as "write_date","website"."social_googleplus" as "social_googleplus","website"."domain" as "domain" FROM "website"
ebsite".id IN (1) ORDER BY "website"."id"
26 02:36:06,699 1 [1;32m[1;49mINFO[0m edh_vietnam odoo.addons.base.ir.ir_http: Exception during request Authentication.
k (most recent call last):
sr/lib/python2.7/dist-packages/odoo/addons/base/ir/ir_http.py", line 112, in _authenticate
cls, "_auth_method_%s" % auth_method)()
sr/lib/python2.7/dist-packages/odoo/addons/website/models/ir_http.py", line 65, in _auth_method_public
uid = website.user_id.id
sr/lib/python2.7/dist-packages/odoo/fields.py", line 869, in __get__
ermine_value(record)
sr/lib/python2.7/dist-packages/odoo/fields.py", line 971, in determine_value
prefetch_field(self)
sr/lib/python2.7/dist-packages/odoo/models.py", line 3056, in _prefetch_field
records.read([f.name for f in fs], load='_classic_write')
sr/lib/python2.7/dist-packages/odoo/models.py", line 2996, in read
ad_from_database(stored, inherited)
sr/lib/python2.7/dist-packages/odoo/models.py", line 3124, in _read_from_database
te(query_str, params)
sr/lib/python2.7/dist-packages/odoo/sql_db.py", line 141, in wrapper
(self, *args, **kwargs)
sr/lib/python2.7/dist-packages/odoo/sql_db.py", line 218, in execute
lf._obj.execute(query, params)
ingError: column website.channel_id does not exist
...d","website"."social_youtube" as "social_youtube","website"....
26 02:36:06,702 1 [1;32m[1;49mINFO[0m edh_vietnam werkzeug: 172.17.0.1 - - [26/Jul/2017 02:36:06] "GET / HTTP/1.1" 403 -
26 02:36:06,819 1 [1;32m[1;49mINFO[0m edh_vietnam odoo.sql_db: bad query: SELECT "website"."user_id" as "user_id","website"."cdn_activated" as "cdn_activated","website"."social_linkedin" as "social_linkedin","website"."compress_html" as "compress_html","website"."google_analytics_key" as "google_analytics_key","website"."create_uid" as "create_uid","website"."company_id" as "company_id","website"."default_lang_id" as "default_lang_id","website"."website_form_enable_metadata" as "website_form_enable_metadata","website"."cdn_filters" as "cdn_filters","website"."name" as "name","website"."write_uid" as "write_uid","website"."social_youtube" as "social_youtube","website"."channel_id" as "channel_id","website"."social_twitter" as "social_twitter","website"."id" as "id","website"."social_facebook" as "social_facebook","website"."cdn_url" as "cdn_url","website"."create_date" as "create_date","website"."social_github" as "social_github","website"."default_lang_code" as "default_lang_code","website"."write_date" as "write_date","website"."social_googleplus" as "social_googleplus","website"."domain" as "domain" FROM "website"
ebsite".id IN (1) ORDER BY "website"."id"
26 02:36:06,820 1 [1;32m[1;49mINFO[0m edh_vietnam werkzeug: 172.17.0.1 - - [26/Jul/2017 02:36:06] "GET /favicon.ico HTTP/1.1" 500 -
26 02:36:06,830 1 [1;31m[1;49mERROR[0m edh_vietnam werkzeug: Error on request:
k (most recent call last):
sr/lib/python2.7/dist-packages/werkzeug/serving.py", line 177, in run_wsgi
self.server.app)
sr/lib/python2.7/dist-packages/werkzeug/serving.py", line 165, in execute
ion_iter = app(environ, start_response)
sr/lib/python2.7/dist-packages/odoo/service/server.py", line 246, in app
elf.app(e, s)
sr/lib/python2.7/dist-packages/odoo/service/wsgi_server.py", line 184, in application
pplication_unproxied(environ, start_response)
sr/lib/python2.7/dist-packages/odoo/service/wsgi_server.py", line 170, in application_unproxied
handler(environ, start_response)
sr/lib/python2.7/dist-packages/odoo/http.py", line 1306, in __call__
elf.dispatch(environ, start_response)
sr/lib/python2.7/dist-packages/odoo/http.py", line 1280, in __call__
elf.app(environ, start_wrapped)
sr/lib/python2.7/dist-packages/werkzeug/wsgi.py", line 588, in __call__
elf.app(environ, start_response)
sr/lib/python2.7/dist-packages/odoo/http.py", line 1471, in dispatch
ir_http._dispatch()
sr/lib/python2.7/dist-packages/odoo/addons/website/models/ir_http.py", line 169, in _dispatch
ls._handle_exception(e)
sr/lib/python2.7/dist-packages/odoo/addons/website/models/ir_http.py", line 270, in _handle_exception
uper(Http, cls)._handle_exception(exception)
sr/lib/python2.7/dist-packages/odoo/addons/base/ir/ir_http.py", line 169, in _handle_exception
equest._handle_exception(exception)
sr/lib/python2.7/dist-packages/odoo/http.py", line 766, in _handle_exception
uper(HttpRequest, self)._handle_exception(exception)
sr/lib/python2.7/dist-packages/odoo/addons/website/models/ir_http.py", line 167, in _dispatch
h_method_public()
sr/lib/python2.7/dist-packages/odoo/addons/website/models/ir_http.py", line 65, in _auth_method_public
uid = website.user_id.id
sr/lib/python2.7/dist-packages/odoo/fields.py", line 869, in __get__
ermine_value(record)
sr/lib/python2.7/dist-packages/odoo/fields.py", line 971, in determine_value
prefetch_field(self)
sr/lib/python2.7/dist-packages/odoo/models.py", line 3056, in _prefetch_field
records.read([f.name for f in fs], load='_classic_write')
sr/lib/python2.7/dist-packages/odoo/models.py", line 2996, in read
ad_from_database(stored, inherited)
sr/lib/python2.7/dist-packages/odoo/models.py", line 3124, in _read_from_database
te(query_str, params)
sr/lib/python2.7/dist-packages/odoo/sql_db.py", line 141, in wrapper
(self, *args, **kwargs)
sr/lib/python2.7/dist-packages/odoo/sql_db.py", line 218, in execute
lf._obj.execute(query, params)
ingError: column website.channel_id does not exist
...d","website"."social_youtube" as "social_youtube","website"....
26 02:36:20,697 1 [1;32m[1;49mINFO[0m ? odoo.service.server: Initiating shutdown
26 02:36:20,698 1 [1;32m[1;49mINFO[0m ? odoo.service.server: Hit CTRL-C again or send a second signal to force the shutdown.
26 02:42:32,790 1 [1;32m[1;49mINFO[0m ? odoo: Odoo version 10.0-20170207
26 02:42:32,790 1 [1;32m[1;49mINFO[0m ? odoo: Using configuration file at /etc/odoo/odoo.conf
26 02:42:32,790 1 [1;32m[1;49mINFO[0m ? odoo: addons paths: ['/var/lib/odoo/addons/10.0', u'/mnt/extra-addons', u'/usr/lib/python2.7/dist-packages/odoo/addons']
26 02:42:32,790 1 [1;32m[1;49mINFO[0m ? odoo: database: odoo@172.17.0.8:5432
26 02:42:32,794 1 [1;32m[1;49mINFO[0m ? odoo.service.server: HTTP service (werkzeug) running on 0.0.0.0:8069
26 03:16:06,349 1 [1;32m[1;49mINFO[0m ? odoo.addons.bus.models.bus: Bus.loop listen imbus on db postgres
26 03:16:06,522 1 [1;32m[1;49mINFO[0m ? odoo.addons.report.models.report: Will use the Wkhtmltopdf binary at /usr/local/bin/wkhtmltopdf
26 03:16:06,628 1 [1;32m[1;49mINFO[0m ? odoo.http: HTTP Configuring static files
26 03:16:06,634 1 [1;32m[1;49mINFO[0m edh_vietnam odoo.modules.loading: loading 1 modules...
26 03:16:06,651 1 [1;32m[1;49mINFO[0m edh_vietnam odoo.modules.loading: 1 modules loaded in 0.02s, 0 queries
26 03:16:06,669 1 [1;32m[1;49mINFO[0m edh_vietnam odoo.modules.loading: loading 46 modules...
26 03:16:06,763 1 [1;32m[1;49mINFO[0m edh_vietnam odoo.modules.loading: 46 modules loaded in 0.09s, 0 queries
26 03:16:06,965 1 [1;32m[1;49mINFO[0m edh_vietnam odoo.modules.loading: Modules loaded.
26 03:16:06,968 1 [1;32m[1;49mINFO[0m edh_vietnam odoo.addons.base.ir.ir_http: Generating routing map
26 03:16:07,051 1 [1;32m[1;49mINFO[0m edh_vietnam odoo.sql_db: bad query: SELECT "website"."user_id" as "user_id","website"."social_linkedin" as "social_linkedin","website"."compress_html" as "compress_html","website"."google_analytics_key" as "google_analytics_key","website"."create_uid" as "create_uid","website"."social_twitter" as "social_twitter","website"."default_lang_id" as "default_lang_id","website"."website_form_enable_metadata" as "website_form_enable_metadata","website"."name" as "name","website"."write_uid" as "write_uid","website"."social_youtube" as "social_youtube","website"."channel_id" as "channel_id","website"."id" as "id","website"."cdn_filters" as "cdn_filters","website"."social_facebook" as "social_facebook","website"."cdn_url" as "cdn_url","website"."domain" as "domain","website"."create_date" as "create_date","website"."social_github" as "social_github","website"."default_lang_code" as "default_lang_code","website"."company_id" as "company_id","website"."cdn_activated" as "cdn_activated","website"."write_date" as "write_date","website"."social_googleplus" as "social_googleplus" FROM "website"
ebsite".id IN (1) ORDER BY "website"."id"
26 03:16:07,051 1 [1;32m[1;49mINFO[0m edh_vietnam odoo.addons.base.ir.ir_http: Exception during request Authentication.
k (most recent call last):
sr/lib/python2.7/dist-packages/odoo/addons/base/ir/ir_http.py", line 112, in _authenticate
cls, "_auth_method_%s" % auth_method)()
sr/lib/python2.7/dist-packages/odoo/addons/website/models/ir_http.py", line 65, in _auth_method_public
uid = website.user_id.id
sr/lib/python2.7/dist-packages/odoo/fields.py", line 869, in __get__
ermine_value(record)
sr/lib/python2.7/dist-packages/odoo/fields.py", line 971, in determine_value
prefetch_field(self)
sr/lib/python2.7/dist-packages/odoo/models.py", line 3056, in _prefetch_field
records.read([f.name for f in fs], load='_classic_write')
sr/lib/python2.7/dist-packages/odoo/models.py", line 2996, in read
ad_from_database(stored, inherited)
sr/lib/python2.7/dist-packages/odoo/models.py", line 3124, in _read_from_database
te(query_str, params)
sr/lib/python2.7/dist-packages/odoo/sql_db.py", line 141, in wrapper
(self, *args, **kwargs)
sr/lib/python2.7/dist-packages/odoo/sql_db.py", line 218, in execute
lf._obj.execute(query, params)
ingError: column website.channel_id does not exist
...d","website"."social_youtube" as "social_youtube","website"....
26 03:16:07,053 1 [1;32m[1;49mINFO[0m edh_vietnam werkzeug: 172.17.0.1 - - [26/Jul/2017 03:16:07] "GET / HTTP/1.1" 403 -
26 03:16:07,175 1 [1;32m[1;49mINFO[0m edh_vietnam odoo.sql_db: bad query: SELECT "website"."user_id" as "user_id","website"."social_linkedin" as "social_linkedin","website"."compress_html" as "compress_html","website"."google_analytics_key" as "google_analytics_key","website"."create_uid" as "create_uid","website"."social_twitter" as "social_twitter","website"."default_lang_id" as "default_lang_id","website"."website_form_enable_metadata" as "website_form_enable_metadata","website"."name" as "name","website"."write_uid" as "write_uid","website"."social_youtube" as "social_youtube","website"."channel_id" as "channel_id","website"."id" as "id","website"."cdn_filters" as "cdn_filters","website"."social_facebook" as "social_facebook","website"."cdn_url" as "cdn_url","website"."domain" as "domain","website"."create_date" as "create_date","website"."social_github" as "social_github","website"."default_lang_code" as "default_lang_code","website"."company_id" as "company_id","website"."cdn_activated" as "cdn_activated","website"."write_date" as "write_date","website"."social_googleplus" as "social_googleplus" FROM "website"
ebsite".id IN (1) ORDER BY "website"."id"
26 03:16:07,176 1 [1;32m[1;49mINFO[0m edh_vietnam werkzeug: 172.17.0.1 - - [26/Jul/2017 03:16:07] "GET /favicon.ico HTTP/1.1" 500 -
26 03:16:07,187 1 [1;31m[1;49mERROR[0m edh_vietnam werkzeug: Error on request:
k (most recent call last):
sr/lib/python2.7/dist-packages/werkzeug/serving.py", line 177, in run_wsgi
self.server.app)
sr/lib/python2.7/dist-packages/werkzeug/serving.py", line 165, in execute
ion_iter = app(environ, start_response)
sr/lib/python2.7/dist-packages/odoo/service/server.py", line 246, in app
elf.app(e, s)
sr/lib/python2.7/dist-packages/odoo/service/wsgi_server.py", line 184, in application
pplication_unproxied(environ, start_response)
sr/lib/python2.7/dist-packages/odoo/service/wsgi_server.py", line 170, in application_unproxied
handler(environ, start_response)
sr/lib/python2.7/dist-packages/odoo/http.py", line 1306, in __call__
elf.dispatch(environ, start_response)
sr/lib/python2.7/dist-packages/odoo/http.py", line 1280, in __call__
elf.app(environ, start_wrapped)
sr/lib/python2.7/dist-packages/werkzeug/wsgi.py", line 588, in __call__
elf.app(environ, start_response)
sr/lib/python2.7/dist-packages/odoo/http.py", line 1471, in dispatch
ir_http._dispatch()
sr/lib/python2.7/dist-packages/odoo/addons/website/models/ir_http.py", line 169, in _dispatch
ls._handle_exception(e)
sr/lib/python2.7/dist-packages/odoo/addons/website/models/ir_http.py", line 270, in _handle_exception
uper(Http, cls)._handle_exception(exception)
sr/lib/python2.7/dist-packages/odoo/addons/base/ir/ir_http.py", line 169, in _handle_exception
equest._handle_exception(exception)
sr/lib/python2.7/dist-packages/odoo/http.py", line 766, in _handle_exception
uper(HttpRequest, self)._handle_exception(exception)
sr/lib/python2.7/dist-packages/odoo/addons/website/models/ir_http.py", line 167, in _dispatch
h_method_public()
sr/lib/python2.7/dist-packages/odoo/addons/website/models/ir_http.py", line 65, in _auth_method_public
uid = website.user_id.id
sr/lib/python2.7/dist-packages/odoo/fields.py", line 869, in __get__
ermine_value(record)
sr/lib/python2.7/dist-packages/odoo/fields.py", line 971, in determine_value
prefetch_field(self)
sr/lib/python2.7/dist-packages/odoo/models.py", line 3056, in _prefetch_field
records.read([f.name for f in fs], load='_classic_write')
sr/lib/python2.7/dist-packages/odoo/models.py", line 2996, in read
ad_from_database(stored, inherited)
sr/lib/python2.7/dist-packages/odoo/models.py", line 3124, in _read_from_database
te(query_str, params)
sr/lib/python2.7/dist-packages/odoo/sql_db.py", line 141, in wrapper
(self, *args, **kwargs)
sr/lib/python2.7/dist-packages/odoo/sql_db.py", line 218, in execute
lf._obj.execute(query, params)
ingError: column website.channel_id does not exist
...d","website"."social_youtube" as "social_youtube","website"....