Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Crash internal server error after update

Subscribe

Get notified when there's activity on this post

This question has been flagged
2 Replies
6136 Views
Avatar
Boijoux Jerome

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. 


0
Avatar
Discard
Zbik

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

Avatar
Mathias Markl
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

1
Avatar
Discard
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now