keshrath
commented
5 years ago Should be solved by the newest commit
Closed MosabWadea closed 5 years ago
keshrath
commented
5 years ago Should be solved by the newest commit
MosabWadea
commented
5 years ago I am afraid that it is not...
I had to checkout to the same point again
I restarted odoo service and here is the odoo log:
2019-03-15 11:31:21,202 11752 INFO ? odoo.service.server: Initiating shutdown
2019-03-15 11:31:21,202 11752 INFO ? odoo.service.server: Hit CTRL-C again or send a second signal to force the shutdown.
2019-03-15 11:31:22,557 11803 INFO ? odoo: Odoo version 12.0-20190315
2019-03-15 11:31:22,557 11803 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf
2019-03-15 11:31:22,557 11803 INFO ? odoo: addons paths: ['/var/lib/odoo/.local/share/Odoo/addons/12.0', '/usr/lib/python3/dist-packages/odoo/addons', '/home/odoo12/oapps', '/home/odoo12/oapps/muk_base', '/home/odoo12/oapps/muk_dms', '/home/odoo12/oapps/muk_misc', '/home/odoo12/oapps/muk_web', '/home/odoo12/oapps/muk_website', '/home/odoo12/oapps/pos', '/home/odoo12/oapps/product-attribute', '/home/odoo12/oapps/web', '/home/odoo12/oapps/website', '/home/odoo12/oapps/om-accounting', '/home/odoo12/oapps/CybroAddons', '/home/odoo12/oapps/SerpentCS_Contributions', '/home/odoo12/oapps/server-backend']
2019-03-15 11:31:22,557 11803 INFO ? odoo: database: odoo@default:default
2019-03-15 11:31:22,654 11803 INFO ? odoo.addons.base.models.ir_actions_report: Will use the Wkhtmltopdf binary at /usr/local/bin/wkhtmltopdf
2019-03-15 11:31:22,778 11803 INFO ? odoo.service.server: HTTP service (werkzeug) running on ubuntu-16gb-nbg1-1:8069
2019-03-15 11:31:27,170 11803 INFO ? odoo.http: HTTP Configuring static files
2019-03-15 11:31:27,193 11803 INFO MirzaLib1 odoo.modules.loading: loading 1 modules...
2019-03-15 11:31:27,211 11803 INFO MirzaLib1 odoo.modules.loading: 1 modules loaded in 0.02s, 0 queries
2019-03-15 11:31:27,234 11803 WARNING MirzaLib1 odoo.modules.graph: module theme_common: not installable, skipped
2019-03-15 11:31:27,347 11803 INFO MirzaLib1 odoo.modules.loading: loading 146 modules...
2019-03-15 11:31:27,661 11803 INFO MirzaLib1 odoo.addons.sms.wizard.send_sms: The `phonenumbers` Python module is not available. Phone number validation will be skipped. Try `pip3 install phonenumbers` to install it.
2019-03-15 11:31:28,031 11803 WARNING MirzaLib1 odoo.models: The model report.accounting_pdf_reports.report_partnerledger has no _description
2019-03-15 11:31:28,031 11803 WARNING MirzaLib1 odoo.models: The model report.accounting_pdf_reports.report_generalledger has no _description
2019-03-15 11:31:28,031 11803 WARNING MirzaLib1 odoo.models: The model report.accounting_pdf_reports.report_trialbalance has no _description
2019-03-15 11:31:28,032 11803 WARNING MirzaLib1 odoo.models: The model report.accounting_pdf_reports.report_tax has no _description
2019-03-15 11:31:28,032 11803 WARNING MirzaLib1 odoo.models: The model report.accounting_pdf_reports.report_agedpartnerbalance has no _description
2019-03-15 11:31:28,032 11803 WARNING MirzaLib1 odoo.models: The model report.accounting_pdf_reports.report_journal has no _description
2019-03-15 11:31:28,032 11803 WARNING MirzaLib1 odoo.models: The model report.accounting_pdf_reports.report_financial has no _description
2019-03-15 11:31:28,287 11803 INFO MirzaLib1 odoo.modules.loading: 146 modules loaded in 0.94s, 0 queries
2019-03-15 11:31:29,205 11803 INFO MirzaLib1 odoo.fields: Field fleet.vehicle.log.contract.name depends on non-stored field fleet.vehicle.log.contract.vehicle_id
2019-03-15 11:31:29,206 11803 INFO MirzaLib1 odoo.fields: Field fleet.vehicle.log.contract.name depends on non-stored field fleet.vehicle.log.contract.cost_subtype_id
2019-03-15 11:31:29,206 11803 INFO MirzaLib1 odoo.fields: Field fleet.vehicle.log.contract.name depends on non-stored field fleet.vehicle.log.contract.date
2019-03-15 11:31:29,224 11803 INFO MirzaLib1 odoo.fields: Field stock.production.lot.product_uom_id depends on non-stored field product.product.uom_id
2019-03-15 11:31:29,225 11803 INFO MirzaLib1 odoo.fields: Field stock.picking.move_ids_without_package depends on non-stored field stock.move.picking_type_entire_packs
2019-03-15 11:31:29,225 11803 INFO MirzaLib1 odoo.fields: Field stock.picking.move_line_ids_without_package depends on non-stored field stock.move.line.picking_type_entire_packs
2019-03-15 11:31:29,253 11803 INFO MirzaLib1 odoo.fields: Field purchase.order.line.product_uom_qty depends on non-stored field product.product.uom_id
2019-03-15 11:31:29,256 11803 INFO MirzaLib1 odoo.fields: Field sale.order.invoice_status depends on non-stored field product.product.invoice_policy
2019-03-15 11:31:29,260 11803 INFO MirzaLib1 odoo.fields: Field stock.valuation.adjustment.lines.name depends on non-stored field product.product.code
2019-03-15 11:31:29,260 11803 INFO MirzaLib1 odoo.fields: Field stock.valuation.adjustment.lines.name depends on non-stored field product.product.name
2019-03-15 11:31:29,260 11803 INFO MirzaLib1 odoo.fields: Field delivery.carrier.company_id depends on non-stored field product.product.company_id
2019-03-15 11:31:29,261 11803 INFO MirzaLib1 odoo.fields: Field delivery.carrier.fixed_price depends on non-stored field product.product.list_price
2019-03-15 11:31:29,263 11803 INFO MirzaLib1 odoo.modules.loading: Modules loaded.
2019-03-15 11:31:29,314 11803 INFO MirzaLib1 odoo.addons.base.models.ir_http: Generating routing map
2019-03-15 11:31:29,474 11803 ERROR MirzaLib1 odoo.sql_db: bad query: b'SELECT "res_company"."id" as "id","res_company"."partner_id" as "partner_id","res_company"."cash_account_code_prefix" as "cash_account_code_prefix","res_company"."property_stock_account_output_categ_id" as "property_stock_account_output_categ_id","res_company"."vat_check_vies" as "vat_check_vies","res_company"."sale_quotation_onboarding_state" as "sale_quotation_onboarding_state","res_company"."invoice_is_snailmail" as "invoice_is_snailmail","res_company"."sale_onboarding_order_confirmation_state" as "sale_onboarding_order_confirmation_state","res_company"."social_twitter" as "social_twitter","res_company"."currency_id" as "currency_id","res_company"."transfer_account_code_prefix" as "transfer_account_code_prefix","res_company"."property_stock_valuation_account_id" as "property_stock_valuation_account_id","res_company"."portal_confirmation_sign" as "portal_confirmation_sign","res_company"."base_onboarding_company_state" as "base_onboarding_company_state","res_company"."social_facebook" as "social_facebook","res_company"."sale_onboarding_sample_quotation_state" as "sale_onboarding_sample_quotation_state","res_company"."portal_confirmation_pay" as "portal_confirmation_pay","res_company"."favicon_backend_mimetype" as "favicon_backend_mimetype","res_company"."sale_onboarding_payment_method" as "sale_onboarding_payment_method","res_company"."social_github" as "social_github","res_company"."incoterm_id" as "incoterm_id","res_company"."quotation_validity_days" as "quotation_validity_days","res_company"."background_blend_mode" as "background_blend_mode","res_company"."website_sale_onboarding_payment_acquirer_state" as "website_sale_onboarding_payment_acquirer_state","res_company"."social_linkedin" as "social_linkedin","res_company"."account_opening_move_id" as "account_opening_move_id","res_company"."default_sidebar_preference" as "default_sidebar_preference","res_company"."sale_template" as "sale_template","res_company"."social_youtube" as "social_youtube","res_company"."paperformat_id" as "paperformat_id","res_company"."sequence" as "sequence","res_company"."create_date" as "create_date","res_company"."default_chatter_preference" as "default_chatter_preference","res_company"."purchase_template" as "purchase_template","res_company"."social_googleplus" as "social_googleplus","res_company"."external_report_layout_id" as "external_report_layout_id","res_company"."project_time_mode_id" as "project_time_mode_id","res_company"."snailmail_color" as "snailmail_color","res_company"."write_date" as "write_date","res_company"."payment_acquirer_onboarding_state" as "payment_acquirer_onboarding_state","res_company"."stock_template" as "stock_template","res_company"."social_instagram" as "social_instagram","res_company"."timesheet_encode_uom_id" as "timesheet_encode_uom_id","res_company"."snailmail_duplex" as "snailmail_duplex","res_company"."payment_onboarding_payment_method" as "payment_onboarding_payment_method","res_company"."account_template" as "account_template","res_company"."resource_calendar_id" as "resource_calendar_id","res_company"."leave_timesheet_project_id" as "leave_timesheet_project_id","res_company"."propagation_minimum_delta" as "propagation_minimum_delta","res_company"."fiscalyear_last_month" as "fiscalyear_last_month","res_company"."bank_account_code_prefix" as "bank_account_code_prefix","res_company"."fiscalyear_last_day" as "fiscalyear_last_day","res_company"."leave_timesheet_task_id" as "leave_timesheet_task_id","res_company"."nomenclature_id" as "nomenclature_id","res_company"."tax_calculation_rounding_method" as "tax_calculation_rounding_method","res_company"."internal_transit_location_id" as "internal_transit_location_id","res_company"."period_lock_date" as "period_lock_date","res_company"."invoice_reference_type" as "invoice_reference_type","res_company"."bank_account_id" as "bank_account_id","res_company"."fiscalyear_lock_date" as "fiscalyear_lock_date","res_company"."account_setup_bank_data_state" as "account_setup_bank_data_state","res_company"."transfer_account_id" as "transfer_account_id","res_company"."create_uid" as "create_uid","res_company"."expects_chart_of_accounts" as "expects_chart_of_accounts",COALESCE("res_company__overdue_msg"."value", "res_company"."overdue_msg") as "overdue_msg","res_company"."account_setup_fy_data_state" as "account_setup_fy_data_state","res_company"."chart_template_id" as "chart_template_id","res_company"."write_uid" as "write_uid","res_company"."anglo_saxon_accounting" as "anglo_saxon_accounting","res_company"."po_lead" as "po_lead","res_company"."account_setup_coa_state" as "account_setup_coa_state","res_company"."email" as "email","res_company"."account_sale_tax_id" as "account_sale_tax_id","res_company"."tax_exigibility" as "tax_exigibility","res_company"."po_double_validation_amount" as "po_double_validation_amount","res_company"."account_onboarding_invoice_layout_state" as "account_onboarding_invoice_layout_state","res_company"."phone" as "phone","res_company"."account_purchase_tax_id" as "account_purchase_tax_id","res_company"."account_bank_reconciliation_start" as "account_bank_reconciliation_start",COALESCE("res_company__sale_note"."value", "res_company"."sale_note") as "sale_note","res_company"."account_onboarding_sample_invoice_state" as "account_onboarding_sample_invoice_state","res_company"."tax_cash_basis_journal_id" as "tax_cash_basis_journal_id","res_company"."qr_code" as "qr_code","res_company"."report_header" as "report_header","res_company"."security_lead" as "security_lead","res_company"."account_onboarding_sale_tax_state" as "account_onboarding_sale_tax_state","res_company"."currency_exchange_journal_id" as "currency_exchange_journal_id","res_company"."invoice_is_email" as "invoice_is_email",COALESCE("res_company__report_footer"."value", "res_company"."report_footer") as "report_footer","res_company"."account_invoice_onboarding_state" as "account_invoice_onboarding_state","res_company"."name" as "name","res_company"."company_registry" as "company_registry","res_company"."invoice_is_print" as "invoice_is_print","res_company"."account_dashboard_onboarding_state" as "account_dashboard_onboarding_state","res_company"."account_no" as "account_no","res_company"."parent_id" as "parent_id","res_company"."po_lock" as "po_lock","res_company"."property_stock_account_input_categ_id" as "property_stock_account_input_categ_id","res_company"."po_double_validation" as "po_double_validation" FROM "res_company" LEFT JOIN \n (SELECT res_id, value FROM "ir_translation"\n WHERE name=\'res.company,overdue_msg\' AND lang=\'en_US\' AND value!=\'\'\n ORDER BY res_id, id DESC)\n as "res_company__overdue_msg" ON ("res_company"."id" = "res_company__overdue_msg"."res_id") LEFT JOIN \n (SELECT res_id, value FROM "ir_translation"\n WHERE name=\'res.company,sale_note\' AND lang=\'en_US\' AND value!=\'\'\n ORDER BY res_id, id DESC)\n as "res_company__sale_note" ON ("res_company"."id" = "res_company__sale_note"."res_id") LEFT JOIN \n (SELECT res_id, value FROM "ir_translation"\n WHERE name=\'res.company,report_footer\' AND lang=\'en_US\' AND value!=\'\'\n ORDER BY res_id, id DESC)\n as "res_company__report_footer" ON ("res_company"."id" = "res_company__report_footer"."res_id") WHERE "res_company".id IN (1)'
ERROR: column res_company.background_blend_mode does not exist
LINE 1: ...ation_validity_days" as "quotation_validity_days","res_compa...
^
2019-03-15 11:31:29,478 11803 ERROR MirzaLib1 odoo.addons.website.models.ir_http: 500 Internal Server Error:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/api.py", line 1039, in get
value = self._data[key][field][record._ids[0]]
KeyError: 1
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 976, in __get__
value = record.env.cache.get(record, self)
File "/usr/lib/python3/dist-packages/odoo/api.py", line 1041, in get
raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: ('res.company(1,).name', None)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 203, in _dispatch
result = request.dispatch()
File "/usr/lib/python3/dist-packages/odoo/http.py", line 833, in dispatch
r = self._call_function(**self.params)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 344, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 97, in wrapper
return f(dbname, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 340, in checked_call
result.flatten()
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1268, in flatten
self.response.append(self.render())
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1261, in render
return env["ir.ui.view"].render_template(self.template, self.qcontext)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_ui_view.py", line 1284, in render_template
return self.browse(self.get_view_id(template)).render(values, engine)
File "/usr/lib/python3/dist-packages/odoo/addons/website/models/ir_ui_view.py", line 318, in render
return super(View, self).render(values, engine=engine, minimal_qcontext=minimal_qcontext)
File "/usr/lib/python3/dist-packages/odoo/addons/web_editor/models/ir_ui_view.py", line 27, in render
return super(IrUiView, self).render(values=values, engine=engine, minimal_qcontext=minimal_qcontext)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_ui_view.py", line 1290, in render
qcontext = dict() if minimal_qcontext else self._prepare_qcontext()
File "/usr/lib/python3/dist-packages/odoo/addons/website/models/ir_ui_view.py", line 344, in _prepare_qcontext
qcontext['multi_website_companies_current'] = {'company_id': cur_company.id, 'name': cur_company.name}
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 980, in __get__
self.determine_value(record)
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1081, in determine_value
record._prefetch_field(self)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 2827, in _prefetch_field
result = records.read([f.name for f in fs], load='_classic_write')
File "/usr/lib/python3/dist-packages/odoo/models.py", line 2765, in read
self._read_from_database(stored, inherited)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 2892, in _read_from_database
cr.execute(query_str, params)
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 148, in wrapper
return f(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 225, in execute
res = self._obj.execute(query, params)
psycopg2.ProgrammingError: column res_company.background_blend_mode does not exist
LINE 1: ...ation_validity_days" as "quotation_validity_days","res_compa...
^
2019-03-15 11:31:29,499 11803 ERROR MirzaLib1 odoo.sql_db: bad query: b'SELECT "res_company"."id" as "id","res_company"."partner_id" as "partner_id","res_company"."cash_account_code_prefix" as "cash_account_code_prefix","res_company"."property_stock_account_output_categ_id" as "property_stock_account_output_categ_id","res_company"."vat_check_vies" as "vat_check_vies","res_company"."sale_quotation_onboarding_state" as "sale_quotation_onboarding_state","res_company"."invoice_is_snailmail" as "invoice_is_snailmail","res_company"."sale_onboarding_order_confirmation_state" as "sale_onboarding_order_confirmation_state","res_company"."social_twitter" as "social_twitter","res_company"."currency_id" as "currency_id","res_company"."transfer_account_code_prefix" as "transfer_account_code_prefix","res_company"."property_stock_valuation_account_id" as "property_stock_valuation_account_id","res_company"."portal_confirmation_sign" as "portal_confirmation_sign","res_company"."base_onboarding_company_state" as "base_onboarding_company_state","res_company"."social_facebook" as "social_facebook","res_company"."sale_onboarding_sample_quotation_state" as "sale_onboarding_sample_quotation_state","res_company"."portal_confirmation_pay" as "portal_confirmation_pay","res_company"."favicon_backend_mimetype" as "favicon_backend_mimetype","res_company"."sale_onboarding_payment_method" as "sale_onboarding_payment_method","res_company"."social_github" as "social_github","res_company"."incoterm_id" as "incoterm_id","res_company"."quotation_validity_days" as "quotation_validity_days","res_company"."background_blend_mode" as "background_blend_mode","res_company"."website_sale_onboarding_payment_acquirer_state" as "website_sale_onboarding_payment_acquirer_state","res_company"."social_linkedin" as "social_linkedin","res_company"."account_opening_move_id" as "account_opening_move_id","res_company"."default_sidebar_preference" as "default_sidebar_preference","res_company"."sale_template" as "sale_template","res_company"."social_youtube" as "social_youtube","res_company"."paperformat_id" as "paperformat_id","res_company"."sequence" as "sequence","res_company"."create_date" as "create_date","res_company"."default_chatter_preference" as "default_chatter_preference","res_company"."purchase_template" as "purchase_template","res_company"."social_googleplus" as "social_googleplus","res_company"."external_report_layout_id" as "external_report_layout_id","res_company"."project_time_mode_id" as "project_time_mode_id","res_company"."snailmail_color" as "snailmail_color","res_company"."write_date" as "write_date","res_company"."payment_acquirer_onboarding_state" as "payment_acquirer_onboarding_state","res_company"."stock_template" as "stock_template","res_company"."social_instagram" as "social_instagram","res_company"."timesheet_encode_uom_id" as "timesheet_encode_uom_id","res_company"."snailmail_duplex" as "snailmail_duplex","res_company"."payment_onboarding_payment_method" as "payment_onboarding_payment_method","res_company"."account_template" as "account_template","res_company"."resource_calendar_id" as "resource_calendar_id","res_company"."leave_timesheet_project_id" as "leave_timesheet_project_id","res_company"."propagation_minimum_delta" as "propagation_minimum_delta","res_company"."fiscalyear_last_month" as "fiscalyear_last_month","res_company"."bank_account_code_prefix" as "bank_account_code_prefix","res_company"."fiscalyear_last_day" as "fiscalyear_last_day","res_company"."leave_timesheet_task_id" as "leave_timesheet_task_id","res_company"."nomenclature_id" as "nomenclature_id","res_company"."tax_calculation_rounding_method" as "tax_calculation_rounding_method","res_company"."internal_transit_location_id" as "internal_transit_location_id","res_company"."period_lock_date" as "period_lock_date","res_company"."invoice_reference_type" as "invoice_reference_type","res_company"."bank_account_id" as "bank_account_id","res_company"."fiscalyear_lock_date" as "fiscalyear_lock_date","res_company"."account_setup_bank_data_state" as "account_setup_bank_data_state","res_company"."transfer_account_id" as "transfer_account_id","res_company"."create_uid" as "create_uid","res_company"."expects_chart_of_accounts" as "expects_chart_of_accounts",COALESCE("res_company__overdue_msg"."value", "res_company"."overdue_msg") as "overdue_msg","res_company"."account_setup_fy_data_state" as "account_setup_fy_data_state","res_company"."chart_template_id" as "chart_template_id","res_company"."write_uid" as "write_uid","res_company"."anglo_saxon_accounting" as "anglo_saxon_accounting","res_company"."po_lead" as "po_lead","res_company"."account_setup_coa_state" as "account_setup_coa_state","res_company"."email" as "email","res_company"."account_sale_tax_id" as "account_sale_tax_id","res_company"."tax_exigibility" as "tax_exigibility","res_company"."po_double_validation_amount" as "po_double_validation_amount","res_company"."account_onboarding_invoice_layout_state" as "account_onboarding_invoice_layout_state","res_company"."phone" as "phone","res_company"."account_purchase_tax_id" as "account_purchase_tax_id","res_company"."account_bank_reconciliation_start" as "account_bank_reconciliation_start",COALESCE("res_company__sale_note"."value", "res_company"."sale_note") as "sale_note","res_company"."account_onboarding_sample_invoice_state" as "account_onboarding_sample_invoice_state","res_company"."tax_cash_basis_journal_id" as "tax_cash_basis_journal_id","res_company"."qr_code" as "qr_code","res_company"."report_header" as "report_header","res_company"."security_lead" as "security_lead","res_company"."account_onboarding_sale_tax_state" as "account_onboarding_sale_tax_state","res_company"."currency_exchange_journal_id" as "currency_exchange_journal_id","res_company"."invoice_is_email" as "invoice_is_email",COALESCE("res_company__report_footer"."value", "res_company"."report_footer") as "report_footer","res_company"."account_invoice_onboarding_state" as "account_invoice_onboarding_state","res_company"."name" as "name","res_company"."company_registry" as "company_registry","res_company"."invoice_is_print" as "invoice_is_print","res_company"."account_dashboard_onboarding_state" as "account_dashboard_onboarding_state","res_company"."account_no" as "account_no","res_company"."parent_id" as "parent_id","res_company"."po_lock" as "po_lock","res_company"."property_stock_account_input_categ_id" as "property_stock_account_input_categ_id","res_company"."po_double_validation" as "po_double_validation" FROM "res_company" LEFT JOIN \n (SELECT res_id, value FROM "ir_translation"\n WHERE name=\'res.company,overdue_msg\' AND lang=\'en_US\' AND value!=\'\'\n ORDER BY res_id, id DESC)\n as "res_company__overdue_msg" ON ("res_company"."id" = "res_company__overdue_msg"."res_id") LEFT JOIN \n (SELECT res_id, value FROM "ir_translation"\n WHERE name=\'res.company,sale_note\' AND lang=\'en_US\' AND value!=\'\'\n ORDER BY res_id, id DESC)\n as "res_company__sale_note" ON ("res_company"."id" = "res_company__sale_note"."res_id") LEFT JOIN \n (SELECT res_id, value FROM "ir_translation"\n WHERE name=\'res.company,report_footer\' AND lang=\'en_US\' AND value!=\'\'\n ORDER BY res_id, id DESC)\n as "res_company__report_footer" ON ("res_company"."id" = "res_company__report_footer"."res_id") WHERE "res_company".id IN (1)'
ERROR: column res_company.background_blend_mode does not exist
LINE 1: ...ation_validity_days" as "quotation_validity_days","res_compa...
^
2019-03-15 11:31:29,501 11803 ERROR MirzaLib1 odoo.sql_db: bad query: b'SELECT "ir_ui_view".id FROM "ir_ui_view" LEFT JOIN "website" as "ir_ui_view__website_id" ON ("ir_ui_view"."website_id" = "ir_ui_view__website_id"."id") WHERE (("ir_ui_view"."active" = true) AND (("ir_ui_view"."key" = \'website.http_error\') AND (("ir_ui_view"."website_id" in (1)) OR "ir_ui_view"."website_id" IS NULL))) AND TRUE ORDER BY "ir_ui_view__website_id"."id" limit 1'
ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-03-15 11:31:29,603 11803 INFO MirzaLib1 werkzeug: 127.0.0.1 - - [15/Mar/2019 11:31:29] "GET /en_US/ HTTP/1.1" 500 - 75 0.083 2.348
2019-03-15 11:31:29,609 11803 ERROR MirzaLib1 werkzeug: Error on request:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 270, in run_wsgi
execute(self.server.app)
File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 258, in execute
application_iter = app(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 350, in app
return self.app(e, s)
File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 128, in application
return application_unproxied(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 117, in application_unproxied
result = odoo.http.root(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1318, in __call__
return self.dispatch(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1291, in __call__
return self.app(environ, start_wrapped)
File "/usr/lib/python3/dist-packages/werkzeug/wsgi.py", line 766, in __call__
return self.app(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1486, in dispatch
result = ir_http._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/website_sale/models/ir_http.py", line 15, in _dispatch
return super(IrHttp, cls)._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/auth_signup/models/ir_http.py", line 19, in _dispatch
return super(Http, cls)._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/web_editor/models/ir_http.py", line 22, in _dispatch
return super(IrHttp, cls)._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/http_routing/models/ir_http.py", line 383, in _dispatch
return cls.reroute('/'.join(path) or '/')
File "/usr/lib/python3/dist-packages/odoo/addons/http_routing/models/ir_http.py", line 415, in reroute
return cls._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/website_sale/models/ir_http.py", line 15, in _dispatch
return super(IrHttp, cls)._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/auth_signup/models/ir_http.py", line 19, in _dispatch
return super(Http, cls)._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/web_editor/models/ir_http.py", line 22, in _dispatch
return super(IrHttp, cls)._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/http_routing/models/ir_http.py", line 394, in _dispatch
result = super(IrHttp, cls)._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/utm/models/ir_http.py", line 26, in _dispatch
response = super(IrHttp, cls)._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 207, in _dispatch
return cls._handle_exception(e)
File "/usr/lib/python3/dist-packages/odoo/addons/website/models/ir_http.py", line 278, in _handle_exception
html = env['ir.ui.view'].render_template('website.http_error', values)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_ui_view.py", line 1284, in render_template
return self.browse(self.get_view_id(template)).render(values, engine)
File "<decorator-gen-270>", line 2, in get_view_id
File "/usr/lib/python3/dist-packages/odoo/tools/cache.py", line 93, in lookup
value = d[key] = self.method(*args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/addons/website/models/ir_ui_view.py", line 279, in get_view_id
view = self.search(domain, order='website_id', limit=1)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 1561, in search
res = self._search(args, offset=offset, limit=limit, order=order, count=count)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 4096, in _search
self._cr.execute(query_str, where_clause_params)
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 148, in wrapper
return f(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 225, in execute
res = self._obj.execute(query, params)
psycopg2.InternalError: current transaction is aborted, commands ignored until end of transaction block - - -
2019-03-15 11:31:29,752 11803 INFO MirzaLib1 werkzeug: 127.0.0.1 - - [15/Mar/2019 11:31:29] "GET /favicon.ico HTTP/1.1" 302 - 5 0.003 0.006k I was able to reproduce this. I will try to fix it.
MosabWadea
commented
5 years ago I am sorry if I am causing any disturbance, but I am still facing issues with the last update. I restarted the service again and here is the log...
2019-03-15 21:06:59,409 18149 INFO ? odoo: Odoo version 12.0-20190315
2019-03-15 21:06:59,409 18149 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf
2019-03-15 21:06:59,410 18149 INFO ? odoo: addons paths: ['/var/lib/odoo/.local/share/Odoo/addons/12.0', '/usr/lib/python3/dist-packages/odoo/addons', '/home/odoo12/oapps', '/home/odoo12/oapps/muk_base', '/home/odoo12/oapps/muk_dms', '/home/odoo12/oapps/muk_misc', '/home/odoo12/oapps/muk_web', '/home/odoo12/oapps/muk_website', '/home/odoo12/oapps/pos', '/home/odoo12/oapps/product-attribute', '/home/odoo12/oapps/web', '/home/odoo12/oapps/website', '/home/odoo12/oapps/om-accounting', '/home/odoo12/oapps/CybroAddons', '/home/odoo12/oapps/SerpentCS_Contributions', '/home/odoo12/oapps/server-backend']
2019-03-15 21:06:59,410 18149 INFO ? odoo: database: odoo@default:default
2019-03-15 21:06:59,514 18149 INFO ? odoo.addons.base.models.ir_actions_report: Will use the Wkhtmltopdf binary at /usr/local/bin/wkhtmltopdf
2019-03-15 21:06:59,656 18149 INFO ? odoo.service.server: HTTP service (werkzeug) running on ubuntu-16gb-nbg1-1:8069
2019-03-15 21:07:01,268 18149 INFO ? odoo.http: HTTP Configuring static files
2019-03-15 21:07:01,293 18149 INFO MirzaLib2 odoo.modules.loading: loading 1 modules...
2019-03-15 21:07:01,306 18149 INFO MirzaLib2 odoo.modules.loading: 1 modules loaded in 0.01s, 0 queries
2019-03-15 21:07:01,318 18149 WARNING MirzaLib2 odoo.modules.graph: module theme_common: not installable, skipped
2019-03-15 21:07:01,432 18149 INFO MirzaLib2 odoo.modules.loading: loading 149 modules...
2019-03-15 21:07:01,748 18149 INFO MirzaLib2 odoo.addons.sms.wizard.send_sms: The `phonenumbers` Python module is not available. Phone number validation will be skipped. Try `pip3 install phonenumbers` to install it.
2019-03-15 21:07:02,228 18149 WARNING MirzaLib2 odoo.models: The model report.accounting_pdf_reports.report_partnerledger has no _description
2019-03-15 21:07:02,229 18149 WARNING MirzaLib2 odoo.models: The model report.accounting_pdf_reports.report_generalledger has no _description
2019-03-15 21:07:02,229 18149 WARNING MirzaLib2 odoo.models: The model report.accounting_pdf_reports.report_trialbalance has no _description
2019-03-15 21:07:02,229 18149 WARNING MirzaLib2 odoo.models: The model report.accounting_pdf_reports.report_tax has no _description
2019-03-15 21:07:02,230 18149 WARNING MirzaLib2 odoo.models: The model report.accounting_pdf_reports.report_agedpartnerbalance has no _description
2019-03-15 21:07:02,230 18149 WARNING MirzaLib2 odoo.models: The model report.accounting_pdf_reports.report_journal has no _description
2019-03-15 21:07:02,230 18149 WARNING MirzaLib2 odoo.models: The model report.accounting_pdf_reports.report_financial has no _description
2019-03-15 21:07:02,637 18149 INFO MirzaLib2 odoo.modules.loading: 149 modules loaded in 1.20s, 0 queries
2019-03-15 21:07:03,553 18149 INFO MirzaLib2 odoo.fields: Field fleet.vehicle.log.contract.name depends on non-stored field fleet.vehicle.log.contract.vehicle_id
2019-03-15 21:07:03,554 18149 INFO MirzaLib2 odoo.fields: Field fleet.vehicle.log.contract.name depends on non-stored field fleet.vehicle.log.contract.cost_subtype_id
2019-03-15 21:07:03,554 18149 INFO MirzaLib2 odoo.fields: Field fleet.vehicle.log.contract.name depends on non-stored field fleet.vehicle.log.contract.date
2019-03-15 21:07:03,571 18149 INFO MirzaLib2 odoo.fields: Field stock.production.lot.product_uom_id depends on non-stored field product.product.uom_id
2019-03-15 21:07:03,572 18149 INFO MirzaLib2 odoo.fields: Field stock.picking.move_ids_without_package depends on non-stored field stock.move.picking_type_entire_packs
2019-03-15 21:07:03,572 18149 INFO MirzaLib2 odoo.fields: Field stock.picking.move_line_ids_without_package depends on non-stored field stock.move.line.picking_type_entire_packs
2019-03-15 21:07:03,599 18149 INFO MirzaLib2 odoo.fields: Field purchase.order.line.product_uom_qty depends on non-stored field product.product.uom_id
2019-03-15 21:07:03,602 18149 INFO MirzaLib2 odoo.fields: Field sale.order.invoice_status depends on non-stored field product.product.invoice_policy
2019-03-15 21:07:03,605 18149 INFO MirzaLib2 odoo.fields: Field stock.valuation.adjustment.lines.name depends on non-stored field product.product.code
2019-03-15 21:07:03,605 18149 INFO MirzaLib2 odoo.fields: Field stock.valuation.adjustment.lines.name depends on non-stored field product.product.name
2019-03-15 21:07:03,606 18149 INFO MirzaLib2 odoo.fields: Field delivery.carrier.company_id depends on non-stored field product.product.company_id
2019-03-15 21:07:03,606 18149 INFO MirzaLib2 odoo.fields: Field delivery.carrier.fixed_price depends on non-stored field product.product.list_price
2019-03-15 21:07:03,609 18149 INFO MirzaLib2 odoo.modules.loading: Modules loaded.
2019-03-15 21:07:03,653 18149 INFO MirzaLib2 odoo.addons.base.models.ir_http: Generating routing map
2019-03-15 21:07:03,777 18149 INFO MirzaLib2 werkzeug: 127.0.0.1 - - [15/Mar/2019 21:07:03] "GET / HTTP/1.1" 302 - 45 0.076 2.431
2019-03-15 21:07:03,924 18149 ERROR MirzaLib2 odoo.sql_db: bad query: b'SELECT "res_company"."id" as "id","res_company"."social_twitter" as "social_twitter","res_company"."transfer_account_code_prefix" as "transfer_account_code_prefix","res_company"."tax_calculation_rounding_method" as "tax_calculation_rounding_method","res_company"."anglo_saxon_accounting" as "anglo_saxon_accounting","res_company"."property_stock_account_input_categ_id" as "property_stock_account_input_categ_id","res_company"."po_double_validation" as "po_double_validation","res_company"."tax_exigibility" as "tax_exigibility","res_company"."invoice_reference_type" as "invoice_reference_type","res_company"."social_facebook" as "social_facebook","res_company"."partner_id" as "partner_id","res_company"."property_stock_account_output_categ_id" as "property_stock_account_output_categ_id","res_company"."sale_quotation_onboarding_state" as "sale_quotation_onboarding_state","res_company"."account_bank_reconciliation_start" as "account_bank_reconciliation_start","res_company"."sale_onboarding_order_confirmation_state" as "sale_onboarding_order_confirmation_state","res_company"."email" as "email","res_company"."social_github" as "social_github","res_company"."currency_id" as "currency_id","res_company"."property_stock_valuation_account_id" as "property_stock_valuation_account_id","res_company"."account_setup_bank_data_state" as "account_setup_bank_data_state","res_company"."qr_code" as "qr_code",COALESCE("res_company__overdue_msg"."value", "res_company"."overdue_msg") as "overdue_msg","res_company"."account_setup_fy_data_state" as "account_setup_fy_data_state","res_company"."sale_onboarding_sample_quotation_state" as "sale_onboarding_sample_quotation_state","res_company"."phone" as "phone","res_company"."social_linkedin" as "social_linkedin","res_company"."invoice_is_email" as "invoice_is_email","res_company"."po_lead" as "po_lead","res_company"."account_setup_coa_state" as "account_setup_coa_state","res_company"."sale_onboarding_payment_method" as "sale_onboarding_payment_method","res_company"."social_youtube" as "social_youtube","res_company"."incoterm_id" as "incoterm_id","res_company"."invoice_is_print" as "invoice_is_print","res_company"."po_double_validation_amount" as "po_double_validation_amount","res_company"."account_onboarding_invoice_layout_state" as "account_onboarding_invoice_layout_state","res_company"."website_sale_onboarding_payment_acquirer_state" as "website_sale_onboarding_payment_acquirer_state","res_company"."social_googleplus" as "social_googleplus","res_company"."account_opening_move_id" as "account_opening_move_id",COALESCE("res_company__sale_note"."value", "res_company"."sale_note") as "sale_note","res_company"."account_onboarding_sample_invoice_state" as "account_onboarding_sample_invoice_state","res_company"."sale_template" as "sale_template","res_company"."company_registry" as "company_registry","res_company"."social_instagram" as "social_instagram","res_company"."paperformat_id" as "paperformat_id","res_company"."security_lead" as "security_lead","res_company"."account_onboarding_sale_tax_state" as "account_onboarding_sale_tax_state","res_company"."purchase_template" as "purchase_template","res_company"."external_report_layout_id" as "external_report_layout_id","res_company"."project_time_mode_id" as "project_time_mode_id","res_company"."vat_check_vies" as "vat_check_vies","res_company"."account_invoice_onboarding_state" as "account_invoice_onboarding_state","res_company"."stock_template" as "stock_template","res_company"."bank_account_code_prefix" as "bank_account_code_prefix","res_company"."timesheet_encode_uom_id" as "timesheet_encode_uom_id","res_company"."invoice_is_snailmail" as "invoice_is_snailmail","res_company"."account_dashboard_onboarding_state" as "account_dashboard_onboarding_state","res_company"."account_template" as "account_template","res_company"."cash_account_code_prefix" as "cash_account_code_prefix","res_company"."portal_confirmation_sign" as "portal_confirmation_sign","res_company"."resource_calendar_id" as "resource_calendar_id","res_company"."leave_timesheet_project_id" as "leave_timesheet_project_id","res_company"."po_lock" as "po_lock","res_company"."nomenclature_id" as "nomenclature_id","res_company"."leave_timesheet_task_id" as "leave_timesheet_task_id","res_company"."portal_confirmation_pay" as "portal_confirmation_pay","res_company"."quotation_validity_days" as "quotation_validity_days","res_company"."internal_transit_location_id" as "internal_transit_location_id","res_company"."bank_account_id" as "bank_account_id","res_company"."transfer_account_id" as "transfer_account_id","res_company"."create_uid" as "create_uid","res_company"."sequence" as "sequence","res_company"."create_date" as "create_date","res_company"."base_onboarding_company_state" as "base_onboarding_company_state","res_company"."chart_template_id" as "chart_template_id","res_company"."write_uid" as "write_uid","res_company"."snailmail_color" as "snailmail_color","res_company"."write_date" as "write_date","res_company"."favicon_backend_mimetype" as "favicon_backend_mimetype","res_company"."account_sale_tax_id" as "account_sale_tax_id","res_company"."snailmail_duplex" as "snailmail_duplex","res_company"."background_blend_mode" as "background_blend_mode","res_company"."account_purchase_tax_id" as "account_purchase_tax_id","res_company"."propagation_minimum_delta" as "propagation_minimum_delta","res_company"."default_sidebar_preference" as "default_sidebar_preference","res_company"."name" as "name","res_company"."tax_cash_basis_journal_id" as "tax_cash_basis_journal_id","res_company"."fiscalyear_last_day" as "fiscalyear_last_day","res_company"."report_header" as "report_header","res_company"."default_chatter_preference" as "default_chatter_preference","res_company"."account_no" as "account_no","res_company"."currency_exchange_journal_id" as "currency_exchange_journal_id","res_company"."period_lock_date" as "period_lock_date",COALESCE("res_company__report_footer"."value", "res_company"."report_footer") as "report_footer","res_company"."payment_acquirer_onboarding_state" as "payment_acquirer_onboarding_state","res_company"."fiscalyear_lock_date" as "fiscalyear_lock_date","res_company"."payment_onboarding_payment_method" as "payment_onboarding_payment_method","res_company"."expects_chart_of_accounts" as "expects_chart_of_accounts","res_company"."parent_id" as "parent_id","res_company"."fiscalyear_last_month" as "fiscalyear_last_month" FROM "res_company" LEFT JOIN \n (SELECT res_id, value FROM "ir_translation"\n WHERE name=\'res.company,overdue_msg\' AND lang=\'en_US\' AND value!=\'\'\n ORDER BY res_id, id DESC)\n as "res_company__overdue_msg" ON ("res_company"."id" = "res_company__overdue_msg"."res_id") LEFT JOIN \n (SELECT res_id, value FROM "ir_translation"\n WHERE name=\'res.company,sale_note\' AND lang=\'en_US\' AND value!=\'\'\n ORDER BY res_id, id DESC)\n as "res_company__sale_note" ON ("res_company"."id" = "res_company__sale_note"."res_id") LEFT JOIN \n (SELECT res_id, value FROM "ir_translation"\n WHERE name=\'res.company,report_footer\' AND lang=\'en_US\' AND value!=\'\'\n ORDER BY res_id, id DESC)\n as "res_company__report_footer" ON ("res_company"."id" = "res_company__report_footer"."res_id") WHERE "res_company".id IN (1)'
ERROR: column res_company.background_blend_mode does not exist
LINE 1: ...company"."snailmail_duplex" as "snailmail_duplex","res_compa...
^
2019-03-15 21:07:03,930 18149 ERROR MirzaLib2 odoo.addons.website.models.ir_http: 500 Internal Server Error:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/api.py", line 1039, in get
value = self._data[key][field][record._ids[0]]
KeyError: 1
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 976, in __get__
value = record.env.cache.get(record, self)
File "/usr/lib/python3/dist-packages/odoo/api.py", line 1041, in get
raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: ('res.company(1,).name', None)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 203, in _dispatch
result = request.dispatch()
File "/usr/lib/python3/dist-packages/odoo/http.py", line 833, in dispatch
r = self._call_function(**self.params)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 344, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 97, in wrapper
return f(dbname, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 340, in checked_call
result.flatten()
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1268, in flatten
self.response.append(self.render())
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1261, in render
return env["ir.ui.view"].render_template(self.template, self.qcontext)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_ui_view.py", line 1284, in render_template
return self.browse(self.get_view_id(template)).render(values, engine)
File "/usr/lib/python3/dist-packages/odoo/addons/website/models/ir_ui_view.py", line 318, in render
return super(View, self).render(values, engine=engine, minimal_qcontext=minimal_qcontext)
File "/usr/lib/python3/dist-packages/odoo/addons/web_editor/models/ir_ui_view.py", line 27, in render
return super(IrUiView, self).render(values=values, engine=engine, minimal_qcontext=minimal_qcontext)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_ui_view.py", line 1290, in render
qcontext = dict() if minimal_qcontext else self._prepare_qcontext()
File "/usr/lib/python3/dist-packages/odoo/addons/website/models/ir_ui_view.py", line 344, in _prepare_qcontext
qcontext['multi_website_companies_current'] = {'company_id': cur_company.id, 'name': cur_company.name}
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 980, in __get__
self.determine_value(record)
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1081, in determine_value
record._prefetch_field(self)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 2827, in _prefetch_field
result = records.read([f.name for f in fs], load='_classic_write')
File "/usr/lib/python3/dist-packages/odoo/models.py", line 2765, in read
self._read_from_database(stored, inherited)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 2892, in _read_from_database
cr.execute(query_str, params)
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 148, in wrapper
return f(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 225, in execute
res = self._obj.execute(query, params)
psycopg2.ProgrammingError: column res_company.background_blend_mode does not exist
LINE 1: ...company"."snailmail_duplex" as "snailmail_duplex","res_compa...
^
2019-03-15 21:07:03,953 18149 ERROR MirzaLib2 odoo.sql_db: bad query: b'SELECT "res_company"."id" as "id","res_company"."social_twitter" as "social_twitter","res_company"."transfer_account_code_prefix" as "transfer_account_code_prefix","res_company"."tax_calculation_rounding_method" as "tax_calculation_rounding_method","res_company"."anglo_saxon_accounting" as "anglo_saxon_accounting","res_company"."property_stock_account_input_categ_id" as "property_stock_account_input_categ_id","res_company"."po_double_validation" as "po_double_validation","res_company"."tax_exigibility" as "tax_exigibility","res_company"."invoice_reference_type" as "invoice_reference_type","res_company"."social_facebook" as "social_facebook","res_company"."partner_id" as "partner_id","res_company"."property_stock_account_output_categ_id" as "property_stock_account_output_categ_id","res_company"."sale_quotation_onboarding_state" as "sale_quotation_onboarding_state","res_company"."account_bank_reconciliation_start" as "account_bank_reconciliation_start","res_company"."sale_onboarding_order_confirmation_state" as "sale_onboarding_order_confirmation_state","res_company"."email" as "email","res_company"."social_github" as "social_github","res_company"."currency_id" as "currency_id","res_company"."property_stock_valuation_account_id" as "property_stock_valuation_account_id","res_company"."account_setup_bank_data_state" as "account_setup_bank_data_state","res_company"."qr_code" as "qr_code",COALESCE("res_company__overdue_msg"."value", "res_company"."overdue_msg") as "overdue_msg","res_company"."account_setup_fy_data_state" as "account_setup_fy_data_state","res_company"."sale_onboarding_sample_quotation_state" as "sale_onboarding_sample_quotation_state","res_company"."phone" as "phone","res_company"."social_linkedin" as "social_linkedin","res_company"."invoice_is_email" as "invoice_is_email","res_company"."po_lead" as "po_lead","res_company"."account_setup_coa_state" as "account_setup_coa_state","res_company"."sale_onboarding_payment_method" as "sale_onboarding_payment_method","res_company"."social_youtube" as "social_youtube","res_company"."incoterm_id" as "incoterm_id","res_company"."invoice_is_print" as "invoice_is_print","res_company"."po_double_validation_amount" as "po_double_validation_amount","res_company"."account_onboarding_invoice_layout_state" as "account_onboarding_invoice_layout_state","res_company"."website_sale_onboarding_payment_acquirer_state" as "website_sale_onboarding_payment_acquirer_state","res_company"."social_googleplus" as "social_googleplus","res_company"."account_opening_move_id" as "account_opening_move_id",COALESCE("res_company__sale_note"."value", "res_company"."sale_note") as "sale_note","res_company"."account_onboarding_sample_invoice_state" as "account_onboarding_sample_invoice_state","res_company"."sale_template" as "sale_template","res_company"."company_registry" as "company_registry","res_company"."social_instagram" as "social_instagram","res_company"."paperformat_id" as "paperformat_id","res_company"."security_lead" as "security_lead","res_company"."account_onboarding_sale_tax_state" as "account_onboarding_sale_tax_state","res_company"."purchase_template" as "purchase_template","res_company"."external_report_layout_id" as "external_report_layout_id","res_company"."project_time_mode_id" as "project_time_mode_id","res_company"."vat_check_vies" as "vat_check_vies","res_company"."account_invoice_onboarding_state" as "account_invoice_onboarding_state","res_company"."stock_template" as "stock_template","res_company"."bank_account_code_prefix" as "bank_account_code_prefix","res_company"."timesheet_encode_uom_id" as "timesheet_encode_uom_id","res_company"."invoice_is_snailmail" as "invoice_is_snailmail","res_company"."account_dashboard_onboarding_state" as "account_dashboard_onboarding_state","res_company"."account_template" as "account_template","res_company"."cash_account_code_prefix" as "cash_account_code_prefix","res_company"."portal_confirmation_sign" as "portal_confirmation_sign","res_company"."resource_calendar_id" as "resource_calendar_id","res_company"."leave_timesheet_project_id" as "leave_timesheet_project_id","res_company"."po_lock" as "po_lock","res_company"."nomenclature_id" as "nomenclature_id","res_company"."leave_timesheet_task_id" as "leave_timesheet_task_id","res_company"."portal_confirmation_pay" as "portal_confirmation_pay","res_company"."quotation_validity_days" as "quotation_validity_days","res_company"."internal_transit_location_id" as "internal_transit_location_id","res_company"."bank_account_id" as "bank_account_id","res_company"."transfer_account_id" as "transfer_account_id","res_company"."create_uid" as "create_uid","res_company"."sequence" as "sequence","res_company"."create_date" as "create_date","res_company"."base_onboarding_company_state" as "base_onboarding_company_state","res_company"."chart_template_id" as "chart_template_id","res_company"."write_uid" as "write_uid","res_company"."snailmail_color" as "snailmail_color","res_company"."write_date" as "write_date","res_company"."favicon_backend_mimetype" as "favicon_backend_mimetype","res_company"."account_sale_tax_id" as "account_sale_tax_id","res_company"."snailmail_duplex" as "snailmail_duplex","res_company"."background_blend_mode" as "background_blend_mode","res_company"."account_purchase_tax_id" as "account_purchase_tax_id","res_company"."propagation_minimum_delta" as "propagation_minimum_delta","res_company"."default_sidebar_preference" as "default_sidebar_preference","res_company"."name" as "name","res_company"."tax_cash_basis_journal_id" as "tax_cash_basis_journal_id","res_company"."fiscalyear_last_day" as "fiscalyear_last_day","res_company"."report_header" as "report_header","res_company"."default_chatter_preference" as "default_chatter_preference","res_company"."account_no" as "account_no","res_company"."currency_exchange_journal_id" as "currency_exchange_journal_id","res_company"."period_lock_date" as "period_lock_date",COALESCE("res_company__report_footer"."value", "res_company"."report_footer") as "report_footer","res_company"."payment_acquirer_onboarding_state" as "payment_acquirer_onboarding_state","res_company"."fiscalyear_lock_date" as "fiscalyear_lock_date","res_company"."payment_onboarding_payment_method" as "payment_onboarding_payment_method","res_company"."expects_chart_of_accounts" as "expects_chart_of_accounts","res_company"."parent_id" as "parent_id","res_company"."fiscalyear_last_month" as "fiscalyear_last_month" FROM "res_company" LEFT JOIN \n (SELECT res_id, value FROM "ir_translation"\n WHERE name=\'res.company,overdue_msg\' AND lang=\'en_US\' AND value!=\'\'\n ORDER BY res_id, id DESC)\n as "res_company__overdue_msg" ON ("res_company"."id" = "res_company__overdue_msg"."res_id") LEFT JOIN \n (SELECT res_id, value FROM "ir_translation"\n WHERE name=\'res.company,sale_note\' AND lang=\'en_US\' AND value!=\'\'\n ORDER BY res_id, id DESC)\n as "res_company__sale_note" ON ("res_company"."id" = "res_company__sale_note"."res_id") LEFT JOIN \n (SELECT res_id, value FROM "ir_translation"\n WHERE name=\'res.company,report_footer\' AND lang=\'en_US\' AND value!=\'\'\n ORDER BY res_id, id DESC)\n as "res_company__report_footer" ON ("res_company"."id" = "res_company__report_footer"."res_id") WHERE "res_company".id IN (1)'
ERROR: column res_company.background_blend_mode does not exist
LINE 1: ...company"."snailmail_duplex" as "snailmail_duplex","res_compa...
^
2019-03-15 21:07:03,954 18149 ERROR MirzaLib2 odoo.sql_db: bad query: b'SELECT "ir_ui_view".id FROM "ir_ui_view" LEFT JOIN "website" as "ir_ui_view__website_id" ON ("ir_ui_view"."website_id" = "ir_ui_view__website_id"."id") WHERE (("ir_ui_view"."active" = true) AND (("ir_ui_view"."key" = \'website.http_error\') AND (("ir_ui_view"."website_id" in (1)) OR "ir_ui_view"."website_id" IS NULL))) AND TRUE ORDER BY "ir_ui_view__website_id"."id" limit 1'
ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-03-15 21:07:04,070 18149 INFO MirzaLib2 werkzeug: 127.0.0.1 - - [15/Mar/2019 21:07:04] "GET /en_US/ HTTP/1.1" 500 - 37 0.049 0.159
2019-03-15 21:07:04,077 18149 ERROR MirzaLib2 werkzeug: Error on request:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 270, in run_wsgi
execute(self.server.app)
File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 258, in execute
application_iter = app(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 350, in app
return self.app(e, s)
File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 128, in application
return application_unproxied(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 117, in application_unproxied
result = odoo.http.root(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1318, in __call__
return self.dispatch(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1291, in __call__
return self.app(environ, start_wrapped)
File "/usr/lib/python3/dist-packages/werkzeug/wsgi.py", line 766, in __call__
return self.app(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1486, in dispatch
result = ir_http._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/website_sale/models/ir_http.py", line 15, in _dispatch
return super(IrHttp, cls)._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/auth_signup/models/ir_http.py", line 19, in _dispatch
return super(Http, cls)._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/web_editor/models/ir_http.py", line 22, in _dispatch
return super(IrHttp, cls)._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/http_routing/models/ir_http.py", line 383, in _dispatch
return cls.reroute('/'.join(path) or '/')
File "/usr/lib/python3/dist-packages/odoo/addons/http_routing/models/ir_http.py", line 415, in reroute
return cls._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/website_sale/models/ir_http.py", line 15, in _dispatch
return super(IrHttp, cls)._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/auth_signup/models/ir_http.py", line 19, in _dispatch
return super(Http, cls)._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/web_editor/models/ir_http.py", line 22, in _dispatch
return super(IrHttp, cls)._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/http_routing/models/ir_http.py", line 394, in _dispatch
result = super(IrHttp, cls)._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/utm/models/ir_http.py", line 26, in _dispatch
response = super(IrHttp, cls)._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 207, in _dispatch
return cls._handle_exception(e)
File "/usr/lib/python3/dist-packages/odoo/addons/website/models/ir_http.py", line 278, in _handle_exception
html = env['ir.ui.view'].render_template('website.http_error', values)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_ui_view.py", line 1284, in render_template
return self.browse(self.get_view_id(template)).render(values, engine)
File "<decorator-gen-270>", line 2, in get_view_id
File "/usr/lib/python3/dist-packages/odoo/tools/cache.py", line 93, in lookup
value = d[key] = self.method(*args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/addons/website/models/ir_ui_view.py", line 279, in get_view_id
view = self.search(domain, order='website_id', limit=1)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 1561, in search
res = self._search(args, offset=offset, limit=limit, order=order, count=count)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 4096, in _search
self._cr.execute(query_str, where_clause_params)
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 148, in wrapper
return f(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 225, in execute
res = self._obj.execute(query, params)
psycopg2.InternalError: current transaction is aborted, commands ignored until end of transaction block - - -
2019-03-15 21:07:04,268 18149 INFO MirzaLib2 werkzeug: 127.0.0.1 - - [15/Mar/2019 21:07:04] "GET /favicon.ico HTTP/1.1" 302 - 5 0.004 0.011maybe I am missing some module or some configuration that I should do? Please help
keshrath
commented
5 years ago The reason why it didn't work for us was the unmodified version number, so the update wasn't pulled. Now it works without any problems. Have you tried it on a fresh database? I'm sorry I can't tell you more, but I can't reproduce the error.
Hi I had to revert to commit
63de0ee762de72b18b7dc3915a7711e1b41a8a20in order to make odoo work again!because today I have pulled the updates and this error appeared and odoo didn't work: