Odoo 19: What Causes the ‘Undefined Table’ Warning and How to Resolve It

When setting up Odoo 19 on Windows, I ran into a tricky error message after finally solving a PostgreSQL collation issue. This post documents how I encountered and resolved the following error:

"WARNING odoo19_demo_01 odoo.addons.base.models.ir_cron: Tried to poll an undefined table on database odoo19_demo_01."

If you’re seeing something similar, this guide might save you hours of troubleshooting.

Setting up Odoo 19 on Windows,

I was deploying an Odoo 19 instance on a Windows 11 machine using PostgreSQL as the backend.

Initially, the database creation failed due to collation mismatches between Odoo and PostgreSQL. Specifically, I got errors like:

"collations with different collate and ctype values are not supported on this platform"

After correcting the collation and successfully creating the database, Odoo booted — but then the logs started showing this warning repeatedly.

WARNING odoo19_demo_01 odoo.addons.base.models.ir_cron: Tried to poll an undefined table on database odoo19_demo_01.

What the Warning Means Odoo uses the ir_cron model to manage automated scheduled actions (background jobs like database cleanup, email scheduling, etc.).

When Odoo starts, it polls the database for pending cron jobs.

This warning means Odoo tried to access a table that doesn’t exist yet — most likely because the database wasn’t fully initialized or the base module wasn’t properly installed.

ROOT CAUSE:

In my case, the issue occurred because the database was created, but Odoo modules were not fully loaded after resolving the collation issue.

The database existed, but its core schema (tables like ir_cron, ir_module_module, etc.) was missing because the initialization didn’t complete correctly.

SOLUTION:

1) Check Whether the table exists in Odoo Database

Open PgAdmin4, Database -> Schema -> Public -> Tables

If No tables available, proceed with the following steps.

2) Reinitialize the Database

Here’s how I fixed it:

Restart Odoo with the initialization flag

odoo-bin -d your_db_name -i base

or, if you’re running Odoo from Windows services, edit the startup parameters to include:

-d your_db_name -i base 

3) Confirm initialization

Check the Odoo logs — you should see lines like:

"INFO odoo.modules.loading: loading 1 modules...

INFO odoo.modules.loading: Module base: creating or updating database tables"

Once the base module is installed, the warning about “undefined table” disappears because ir_cron now exists.

After reinitializing the database correctly, Odoo 19 started cleanly on Windows without any warnings.

If you’re running into the same issue, don’t panic — it’s just Odoo trying to talk to a table that hasn’t been created yet.


Hope it Useful :-) :-) :-)

Start the learning journey along with me.

Suggest me some topics you want to learn and I will learn and write. :-)

Comments

Post a Comment

Popular posts from this blog

How I Solved the PostgreSQL Collation Error While Setup Odoo19 Development Environment on Windows?

If you’ve ever tried Setup Development Environment on a Windows machine for Odoo, you probably know that it can be a little tricky. Recently, I ran into one of those frustrating moments — everything seemed to be going well until I hit a strange PostgreSQL error I’d never seen before. I have followed the documentation for Setup Odoo19 Development Environment on my Windows system. Here’s the story of what happened, what caused it, and how I fixed it. Hopefully, this will save you a few hours of head-scratching! 🚧 The Problem After setting up my environment and trying to start Odoo, I got this error: psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed:  FATAL:  collations with different collate and ctype values are not supported on this platform 1. Check What locale database using Open PgAdmin4, Query tool and execute the following query. select datname, datcollate, datctype from pg_database select * from pg_collation; 2. Drop Problematic Data...
Read more

How to Create a Custom Module in Odoo 19 Using Scaffold Command (Step-by-Step Guide)

Image
How to Create a Custom Module in Odoo 19 Using Scaffold Command (Step-by-Step Guide) If you are starting your journey in Odoo development , one of the first things you must learn is how to create a custom module. In Odoo , every feature is built as a module — whether it’s Sales, Inventory, Accounting, or your own custom functionality. In this tutorial, you will learn: What the scaffold command is in Odoo How to create a custom module in Odoo 19 Understanding the generated folder structure This guide is beginner-friendly and practical. What is the Scaffold Command in Odoo? The scaffold command is a built-in command provided by Odoo that automatically generates the basic folder structure of a new module. Instead of manually creating folders like: models views controllers security Odoo creates everything for you in seconds. This saves time and ensures your module follows Odoo’s development standards. Prerequisites Before Creating a Module Before running the scaffold command, make sure yo...
Read more

Odoo 19 Scaffold Folder Structure Explained: Complete Guide for Developers

Image
Odoo 19 Scaffold Folder Structure Explained: Complete Guide for Developers Introduction When developing a custom module in Odoo 19, the first step is usually running the scaffold command. This automatically generates a ready-to-use module structure. Understanding this folder structure is essential for clean, scalable module development. What is the Scaffold Command in Odoo? The scaffold command is a built-in command provided by Odoo that automatically generates the basic folder structure of a new module. Instead of manually creating folders like: models views controllers security Odoo creates everything for you in seconds. This saves time and ensures your module follows Odoo’s development standards. Generated Folder Structure Your newly created module will look like this: your_module_name/  ├── __init__.py  ├── __manifest__.py  ├── controllers/  ├── models/  ├── views/  ├── security/  └── static/ Now let’s understand each file and folder. 1. init.py ...
Read more