c2c-oerpscenario team mailing list archive

Thread
Date
[Bug 663246] Re: Cant' create db because to many missing fields on module base

To: c2c-oerpscenario@xxxxxxxxxxxxxxxxxxx
From: Mario César Señoranis <mariocesar.c50@xxxxxxxxx>
Date: Tue, 19 Oct 2010 19:29:43 -0000
Reply-to: Bug 663246 <663246@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Thank you,

It still doesn't update the module, When I try to create a database, it
raises as I say:

-------------------------------

[2010-10-19 15:26:41,601][template1] INFO:web-services:CREATE DATABASE: test1
[2010-10-19 15:26:44,487][test1] ERROR:db.cursor:Programming error: no existe la columna «web» en la relación «ir_module_module»
LÍNEA 1: ...                 category_id, state, certificate, web)      ...
                                                              ^
, in query insert into ir_module_module                 (id, author, website, name, shortdesc, description,                     category_id, state, certificate, web)                 values (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
[2010-10-19 15:26:44,489][test1] ERROR:web-services:[01]: CREATE DATABASE
[2010-10-19 15:26:44,490][test1] ERROR:web-services:[02]: Traceback (most recent call last):
[2010-10-19 15:26:44,490][test1] ERROR:web-services:[03]:   File "/home/openerp/openerp-server-6.0.0-rc1/bin/service/web_services.py", line 94, in __call__
[2010-10-19 15:26:44,490][test1] ERROR:web-services:[04]:     tools.init_db(cr)
[2010-10-19 15:26:44,490][test1] ERROR:web-services:[05]:   File "/home/openerp/openerp-server-6.0.0-rc1/bin/tools/misc.py", line 118, in init_db
[2010-10-19 15:26:44,491][test1] ERROR:web-services:[06]:     info.get('web') or False))
[2010-10-19 15:26:44,491][test1] ERROR:web-services:[07]:   File "/home/openerp/openerp-server-6.0.0-rc1/bin/sql_db.py", line 75, in wrapper
[2010-10-19 15:26:44,491][test1] ERROR:web-services:[08]:     return f(self, *args, **kwargs)
[2010-10-19 15:26:44,492][test1] ERROR:web-services:[09]:   File "/home/openerp/openerp-server-6.0.0-rc1/bin/sql_db.py", line 122, in execute
[2010-10-19 15:26:44,492][test1] ERROR:web-services:[10]:     res = self._obj.execute(query, params)
[2010-10-19 15:26:44,492][test1] ERROR:web-services:[11]: ProgrammingError: no existe la columna «web» en la relación «ir_module_module»
[2010-10-19 15:26:44,493][test1] ERROR:web-services:[12]: LÍNEA 1: ...                 category_id, state, certificate, web)      ...
[2010-10-19 15:26:44,493][test1] ERROR:web-services:[13]:                                                               ^

--------------------------------
Trying to update the base module, do not fix the problem
--------------------------------


$ ./openerp-server.py -d test1 -u base
[2010-10-19 15:27:11,286][?] INFO:server:OpenERP version - 6.0.0-rc1
[2010-10-19 15:27:11,287][?] INFO:server:addons_path - /home/openerp/server/bin/addons
[2010-10-19 15:27:11,287][?] INFO:server:database hostname - localhost
[2010-10-19 15:27:11,287][?] INFO:server:database port - 5432
[2010-10-19 15:27:11,287][?] INFO:server:database user - openerp
[2010-10-19 15:27:11,287][?] INFO:server:initialising distributed objects services
[2010-10-19 15:27:11,519][?] INFO:web-services:starting HTTP service at 0.0.0.0 port 8069
[2010-10-19 15:27:11,520][?] INFO:web-services:starting HTTPS service at 0.0.0.0 port 8071
[2010-10-19 15:27:11,520][?] INFO:web-services:Registered XML-RPC over HTTP
[2010-10-19 15:27:11,521][?] INFO:web-services:starting NET-RPC service at 0.0.0.0 port 8070
[2010-10-19 15:27:11,626][test1] INFO:init:module base: loading objects
[2010-10-19 15:27:11,627][test1] INFO:init:module base: registering objects
[2010-10-19 15:27:11,700][test1] INFO:init:module base: creating or updating database tables
[2010-10-19 15:27:16,077][test1] ERROR:db.cursor:Programming error: no existe la columna «selectable» en la relación «ir_model_fields»
LÍNEA 3: ...ect_level=E'True', readonly=false ,required=true, selectable...
                                                              ^
, in query UPDATE ir_model_fields SET
                            model_id=%s, field_description=%s, ttype=%s, relation=%s,
                            view_load=%s, select_level=%s, readonly=%s ,required=%s, selectable=%s, relation_field=%s
                        WHERE
                            model=%s AND name=%s
