This question has been flagged

I am currently testing my website's ecommerce store and am hitting an error where a customer who has made a previous purchase and created an account can't login using the same login details.

I can go through the process of adding products to my cart but after clicking 'Process Checkout', at the screen where I enter customer details or 'Log in', if I click 'Log in' I get the 'Internal Server Error' screen.

The error log is quite long and has a number of 'During handling of the above exception, another exception occurred' instances, but the first error in the traceback is as follows:

2019-05-04 07:50:05,311 1460 ERROR prodcopy4 odoo.sql_db: bad query: b'UPDATE "sale_order" SET "partner_id"=NULL,"write_uid"=1,"write_date"=(now() at time zone \'UTC\') WHERE id IN (258)'

ERROR: null value in column "partner_id" violates not-null constraint

DETAIL:  Failing row contains (258, SO258, null, null, 57270fa0-e025-48ed-b602-493663300912, draft, 2019-05-04 06:08:11, null, 2019-05-04 06:08:11.263051, null, 149, null, 5, 5, 1, null, no, Thank you for your enquiry about our Eco-Arts Workshops.  Please..., 83.18, 1.82, 85.00, 1, null, 1, 5, null, null, 1, 1, 2019-05-04 07:50:04.60004, null, null, f, f, null, null, null, null, null, direct, 2, null, null, null, null, f, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 0, SO258, t, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, f, f, 0.00, f).

2019-05-04 07:50:05,313 1460 ERROR prodcopy4 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.layout\'))  AND  (("ir_ui_view"."website_id" = 1)  OR  "ir_ui_view"."website_id" IS NULL )) ORDER BY "ir_ui_view__website_id"."id"   limit 1'

ERROR: current transaction is aborted, commands ignored until end of transaction block

2019-05-04 07:50:05,317 1460 ERROR prodcopy4 odoo.addons.website.models.ir_http: 500 Internal Server Error:

Traceback (most recent call last):

  File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_qweb/qweb.py", line 345, in _compiled_fn

    return compiled(self, append, new, options, log)

  File "<template>", line 1, in template_website_layout_846

  File "<template>", line 2, in body_call_content_845

  File "/home/odoo/odoo-server/addons/website_sale/models/website.py", line 253, in sale_get_order

    sale_order.write({'partner_id': partner.id})

  File "/home/odoo/odoo-server/addons/mail/models/mail_thread.py", line 284, in write

    result = super(MailThread, self).write(values)

  File "/home/odoo/odoo-server/addons/mail/models/mail_activity.py", line 343, in write

    return super(MailActivityMixin, self).write(vals)

  File "/home/odoo/odoo-server/odoo/models.py", line 3109, in write

    self._write(old_vals)

  File "/home/odoo/odoo-server/odoo/models.py", line 3212, in _write

    cr.execute(query, params + (sub_ids,))

  File "/home/odoo/odoo-server/odoo/sql_db.py", line 155, in wrapper

    return f(self, *args, **kwargs)

  File "/home/odoo/odoo-server/odoo/sql_db.py", line 232, in execute

    res = self._obj.execute(query, params)

psycopg2.IntegrityError: null value in column "partner_id" violates not-null constraint

DETAIL:  Failing row contains (258, SO258, null, null, 57270fa0-e025-48ed-b602-493663300912, draft, 2019-05-04 06:08:11, null, 2019-05-04 06:08:11.263051, null, 149, null, 5, 5, 1, null, no, Thank you for your enquiry about our Eco-Arts Workshops.  Please..., 83.18, 1.82, 85.00, 1, null, 1, 5, null, null, 1, 1, 2019-05-04 07:50:04.60004, null, null, f, f, null, null, null, null, null, direct, 2, null, null, null, null, f, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 0, SO258, t, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, f, f, 0.00, f).

I have no idea where to start with this error.

Can  anybody help?

Bill.


Avatar
Discard
Author

Some further information - if I create a fresh database with demo data the error does not occur, so that would suggest that the general installation is ok but there is a problem with the configuration of my database or the combination of modules installed.

Also, if I try to log in from the initial login screen, rather than during the checkout process, I get a different error (a red 'access' underneath the password field with an access control error in the log for ir.ui.menu), but the user is actually logged in because they can go to the shop, proceed through checkout, and their address details are already filled out the address fields. It's not working perfectly but it is still working in a sense. It just seems to be logging in from the log in button on the address details page during the payment process that causes the 500 error.

