c2c-oerpscenario team mailing list archive

["Guewen Baconnier @ Camptocamp" <809745@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Hello,

On trunk (same problem in stable 6):
In the document module, in document.py there is a method _attach_parent_id to migrate documents on the installation of the module.

The query :
cr.execute("UPDATE ir_attachment SET file_size=length(db_datas) WHERE file_size = 0;")
will work only for attachments of type "binary", for those one of type "url" it will raise a not null constraint error and block the module installation :
ERROR:  null value in column "file_size" violates not-null constraint
Because length() of an empty column returns null.

To fix, replace the query by:
cr.execute("UPDATE ir_attachment SET file_size=length(db_datas) WHERE file_size = 0 and type = 'binary';")

Thanks
Regards
Guewen

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/809745

Title:
  Document module migration of "url" attachments

Status in OpenERP Modules (addons):
  New

Bug description:
  Hello,

  On trunk (same problem in stable 6):
  In the document module, in document.py there is a method _attach_parent_id to migrate documents on the installation of the module.

  The query :
  cr.execute("UPDATE ir_attachment SET file_size=length(db_datas) WHERE file_size = 0;")
  will work only for attachments of type "binary", for those one of type "url" it will raise a not null constraint error and block the module installation :
  ERROR:  null value in column "file_size" violates not-null constraint
  Because length() of an empty column returns null.

  To fix, replace the query by:
  cr.execute("UPDATE ir_attachment SET file_size=length(db_datas) WHERE file_size = 0 and type = 'binary';")

  Thanks
  Regards
  Guewen

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