İçereği Atla
Odoo Menü
  • Portal
  • Ücretsiz deneyin
  • Uygulamalar
    Finans
    • Muhasebe
    • Faturalama
    • Masraf Yönetimi
    • Elektronik Çizelge (BI)
    • Belgeler
    • İmza
    Satış
    • Müşteri İlişkileri Yönetimi (CRM)
    • Satış
    • Satış Noktası Mağaza
    • Satış Noktası Restoran
    • Abonelikler
    • Kiralama
    Web Sitesi
    • Web Sitesi Oluşturucu
    • eTicaret
    • Blog
    • Forum
    • Canlı Sohbet
    • eÖğrenme
    Tedarik Zinciri
    • Envanter
    • Üretim
    • Ürün Yaşam Döngüsü Yönetimi
    • Satın Alma
    • Bakım
    • Kalite
    İnsan Kaynakları
    • Çalışanlar
    • İşe Alım
    • İzin
    • Değerlendirme
    • Referans
    • Filo Yönetimi
    Pazarlama
    • Sosyal Medyada Pazarlama
    • E-posta ile Pazarlama
    • SMS ile Pazarlama
    • Etkinlikler
    • Pazarlama Otomasyonu
    • Anket
    Hizmetler
    • Proje Yönetimi
    • Çalışma Çizelgeleri
    • Saha Hizmeti
    • Yardım Masası
    • Planlama
    • Randevular
    Verimlilik
    • Sohbet
    • Onay
    • Nesnelerin İnterneti
    • VoIP
    • Bilgi Bankası
    • WhatsApp
    Üçüncü taraf uygulamalar Odoo Stüdyo Odoo Bulut Platformu
  • Sektörler
    Perakende satış
    • Kitapçı
    • Giyim Mağazası
    • Mobilya Mağazası
    • Gıda Marketi
    • Hırdavat Dükkanı
    • Oyuncak Dükkanı
    Gıda ve Konaklama
    • Bar ve Pub
    • Restoran
    • Fast Food Restoranı
    • Konuk Evi
    • İçecek Distribütörü
    • Otel
    Gayrimenkul
    • Emlak Acentesi
    • Mimarlık Firması
    • İnşaat
    • Emlak Yönetimi
    • Bahçe Tasarımı
    • Mülk Sahipleri Derneği
    Uzmanlık
    • Muhasebe Firması
    • Odoo Partner
    • Pazarlama Ajansı
    • Hukuk Firması
    • Yetenek Kazanımı
    • Denetim ve Belgelendirme
    Üretim
    • Tekstil
    • Metal
    • Mobilyalar
    • Gıda
    • Bira fabrikası
    • Kurumsal Hediye
    Sağlık ve Spor
    • Spor Kulübü
    • Optik Mağazası
    • Fitness Merkezi
    • Sağlıklı Yaşam Merkezi
    • Eczane
    • Kuaför Salonu
    Ticaret
    • Tamirci
    • BT Donanım & Destek
    • Güneş Enerjisi Sistemleri
    • Ayakkabı İmalatçısı
    • Temizlik Hizmetleri
    • HVAC Hizmetleri
    Diğerleri
    • Kar Amacı Gütmeyen Kuruluş
    • Çevre Ajansı
    • Reklam Panosu Kiralama
    • Fotoğrafçılık
    • Bisiklet Kiralama
    • Yazılım Bayisi
    Tüm Sektörlere Göz Atın
  • Topluluk
    Öğrenim
    • Eğitim Araçları
    • Dokümantasyon
    • Sertifikasyonlar
    • Eğitim Etkinlikleri
    • Blog
    • Podcast
    Eğitim ve Gelişim
    • Eğitim Programı
    • Scale Up! İşletme Oyunu
    • Odoo'yu Ziyaret Edin
    Yazılım
    • İndirin
    • Sürümleri Kıyaslayın
    • Sürümler
    İş Birliği
    • Github
    • Forum
    • Etkinlikler
    • Çeviriler
    • Partner Olun
    • Partnerler için Hizmetler
    • Muhasebe Firmanızı Kaydettirin
    Hizmetler
    • Partner Bulun
    • Muhasebeci Bulun
    • Bir danışmanla görüşün
    • Kurulum Hizmetleri
    • Müşteri Referansları
    • Destek
    • Sürüm Yükseltme
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Demo randevusu alın
  • Fiyatlandırma
  • Yardım

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

  • Müşteri İlişkileri Yönetimi
  • e-Commerce
  • Muhasebe
  • Envanter
  • PoS
  • Proje Yönetimi
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Etiketler (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Etiketler (View all)
odoo accounting v14 pos v15
About this forum
Yardım

Odoo 14 Server Crash after System Upgrade

Abone Ol

Get notified when there's activity on this post

Bu soru işaretlendi
python3XMLv14ubuntu20.04
3 Cevaplar
7716 Görünümler
Avatar
Muhammad Faheem Khan

I am in serious trouble.
I am running Odoo 10, 11, 12, 13, and 14 CE on the same server with Postgresql 12 ubuntu 20.04 and Nginx as a reverse proxy.
All instances were working fine since the last system upgrade. I upgraded my server with "apt upgrade", it asked for a reboot. I rebooted the server. Now all my instances are throwing errors. Some on running databases, some on during the creation of new databases.
Errors are similar on all versions.
Every error has
`"Extra content at the end of the document, line 24, column 9"`
type issues.
An error during database creation in Odoo 13 and Odoo 14

2021-07-01 21:25:13,774 392124 ERROR urdu odoo.modules.registry: Failed to load registry
Traceback (most recent call last):
File "/opt/odoo13/odoo/tools/convert.py", line 712, in parse
self._tag_root(de)
File "/opt/odoo13/odoo/tools/convert.py", line 674, in _tag_root
f(rec)
File "/opt/odoo13/odoo/tools/convert.py", line 577, in _tag_record
record = model._load_records([data], self.mode == 'update')
File "/opt/odoo13/odoo/models.py", line 4146, in _load_records
records = self._load_records_create([data['values'] for data in to_create])
File "/opt/odoo13/odoo/models.py", line 4060, in _load_records_create
return self.create(values)
File "", line 2, in create
File "/opt/odoo13/odoo/api.py", line 336, in _model_create_multi
return create(self, arg)
File "/opt/odoo13/odoo/addons/base/models/ir_ui_view.py", line 475, in create
return super(View, self).create(vals_list)
File "", line 2, in create
File "/opt/odoo13/odoo/api.py", line 336, in _model_create_multi
return create(self, arg)
File "/opt/odoo13/odoo/models.py", line 3821, in create
fields[0].determine_inverse(batch_recs)
File "/opt/odoo13/odoo/fields.py", line 1122, in determine_inverse
getattr(records, self.inverse)()
File "/opt/odoo13/odoo/addons/base/models/ir_ui_view.py", line 299, in _inverse_arch
view.write(data)
File "/opt/odoo13/odoo/addons/base/models/ir_ui_view.py", line 493, in write
res = super(View, self).write(self._compute_defaults(vals))
File "/opt/odoo13/odoo/models.py", line 3610, in write
real_recs._validate_fields(set(vals) - set(inverse_fields))
File "/opt/odoo13/odoo/models.py", line 1201, in _validate_fields
check(self)
File "/opt/odoo13/odoo/addons/base/models/ir_ui_view.py", line 385, in _check_xml
view_arch = etree.fromstring(view.arch.encode('utf-8'))
File "src/lxml/lxml.etree.pyx", line 3213, in lxml.etree.fromstring (src/lxml/lxml.etree.c:79003)
File "src/lxml/parser.pxi", line 1848, in lxml.etree._parseMemoryDocument (src/lxml/lxml.etree.c:118334)
File "src/lxml/parser.pxi", line 1736, in lxml.etree._parseDoc (src/lxml/lxml.etree.c:117014)
File "src/lxml/parser.pxi", line 1102, in lxml.etree._BaseParser._parseDoc (src/lxml/lxml.etree.c:111258)
File "src/lxml/parser.pxi", line 595, in lxml.etree._ParserContext._handleParseResultDoc (src/lxml/lxml.etree.c:105102)
File "src/lxml/parser.pxi", line 706, in lxml.etree._handleParseResult (src/lxml/lxml.etree.c:106810)
File "src/lxml/parser.pxi", line 635, in lxml.etree._raiseParseError (src/lxml/lxml.etree.c:105664)
File "", line 24
lxml.etree.XMLSyntaxError: Extra content at the end of the document, line 24, column 9

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/opt/odoo13/odoo/modules/registry.py", line 86, in new
odoo.modules.load_modules(registry._db, force_demo, status, update_module)
File "/opt/odoo13/odoo/modules/loading.py", line 364, in load_modules
report=report, models_to_check=models_to_check)
File "/opt/odoo13/odoo/modules/loading.py", line 225, in load_module_graph
load_data(cr, idref, mode, kind='data', package=package, report=report)
File "/opt/odoo13/odoo/modules/loading.py", line 68, in load_data
tools.convert_file(cr, package.name, filename, idref, mode, noupdate, kind, report)
File "/opt/odoo13/odoo/tools/convert.py", line 736, in convert_file
convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
File "/opt/odoo13/odoo/tools/convert.py", line 803, in convert_xml_import
obj.parse(doc.getroot())
File "/opt/odoo13/odoo/tools/convert.py", line 721, in parse
exc_info[2]
File "/opt/odoo13/odoo/tools/pycompat.py", line 13, in reraise
raise value.with_traceback(tb)
File "/opt/odoo13/odoo/tools/convert.py", line 712, in parse
self._tag_root(de)
File "/opt/odoo13/odoo/tools/convert.py", line 674, in _tag_root
f(rec)
File "/opt/odoo13/odoo/tools/convert.py", line 577, in _tag_record
record = model._load_records([data], self.mode == 'update')
File "/opt/odoo13/odoo/models.py", line 4146, in _load_records
records = self._load_records_create([data['values'] for data in to_create])
File "/opt/odoo13/odoo/models.py", line 4060, in _load_records_create
return self.create(values)
File "", line 2, in create
File "/opt/odoo13/odoo/api.py", line 336, in _model_create_multi
return create(self, arg)
File "/opt/odoo13/odoo/addons/base/models/ir_ui_view.py", line 475, in create
return super(View, self).create(vals_list)
File "", line 2, in create
File "/opt/odoo13/odoo/api.py", line 336, in _model_create_multi
return create(self, arg)
File "/opt/odoo13/odoo/models.py", line 3821, in create
fields[0].determine_inverse(batch_recs)
File "/opt/odoo13/odoo/fields.py", line 1122, in determine_inverse
getattr(records, self.inverse)()
File "/opt/odoo13/odoo/addons/base/models/ir_ui_view.py", line 299, in _inverse_arch
view.write(data)
File "/opt/odoo13/odoo/addons/base/models/ir_ui_view.py", line 493, in write
res = super(View, self).write(self._compute_defaults(vals))
File "/opt/odoo13/odoo/models.py", line 3610, in write
real_recs._validate_fields(set(vals) - set(inverse_fields))
File "/opt/odoo13/odoo/models.py", line 1201, in _validate_fields
check(self)
File "/opt/odoo13/odoo/addons/base/models/ir_ui_view.py", line 385, in _check_xml
view_arch = etree.fromstring(view.arch.encode('utf-8'))
File "src/lxml/lxml.etree.pyx", line 3213, in lxml.etree.fromstring (src/lxml/lxml.etree.c:79003)
File "src/lxml/parser.pxi", line 1848, in lxml.etree._parseMemoryDocument (src/lxml/lxml.etree.c:118334)
File "src/lxml/parser.pxi", line 1736, in lxml.etree._parseDoc (src/lxml/lxml.etree.c:117014)
File "src/lxml/parser.pxi", line 1102, in lxml.etree._BaseParser._parseDoc (src/lxml/lxml.etree.c:111258)
File "src/lxml/parser.pxi", line 595, in lxml.etree._ParserContext._handleParseResultDoc (src/lxml/lxml.etree.c:105102)
File "src/lxml/parser.pxi", line 706, in lxml.etree._handleParseResult (src/lxml/lxml.etree.c:106810)
File "src/lxml/parser.pxi", line 635, in lxml.etree._raiseParseError (src/lxml/lxml.etree.c:105664)
odoo.tools.convert.ParseError: "Extra content at the end of the document, line 24, column 9" while parsing /opt/odoo13/odoo/addons/base/data/ir_demo_data.xml:1, near


