Overslaan naar inhoud
Menu
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Deze vraag is gerapporteerd
2 Antwoorden
345 Weergaven

im facing this error , can anyone help me to resolve this error 
sep19_v16 odoo.sql_db: bad query: SELECT "website"."id", "website"."name", "website"."sequence", "website"."domain", "website"."company_id", "website"."default_lang_id", "website"."auto_redirect_lang", "website"."cookies_bar", "website"."configurator_done", "website"."social_twitter", "website"."social_facebook", "website"."social_github", "website"."social_linkedin", "website"."social_youtube", "website"."social_instagram", "website"."social_tiktok", "website"."has_social_default_image", "website"."google_analytics_key", "website"."google_search_console", "website"."google_maps_api_key", "website"."plausible_shared_key", "website"."plausible_site", "website"."user_id", "website"."cdn_activated", "website"."cdn_url", "website"."cdn_filters", "website"."homepage_url", "website"."custom_code_head", "website"."custom_code_footer", "website"."robots_txt", "website"."theme_id", "website"."specific_user_account", "website"."auth_signup_uninvited", "website"."create_uid", "website"."create_date", "website"."write_uid", "website"."write_date", "website"."channel_id" FROM "website" WHERE ("website"."id" IN (1))

ERROR: column website.social_tiktok does not exist

LINE 1: ..."."social_youtube", "website"."social_instagram", "website"....

Avatar
Annuleer
Beste antwoord

Hello,

Please refer https://github.com/OCA/OpenUpgrade

Avatar
Annuleer
Beste antwoord

Hi,

Use the OpenUpgrade project; it has migration scripts for Odoo 16 → 17.It will automatically drop old columns (like social_tiktok) and adapt data where needed.


Steps:

Clone OpenUpgrade for v17.

Run it with your v16 DB dump.

Let the migration scripts update your schema and data.

Launch Odoo 17 with the migrated DB.


Refer: https://github.com/OCA/OpenUpgrade


Hope it helps

Avatar
Annuleer