# odoo12-14 **Repository Path**: anlangzi/odoo12-14 ## Basic Information - **Project Name**: odoo12-14 - **Description**: odoo12 update odoo14 - **Primary Language**: Python - **License**: GPL-3.0 - **Default Branch**: master - **Homepage**: None - **GVP Project**: No ## Statistics - **Stars**: 2 - **Forks**: 2 - **Created**: 2021-11-08 - **Last Updated**: 2024-05-30 ## Categories & Tags **Categories**: Uncategorized **Tags**: Odoo ## README [![Build Status](http://runbot.odoo.com/runbot/badge/flat/1/master.svg)](http://runbot.odoo.com/runbot) [![Tech Doc](http://img.shields.io/badge/master-docs-875A7B.svg?style=flat&colorA=8F8F8F)](http://www.odoo.com/documentation/master) [![Help](http://img.shields.io/badge/master-help-875A7B.svg?style=flat&colorA=8F8F8F)](https://www.odoo.com/forum/help-1) [![Nightly Builds](http://img.shields.io/badge/master-nightly-875A7B.svg?style=flat&colorA=8F8F8F)](http://nightly.odoo.com/) Odoo ---- Odoo is a suite of web based open source business apps. The main Odoo Apps include an Open Source CRM, Website Builder, eCommerce, Warehouse Management, Project Management, Billing & Accounting, Point of Sale, Human Resources, Marketing, Manufacturing, ... Odoo Apps can be used as stand-alone applications, but they also integrate seamlessly so you get a full-featured Open Source ERP when you install several Apps. Getting started with Odoo ------------------------- For a standard installation please follow the Setup instructions from the documentation. To learn the software, we recommend the Odoo eLearning, or Scale-up, the business game. Developers can start with the developer tutorials # odoo12-14 #### 介绍 odoo12 update odoo14 #### 软件架构 软件架构说明 #### 移植步骤 1. 在odoo12生产环境备份数据库 2. 在odoo12开发环境中恢复备份的数据库 3. 在odoo12的开环境卸载企业插件(如需要从企业版移植升级到社区版) web_enterprise web_cohort web_dashboard web_diagram web_gantt web_grid web_mobile web_settings_dashboard #### 恢复数据库 1. 在odoo12-14项目中恢复数据库 ![输入图片说明](https://images.gitee.com/uploads/images/2021/1108/114410_1d83b8a9_482739.png "屏幕截图.png") #### 修复数据库 ``` update ir_module_module set latest_version='14.0.1.3' where name='base'; ALTER TABLE ir_ui_view ADD COLUMN arch_updated boolean; ALTER TABLE ir_ui_view ADD COLUMN arch_prev boolean; ALTER TABLE res_lang ADD COLUMN url_code VARCHAR; ALTER TABLE ir_attachment ADD COLUMN original_id Integer; ALTER TABLE ir_cron ADD COLUMN lastcall timestamp; ALTER TABLE res_partner ADD COLUMN partner_latitude float; ALTER TABLE res_partner ADD COLUMN partner_longitude float; CREATE TABLE ir_act_server_group_rel( act_id Integer, gid Integer ); ALTER TABLE ir_act_window ADD COLUMN binding_view_types VARCHAR; ALTER TABLE res_company ADD COLUMN font VARCHAR; ALTER TABLE res_company ADD COLUMN primary_color VARCHAR; ALTER TABLE res_company ADD COLUMN secondary_color VARCHAR; ALTER TABLE ir_module_module_dependency ADD COLUMN auto_install_required boolean; ALTER TABLE ir_actions ADD COLUMN binding_view_types VARCHAR; delete from res_company_users_rel where user_id not in (select id from res_users); delete from ir_model_fields where model_id not in (select id from ir_model); delete from ir_ui_menu_group_rel where menu_id not in (select id from ir_ui_menu); delete from rule_group_rel where rule_group_id not in (select id from ir_rule); delete from rule_group_rel where group_id not in (select id from res_groups); delete from res_groups_users_rel where uid not in (select id from res_users); delete from res_users_log where create_uid not in (select id from res_users); delete from res_partner_res_users_rel where res_users_id not in (select id from res_users); delete from res_partner_res_users_rel where res_partner_id not in (select id from res_partner); delete from fm_device_fm_rule_trigger_rel where fm_rule_trigger_id not in (select id from fm_rule_trigger); delete from fm_device_fm_rule_trigger_rel where fm_device_id not in (select id from fm_device); delete from fm_gateway_scene_fm_rule_action_rel where fm_rule_action_id not in (select id from fm_rule_action); delete from fm_device_fm_rule_action_rel where fm_rule_action_id not in (select id from fm_rule_action); delete from fm_ai_subsystem_fm_device_rel where fm_ai_subsystem_id not in (select id from fm_ai_subsystem); delete from fm_ai_subsystem_fm_device_rel where fm_device_id not in (select id from fm_device); delete from fm_device_category_fm_nursing_rel where fm_nursing_id not in (select id from fm_nursing); delete from fm_device_fm_nursing_bed_rel where fm_nursing_bed_id not in (select id from fm_nursing_bed); delete from fm_device_fm_nursing_bed_rel where fm_device_id not in (select id from fm_device); update res_lang set url_code=iso_code; ``` #### 升级数据库 1. 以管理员身份进入系统,在应用中升级base #### 修复翻译语言 1. 保留这两种语言,其余的全部删掉 ![输入图片说明](https://images.gitee.com/uploads/images/2021/1108/114616_0f5a4227_482739.png "屏幕截图.png") 2. 重新升级base,将odoo14语言包修复。 #### 备份数据库 1. 备份数据库 #### 手动升级 1. 升级需要手动安装模块 base_setup,auth_signup,auth_totp web_unsplash #### 参与贡献 1. Fork 本仓库 2. 新建 Feat_xxx 分支 3. 提交代码 4. 新建 Pull Request #### 特技 1. 使用 Readme\_XXX.md 来支持不同的语言,例如 Readme\_en.md, Readme\_zh.md 2. Gitee 官方博客 [blog.gitee.com](https://blog.gitee.com) 3. 你可以 [https://gitee.com/explore](https://gitee.com/explore) 这个地址来了解 Gitee 上的优秀开源项目 4. [GVP](https://gitee.com/gvp) 全称是 Gitee 最有价值开源项目,是综合评定出的优秀开源项目 5. Gitee 官方提供的使用手册 [https://gitee.com/help](https://gitee.com/help) 6. Gitee 封面人物是一档用来展示 Gitee 会员风采的栏目 [https://gitee.com/gitee-stars/](https://gitee.com/gitee-stars/) >>>>>>> 3969dc0239701ed1f6b67f0724ba054ba50e7e50