Load demo data
ir.demo
form
new



ir.demo.form
ir.demo






 
Danger Zone


Demo data should only be used on test databases!
Once they are loaded, they cannot be removed!


Please confirm that you want to irreversibly make this database a demo database.















2021-07-01 21:25:13,818 392124 ERROR urdu odoo.service.db: CREATE DATABASE failed:
Traceback (most recent call last):
File "/opt/odoo13/odoo/tools/convert.py", line 712, in parse
self._tag_root(de)
File "/opt/odoo13/odoo/tools/convert.py", line 674, in _tag_root
f(rec)
File "/opt/odoo13/odoo/tools/convert.py", line 577, in _tag_record
record = model._load_records([data], self.mode == 'update')
File "/opt/odoo13/odoo/models.py", line 4146, in _load_records
records = self._load_records_create([data['values'] for data in to_create])
File "/opt/odoo13/odoo/models.py", line 4060, in _load_records_create
return self.create(values)
File "", line 2, in create
File "/opt/odoo13/odoo/api.py", line 336, in _model_create_multi
return create(self, arg)
File "/opt/odoo13/odoo/addons/base/models/ir_ui_view.py", line 475, in create
return super(View, self).create(vals_list)
File "", line 2, in create
File "/opt/odoo13/odoo/api.py", line 336, in _model_create_multi
return create(self, arg)
File "/opt/odoo13/odoo/models.py", line 3821, in create
fields[0].determine_inverse(batch_recs)
File "/opt/odoo13/odoo/fields.py", line 1122, in determine_inverse
getattr(records, self.inverse)()
File "/opt/odoo13/odoo/addons/base/models/ir_ui_view.py", line 299, in _inverse_arch
view.write(data)
File "/opt/odoo13/odoo/addons/base/models/ir_ui_view.py", line 493, in write
res = super(View, self).write(self._compute_defaults(vals))
File "/opt/odoo13/odoo/models.py", line 3610, in write
real_recs._validate_fields(set(vals) - set(inverse_fields))
File "/opt/odoo13/odoo/models.py", line 1201, in _validate_fields
check(self)
File "/opt/odoo13/odoo/addons/base/models/ir_ui_view.py", line 385, in _check_xml
view_arch = etree.fromstring(view.arch.encode('utf-8'))
File "src/lxml/lxml.etree.pyx", line 3213, in lxml.etree.fromstring (src/lxml/lxml.etree.c:79003)
File "src/lxml/parser.pxi", line 1848, in lxml.etree._parseMemoryDocument (src/lxml/lxml.etree.c:118334)
File "src/lxml/parser.pxi", line 1736, in lxml.etree._parseDoc (src/lxml/lxml.etree.c:117014)
File "src/lxml/parser.pxi", line 1102, in lxml.etree._BaseParser._parseDoc (src/lxml/lxml.etree.c:111258)
File "src/lxml/parser.pxi", line 595, in lxml.etree._ParserContext._handleParseResultDoc (src/lxml/lxml.etree.c:105102)
File "src/lxml/parser.pxi", line 706, in lxml.etree._handleParseResult (src/lxml/lxml.etree.c:106810)
File "src/lxml/parser.pxi", line 635, in lxml.etree._raiseParseError (src/lxml/lxml.etree.c:105664)
File "", line 24
lxml.etree.XMLSyntaxError: Extra content at the end of the document, line 24, column 9

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/opt/odoo13/odoo/service/db.py", line 62, in _initialize_db
registry = odoo.modules.registry.Registry.new(db_name, demo, None, update_module=True)
File "/opt/odoo13/odoo/modules/registry.py", line 86, in new
odoo.modules.load_modules(registry._db, force_demo, status, update_module)
File "/opt/odoo13/odoo/modules/loading.py", line 364, in load_modules
report=report, models_to_check=models_to_check)
File "/opt/odoo13/odoo/modules/loading.py", line 225, in load_module_graph
load_data(cr, idref, mode, kind='data', package=package, report=report)
File "/opt/odoo13/odoo/modules/loading.py", line 68, in load_data
tools.convert_file(cr, package.name, filename, idref, mode, noupdate, kind, report)
File "/opt/odoo13/odoo/tools/convert.py", line 736, in convert_file
convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
File "/opt/odoo13/odoo/tools/convert.py", line 803, in convert_xml_import
obj.parse(doc.getroot())
File "/opt/odoo13/odoo/tools/convert.py", line 721, in parse
exc_info[2]
File "/opt/odoo13/odoo/tools/pycompat.py", line 13, in reraise
raise value.with_traceback(tb)
File "/opt/odoo13/odoo/tools/convert.py", line 712, in parse
self._tag_root(de)
File "/opt/odoo13/odoo/tools/convert.py", line 674, in _tag_root
f(rec)
File "/opt/odoo13/odoo/tools/convert.py", line 577, in _tag_record
record = model._load_records([data], self.mode == 'update')
File "/opt/odoo13/odoo/models.py", line 4146, in _load_records
records = self._load_records_create([data['values'] for data in to_create])
File "/opt/odoo13/odoo/models.py", line 4060, in _load_records_create
return self.create(values)
File "", line 2, in create
File "/opt/odoo13/odoo/api.py", line 336, in _model_create_multi
return create(self, arg)
File "/opt/odoo13/odoo/addons/base/models/ir_ui_view.py", line 475, in create
return super(View, self).create(vals_list)
File "", line 2, in create
File "/opt/odoo13/odoo/api.py", line 336, in _model_create_multi
return create(self, arg)
File "/opt/odoo13/odoo/models.py", line 3821, in create
fields[0].determine_inverse(batch_recs)
File "/opt/odoo13/odoo/fields.py", line 1122, in determine_inverse
getattr(records, self.inverse)()
File "/opt/odoo13/odoo/addons/base/models/ir_ui_view.py", line 299, in _inverse_arch
view.write(data)
File "/opt/odoo13/odoo/addons/base/models/ir_ui_view.py", line 493, in write
res = super(View, self).write(self._compute_defaults(vals))
File "/opt/odoo13/odoo/models.py", line 3610, in write
real_recs._validate_fields(set(vals) - set(inverse_fields))
File "/opt/odoo13/odoo/models.py", line 1201, in _validate_fields
check(self)
File "/opt/odoo13/odoo/addons/base/models/ir_ui_view.py", line 385, in _check_xml
view_arch = etree.fromstring(view.arch.encode('utf-8'))
File "src/lxml/lxml.etree.pyx", line 3213, in lxml.etree.fromstring (src/lxml/lxml.etree.c:79003)
File "src/lxml/parser.pxi", line 1848, in lxml.etree._parseMemoryDocument (src/lxml/lxml.etree.c:118334)
File "src/lxml/parser.pxi", line 1736, in lxml.etree._parseDoc (src/lxml/lxml.etree.c:117014)
File "src/lxml/parser.pxi", line 1102, in lxml.etree._BaseParser._parseDoc (src/lxml/lxml.etree.c:111258)
File "src/lxml/parser.pxi", line 595, in lxml.etree._ParserContext._handleParseResultDoc (src/lxml/lxml.etree.c:105102)
File "src/lxml/parser.pxi", line 706, in lxml.etree._handleParseResult (src/lxml/lxml.etree.c:106810)
File "src/lxml/parser.pxi", line 635, in lxml.etree._raiseParseError (src/lxml/lxml.etree.c:105664)
odoo.tools.convert.ParseError: "Extra content at the end of the document, line 24, column 9" while parsing /opt/odoo13/odoo/addons/base/data/ir_demo_data.xml:1, near


