openerp - PSQL Module Live Chat (odoo) -
i'm trying manually uninstall live chat module, please me correct name live chat module? , located in ir_module_module?
within psql 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 use these:
delete ir_model ir ir.model = 'live_chat';
delete ir_model_data ird ird.module = 'live_chat'
delete ir_model_fields irf irf.model = 'live_chat'
and this
update ir_module_module set state='to remove' name='live_chat' , state='installed';
all return 0.
many thanks
error got logs
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 @ /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: use wkhtmltopdf binary @ /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" "user_id","website"."cdn_activated" "cdn_activated","website"."social_linkedin" "social_linkedin","website"."compress_html" "compress_html","website"."google_analytics_key" "google_analytics_key","website"."create_uid" "create_uid","website"."company_id" "company_id","website"."default_lang_id" "default_lang_id","website"."website_form_enable_metadata" "website_form_enable_metadata","website"."cdn_filters" "cdn_filters","website"."name" "name","website"."write_uid" "write_uid","website"."social_youtube" "social_youtube","website"."channel_id" "channel_id","website"."social_twitter" "social_twitter","website"."id" "id","website"."social_facebook" "social_facebook","website"."cdn_url" "cdn_url","website"."create_date" "create_date","website"."social_github" "social_github","website"."default_lang_code" "default_lang_code","website"."write_date" "write_date","website"."social_googleplus" "social_googleplus","website"."domain" "domain" "website" ebsite".id in (1) order "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 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 not exist ...d","website"."social_youtube" "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" "user_id","website"."cdn_activated" "cdn_activated","website"."social_linkedin" "social_linkedin","website"."compress_html" "compress_html","website"."google_analytics_key" "google_analytics_key","website"."create_uid" "create_uid","website"."company_id" "company_id","website"."default_lang_id" "default_lang_id","website"."website_form_enable_metadata" "website_form_enable_metadata","website"."cdn_filters" "cdn_filters","website"."name" "name","website"."write_uid" "write_uid","website"."social_youtube" "social_youtube","website"."channel_id" "channel_id","website"."social_twitter" "social_twitter","website"."id" "id","website"."social_facebook" "social_facebook","website"."cdn_url" "cdn_url","website"."create_date" "create_date","website"."social_github" "social_github","website"."default_lang_code" "default_lang_code","website"."write_date" "write_date","website"."social_googleplus" "social_googleplus","website"."domain" "domain" "website" ebsite".id in (1) order "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 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 not exist ...d","website"."social_youtube" "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 second signal force 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 @ /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: use wkhtmltopdf binary @ /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" "user_id","website"."social_linkedin" "social_linkedin","website"."compress_html" "compress_html","website"."google_analytics_key" "google_analytics_key","website"."create_uid" "create_uid","website"."social_twitter" "social_twitter","website"."default_lang_id" "default_lang_id","website"."website_form_enable_metadata" "website_form_enable_metadata","website"."name" "name","website"."write_uid" "write_uid","website"."social_youtube" "social_youtube","website"."channel_id" "channel_id","website"."id" "id","website"."cdn_filters" "cdn_filters","website"."social_facebook" "social_facebook","website"."cdn_url" "cdn_url","website"."domain" "domain","website"."create_date" "create_date","website"."social_github" "social_github","website"."default_lang_code" "default_lang_code","website"."company_id" "company_id","website"."cdn_activated" "cdn_activated","website"."write_date" "write_date","website"."social_googleplus" "social_googleplus" "website" ebsite".id in (1) order "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 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 not exist ...d","website"."social_youtube" "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" "user_id","website"."social_linkedin" "social_linkedin","website"."compress_html" "compress_html","website"."google_analytics_key" "google_analytics_key","website"."create_uid" "create_uid","website"."social_twitter" "social_twitter","website"."default_lang_id" "default_lang_id","website"."website_form_enable_metadata" "website_form_enable_metadata","website"."name" "name","website"."write_uid" "write_uid","website"."social_youtube" "social_youtube","website"."channel_id" "channel_id","website"."id" "id","website"."cdn_filters" "cdn_filters","website"."social_facebook" "social_facebook","website"."cdn_url" "cdn_url","website"."domain" "domain","website"."create_date" "create_date","website"."social_github" "social_github","website"."default_lang_code" "default_lang_code","website"."company_id" "company_id","website"."cdn_activated" "cdn_activated","website"."write_date" "write_date","website"."social_googleplus" "social_googleplus" "website" ebsite".id in (1) order "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 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 not exist ...d","website"."social_youtube" "social_youtube","website"....
Comments
Post a Comment