跳至內容
選單
此問題已被標幟
774 瀏覽次數
I am trying to migrate a database from odoo.sh 14 to a local entrepite14 but every time I do it I get a compatibility error and it generates an error when entering, when I check the database it creates an empty database, try to restore the database directly in potgrest and it doesn't work either, it has errors in keys and references, I don't know what to do and I would really like your help, I download the backup directly from odoo.sh14 where the project is, I would appreciate your response.
I use potgrests version 12, entrepite 14 local, odoo, sh 14, windows 10 and visual studio code

When I add restoration from odoo I get this error

"2023-09-12 05:18:34,994 17696 WARNING ? odoo.addonsbase.models.ir_cron: Tried to poll an undefined table on database entrepite14_ipmConsulting. 

2023-09-12 05:19:30,741 17696 ERROR entrepite14_ipmConsulting odoo.sql_db: bad query: SELECT latest_version FROM ir_module_module WHERE name='base'

ERROR: no existe la relación «ir_module_module»

LINE 1: SELECT latest_version FROM ir_module_module WHERE name='base...

^"

When I do it from postgresql with this command psql -U postgres -d entrepite14_ipm -f "C:\Users\HomeBachue\Downloads\camiloapi-ipmconsulting-main-1968382_2023-09-12_052206_test_nofs\dump.sql"


I get these errors

psql:C:/Users/HomeBachue/Downloads/camiloapi-ipmconsulting-main-1968382_2023-09-12_052206_test_nofs/dump.sql:2033786: erro

r: invalid command \N

psql:C:/Users/HomeBachue/Downloads/camiloapi-ipmconsulting-main-1968382_2023-09-12_052206_test_nofs/dump.sql:2033787: erro

r: invalid command \N

psql:C:/Users/HomeBachue/Downloads/camiloapi-ipmconsulting-main-1968382_2023-09-12_052206_test_nofs/dump.sql:2033788: erro

r: invalid command \N

Tuples only is on.

Tuples only is off.

Tuples only is on.

psql:C:/Users/HomeBachue/Downloads/camiloapi-ipmconsulting-main-1968382_2023-09-12_052206_test_nofs/dump.sql:2033789: erro

r: unrecognized value "10" for "tuples_only": Boolean expected

psql:C:/Users/HomeBachue/Downloads/camiloapi-ipmconsulting-main-1968382_2023-09-12_052206_test_nofs/dump.sql:2033790: erro

r: invalid command \N

頭像
捨棄

could you update the post with the error details