Load demo data
ir.demo
form
new



ir.demo.form
ir.demo






 
Danger Zone


Demo data should only be used on test databases!
Once they are loaded, they cannot be removed!


Please confirm that you want to irreversibly make this database a demo database.















2021-07-01 21:25:13,830 392124 DEBUG urdu odoo.modules.registry: Multiprocess load registry signaling: [Registry: 1] [Cache: 1]
2021-07-01 21:25:13,834 392124 INFO urdu odoo.modules.loading: loading 1 modules...
2021-07-01 21:25:13,834 392124 DEBUG urdu odoo.modules.loading: loading module base (1/1)
2021-07-01 21:25:13,850 392124 INFO urdu odoo.modules.loading: 1 modules loaded in 0.02s, 0 queries
2021-07-01 21:25:13,851 392124 ERROR urdu odoo.sql_db: bad query: SELECT * FROM ir_model WHERE state='manual'
ERROR: relation "ir_model" does not exist
LINE 1: SELECT * FROM ir_model WHERE state='manual'
^

2021-07-01 21:25:13,853 392124 WARNING urdu odoo.modules.loading: Transient module states were reset
2021-07-01 21:25:13,853 392124 ERROR urdu odoo.modules.registry: Failed to load registry
Traceback (most recent call last):
File "/opt/odoo13/odoo/modules/registry.py", line 60, in __new__
return cls.registries[db_name]
File "/opt/odoo13/odoo/tools/func.py", line 69, in wrapper
return func(self, *args, **kwargs)
File "/opt/odoo13/odoo/tools/lru.py", line 44, in __getitem__
a = self.d[obj].me
KeyError: 'urdu'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/opt/odoo13/odoo/modules/registry.py", line 86, in new
odoo.modules.load_modules(registry._db, force_demo, status, update_module)
File "/opt/odoo13/odoo/modules/loading.py", line 369, in load_modules
registry.setup_models(cr)
File "/opt/odoo13/odoo/modules/registry.py", line 249, in setup_models
env['ir.model']._add_manual_models()
File "/opt/odoo13/odoo/addons/base/models/ir_model.py", line 320, in _add_manual_models
cr.execute('SELECT * FROM ir_model WHERE state=%s', ['manual'])
File "/opt/odoo13/odoo/sql_db.py", line 173, in wrapper
return f(self, *args, **kwargs)
File "/opt/odoo13/odoo/sql_db.py", line 250, in execute
res = self._obj.execute(query, params)
psycopg2.ProgrammingError: relation "ir_model" does not exist
LINE 1: SELECT * FROM ir_model WHERE state='manual'


