Skip to Content
This question has been flagged
configurationsetup
2 Replies
186 Views
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
Discard
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
Discard
eb
Author

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

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
Discard
eb
Author

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 ?

Related Posts Replies Views Activity
What is the relationship between my odoo.com account / login and my test database account / login ?
configuration setup
Avatar
0
Nov 25
457
Issue with CNAME Record & Custom Domain Configuration in Odoo
configuration setup
Avatar
Avatar
Avatar
Avatar
3
Nov 25
4178
email address change vendor invoices
configuration setup
Avatar
Avatar
Avatar
3
Oct 25
3565
Linking DBs to sub-domains Solved
configuration setup
Avatar
Avatar
1
Sep 25
1038
3-tier website account membership
configuration setup
Avatar
0
Jul 25
1274