From 0c7219eac4e1bc136fc5351eaa38aa356364dd19 Mon Sep 17 00:00:00 2001 From: Ivan Yelizariev Date: Mon, 28 Dec 2020 10:39:13 +0000 Subject: [FIX] base_data.sql: remove obsolete field size those field sizes were deleted from orm definition in 2014 https://github.com/odoo/odoo/commit/026e38b48f3963aed08bba4e76a0a796d662f6a4 STEPS: * set manifest's summary attribute to a long string * create empty database BEFORE: error ``` 2020-12-28 10:44:51,325 1 ERROR ? odoo.sql_db: bad query: UPDATE ir_module_module SET state='installed' WHERE state IN ('to remove', 'to upgrade') ERROR: relation "ir_module_module" does not exist LINE 1: UPDATE ir_module_module SET state='installed' WHERE state IN... ^ 2020-12-28 10:44:51,325 1 ERROR ? odoo.modules.registry: Failed to load registry Traceback (most recent call last): File "/opt/odoo/custom/src/odoo/odoo/modules/registry.py", line 86, in new odoo.modules.load_modules(registry._db, force_demo, status, update_module) File "/opt/odoo/custom/src/odoo/odoo/modules/loading.py", line 338, in load_modules odoo.modules.db.initialize(cr) File "/opt/odoo/custom/src/odoo/odoo/modules/db.py", line 63, in initialize info['sequence'], info['summary'])) File "/opt/odoo/custom/src/odoo/odoo/sql_db.py", line 173, in wrapper return f(self, *args, **kwargs) File "/opt/odoo/custom/src/odoo/odoo/sql_db.py", line 250, in execute res = self._obj.execute(query, params) psycopg2.DataError: value too long for type character varying(256) During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/opt/odoo/custom/src/odoo/odoo/modules/registry.py", line 88, in new odoo.modules.reset_modules_state(db_name) File "/opt/odoo/custom/src/odoo/odoo/modules/loading.py", line 558, in reset_modules_state "UPDATE ir_module_module SET state='installed' WHERE state IN ('to remove', 'to upgrade')" File "/opt/odoo/custom/src/odoo/odoo/sql_db.py", line 173, in wrapper return f(self, *args, **kwargs) File "/opt/odoo/custom/src/odoo/odoo/sql_db.py", line 250, in execute res = self._obj.execute(query, params) psycopg2.ProgrammingError: relation "ir_module_module" does not exist LINE 1: UPDATE ir_module_module SET state='installed' WHERE state IN... ``` AFTER: database successfully created --- opw-2415057 closes odoo/odoo#63907 X-original-commit: 2a44e233deffd17460e0e9a8f8225602a28c24a6 Signed-off-by: Ivan Yelizariev // IEL --- odoo/addons/base/data/base_data.sql | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) (limited to 'odoo/addons/base/data/base_data.sql') diff --git a/odoo/addons/base/data/base_data.sql b/odoo/addons/base/data/base_data.sql index 837c5635a7c..2e295332db3 100644 --- a/odoo/addons/base/data/base_data.sql +++ b/odoo/addons/base/data/base_data.sql @@ -38,7 +38,7 @@ CREATE TABLE ir_module_category ( write_date timestamp without time zone, write_uid integer, -- references res_users on delete set null, parent_id integer REFERENCES ir_module_category ON DELETE SET NULL, - name character varying(128) NOT NULL, + name character varying NOT NULL, primary key(id) ); @@ -48,14 +48,14 @@ CREATE TABLE ir_module_module ( create_date timestamp without time zone, write_date timestamp without time zone, write_uid integer, -- references res_users on delete set null, - website character varying(256), - summary character varying(256), - name character varying(128) NOT NULL, + website character varying, + summary character varying, + name character varying NOT NULL, author character varying, icon varchar, state character varying(16), - latest_version character varying(64), - shortdesc character varying(256), + latest_version character varying, + shortdesc character varying, category_id integer REFERENCES ir_module_category ON DELETE SET NULL, description text, application boolean default False, @@ -75,7 +75,7 @@ CREATE TABLE ir_module_module_dependency ( create_date timestamp without time zone, write_date timestamp without time zone, write_uid integer, -- references res_users on delete set null, - name character varying(128), + name character varying, module_id integer REFERENCES ir_module_module ON DELETE cascade, auto_install_required boolean DEFAULT true, primary key(id) -- cgit v1.2.3