Sample error code in Odoo 10

2021-07-01 21:33:36,929 417046 ERROR munshi odoo.addons.website.models.ir_http: 500 Internal Server Error:

Traceback (most recent call last):
File "/opt/munshi/addons/website/models/ir_http.py", line 274, in _handle_exception
response = super(Http, cls)._handle_exception(exception)
File "/opt/munshi/odoo/addons/base/ir/ir_http.py", line 169, in _handle_exception
return request._handle_exception(exception)
File "/opt/munshi/odoo/http.py", line 775, in _handle_exception
return super(HttpRequest, self)._handle_exception(exception)
File "/opt/munshi/odoo/addons/base/ir/ir_http.py", line 195, in _dispatch
result = request.dispatch()
File "/opt/munshi/odoo/http.py", line 834, in dispatch
r = self._call_function(**self.params)
File "/opt/munshi/odoo/http.py", line 334, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/opt/munshi/odoo/service/model.py", line 101, in wrapper
return f(dbname, *args, **kwargs)
File "/opt/munshi/odoo/http.py", line 327, in checked_call
result = self.endpoint(*a, **kw)
File "/opt/munshi/odoo/http.py", line 942, in __call__
return self.method(*args, **kw)
File "/opt/munshi/odoo/http.py", line 507, in response_wrap
response = f(*args, **kw)
File "/opt/munshi/addons/website_forum/controllers/main.py", line 128, in questions
Post._generate_order_by(sorting, None)
File "/opt/munshi/odoo/models.py", line 4218, in _generate_order_by
order_by_elements = self._generate_order_by_inner(self._table, order_spec, query)
File "/opt/munshi/odoo/models.py", line 4172, in _generate_order_by_inner
self._check_qorder(order_spec)
File "/opt/munshi/odoo/models.py", line 4052, in _check_qorder
raise UserError(_('Invalid "order" specified. A valid "order" specification is a comma-separated list of valid field names (optionally followed by asc/desc for the direction)'))
UserError: (u'Invalid "order" specified. A valid "order" specification is a comma-separated list of valid field names (optionally followed by asc/desc for the direction)', '')

