Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
1 Odpowiedz
1731 Widoki

I am trying to migrate Odoo 16 community to Odoo 17 community and I am having problem, even though Odoo16 database only includes default warehouse module I installed, no custom module.


  1. Config Run/Debug
-c
odoo.conf
--database=test16_17
--update
all
--stop-after-init


 2. odoo.conf file

[options]
addons_path = d:\study\python_code\odoo_17\server\odoo\addons,D:\Study\python_code\odoo_17\server\OpenUpgrade-17.0
server_wide_modules = base,web,openupgrade_framework
upgrade_path = D:\Study\python_code\odoo_17\server\OpenUpgrade-17.0\openupgrade_scripts\scripts\

3. Error

psycopg2.errors.UndefinedColumn: column res_company.alias_domain_id does not exist
LINE 1: SELECT "res_company"."id", "res_company"."alias_domain_id" F...


I searched and found that in the source code of Odoo16 there is no field "alias_domain_id" but in Odoo17 there is


Awatar
Odrzuć
Najlepsza odpowiedź

Hi,

Manually adding the missing column can fix the issue if the migration script for the alias_domain_id column hasn’t run. To do this, open your PostgreSQL database using the psql command line tool. After connecting to the right database, run this command to add the missing column:


Hope it helps


ALTER TABLE res_company ADD COLUMN alias_domain_id INTEGER;

Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
1
lip 24
1872
1
lis 24
1031
1
lis 24
1933
0
sie 24
1166
0
sie 24
1753