跳至內容
選單
此問題已被標幟
1 回覆
1624 瀏覽次數

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


頭像
捨棄
最佳答案

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;

頭像
捨棄
相關帖文 回覆 瀏覽次數 活動
1
7月 24
1794
1
11月 24
964
1
11月 24
1824
0
8月 24
1123
0
8月 24
1662