2021-07-01 21:33:36,978 417046 INFO munshi werkzeug: 127.0.0.1 - - [01/Jul/2021 21:33:36] "GET /forum/help-1?filters=all&sorting=create_date%2Bdesc HTTP/1.0" 500 -
2021-07-01 21:33:36,982 417046 ERROR munshi werkzeug: Error on request:
Traceback (most recent call last):
File "/opt/munshi/odoo-venv/lib/python2.7/site-packages/werkzeug/serving.py", line 193, in run_wsgi
execute(self.server.app)
File "/opt/munshi/odoo-venv/lib/python2.7/site-packages/werkzeug/serving.py", line 181, in execute
application_iter = app(environ, start_response)
File "/opt/munshi/odoo/service/wsgi_server.py", line 184, in application
return werkzeug.contrib.fixers.ProxyFix(application_unproxied)(environ, start_response)
File "/opt/munshi/odoo-venv/lib/python2.7/site-packages/werkzeug/contrib/fixers.py", line 152, in __call__
return self.app(environ, start_response)
File "/opt/munshi/odoo/service/wsgi_server.py", line 172, in application_unproxied
result = handler(environ, start_response)
File "/opt/munshi/odoo/http.py", line 1326, in __call__
return self.dispatch(environ, start_response)
File "/opt/munshi/odoo/http.py", line 1300, in __call__
return self.app(environ, start_wrapped)
File "/opt/munshi/odoo-venv/lib/python2.7/site-packages/werkzeug/wsgi.py", line 599, in __call__
return self.app(environ, start_response)
File "/opt/munshi/odoo/http.py", line 1499, in dispatch
result = ir_http._dispatch()
File "/opt/munshi/addons/website_sale/models/ir_http.py", line 15, in _dispatch
return super(IrHttp, cls)._dispatch()
File "/opt/munshi/addons/website/models/ir_http.py", line 219, in _dispatch
resp = super(Http, cls)._dispatch()
File "/opt/munshi/addons/web_editor/models/ir_http.py", line 21, in _dispatch
return super(IrHttp, cls)._dispatch()
File "/opt/munshi/addons/utm/models/ir_http.py", line 20, in _dispatch
response = super(IrHttp, cls)._dispatch()
File "/opt/munshi/odoo/addons/base/ir/ir_http.py", line 199, in _dispatch
return cls._handle_exception(e)
File "/opt/munshi/addons/website/models/ir_http.py", line 327, in _handle_exception
html = request.env['ir.ui.view'].render_template('website.http_error', values)
File "/opt/munshi/odoo/addons/base/ir/ir_ui_view.py", line 1049, in render_template
return self.browse(self.get_view_id(template)).render(values, engine)
File "/opt/munshi/addons/website/models/ir_ui_view.py", line 115, in render
return super(View, self).render(values, engine=engine)
File "/opt/munshi/addons/web_editor/models/ir_ui_view.py", line 26, in render
return super(IrUiView, self).render(values=values, engine=engine)
File "/opt/munshi/odoo/addons/base/ir/ir_ui_view.py", line 1069, in render
return self.env[engine].render(self.id, qcontext)
File "/opt/munshi/odoo/addons/base/ir/ir_qweb/ir_qweb.py", line 53, in render
return super(IrQWeb, self).render(id_or_xml_id, values=values, **context)
File "/opt/munshi/odoo/addons/base/ir/ir_qweb/qweb.py", line 248, in render
self.compile(template, options)(self, body.append, values or {})
File "/opt/munshi/odoo/addons/base/ir/ir_qweb/qweb.py", line 317, in _compiled_fn
raise e
QWebException: None
Traceback (most recent call last):
File "/opt/munshi/odoo/addons/base/ir/ir_qweb/qweb.py", line 341, in get_template
document = options.get('load', self.load)(template, options)
File "/opt/munshi/odoo/addons/base/ir/ir_qweb/ir_qweb.py", line 81, in load
template = env['ir.ui.view'].read_template(name)
File "/opt/munshi/odoo/addons/base/ir/ir_ui_view.py", line 944, in read_template
return self._read_template(self.get_view_id(xml_id))
File "", line 2, in _read_template
File "/opt/munshi/odoo/tools/cache.py", line 87, in lookup
value = d[key] = self.method(*args, **kwargs)
File "/opt/munshi/odoo/addons/base/ir/ir_ui_view.py", line 935, in _read_template
arch = self.browse(view_id).read_combined(['arch'])['arch']
File "/opt/munshi/custom-addons/it-projects-llc/misc-addons/web_debranding/models/ir_ui_view.py", line 17, in read_combined
res = super(View, self).read_combined(fields=fields)
File "/opt/munshi/odoo/addons/base/ir/ir_ui_view.py", line 658, in read_combined
view_arch = etree.fromstring(view_data['arch'].encode('utf-8'))
File "src/lxml/lxml.etree.pyx", line 3213, in lxml.etree.fromstring (src/lxml/lxml.etree.c:82934)
File "src/lxml/parser.pxi", line 1819, in lxml.etree._parseMemoryDocument (src/lxml/lxml.etree.c:124533)
File "src/lxml/parser.pxi", line 1707, in lxml.etree._parseDoc (src/lxml/lxml.etree.c:123074)
File "src/lxml/parser.pxi", line 1079, in lxml.etree._BaseParser._parseDoc (src/lxml/lxml.etree.c:117114)
File "src/lxml/parser.pxi", line 573, in lxml.etree._ParserContext._handleParseResultDoc (src/lxml/lxml.etree.c:110510)
File "src/lxml/parser.pxi", line 683, in lxml.etree._handleParseResult (src/lxml/lxml.etree.c:112276)
File "src/lxml/parser.pxi", line 613, in lxml.etree._raiseParseError (src/lxml/lxml.etree.c:111124)
XMLSyntaxError: Extra content at the end of the document, line 112, column 13