Author

I thought there might be more useful information in the full error log. Please note that I upgraded the database with the following command prior to this error log being generated:

./odoo-bin -d prodcopy4 -c /etc/odoo/odoo-server.conf -u base --stop-after-init

2019-05-05 03:11:09,636 3012 ERROR prodcopy4 odoo.sql_db: bad query: b'UPDATE "sale_order" SET "partner_id"=NULL,"write_uid"=1,"write_date"=(now() at time zone \'UTC\') WHERE id IN (265)'

ERROR: null value in column "partner_id" violates not-null constraint

DETAIL: Failing row contains (265, SO265, null, null, 79e401f6-4aa2-4a62-8a6a-1ed83397bd22, draft, 2019-05-05 03:11:03, null, 2019-05-05 03:11:03.137412, null, 149, null, 5, 5, 1, null, no, Thank you for your enquiry about our Eco-Arts Workshops. Please..., 83.18, 1.82, 85.00, 1, null, 1, 5, null, null, 1, 1, 2019-05-05 03:11:09.442359, null, null, f, f, null, null, null, null, null, direct, 2, null, null, null, null, f, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 0, SO265, t, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, f, f, 0.00, f).

2019-05-05 03:11:09,637 3012 ERROR prodcopy4 odoo.sql_db: bad query: b'SELECT "ir_ui_view"."id" as "id","ir_ui_view"."key" as "key","ir_ui_view"."website_id" as "website_id","ir_ui_view"."write_date" as "write_date","ir_ui_view"."arch_db" as "arch_db","ir_ui_view"."use_as_layout" as "use_as_layout",COALESCE("ir_ui_view__website_meta_title"."value", "ir_ui_view"."website_meta_title") as "website_meta_title",COALESCE("ir_ui_view__website_meta_description"."value", "ir_ui_view"."website_meta_description") as "website_meta_description","ir_ui_view"."model" as "model","ir_ui_view"."write_uid" as "write_uid","ir_ui_view"."field_parent" as "field_parent","ir_ui_view"."create_date" as "create_date","ir_ui_view"."customize_show" as "customize_show","ir_ui_view"."type" as "type","ir_ui_view"."inherit_id" as "inherit_id","ir_ui_view"."name" as "name","ir_ui_view"."create_uid" as "create_uid","ir_ui_view"."arch_fs" as "arch_fs","ir_ui_view"."priority" as "priority",COALESCE("ir_ui_view__website_meta_keywords"."value", "ir_ui_view"."website_meta_keywords") as "website_meta_keywords","ir_ui_view"."mode" as "mode","ir_ui_view"."active" as "active" FROM "ir_ui_view" LEFT JOIN \n (SELECT DISTINCT ON (res_id) res_id, value\n FROM "ir_translation"\n WHERE name=\'ir.ui.view,website_meta_title\' AND lang=\'en_AU\' AND value!=\'\'\n ORDER BY res_id, id DESC)\n as "ir_ui_view__website_meta_title" ON ("ir_ui_view"."id" = "ir_ui_view__website_meta_title"."res_id") LEFT JOIN \n (SELECT DISTINCT ON (res_id) res_id, value\n FROM "ir_translation"\n WHERE name=\'ir.ui.view,website_meta_description\' AND lang=\'en_AU\' AND value!=\'\'\n ORDER BY res_id, id DESC)\n as "ir_ui_view__website_meta_description" ON ("ir_ui_view"."id" = "ir_ui_view__website_meta_description"."res_id") LEFT JOIN \n (SELECT DISTINCT ON (res_id) res_id, value\n FROM "ir_translation"\n WHERE name=\'ir.ui.view,website_meta_keywords\' AND lang=\'en_AU\' AND value!=\'\'\n ORDER BY res_id, id DESC)\n as "ir_ui_view__website_meta_keywords" ON ("ir_ui_view"."id" = "ir_ui_view__website_meta_keywords"."res_id") WHERE "ir_ui_view".id IN (1126)'

ERROR: current transaction is aborted, commands ignored until end of transaction block

2019-05-05 03:11:09,669 3012 ERROR prodcopy4 odoo.addons.website.models.ir_http: 500 Internal Server Error:

Traceback (most recent call last):

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_qweb/qweb.py", line 345, in _compiled_fn

return compiled(self, append, new, options, log)

File "<template>", line 1, in template_website_layout_566

File "<template>", line 2, in body_call_content_565

File "/home/odoo/odoo-server/addons/website_sale/models/website.py", line 253, in sale_get_order

sale_order.write({'partner_id': partner.id})

File "/home/odoo/odoo-server/addons/mail/models/mail_thread.py", line 284, in write

result = super(MailThread, self).write(values)

File "/home/odoo/odoo-server/addons/mail/models/mail_activity.py", line 343, in write

return super(MailActivityMixin, self).write(vals)

File "/home/odoo/odoo-server/odoo/models.py", line 3109, in write

self._write(old_vals)

File "/home/odoo/odoo-server/odoo/models.py", line 3212, in _write

cr.execute(query, params + (sub_ids,))

File "/home/odoo/odoo-server/odoo/sql_db.py", line 155, in wrapper

return f(self, *args, **kwargs)

File "/home/odoo/odoo-server/odoo/sql_db.py", line 232, in execute

res = self._obj.execute(query, params)

psycopg2.IntegrityError: null value in column "partner_id" violates not-null constraint

DETAIL: Failing row contains (265, SO265, null, null, 79e401f6-4aa2-4a62-8a6a-1ed83397bd22, draft, 2019-05-05 03:11:03, null, 2019-05-05 03:11:03.137412, null, 149, null, 5, 5, 1, null, no, Thank you for your enquiry about our Eco-Arts Workshops. Please..., 83.18, 1.82, 85.00, 1, null, 1, 5, null, null, 1, 1, 2019-05-05 03:11:09.442359, null, null, f, f, null, null, null, null, null, direct, 2, null, null, null, null, f, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 0, SO265, t, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, f, f, 0.00, f).

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/home/odoo/odoo-server/odoo/tools/cache.py", line 84, in lookup

r = d[key]

File "/home/odoo/odoo-server/odoo/tools/func.py", line 68, in wrapper

return func(self, *args, **kwargs)

File "/home/odoo/odoo-server/odoo/tools/lru.py", line 44, in __getitem__

a = self.d[obj].me

KeyError: ('ir.ui.view', <function View._read_template at 0x7f35884e0400>, frozenset({128, 1, 3, 4, 7, 8, 9, 138, 139, 12, 13, 10, 143, 144, 145, 146, 147, 20, 17, 19, 18, 24, 23, 26, 21, 28, 29, 30, 31, 32, 33, 34, 37, 38, 39, 40, 42, 43, 44, 45, 46, 47, 48, 49, 50, 137, 51, 11, 61, 62, 63, 64, 65, 66, 141, 74, 75, 76, 142, 80, 16, 82, 81, 90, 93, 94, 100, 104, 105, 107, 113, 114, 118, 119, 123, 124, 125, 126, 127}), 1126, ('en_AU', None, None, None, False, 1))

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/home/odoo/odoo-server/odoo/fields.py", line 944, in __get__

value = record.env.cache.get(record, self)

File "/home/odoo/odoo-server/odoo/api.py", line 967, in get

value = self._data[key][field][record._ids[0]]

KeyError: 1126

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_qweb/qweb.py", line 371, in get_template

document = options.get('load', self.load)(template, options)

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_qweb/ir_qweb.py", line 85, in load

template = env['ir.ui.view'].read_template(name)

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_ui_view.py", line 1106, in read_template

return self._read_template(self.get_view_id(xml_id))

File "<decorator-gen-25>", line 2, in _read_template

File "/home/odoo/odoo-server/odoo/tools/cache.py", line 89, in lookup

value = d[key] = self.method(*args, **kwargs)

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_ui_view.py", line 1097, in _read_template

arch = self.browse(view_id).read_combined(['arch'])['arch']

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_ui_view.py", line 702, in read_combined

while root.mode != 'primary':

File "/home/odoo/odoo-server/odoo/fields.py", line 948, in __get__

self.determine_value(record)

File "/home/odoo/odoo-server/odoo/fields.py", line 1049, in determine_value

record._prefetch_field(self)

File "/home/odoo/odoo-server/odoo/models.py", line 2653, in _prefetch_field

result = records.read([f.name for f in fs], load='_classic_write')