Traceback (most recent call last):
  File "./openerp-server.py", line 121, in <module>
    db,pool = pooler.get_db_and_pool(dbname, update_module=tools.config['init'] or tools.config['update'], pooljobs=False)
  File "/home/openerp/openerp-server-6.0.0-rc1/bin/pooler.py", line 39, in get_db_and_pool
    addons.load_modules(db, force_demo, status, update_module)
  File "/home/openerp/openerp-server-6.0.0-rc1/bin/addons/__init__.py", line 809, in load_modules
    has_updates = load_module_graph(cr, graph, status, perform_checks=(not update_module), report=report)
  File "/home/openerp/openerp-server-6.0.0-rc1/bin/addons/__init__.py", line 700, in load_module_graph
    init_module_objects(cr, package.name, modules)
  File "/home/openerp/openerp-server-6.0.0-rc1/bin/addons/__init__.py", line 404, in init_module_objects
    result = obj._auto_init(cr, {'module': module_name})
  File "/home/openerp/openerp-server-6.0.0-rc1/bin/osv/orm.py", line 2390, in _auto_init
    self._field_create(cr, context=context)
  File "/home/openerp/openerp-server-6.0.0-rc1/bin/osv/orm.py", line 485, in _field_create
    vals['select_level'], bool(vals['readonly']), bool(vals['required']), bool(vals['selectable']), vals['relation_field'], vals['model'], vals['name']
  File "/home/openerp/openerp-server-6.0.0-rc1/bin/sql_db.py", line 75, in wrapper
    return f(self, *args, **kwargs)
  File "/home/openerp/openerp-server-6.0.0-rc1/bin/sql_db.py", line 122, in execute
    res = self._obj.execute(query, params)
psycopg2.ProgrammingError: no existe la columna «selectable» en la relación «ir_model_fields»
LÍNEA 3: ...ect_level=E'True', readonly=false ,required=true, selectable...
                                                              ^

-- 
Cant' create db because to many missing fields on module base
https://bugs.launchpad.net/bugs/663246
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP OpenObject.

Status in OpenObject Server: Invalid

Bug description:
With the 6.0 rc1 there are fields that are missing when creating the db.

------------------

[2010-10-19 08:38:40,660][test8] ERROR:db.cursor:Programming error: no existe la columna «web» en la relación «ir_module_module»
LÍNEA 1: ...                 category_id, state, certificate, web)      ...
                                                              ^
, in query insert into ir_module_module                 (id, author, website, name, shortdesc, description,                     category_id, state, certificate, web)                 values (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
[2010-10-19 08:38:40,661][test8] ERROR:web-services:[01]: CREATE DATABASE
[2010-10-19 08:38:40,661][test8] ERROR:web-services:[02]: Traceback (most recent call last):
[2010-10-19 08:38:40,662][test8] ERROR:web-services:[03]:   File "/home/openerp/openerp-server-6.0.0-rc1/bin/service/web_services.py", line 94, in __call__
[2010-10-19 08:38:40,662][test8] ERROR:web-services:[04]:     tools.init_db(cr)
[2010-10-19 08:38:40,662][test8] ERROR:web-services:[05]:   File "/home/openerp/openerp-server-6.0.0-rc1/bin/tools/misc.py", line 118, in init_db
[2010-10-19 08:38:40,662][test8] ERROR:web-services:[06]:     info.get('web', False))
[2010-10-19 08:38:40,662][test8] ERROR:web-services:[07]:   File "/home/openerp/openerp-server-6.0.0-rc1/bin/sql_db.py", line 75, in wrapper
[2010-10-19 08:38:40,662][test8] ERROR:web-services:[08]:     return f(self, *args, **kwargs)
[2010-10-19 08:38:40,663][test8] ERROR:web-services:[09]:   File "/home/openerp/openerp-server-6.0.0-rc1/bin/sql_db.py", line 122, in execute
[2010-10-19 08:38:40,663][test8] ERROR:web-services:[10]:     res = self._obj.execute(query, params)
[2010-10-19 08:38:40,663][test8] ERROR:web-services:[11]: ProgrammingError: no existe la columna «web» en la relación «ir_module_module»
[2010-10-19 08:38:40,663][test8] ERROR:web-services:[12]: LÍNEA 1: ...                 category_id, state, certificate, web)      ...
[2010-10-19 08:38:40,663][test8] ERROR:web-services:[13]:

------------------

Trying to do a workaround, I manually create the missing 'web' boolean field, but raises another missing field

------------------

