Skip to Content
Menu
This question has been flagged
2 Replies
5426 Views

Hello,

I launch an update for odoo (v12) yesterday and also apps.
Now, I’ve got « internal server error », 
Could you help me please ? Here the odoo server log file 

Regards

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/base/models/ir_ui_menu.py", line 234, in load_menus

    menu_roots_data = menu_roots.read(fields) if menu_roots else []

  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 2926, in _read_from_database

    field.read(fetched)

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1813, in read

    for att in records.env['ir.attachment'].sudo().search(domain)}

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1813, in <dictcomp>

    for att in records.env['ir.attachment'].sudo().search(domain)}

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 984, in __get__

    self.determine_value(record)

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1095, in determine_value

    self.compute_value(recs)

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1051, in compute_value

    self._compute_value(records)

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1042, in _compute_value

    getattr(records, self.compute)()

  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_attachment.py", line 201, in _compute_datas

    if attach.store_fname:

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 984, in __get__

    self.determine_value(record)

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1085, 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/addons/base/models/ir_attachment.py", line 450, in read

    return super(IrAttachment, self).read(fields, load=load)

  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 ir_attachment.temporary does not exist

LINE 1: ...e" as "mimetype","ir_attachment"."name" as "name","ir_attach...

                                                             ^ - - -

2019-04-23 08:42:53,251 1160 WARNING 3A-dentaire odoo.sql_db: Cursor not closed explicitly

Please enable sql debugging to trace the caller. 

2019-04-23 08:42:53,251 1160 INFO 3A-dentaire werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/database/manager HTTP/1.1" 200 - 4 0.005 0.054

2019-04-23 08:42:53,353 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/fontawesome/css/font-awesome.css HTTP/1.1" 200 - - - -

2019-04-23 08:42:53,356 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/util.js HTTP/1.1" 200 - - - -

2019-04-23 08:42:53,356 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/index.js HTTP/1.1" 200 - - - -

2019-04-23 08:42:53,366 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/popper/popper.js HTTP/1.1" 200 - - - -

2019-04-23 08:42:53,385 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/css/bootstrap.css HTTP/1.1" 200 - - - -

2019-04-23 08:42:53,398 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/jquery/jquery.js HTTP/1.1" 200 - - - -

2019-04-23 08:42:53,423 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/alert.js HTTP/1.1" 200 - - - -

2019-04-23 08:42:53,429 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/carousel.js HTTP/1.1" 200 - - - -

2019-04-23 08:42:53,439 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/button.js HTTP/1.1" 200 - - - -

2019-04-23 08:42:53,441 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/collapse.js HTTP/1.1" 200 - - - -

2019-04-23 08:42:53,468 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/dropdown.js HTTP/1.1" 200 - - - -

2019-04-23 08:42:53,513 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/modal.js HTTP/1.1" 200 - - - -

2019-04-23 08:42:53,529 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/tooltip.js HTTP/1.1" 200 - - - -

2019-04-23 08:42:53,539 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/popover.js HTTP/1.1" 200 - - - -

2019-04-23 08:42:53,547 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/scrollspy.js HTTP/1.1" 200 - - - -

2019-04-23 08:42:53,555 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/bootstrap/js/tab.js HTTP/1.1" 200 - - - -

2019-04-23 08:42:53,612 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/src/img/logo2.png HTTP/1.1" 200 - - - -

2019-04-23 08:42:53,908 1160 INFO ? werkzeug: 78.217.177.58 - - [23/Apr/2019 08:42:53] "GET /web/static/lib/fontawesome/fonts/fontawesome-webfont.woff2?v=4.7.0 HTTP/1.1" 200 - - - -

2019-04-23 08:43:00,533 1160 INFO 3A-dentaire odoo.sql_db: ConnectionPool(used=0/count=3/max=64): Free leaked connection to 'user=odoo sslmode=prefer dbname=3A-dentaire' 

2019-04-23 08:43:00,565 1160 ERROR 3A-dentaire odoo.sql_db: bad query: b'SELECT "ir_attachment"."id" as "id","ir_attachment"."datas_fname" as "datas_fname","ir_attachment"."res_id" as "res_id","ir_attachment"."create_uid" as "create_uid","ir_attachment"."create_date" as "create_date","ir_attachment"."description" as "description","ir_attachment"."access_token" as "access_token","ir_attachment"."public" as "public","ir_attachment"."res_name" as "res_name","ir_attachment"."write_uid" as "write_uid","ir_attachment"."write_date" as "write_date","ir_attachment"."store_fname" as "store_fname","ir_attachment"."company_id" as "company_id","ir_attachment"."file_size" as "file_size","ir_attachment"."res_model" as "res_model","ir_attachment"."key" as "key","ir_attachment"."checksum" as "checksum","ir_attachment"."active" as "active","ir_attachment"."website_id" as "website_id","ir_attachment"."res_model_name" as "res_model_name","ir_attachment"."mimetype" as "mimetype","ir_attachment"."name" as "name","ir_attachment"."temporary" as "temporary","ir_attachment"."type" as "type","ir_attachment"."theme_template_id" as "theme_template_id","ir_attachment"."res_field" as "res_field","ir_attachment"."url" as "url" FROM "ir_attachment" WHERE "ir_attachment".id IN (2302, 256, 260, 261, 265, 273, 279, 539, 543, 1825, 2115, 2119, 330, 340, 745, 749, 753, 243, 244, 1146, 508)'