load could not load template
Template: website.layout
2021-07-01 21:34:28,262 417050 DEBUG ? odoo.service.server: WorkerCron (417050) polling for jobs

I failed to troubleshoot it. Please help me.
Steps I taken:
I reinstalled all dependencies. I installed pip dependencies in odoo-venv for each version (Python 2.7, Python 3.6 Python 3.8 etc) with below command

> /path/to/odoo-venv/bin/pythonx -m pip install --no-cache-dir -r
> requirements.text

I configured a VPS to test my codes, I migrated all my code for Odoo 10, I used all configurations from my server in that VPS (odoo.conf, systelctl service, custom addons, etc). I connected it to my current PostgreSQL server, in VPS there is no issue, no error.
I did the same then for every version and I found out that there is nothing wrong with my code or configuration or with databases. It is something related to some upgraded package version but I could not find the issue.
1
Avatar
Vazgeç
Avatar
Muhammad Faheem Khan
Üretici En İyi Yanıt

After 3 days of struggle, I successfully found the culprit dependency. It was LXML. What I did.

rm -rf venv
virtualenv -p pythonx venv
source venv/bin/activate
pip install -r requirements.txt
pip uninstall lxml
find .cache -name 'lxml*'
find .cache -name 'lxml*' -delete
pip install lxml

