Skip to Content
This question has been flagged
configurationsetup
2 Respostes
541 Vistes
Avatar
eb

Hi,


We installed on-premise Odoo v19 community from source github and Enterprise from .deb package.


Question1 : can I always update codebase from github if I stay  on v19 or v19.x github branche without update database ?


Question2: when need I update database and how to know if my codebase is  compatible with current data se version ?


Question3: How can I track database version? 

Avatar
Descartar
Avatar
CandidRoot Solutions
Best Answer

Hi Eb,

I hope you are doing good.

Please find answers to your questions below:

Q1: Can I update the codebase from GitHub (v19 / v19.x) without updating the database?

  • Yes, minor updates (bug fixes, small improvements) can usually be pulled from the v19.x branch without upgrading the database.

  • However, if the update includes new fields, models, or schema changes, then a database update will be required.

Q2: When do I need to update the database, and how do I know if the code is compatible?

  • You need to update the database when:

    • Release notes mention database/schema changes

    • You see errors like missing columns, models, or fields

  • Best practice:

    • Always check GitHub commit messages / release notes

    • Test updates first on a staging database

  • If Odoo starts normally and no migration errors appear, the code is compatible.

Q3: How can I track the database version?

You can check it in the following ways:

  • Enable Developer Mode → go to Settings → About

  • Or check the table ir_module_module for installed module versions

  • Also, the Odoo server log shows DB version during startup

Avatar
Descartar
eb
Autor

When you say test on staging first, so i need duplicate my /opt/odoo and duplicate database ? If im on same instance ? And what about Enterprise licence I can have/run 2 Odoo with same licence code ?

Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer
Hi,

1- Simply pulling code from GitHub for your Odoo Community installation does not automatically update your database. For minor code changes like bug fixes or UI tweaks that don't alter data models, you can often restart Odoo without a database update. However, if the code changes involve modifications to database schemas (e.g., new fields, changed field types, new models), you must update the database by running Odoo with the -u flag (e.g., odoo-bin -u all). It's generally a best practice to perform a database update after any significant code pull, always testing in a staging environment first, and be mindful of potential compatibility issues if your Enterprise modules are from a separate .deb package and not updated in sync with your source-based Community code.

2- You need to update your database for major version upgrades, any schema changes within modules (like adding or modifying fields/models), data migrations, or after pulling significant code updates from GitHub. Incompatibility is often indicated by Odoo failing to start or throwing specific errors such as UndefinedColumn or UndefinedTable, which signal that the code expects a database structure different from what exists. Odoo internally tracks the version of each installed module, and running odoo-bin -u module_name compares these versions to apply necessary updates. Always test code and database updates in a staging environment before applying them to production.

3-  Odoo does not maintain a single "database version" number; instead, it tracks the version of each individual installed module within the database. You can monitor these module versions through the Odoo user interface by navigating to Settings > Apps > Installed Apps and checking the "Version" column for each module. Alternatively, you can query the ir_module_module table in your PostgreSQL database, where the latest_version column for each module record indicates its current version in the database. When you run odoo-bin -u all, Odoo uses these stored versions to determine which modules require an update.

Hope it helps

Avatar
Descartar
eb
Autor

1. Do you recommend me to install Enterprise from source too?
2. Where can i read more in Odoo-bin -u? Does this check Enterprise module too.
3. You Said if New model New fields… i need update database but instead read hundreds commit message how can I be awared easily if database is not compatible? I was thinking if we stay on v19 branch there is no New fields new model

Related Posts Respostes Vistes Activitat
What is the relationship between my odoo.com account / login and my test database account / login ?
configuration setup
Avatar
0
de nov. 25
621
Issue with CNAME Record & Custom Domain Configuration in Odoo Solved
configuration setup
Avatar
Avatar
Avatar
Avatar
3
de febr. 26
4540
email address change vendor invoices
configuration setup
Avatar
Avatar
Avatar
3
d’oct. 25
3820
Linking DBs to sub-domains Solved
configuration setup
Avatar
Avatar
1
de set. 25
1158
3-tier website account membership
configuration setup
Avatar
0
de jul. 25
1400