File "/home/odoo/odoo-server/odoo/models.py", line 2591, in read

self._read_from_database(stored, inherited)

File "/home/odoo/odoo-server/odoo/models.py", line 2718, in _read_from_database

cr.execute(query_str, params)

File "/home/odoo/odoo-server/odoo/sql_db.py", line 155, in wrapper

return f(self, *args, **kwargs)

File "/home/odoo/odoo-server/odoo/sql_db.py", line 232, in execute

res = self._obj.execute(query, params)

psycopg2.InternalError: current transaction is aborted, commands ignored until end of transaction block

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_http.py", line 208, in _dispatch

result = request.dispatch()

File "/home/odoo/odoo-server/odoo/http.py", line 830, in dispatch

r = self._call_function(**self.params)

File "/home/odoo/odoo-server/odoo/http.py", line 342, in _call_function

return checked_call(self.db, *args, **kwargs)

File "/home/odoo/odoo-server/odoo/service/model.py", line 97, in wrapper

return f(dbname, *args, **kwargs)

File "/home/odoo/odoo-server/odoo/http.py", line 338, in checked_call

result.flatten()

File "/home/odoo/odoo-server/odoo/http.py", line 1270, in flatten

self.response.append(self.render())

File "/home/odoo/odoo-server/odoo/http.py", line 1263, in render

return env["ir.ui.view"].render_template(self.template, self.qcontext)

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_ui_view.py", line 1211, in render_template

return self.browse(self.get_view_id(template)).render(values, engine)

File "/home/odoo/thirdparty/addons/report_designer_73lines/models/ir_ui_view.py", line 17, in render

return super(View, self).render(values=values, engine=engine)

File "/home/odoo/odoo-server/addons/website/models/ir_ui_view.py", line 113, in render

return super(View, self).render(values, engine=engine)

File "/home/odoo/odoo-server/addons/web_editor/models/ir_ui_view.py", line 27, in render

return super(IrUiView, self).render(values=values, engine=engine)

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_ui_view.py", line 1220, in render

return self.env[engine].render(self.id, qcontext)

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_qweb/ir_qweb.py", line 57, in render

return super(IrQWeb, self).render(id_or_xml_id, values=values, **context)

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_qweb/qweb.py", line 274, in render

self.compile(template, options)(self, body.append, values or {})

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_qweb/qweb.py", line 347, in _compiled_fn

raise e

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_qweb/qweb.py", line 345, in _compiled_fn

return compiled(self, append, new, options, log)

File "<template>", line 1, in template_161_721

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_qweb/qweb.py", line 347, in _compiled_fn

raise e

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_qweb/qweb.py", line 345, in _compiled_fn

return compiled(self, append, new, options, log)

File "<template>", line 1, in template_web_login_layout_730

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_qweb/qweb.py", line 350, in _compiled_fn

element, document = self.get_template(template, options)

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_qweb/qweb.py", line 375, in get_template

raise QWebException("load could not load template", name=template)

odoo.addons.base.ir.ir_qweb.qweb.QWebException: None

Traceback (most recent call last):

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_qweb/qweb.py", line 345, in _compiled_fn

return compiled(self, append, new, options, log)

File "<template>", line 1, in template_website_layout_566

File "<template>", line 2, in body_call_content_565

File "/home/odoo/odoo-server/addons/website_sale/models/website.py", line 253, in sale_get_order

sale_order.write({'partner_id': partner.id})

File "/home/odoo/odoo-server/addons/mail/models/mail_thread.py", line 284, in write

result = super(MailThread, self).write(values)

File "/home/odoo/odoo-server/addons/mail/models/mail_activity.py", line 343, in write

return super(MailActivityMixin, self).write(vals)

File "/home/odoo/odoo-server/odoo/models.py", line 3109, in write

self._write(old_vals)

File "/home/odoo/odoo-server/odoo/models.py", line 3212, in _write

cr.execute(query, params + (sub_ids,))

File "/home/odoo/odoo-server/odoo/sql_db.py", line 155, in wrapper

return f(self, *args, **kwargs)

File "/home/odoo/odoo-server/odoo/sql_db.py", line 232, in execute

res = self._obj.execute(query, params)

psycopg2.IntegrityError: null value in column "partner_id" violates not-null constraint