[2010-10-19 08:43:44,049][test9] ERROR:db.cursor:Programming error: no existe la columna «selectable» en la relación «ir_model_fields»
LÍNEA 3: ...ect_level=E'True', readonly=false ,required=true, selectable...
                                                              ^
, in query UPDATE ir_model_fields SET
                            model_id=%s, field_description=%s, ttype=%s, relation=%s,
                            view_load=%s, select_level=%s, readonly=%s ,required=%s, selectable=%s, relation_field=%s
                        WHERE
                            model=%s AND name=%s
[2010-10-19 08:43:44,051][test9] ERROR:web-services:[01]: CREATE DATABASE
[2010-10-19 08:43:44,051][test9] ERROR:web-services:[02]: Traceback (most recent call last):
[2010-10-19 08:43:44,051][test9] ERROR:web-services:[03]:   File "/home/openerp/openerp-server-6.0.0-rc1/bin/service/web_services.py", line 99, in __call__
[2010-10-19 08:43:44,052][test9] ERROR:web-services:[04]:     update_module=True)[1]
[2010-10-19 08:43:44,052][test9] ERROR:web-services:[05]:   File "/home/openerp/openerp-server-6.0.0-rc1/bin/pooler.py", line 60, in restart_pool
[2010-10-19 08:43:44,052][test9] ERROR:web-services:[06]:     return get_db_and_pool(db_name, force_demo, status, update_module=update_module)
[2010-10-19 08:43:44,053][test9] ERROR:web-services:[07]:   File "/home/openerp/openerp-server-6.0.0-rc1/bin/pooler.py", line 39, in get_db_and_pool
[2010-10-19 08:43:44,053][test9] ERROR:web-services:[08]:     addons.load_modules(db, force_demo, status, update_module)
[2010-10-19 08:43:44,053][test9] ERROR:web-services:[09]:   File "/home/openerp/openerp-server-6.0.0-rc1/bin/addons/__init__.py", line 809, in load_modules
[2010-10-19 08:43:44,054][test9] ERROR:web-services:[10]:     has_updates = load_module_graph(cr, graph, status, perform_checks=(not update_module), report=report)
[2010-10-19 08:43:44,054][test9] ERROR:web-services:[11]:   File "/home/openerp/openerp-server-6.0.0-rc1/bin/addons/__init__.py", line 700, in load_module_graph
[2010-10-19 08:43:44,054][test9] ERROR:web-services:[12]:     init_module_objects(cr, package.name, modules)
[2010-10-19 08:43:44,055][test9] ERROR:web-services:[13]:   File "/home/openerp/openerp-server-6.0.0-rc1/bin/addons/__init__.py", line 404, in init_module_objects
[2010-10-19 08:43:44,055][test9] ERROR:web-services:[14]:     result = obj._auto_init(cr, {'module': module_name})
[2010-10-19 08:43:44,055][test9] ERROR:web-services:[15]:   File "/home/openerp/openerp-server-6.0.0-rc1/bin/osv/orm.py", line 2390, in _auto_init
[2010-10-19 08:43:44,056][test9] ERROR:web-services:[16]:     self._field_create(cr, context=context)
[2010-10-19 08:43:44,056][test9] ERROR:web-services:[17]:   File "/home/openerp/openerp-server-6.0.0-rc1/bin/osv/orm.py", line 485, in _field_create
[2010-10-19 08:43:44,056][test9] ERROR:web-services:[18]:     vals['select_level'], bool(vals['readonly']), bool(vals['required']), bool(vals['selectable']), vals['relation_field'], vals['model'], vals['name']
[2010-10-19 08:43:44,056][test9] ERROR:web-services:[19]:   File "/home/openerp/openerp-server-6.0.0-rc1/bin/sql_db.py", line 75, in wrapper
[2010-10-19 08:43:44,057][test9] ERROR:web-services:[20]:     return f(self, *args, **kwargs)
[2010-10-19 08:43:44,057][test9] ERROR:web-services:[21]:   File "/home/openerp/openerp-server-6.0.0-rc1/bin/sql_db.py", line 122, in execute
[2010-10-19 08:43:44,057][test9] ERROR:web-services:[22]:     res = self._obj.execute(query, params)
[2010-10-19 08:43:44,058][test9] ERROR:web-services:[23]: ProgrammingError: no existe la columna «selectable» en la relación «ir_model_fields»
[2010-10-19 08:43:44,058][test9] ERROR:web-services:[24]: LÍNEA 3: ...ect_level=E'True', readonly=false ,required=true, selectable...
[2010-10-19 08:43:44,059][test9] ERROR:web-services:[25]:
References

[Bug 663246] [NEW] Cant' create db because to many missing fields on module base
From: Mario César Señoranis, 2010-10-19