**What was the difference here.**

It was the version of **lxml**, I had lxml-3.7.1, it was causing issues.
I installed the latest version and it removed the error. It may be risky or may cause other troubles because Odoo recommends lxml-3.7.1 for python < 3.7 but at the moment, it solved my issue and that is enough for me for now. anyways, thanks for giving attention to this question.

2
Avatar
Vazgeç
Avatar
Sylvain LE GAL
En İyi Yanıt

Same here ! I applied this patch (regarding lxml and another lib) and it works like a charm.

however, don't know why it has stopped working.

https://github.com/odoo/odoo/commit/340e273f677f5c756dad3a5bd8062c26ccfad612

0
Avatar
Vazgeç
Avatar
Tuxane
En İyi Yanıt

Thank you ! I had the same error in odoo12 .

Your solution works great

0
Avatar
Vazgeç
Enjoying the discussion? Don't just read, join in!

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

Üye Ol
İlgili Gönderiler Cevaplar Görünümler Aktivite
ValueError: Compute method failed to assign Çözüldü
python3 v14
Avatar
Avatar
Avatar
Avatar
Avatar
5
Eki 24
34278
what's the most recent Python version Odoo 14 can be built on ? Çözüldü
python3 v14
Avatar
1
Tem 23
8916
ModuleNotFoundError: No module named 'html2text' Çözüldü
python3 v14
Avatar
Avatar
2
Tem 22
12549
Installation the Odoo 14 for lunix
v14 ubuntu20.04
Avatar
Avatar
1
Kas 21
211
How to call a method of a class from another class?
python3 v14
Avatar
Avatar
2
Eki 21
4224
Topluluk
  • Eğitim Araçları
  • Dokümantasyon
  • Forum
Açık Kaynak
  • İndirin
  • Github
  • Runbot
  • Çeviriler
Hizmetler
  • Odoo.sh Hosting
  • Destek
  • Sürüm Yükseltme
  • Özel Geliştirmeler
  • Eğitim
  • Muhasebeci Bulun
  • Partner Bulun
  • Partner Olun
Hakkında
  • Şirketimiz
  • Pazarlama Gereçleri
  • İletişim
  • Kariyer
  • Etkinlikler
  • Podcast
  • Blog
  • Müşteriler
  • Hukuki • Gizlilik
  • Güvenlik
الْعَرَبيّة 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, müşteri ilişkileri yönetimi, eTicaret, muhasebe, envanter, satış noktası, proje yönetimi gibi şirketinizin tüm ihtiyaçlarını karşılayan bir açık kaynak işletme uygulamaları paketidir.

Odoo’nun eşsiz değer önermesi, aynı anda hem kullanımının çok kolay olup hem de tamamen entegre olmasıdır.

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