DETAIL: Failing row contains (265, SO265, null, null, 79e401f6-4aa2-4a62-8a6a-1ed83397bd22, draft, 2019-05-05 03:11:03, null, 2019-05-05 03:11:03.137412, null, 149, null, 5, 5, 1, null, no, Thank you for your enquiry about our Eco-Arts Workshops. Please..., 83.18, 1.82, 85.00, 1, null, 1, 5, null, null, 1, 1, 2019-05-05 03:11:09.442359, null, null, f, f, null, null, null, null, null, direct, 2, null, null, null, null, f, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 0, SO265, t, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, f, f, 0.00, f).

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/home/odoo/odoo-server/odoo/tools/cache.py", line 84, in lookup

r = d[key]

File "/home/odoo/odoo-server/odoo/tools/func.py", line 68, in wrapper

return func(self, *args, **kwargs)

File "/home/odoo/odoo-server/odoo/tools/lru.py", line 44, in __getitem__

a = self.d[obj].me

KeyError: ('ir.ui.view', <function View._read_template at 0x7f35884e0400>, frozenset({128, 1, 3, 4, 7, 8, 9, 138, 139, 12, 13, 10, 143, 144, 145, 146, 147, 20, 17, 19, 18, 24, 23, 26, 21, 28, 29, 30, 31, 32, 33, 34, 37, 38, 39, 40, 42, 43, 44, 45, 46, 47, 48, 49, 50, 137, 51, 11, 61, 62, 63, 64, 65, 66, 141, 74, 75, 76, 142, 80, 16, 82, 81, 90, 93, 94, 100, 104, 105, 107, 113, 114, 118, 119, 123, 124, 125, 126, 127}), 1126, ('en_AU', None, None, None, False, 1))

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/home/odoo/odoo-server/odoo/fields.py", line 944, in __get__

value = record.env.cache.get(record, self)

File "/home/odoo/odoo-server/odoo/api.py", line 967, in get

value = self._data[key][field][record._ids[0]]

KeyError: 1126

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_qweb/qweb.py", line 371, in get_template

document = options.get('load', self.load)(template, options)

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_qweb/ir_qweb.py", line 85, in load

template = env['ir.ui.view'].read_template(name)

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_ui_view.py", line 1106, in read_template

return self._read_template(self.get_view_id(xml_id))

File "<decorator-gen-25>", line 2, in _read_template

File "/home/odoo/odoo-server/odoo/tools/cache.py", line 89, in lookup

value = d[key] = self.method(*args, **kwargs)

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_ui_view.py", line 1097, in _read_template

arch = self.browse(view_id).read_combined(['arch'])['arch']

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_ui_view.py", line 702, in read_combined

while root.mode != 'primary':

File "/home/odoo/odoo-server/odoo/fields.py", line 948, in __get__

self.determine_value(record)

File "/home/odoo/odoo-server/odoo/fields.py", line 1049, in determine_value

record._prefetch_field(self)

File "/home/odoo/odoo-server/odoo/models.py", line 2653, in _prefetch_field

result = records.read([f.name for f in fs], load='_classic_write')

File "/home/odoo/odoo-server/odoo/models.py", line 2591, in read

self._read_from_database(stored, inherited)

File "/home/odoo/odoo-server/odoo/models.py", line 2718, in _read_from_database

cr.execute(query_str, params)

File "/home/odoo/odoo-server/odoo/sql_db.py", line 155, in wrapper

return f(self, *args, **kwargs)

File "/home/odoo/odoo-server/odoo/sql_db.py", line 232, in execute

res = self._obj.execute(query, params)

psycopg2.InternalError: current transaction is aborted, commands ignored until end of transaction block

load could not load template

Template: website.layout

2019-05-05 03:11:09,671 3012 ERROR prodcopy4 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.500\')) AND (("ir_ui_view"."website_id" = 1) OR "ir_ui_view"."website_id" IS NULL )) ORDER BY "ir_ui_view__website_id"."id" limit 1'

ERROR: current transaction is aborted, commands ignored until end of transaction block

2019-05-05 03:11:09,673 3012 ERROR prodcopy4 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" = 1) OR "ir_ui_view"."website_id" IS NULL )) ORDER BY "ir_ui_view__website_id"."id" limit 1'

ERROR: current transaction is aborted, commands ignored until end of transaction block

