← Back to team overview

openerp-india team mailing list archive

[Bug 923793] Re: [6.1.trunk] Error when creating new database ir_module_module_certificate_uniq

 

While initializing the db modules with certificates == str'' manage to
get loaded in the db

here is a patch to revno 4228 in  branch 6.1


** Patch added: "prevent empty-string certificates to get into the db"
   https://bugs.launchpad.net/openobject-server/+bug/923793/+attachment/3212565/+files/bug923793_branch-6.1_revno4228.patch

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/923793

Title:
  [6.1.trunk] Error when creating new database
  ir_module_module_certificate_uniq

Status in OpenERP Server:
  Confirmed

Bug description:
  Server's log displays:

  [2012-01-30 15:31:38,392][?] INFO:werkzeug:80.14.194.230 - - [30/Jan/2012 15:31:38] "POST /web/database/progress HTTP/1.1" 200 -
  [2012-01-30 15:31:38,765][lun_30_01_2012] ERROR:db.cursor:bad query: ALTER TABLE "ir_module_module" ADD CONSTRAINT "ir_module_module_certificate_uniq" UNIQUE (certificate)
  Traceback (most recent call last):
    File "/home/decindus/private/tools/openerp-trunk/server/openerp/sql_db.py", line 214, in execute
      res = self._obj.execute(query, params)
  IntegrityError: could not create unique index "ir_module_module_certificate_uniq"
  DÉTAIL : Table contains duplicated values.

  [2012-01-30 15:31:38,766][lun_30_01_2012] WARNING:orm.schema:Table 'ir_module_module': unable to add 'UNIQUE (certificate)' constraint !
   If you want to have it, you should update the records and execute manually:
  ALTER TABLE "ir_module_module" ADD CONSTRAINT "ir_module_module_certificate_uniq" UNIQUE (certificate)

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/923793/+subscriptions


References