[6.0] error with tips

Bug #626720 reported by Eric Caudal - www.elico-corp.com
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Odoo Server (MOVED TO GITHUB)
Fix Released
Undecided
Unassigned

Bug Description

Just update server with revision 2657 and cannot enter anymore in the database due to the following error:
Environment Information :
System : Linux-2.6.32-24-generic-i686-with-Ubuntu-10.04-lucid
OS Name : posix
Distributor ID: Ubuntu
Description: Ubuntu 10.04.1 LTS
Release: 10.04
Codename: lucid
Operating System Release : 2.6.32-24-generic
Operating System Version : #41-Ubuntu SMP Thu Aug 19 01:12:52 UTC 2010
Operating System Architecture : 32bit
Operating System Locale : fr_FR.UTF8
Python Version : 2.6.5
OpenERP-Client Version : 6.0dev
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/netsvc.py", line 431, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/service/web_services.py", line 589, in dispatch
    res = fn(db, uid, *params)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/osv/osv.py", line 57, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/osv/osv.py", line 135, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/osv/osv.py", line 125, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/addons/base/res/res_user.py", line 413, in context_get
    res = getattr(user,k) or False
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/osv/orm.py", line 275, in __getattr__
    return self[name]
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/osv/orm.py", line 200, in __getitem__
    field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/addons/base/res/res_user.py", line 273, in read
    result = super(users, self).read(cr, uid, ids, fields, context, load)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/osv/orm.py", line 2803, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/osv/orm.py", line 2880, in _read_flat
    cr.execute(query, (tuple(sub_ids),))
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/sql_db.py", line 74, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/sql_db.py", line 123, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column res_users.menu_tips does not exist
LINE 1: ..._section_id,res_users.active,res_users.context_tz,res_users....
                                                             ^

So I launch the server with update⁼all and then I get this error in my output:

[2010-08-30 17:57:12,024] ERROR:db.cursor:bad query: insert into "res_groups" (id,"name",create_uid,create_date) values (38,E'Human Resources / Manager',1,now())
Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/sql_db.py", line 123, in execute
    res = self._obj.execute(query, params)
IntegrityError: duplicate key value violates unique constraint "res_groups_name_uniq"

[2010-08-30 17:57:12,025] ERROR:init:[01]: <record id="base.group_hr_manager" model="res.groups">
[2010-08-30 17:57:12,025] ERROR:init:[02]: <field name="name">Human Resources / Manager</field>
[2010-08-30 17:57:12,025] ERROR:init:[03]: </record>

Then I delete the duplicate value already existing in the database. Then got the following error:

[2010-08-30 18:00:53,385] ERROR:db.cursor:bad query: insert into "res_groups" (id,"name",create_uid,create_date) values (40,E'Human Resources / User',1,now())
Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/sql_db.py", line 123, in execute
    res = self._obj.execute(query, params)
IntegrityError: duplicate key value violates unique constraint "res_groups_name_uniq"

[2010-08-30 18:00:53,385] ERROR:init:[01]: <record id="base.group_hr_user" model="res.groups">
[2010-08-30 18:00:53,386] ERROR:init:[02]: <field name="name">Human Resources / User</field>
[2010-08-30 18:00:53,386] ERROR:init:[03]: </record>

Again deleted and then I got this final message:
[2010-08-30 18:02:52,288] INFO:init:module mrp: loading mrp_view.xml
[2010-08-30 18:02:52,350] ERROR:init:<menuitem id="menu_mrp_manufacturing" name="Manufacturing" parent="base.menu_mrp_root" sequence="1"/>

In the meantime, the client said: Please double-check the database name or contact your administrator to verify the database status....

Revision history for this message
Eric Caudal - www.elico-corp.com (elicoidal) wrote :

and finally another error:

[2010-08-30 18:07:35,608] INFO:init:module crm: loading crm_view.xml
[2010-08-30 18:07:35,824] ERROR:init:<menuitem action="crm_segmentation_tree-act" id="menu_crm_segmentation-act" groups="base.group_extended" sequence="2" parent="base.menu_base_action_rule"/>

Will recreate a database...

Revision history for this message
Jay Vora (Serpent Consulting Services) (jayvora) wrote :

This has been fixed by immediate revisions.
Creating a new database will do.
Thanks.

affects: openobject-addons → openobject-server
Changed in openobject-server:
status: New → Fix Released
milestone: none → 6.0
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.