2019-05-05 03:11:09,972 3012 INFO prodcopy4 werkzeug: 192.168.1.8 - - [05/May/2019 03:11:09] "GET /web/login?redirect=/shop/checkout HTTP/1.1" 500 -

2019-05-05 03:11:09,980 3012 ERROR prodcopy4 werkzeug: Error on request:

Traceback (most recent call last):

File "/usr/local/lib/python3.5/dist-packages/werkzeug/serving.py", line 205, in run_wsgi

execute(self.server.app)

File "/usr/local/lib/python3.5/dist-packages/werkzeug/serving.py", line 193, in execute

application_iter = app(environ, start_response)

File "/home/odoo/odoo-server/odoo/service/server.py", line 319, in app

return self.app(e, s)

File "/home/odoo/odoo-server/odoo/service/wsgi_server.py", line 166, in application

return application_unproxied(environ, start_response)

File "/home/odoo/odoo-server/odoo/service/wsgi_server.py", line 154, in application_unproxied

result = handler(environ, start_response)

File "/home/odoo/odoo-server/odoo/http.py", line 1319, in __call__

return self.dispatch(environ, start_response)

File "/home/odoo/odoo-server/odoo/http.py", line 1293, in __call__

return self.app(environ, start_wrapped)

File "/usr/local/lib/python3.5/dist-packages/werkzeug/wsgi.py", line 599, in __call__

return self.app(environ, start_response)

File "/home/odoo/odoo-server/odoo/http.py", line 1491, in dispatch

result = ir_http._dispatch()

File "/home/odoo/odoo-server/addons/website_sale/models/ir_http.py", line 15, in _dispatch

return super(IrHttp, cls)._dispatch()

File "/home/odoo/odoo-server/addons/auth_signup/models/ir_http.py", line 19, in _dispatch

return super(Http, cls)._dispatch()

File "/home/odoo/odoo-server/addons/web_editor/models/ir_http.py", line 22, in _dispatch

return super(IrHttp, cls)._dispatch()

File "/home/odoo/odoo-server/addons/http_routing/models/ir_http.py", line 397, in _dispatch

result = super(IrHttp, cls)._dispatch()

File "/home/odoo/odoo-server/addons/utm/models/ir_http.py", line 26, in _dispatch

response = super(IrHttp, cls)._dispatch()

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_http.py", line 212, in _dispatch

return cls._handle_exception(e)

File "/home/odoo/odoo-server/addons/website/models/ir_http.py", line 231, in _handle_exception

html = request.env['ir.ui.view'].render_template('website.http_error', values)

File "/home/odoo/odoo-server/odoo/addons/base/ir/ir_ui_view.py", line 1211, in render_template

return self.browse(self.get_view_id(template)).render(values, engine)

File "<decorator-gen-239>", line 2, in get_view_id

File "/home/odoo/odoo-server/odoo/tools/cache.py", line 89, in lookup

value = d[key] = self.method(*args, **kwargs)

File "/home/odoo/odoo-server/addons/website/models/ir_ui_view.py", line 87, in get_view_id

view = self.search(domain, order='website_id', limit=1)

File "/home/odoo/odoo-server/odoo/models.py", line 1481, in search

res = self._search(args, offset=offset, limit=limit, order=order, count=count)

File "/home/odoo/odoo-server/odoo/models.py", line 3813, in _search

self._cr.execute(query_str, where_clause_params)

File "/home/odoo/odoo-server/odoo/sql_db.py", line 155, in wrapper

return f(self, *args, **kwargs)

File "/home/odoo/odoo-server/odoo/sql_db.py", line 232, in execute

res = self._obj.execute(query, params)

psycopg2.InternalError: current transaction is aborted, commands ignored until end of transaction block

Author Best Answer

After three days tearing my hair out trying to solve this problem, the answer is incredibly simple!

I was working on a test local server that had multiple databases running on it and my .conf file did not specify db_name.  I've read the implementation docs and the references within them that state that you should set db_filter if you are using website or features may not work, and many .

Anyway, if anyone is having trouble with website or ecommerce related functions, particularly if it's in a test environment where your .conf file is likely to be configured to allow access to multiple databases, make sure this is in there:

db_name = yourdatabasename

Hopefully this saves someone else a lot of wasted time.  It would be great if there was something more meaningful in the error log to help inexperienced admins troubleshoot.

Avatar
Discard