Skip to Content
Odoo Menu
  • Prihlásiť sa
  • Vyskúšajte zadarmo
  • Aplikácie
    Financie
    • Účtovníctvo
    • Fakturácia
    • Výdavky
    • Tabuľka (BI)
    • Dokumenty
    • Podpis
    Predaj
    • CRM
    • Predaj
    • POS Shop
    • POS Restaurant
    • Manažment odberu
    • Požičovňa
    Webstránky
    • Tvorca webstránok
    • eShop
    • Blog
    • Fórum
    • Živý chat
    • eLearning
    Supply Chain
    • Sklad
    • Výroba
    • Správa životného cyklu produktu
    • Nákup
    • Údržba
    • Manažment kvality
    Ľudské zdroje
    • Zamestnanci
    • Nábor zamestnancov
    • Voľné dni
    • Hodnotenia
    • Odporúčania
    • Vozový park
    Marketing
    • Marketing sociálnych sietí
    • Email marketing
    • SMS marketing
    • Eventy
    • Marketingová automatizácia
    • Prieskumy
    Služby
    • Projektové riadenie
    • Pracovné výkazy
    • Práca v teréne
    • Helpdesk
    • Plánovanie
    • Schôdzky
    Produktivita
    • Tímová komunikácia
    • Schvalovania
    • IoT
    • VoIP
    • Znalosti
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Priemyselné odvetvia
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Reštaurácia
    • Fast Food
    • Guest House
    • Beverage distributor
    • Hotel
    Reality
    • Real Estate Agency
    • Architecture Firm
    • Konštrukcia
    • Estate Managament
    • Gardening
    • Property Owner Association
    Poradenstvo
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Výroba
    • Textile
    • Metal
    • Furnitures
    • Jedlo
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware and Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Iní
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Komunita
    Vzdelávanie
    • Tutoriály
    • Dokumentácia
    • Certifikácie
    • Školenie
    • Blog
    • Podcast
    Empower Education
    • Vzdelávací program
    • Scale Up! Business Game
    • Visit Odoo
    Softvér
    • Stiahnuť
    • Porovnanie Community a Enterprise vierzie
    • Releases
    Spolupráca
    • Github
    • Fórum
    • Eventy
    • Preklady
    • Staň sa partnerom
    • Services for Partners
    • Register your Accounting Firm
    Služby
    • Nájdite partnera
    • Nájdite účtovníka
    • Meet an advisor
    • Implementation Services
    • Zákaznícke referencie
    • Podpora
    • Upgrades
    ​Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Získajte demo
  • Cenník
  • Pomoc

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

  • CRM
  • e-Commerce
  • Účtovníctvo
  • Sklady
  • PoS
  • Projektové riadenie
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tagy (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tagy (View all)
odoo accounting v14 pos v15
About this forum
Pomoc

Cannot initialize DB in Odoo12

Odoberať

Get notified when there's activity on this post

This question has been flagged
developmentinstallationdatabaseodoo12
2 Replies
24887 Zobrazenia
Avatar
Jorge

Hi, when I try to initialize the DB I get the following errors:

$ python odoo-bin --addons-path=addons  -i base

....
2021-07-14 04:46:48,122 6452 INFO borch odoo.modules.loading: loading base/data/res.lang.csv 2021-07-14 04:46:48,185 6452 INFO borch odoo.modules.loading: loading base/data/res_lang_data.xml 2021-07-14 04:46:48,195 6452 INFO borch odoo.modules.loading: loading base/data/res_partner_data.xml 2021-07-14 04:46:48,339 6452 INFO borch odoo.modules.loading: loading base/data/res_company_data.xml 2021-07-14 04:46:48,359 6452 INFO borch odoo.modules.loading: loading base/data/res_users_data.xml 2021-07-14 04:46:48,570 6452 INFO borch odoo.modules.loading: loading base/data/report_paperformat_data.xml 2021-07-14 04:46:48,578 6452 INFO borch odoo.modules.loading: loading base/data/res_currency_data.xml 2021-07-14 04:46:48,981 6452 INFO borch odoo.modules.loading: loading base/data/res_country_data.xml 2021-07-14 04:46:50,597 6452 INFO borch odoo.modules.loading: loading base/data/ir_demo_data.xml 2021-07-14 04:46:50,625 6452 ERROR borch odoo.sql_db: bad query: UPDATE ir_module_module SET state='installed' WHERE state IN ('to remove', 'to upgrade')ERROR: relation "ir_module_module" does not existLINE 1: UPDATE ir_module_module SET state='installed' WHERE state IN... ^ 2021-07-14 04:46:50,625 6452 ERROR borch odoo.modules.registry: Failed to load registry Traceback (most recent call last): File "/home/borch/odoo/odoo/models.py", line 1128, in _validate_fields check(self) File "/home/borch/odoo/odoo/addons/base/models/ir_ui_view.py", line 343, in _check_xml view_arch = etree.fromstring(view.arch.encode('utf-8')) File "src/lxml/etree.pyx", line 3213, in lxml.etree.fromstring File "src/lxml/parser.pxi", line 1877, in lxml.etree._parseMemoryDocument File "src/lxml/parser.pxi", line 1765, in lxml.etree._parseDoc File "src/lxml/parser.pxi", line 1127, in lxml.etree._BaseParser._parseDoc File "src/lxml/parser.pxi", line 601, in lxml.etree._ParserContext._handleParseResultDoc File "src/lxml/parser.pxi", line 711, in lxml.etree._handleParseResult File "src/lxml/parser.pxi", line 640, in lxml.etree._raiseParseError File "", line 24lxml.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 "/home/borch/odoo/odoo/tools/convert.py", line 758, in parse self._tags[rec.tag](rec, de, mode=mode) File "/home/borch/odoo/odoo/tools/convert.py", line 663, in _tag_record record = model.with_context(rec_context)._load_records([data], self.mode == 'update') File "/home/borch/odoo/odoo/models.py", line 3910, in _load_records records = self._load_records_create([data['values'] for data in to_create]) File "/home/borch/odoo/odoo/models.py", line 3824, in _load_records_create return self.create(values) File "", line 2, in create File "/home/borch/odoo/odoo/api.py", line 462, in _model_create_multi return create(self, arg) File "/home/borch/odoo/odoo/addons/base/models/ir_ui_view.py", line 428, in create return super(View, self).create(vals_list) File "", line 2, in create File "/home/borch/odoo/odoo/api.py", line 462, in _model_create_multi return create(self, arg) File "/home/borch/odoo/odoo/models.py", line 3641, in create fields[0].determine_inverse(batch_recs) File "/home/borch/odoo/odoo/fields.py", line 1200, in determine_inverse getattr(records, self.inverse)() File "/home/borch/odoo/odoo/addons/base/models/ir_ui_view.py", line 275, in _inverse_arch view.write(data) File "/home/borch/odoo/odoo/addons/base/models/ir_ui_view.py", line 445, in write res = super(View, self).write(self._compute_defaults(vals)) File "/home/borch/odoo/odoo/models.py", line 3366, in write self._write(store_vals) File "/home/borch/odoo/odoo/models.py", line 3502, in _write self._validate_fields(vals) File "/home/borch/odoo/odoo/models.py", line 1132, in _validate_fields raise ValidationError("%s\n\n%s" % (_("Error while validating constraint"), tools.ustr(e)))odoo.exceptions.ValidationError: ('Error while validating constraint\n\nExtra content at the end of the document, line 24, column 9', None)
During handling of the above exception, another exception occurred:
Traceback (most recent call last): File "/home/borch/odoo/odoo/modules/registry.py", line 86, in new odoo.modules.load_modules(registry._db, force_demo, status, update_module) File "/home/borch/odoo/odoo/modules/loading.py", line 360, in load_modules loaded_modules, processed_modules = load_module_graph( File "/home/borch/odoo/odoo/modules/loading.py", line 222, in load_module_graph load_data(cr, idref, mode, kind='data', package=package, report=report) File "/home/borch/odoo/odoo/modules/loading.py", line 68, in load_data tools.convert_file(cr, package.name, filename, idref, mode, noupdate, kind, report) File "/home/borch/odoo/odoo/tools/convert.py", line 802, in convert_file convert_xml_import(cr, module, fp, idref, mode, noupdate, report) File "/home/borch/odoo/odoo/tools/convert.py", line 865, in convert_xml_import obj.parse(doc.getroot(), mode=mode) File "/home/borch/odoo/odoo/tools/convert.py", line 761, in parse pycompat.reraise( File "/home/borch/odoo/odoo/tools/pycompat.py", line 86, in reraise raise value.with_traceback(tb) File "/home/borch/odoo/odoo/tools/convert.py", line 758, in parse self._tags[rec.tag](rec, de, mode=mode) File "/home/borch/odoo/odoo/tools/convert.py", line 663, in _tag_record record = model.with_context(rec_context)._load_records([data], self.mode == 'update') File "/home/borch/odoo/odoo/models.py", line 3910, in _load_records records = self._load_records_create([data['values'] for data in to_create]) File "/home/borch/odoo/odoo/models.py", line 3824, in _load_records_create return self.create(values) File "", line 2, in create File "/home/borch/odoo/odoo/api.py", line 462, in _model_create_multi return create(self, arg) File "/home/borch/odoo/odoo/addons/base/models/ir_ui_view.py", line 428, in create return super(View, self).create(vals_list) File "", line 2, in create File "/home/borch/odoo/odoo/api.py", line 462, in _model_create_multi return create(self, arg) File "/home/borch/odoo/odoo/models.py", line 3641, in create fields[0].determine_inverse(batch_recs) File "/home/borch/odoo/odoo/fields.py", line 1200, in determine_inverse getattr(records, self.inverse)() File "/home/borch/odoo/odoo/addons/base/models/ir_ui_view.py", line 275, in _inverse_arch view.write(data) File "/home/borch/odoo/odoo/addons/base/models/ir_ui_view.py", line 445, in write res = super(View, self).write(self._compute_defaults(vals)) File "/home/borch/odoo/odoo/models.py", line 3366, in write self._write(store_vals) File "/home/borch/odoo/odoo/models.py", line 3502, in _write self._validate_fields(vals) File "/home/borch/odoo/odoo/models.py", line 1132, in _validate_fields raise ValidationError("%s\n\n%s" % (_("Error while validating constraint"), tools.ustr(e)))odoo.tools.convert.ParseError: "Error while validating constraint
Extra content at the end of the document, line 24, column 9None" while parsing /home/borch/odoo/odoo/addons/base/data/ir_demo_data.xml:9, near 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.



During handling of the above exception, another exception occurred:
Traceback (most recent call last): File "/home/borch/odoo/odoo/modules/registry.py", line 88, in new odoo.modules.reset_modules_state(db_name) File "/home/borch/odoo/odoo/modules/loading.py", line 556, in reset_modules_state cr.execute( File "/home/borch/odoo/odoo/sql_db.py", line 148, in wrapper return f(self, *args, **kwargs) File "/home/borch/odoo/odoo/sql_db.py", line 225, in execute res = self._obj.execute(query, params)psycopg2.errors.UndefinedTable: relation "ir_module_module" does not existLINE 1: UPDATE ir_module_module SET state='installed' WHERE state IN... ^
2021-07-14 04:46:50,627 6452 CRITICAL borch odoo.service.server: Failed to initialize database `borch`. Traceback (most recent call last): File "/home/borch/odoo/odoo/models.py", line 1128, in _validate_fields check(self) File "/home/borch/odoo/odoo/addons/base/models/ir_ui_view.py", line 343, in _check_xml view_arch = etree.fromstring(view.arch.encode('utf-8')) File "src/lxml/etree.pyx", line 3213, in lxml.etree.fromstring File "src/lxml/parser.pxi", line 1877, in lxml.etree._parseMemoryDocument File "src/lxml/parser.pxi", line 1765, in lxml.etree._parseDoc File "src/lxml/parser.pxi", line 1127, in lxml.etree._BaseParser._parseDoc File "src/lxml/parser.pxi", line 601, in lxml.etree._ParserContext._handleParseResultDoc File "src/lxml/parser.pxi", line 711, in lxml.etree._handleParseResult File "src/lxml/parser.pxi", line 640, in lxml.etree._raiseParseError File "", line 24lxml.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 "/home/borch/odoo/odoo/tools/convert.py", line 758, in parse self._tags[rec.tag](rec, de, mode=mode) File "/home/borch/odoo/odoo/tools/convert.py", line 663, in _tag_record record = model.with_context(rec_context)._load_records([data], self.mode == 'update') File "/home/borch/odoo/odoo/models.py", line 3910, in _load_records records = self._load_records_create([data['values'] for data in to_create]) File "/home/borch/odoo/odoo/models.py", line 3824, in _load_records_create return self.create(values) File "", line 2, in create File "/home/borch/odoo/odoo/api.py", line 462, in _model_create_multi return create(self, arg) File "/home/borch/odoo/odoo/addons/base/models/ir_ui_view.py", line 428, in create return super(View, self).create(vals_list) File "", line 2, in create File "/home/borch/odoo/odoo/api.py", line 462, in _model_create_multi return create(self, arg) File "/home/borch/odoo/odoo/models.py", line 3641, in create fields[0].determine_inverse(batch_recs) File "/home/borch/odoo/odoo/fields.py", line 1200, in determine_inverse getattr(records, self.inverse)() File "/home/borch/odoo/odoo/addons/base/models/ir_ui_view.py", line 275, in _inverse_arch view.write(data) File "/home/borch/odoo/odoo/addons/base/models/ir_ui_view.py", line 445, in write res = super(View, self).write(self._compute_defaults(vals)) File "/home/borch/odoo/odoo/models.py", line 3366, in write self._write(store_vals) File "/home/borch/odoo/odoo/models.py", line 3502, in _write self._validate_fields(vals) File "/home/borch/odoo/odoo/models.py", line 1132, in _validate_fields raise ValidationError("%s\n\n%s" % (_("Error while validating constraint"), tools.ustr(e)))odoo.exceptions.ValidationError: ('Error while validating constraint\n\nExtra content at the end of the document, line 24, column 9', None)
During handling of the above exception, another exception occurred:
Traceback (most recent call last): File "/home/borch/odoo/odoo/modules/registry.py", line 86, in new odoo.modules.load_modules(registry._db, force_demo, status, update_module) File "/home/borch/odoo/odoo/modules/loading.py", line 360, in load_modules loaded_modules, processed_modules = load_module_graph( File "/home/borch/odoo/odoo/modules/loading.py", line 222, in load_module_graph load_data(cr, idref, mode, kind='data', package=package, report=report) File "/home/borch/odoo/odoo/modules/loading.py", line 68, in load_data tools.convert_file(cr, package.name, filename, idref, mode, noupdate, kind, report) File "/home/borch/odoo/odoo/tools/convert.py", line 802, in convert_file convert_xml_import(cr, module, fp, idref, mode, noupdate, report) File "/home/borch/odoo/odoo/tools/convert.py", line 865, in convert_xml_import obj.parse(doc.getroot(), mode=mode) File "/home/borch/odoo/odoo/tools/convert.py", line 761, in parse pycompat.reraise( File "/home/borch/odoo/odoo/tools/pycompat.py", line 86, in reraise raise value.with_traceback(tb) File "/home/borch/odoo/odoo/tools/convert.py", line 758, in parse self._tags[rec.tag](rec, de, mode=mode) File "/home/borch/odoo/odoo/tools/convert.py", line 663, in _tag_record record = model.with_context(rec_context)._load_records([data], self.mode == 'update') File "/home/borch/odoo/odoo/models.py", line 3910, in _load_records records = self._load_records_create([data['values'] for data in to_create]) File "/home/borch/odoo/odoo/models.py", line 3824, in _load_records_create return self.create(values) File "", line 2, in create File "/home/borch/odoo/odoo/api.py", line 462, in _model_create_multi return create(self, arg) File "/home/borch/odoo/odoo/addons/base/models/ir_ui_view.py", line 428, in create return super(View, self).create(vals_list) File "", line 2, in create File "/home/borch/odoo/odoo/api.py", line 462, in _model_create_multi return create(self, arg) File "/home/borch/odoo/odoo/models.py", line 3641, in create fields[0].determine_inverse(batch_recs) File "/home/borch/odoo/odoo/fields.py", line 1200, in determine_inverse getattr(records, self.inverse)() File "/home/borch/odoo/odoo/addons/base/models/ir_ui_view.py", line 275, in _inverse_arch view.write(data) File "/home/borch/odoo/odoo/addons/base/models/ir_ui_view.py", line 445, in write res = super(View, self).write(self._compute_defaults(vals)) File "/home/borch/odoo/odoo/models.py", line 3366, in write self._write(store_vals) File "/home/borch/odoo/odoo/models.py", line 3502, in _write self._validate_fields(vals) File "/home/borch/odoo/odoo/models.py", line 1132, in _validate_fields raise ValidationError("%s\n\n%s" % (_("Error while validating constraint"), tools.ustr(e)))odoo.tools.convert.ParseError: "Error while validating constraint
Extra content at the end of the document, line 24, column 9None" while parsing /home/borch/odoo/odoo/addons/base/data/ir_demo_data.xml:9, near 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.



During handling of the above exception, another exception occurred:
Traceback (most recent call last): File "/home/borch/odoo/odoo/service/server.py", line 1164, in preload_registries registry = Registry.new(dbname, update_module=update_module) File "/home/borch/odoo/odoo/modules/registry.py", line 88, in new odoo.modules.reset_modules_state(db_name) File "/home/borch/odoo/odoo/modules/loading.py", line 556, in reset_modules_state cr.execute( File "/home/borch/odoo/odoo/sql_db.py", line 148, in wrapper return f(self, *args, **kwargs) File "/home/borch/odoo/odoo/sql_db.py", line 225, in execute res = self._obj.execute(query, params)psycopg2.errors.UndefinedTable: relation "ir_module_module" does not existLINE 1: UPDATE ir_module_module SET state='installed' WHERE state IN... ^

I have already created the database using the following commands:

$ sudo -u postgres createuser -s $USER
$ createdb $USER

Instructions from here: https://www.odoo.com/documentation/12.0/administration/install.html#id7


I can connect with the database without any issues:
$ psql 

psql (11.12 (Debian 11.12-0+deb10u1))Type "help" for help.
borch=# 

Already installed all requirements. Is there something I am missing? Thanks.


0
Avatar
Zrušiť
Jorge
Autor

Hi Rajprasad, I recreated the DB and tried to initialize again but I got the same problem:

(.venv) borch@g4560:~/odoo$ dropdb borch

(.venv) borch@g4560:~/odoo$ createdb odoodb

(.venv) borch@g4560:~/odoo$ psql

psql: FATAL: database "borch" does not exist

(.venv) borch@g4560:~/odoo$ psql odoodb

psql (11.12 (Debian 11.12-0+deb10u1))

Type "help" for help.

odoodb=# \l

odoodb=# exit

(.venv) borch@g4560:~/odoo$ python3 odoo-bin --addons-path=addons -d odoodb -i base

es.loading: loading base/data/ir_demo_data.xml

2021-07-14 14:14:19,452 14647 ERROR odoodb odoo.sql_db: bad query: UPDATE ir_module_module SET state='installed' WHERE state IN ('to remove', 'to upgrade')

ERROR: relation "ir_module_module" does not exist

LINE 1: UPDATE ir_module_module SET state='installed' WHERE state IN...

^

2021-07-14 14:14:19,452 14647 ERROR odoodb odoo.modules.registry: Failed to load registry

Avatar
Rajprasad Joshi
Best Answer

Hi Jorge,

Try with the below commands:
1) Create a new database:
    createdb #database name
2) Run using python3 instead of python and add newly created db in terminal
    python3 odoo-bin --addons-path=addons  -d #database name -i base

Regards,
RPJ

4
Avatar
Zrušiť
Avatar
Mustaq Ahmed
Best Answer

The working configuration for ODOO14 docker compose is as follows

docker-compose:::

version: '2'
services:
web:
image: odoo:14.0
depends_on:
- db
ports:
- "8069:8069"
volumes:
- odoo-web-data:/var/lib/odoo
- ./config:/etc/odoo
- ./addons:/mnt/extra-addons
db:
image: postgres:10
environment:
- POSTGRES_PASSWORD=odoo
- POSTGRES_USER=odoo
- POSTGRES_DB=odoodb
- PGDATA=/var/lib/postgresql/data/pgdata
volumes:
- odoo-db-data:/var/lib/postgresql/data/pgdata
volumes:
odoo-web-data:
odoo-db-data:


odoo.conf in /config folder

[options]
admin_passwd = yoursecret
db_host = db
db_name = odoodb
db_port = 5432
db_user = odoo
db_password = odoo
addons_path = /mnt/extra-addons,/mnt/enterprise
proxy_mode = True
data_dir = /var/lib/odoo

0
Avatar
Zrušiť
Enjoying the discussion? Don't just read, join in!

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

Registrácia
Related Posts Replies Zobrazenia Aktivita
Odoo OpenERP Server Error Traceback (most recent call last):
development installation database odoo8
Avatar
0
jún 16
11515
How to reset the development database Solved
development database
Avatar
Avatar
Avatar
2
aug 25
3066
how to install sassc? Solved
installation odoo12
Avatar
Avatar
Avatar
Avatar
Avatar
12
júl 24
81152
Restore backup to postgresql for odoo
development database pgadmin
Avatar
0
nov 24
50
Database selector for on-premises instance first setup
development setup database
Avatar
0
apr 22
109
Komunita
  • Tutoriály
  • Dokumentácia
  • Fórum
Open Source
  • Stiahnuť
  • Github
  • Runbot
  • Preklady
Služby
  • Odoo.sh hosting
  • Podpora
  • Vyššia verzia
  • Custom Developments
  • Vzdelávanie
  • Nájdite účtovníka
  • Nájdite partnera
  • Staň sa partnerom
O nás
  • Naša spoločnosť
  • Majetok značky
  • Kontaktujte nás
  • Pracovné ponuky
  • Eventy
  • Podcast
  • Blog
  • Zákazníci
  • Právne dokumenty • Súkromie
  • Bezpečnosť
الْعَرَبيّة 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 je sada podnikových aplikácií s otvoreným zdrojovým kódom, ktoré pokrývajú všetky potreby vašej spoločnosti: CRM, e-shop, účtovníctvo, skladové hospodárstvo, miesto predaja, projektový manažment atď.

Odoo prináša vysokú pridanú hodnotu v jednoduchom použití a súčasne plne integrovanými biznis aplikáciami.

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