[6.1.trunk] Error when creating new database ir_module_module_certificate_uniq

[Yann Papouin]

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)

[Jignesh Rathod(OpenERP) (jir-openerp)]

Hello Yann Papouin ,

I have checked this issue with trunk
and I think this problem occurs due to the
uncertified module in your addons branch.
So would you please check it again.

Thanks and waiting for reply!

[Yann Papouin (yann-papouin)]

I will check this, it would be nice if the error message could report both module names

[D. Hille (dhille)]

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