Error Can't Import Web Pages (Theres a Bug)

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Project
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

Error Can't Import Web Pages (Theres a Bug)

error import webpage

1 Odpowiedz

1278 Widoki

Johnny Solas

I tried to import some webpages data via this "Import File" in Website Module and the data came from exporting some webpages data from another odoo project. I followed this tutorial on how to do it "https://youtu.be/H2fXRXoSZiI" . Note I'm currently working in Odoo 18.

However I got this error " Missing required value for the field 'Page URL' (url) ".

I have done something to solve this problem

I tried to import the data without editing the data to be imported, got that error
tried to change the format of import file from XLSX to CSV, got that error
tried to change the header label to "Page/Page URL", "Page URL", "URL", and "url" got that error
already check the file if urls are missing, but there is a data
tried to remove "/", got that error

I'm already out of solutions to try. Please help me solve this problem. Thank you in advance.

Johnny Solas

Autor

I look more info in the logs and i found this

ERROR odoo_project odoo.sql_db: bad query: b'INSERT INTO "website_page" ("create_date", "create_uid", "footer_visible", "header_visible", "is_published", "view_id", "website_indexed", "write_date", "write_uid") VALUES (\'2025-02-15 13:41:59.952944\', 2, true, true, false, 1686, true, \'2025-02-15 13:41:59.952944\', 2) RETURNING "id"'

ERROR: null value in column "url" of relation "website_page" violates not-null constraint

DETAIL:  Failing row contains (380, null, 1686, 2, 2, null, null, null, null, f, t, null, null, t, t, null, 2025-02-15 13:41:59.952944, 2025-02-15 13:41:59.952944).

Apparently the column "url" was not in that insert query in which it lead to this problem. The page i was about to add has url of "/practice", but i could not see "/practice" as part in the query. With this i can say that this might be a bug.

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Importing Web Pages Seems Impossible Rozwiązane error import webpage	2 lip 25	1291
Odoo12 babel error Rozwiązane error import	1 lis 19	6684
Bug following a contact import : column res_partner_bank.active doesn't exist error import	1 mar 15	5253
error in installing only-office module error import bug	0 mar 25	1082
Chatbot Integration Error error webpage chatbot	0 sty 24	1893

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!