Hello, - Create a new database with demo data - Open a customer - Go to attachments and create a new one : * Name: as you want * Type: URL * Url: as you want - Go to Modules - Install the "document" module
Thanks -- 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): Incomplete 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 _______________________________________________ Mailing list: https://launchpad.net/~c2c-oerpscenario Post to : [email protected] Unsubscribe : https://launchpad.net/~c2c-oerpscenario More help : https://help.launchpad.net/ListHelp