ERROR: column ir_attachment.temporary does not exist

LINE 1: ...e" as "mimetype","ir_attachment"."name" as "name","ir_attach...

                                                             ^

 

2019-04-23 08:43:00,619 1160 INFO 3A-dentaire werkzeug: 78.217.177.58 - - [23/Apr/2019 08:43:00] "GET /web/webclient/qweb?mods=base,web,muk_utils,bus,web_tour,mail,sales_team,calendar,utm,contacts,portal,digest,crm,web_editor,website,rating,project,product,barcodes,stock,account,payment,sale,sale_management,hr,hr_timesheet,note,purchase,hr_expense,account_bank_statement_import,auth_signup,automatic_backup,base_import,event,event_sale,google_calendar,hr_holidays,web_settings_dashboard,iap,l10n_fr,mail_bot,muk_web_utils,muk_account_accountant,muk_account_bank_statement_import_sheet,muk_web_attachment_dnd,muk_web_theme,payment_transfer,product_expiry,sale_stock,sale_timesheet,sms,snailmail,web_diagram,web_kanban_gauge,web_unsplash,website_helpdesk_support_ticket,website_mail,website_partner,website_rating,website_theme_install,fleet,website_event,repair,theme_bootswatch,theme_default HTTP/1.1" 304 - 1 0.000 0.077

2019-04-23 08:43:00,620 1160 INFO 3A-dentaire werkzeug: 78.217.177.58 - - [23/Apr/2019 08:43:00] "GET /web HTTP/1.1" 500 - 10 0.025 0.064

2019-04-23 08:43:00,633 1160 ERROR 3A-dentaire 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 409, 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/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 398, 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 195, in _handle_exception

    return super(Http, cls)._handle_exception(exception)

  File "/usr/lib/python3/dist-packages/odoo/addons/utm/models/ir_http.py", line 31, in _handle_exception

    response = super(IrHttp, cls)._handle_exception(exc)

  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 177, in _handle_exception

    return request._handle_exception(exception)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 774, in _handle_exception

    return super(HttpRequest, self)._handle_exception(exception)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 312, in _handle_exception

    raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])

  File "/usr/lib/python3/dist-packages/odoo/tools/pycompat.py", line 87, in reraise

    raise value

  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 337, in checked_call

    result = self.endpoint(*a, **kw)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 939, in __call__

    return self.method(*args, **kw)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 517, in response_wrap

    response = f(*args, **kw)

  File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 457, in web_client

    context = request.env['ir.http'].webclient_rendering_context()

  File "/usr/lib/python3/dist-packages/odoo/addons/web/models/ir_http.py", line 17, in webclient_rendering_context

    'menu_data': request.env['ir.ui.menu'].load_menus(request.debug),

  File "<decorator-gen-31>", line 2, in load_menus

    

  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/base/models/ir_ui_menu.py", line 234, in load_menus

    menu_roots_data = menu_roots.read(fields) if menu_roots else []

  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 2926, in _read_from_database

    field.read(fetched)

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1813, in read

    for att in records.env['ir.attachment'].sudo().search(domain)}

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1813, in <dictcomp>

    for att in records.env['ir.attachment'].sudo().search(domain)}

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 984, in __get__

    self.determine_value(record)

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1095, in determine_value

    self.compute_value(recs)

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1051, in compute_value

    self._compute_value(records)

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1042, in _compute_value

    getattr(records, self.compute)()

  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_attachment.py", line 201, in _compute_datas

    if attach.store_fname:

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 984, in __get__

    self.determine_value(record)

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1085, 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/addons/base/models/ir_attachment.py", line 450, in read

    return super(IrAttachment, self).read(fields, load=load)

  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 ir_attachment.temporary does not exist

LINE 1: ...e" as "mimetype","ir_attachment"."name" as "name","ir_attach...

                                                             ^ - - -

2019-04-23 08:44:28,744 1160 INFO 3A-dentaire werkzeug: 86.203.251.254 - - [23/Apr/2019 08:44:28] "GET /logo.png?company=1 HTTP/1.1" 200 - 3 0.004 0.010

2019-04-23 08:45:07,983 1160 INFO 3A-dentaire odoo.addons.base.models.ir_cron: Starting job `Mail: Fetchmail Service`. 

2019-04-23 08:45:07,996 1160 INFO 3A-dentaire odoo.addons.fetchmail.models.fetchmail: start checking for new emails on imap server 3A Dentaire 

2019-04-23 08:45:08,382 1160 INFO 3A-dentaire odoo.addons.fetchmail.models.fetchmail: Fetched 0 email(s) on imap server 3A Dentaire; 0 succeeded, 0 failed. 


Avatar
Discard

See on many info: ERROR: column ir_attachment.temporary does not exist

Best Answer

You probably need to update the module muk_web_utils. This has added this field with one of the newer versions.

Issue: https://github.com/muk-it/muk_web/issues/83

See this blog post on how to do this via the command line.

​Blog: https://medium.com/@reedrehg/upgrade-odoo-apps-from-command-line-4973ea7f7bac

Avatar
Discard