"Document" installation delete all previous attachments...

[Nicolas DS]

Hi, I am using latest 5.0 (stable) version (branch)

Instead of storing attachment in DB, the "document" module store them on disk.
But when installing this module you will lose ALL previous attachments.

Indeed, this module replace "datas" binary field, by a function field. So all data are deleted from DB without warning.

This is a big issue with this module. The user must be warned before installing the module.

One simple solution: change the module description with a warning.

[Jay Vora (Serpent Consulting Services) (jayvora)]

Hello,

Please describe the problem in steps to reproduce.

Installing document modules removes ir.attachment entires?

No this is not the case at our end.

Kindly check and let us know.

Thank you.

[Jay Vora (Serpent Consulting Services) (jayvora)]

OOPS, sorry for mis-posting.

This was a confirmed error.

[Xavier (Open ERP) (xmo-deactivatedaccount)]

Do users really read that kind of warnings? Isn't there a way for document to serialize all attachments to disk before altering the DB field, to make the migration/installation transparent?

(though that begs the question of how to handle the uninstallation)

[Nicolas DS (zyphos)]

I was thinking the same thing. (Serialization) The best approach should be to re-inject all data from old definition of an object through the new definition of this object.

[Richard (John) Nopkins@Servosoft (richard-nopkins)]

any updates?

[Jan Verlaan (jan-verlaan)]

Milestone 5.2 for the total solution to fix this bug.
Milestone 5.0.7 to add at least a warning into the description of the module.

[Jan Verlaan (jan-verlaan)]

Harry, can you add a line into the description before releasing 5.0.7:
ATTENTION: When you install this module in a running company that have already PDF files stored into the database, you will lose them all. After installing this module PDF's are not longer stored into the database, but in the servers rootpad like /server/bin/filestore.

Then it can be removed when your total solution will be delivered and a convert of PDF from database to filestore is done.
Thanks in advance.

[Raphaël Valyi - http://www.akretion.com (rvalyi)]

Hello, I temporary switch the issue to 5.0.7 as per Jan request until his warning is included (not a regression but easy thing to do and very mission critical). After that we will switch it back to 5.2 milestone for a longer term solution.

[Raphaël Valyi - http://www.akretion.com (rvalyi)]

Hello, any reason why you don't add the proposed warning message in the module? Do you agree with that?

[Harry (OpenERP) (hmo-tinyerp)]

Sorry for late. I'm agree with put warning message in stable. and I have fixed it in stable. We will resolve that problem in 5.2.

Thanks

[Harry (OpenERP) (hmo-tinyerp)]

this problem is fixed in my branch :
lp:~hmo-tinyerp/openobject-addons/p_christeas_addons/

[Raphaël Valyi - http://www.akretion.com (rvalyi)]

Hello Harry,

thank you for the warning message.

On Thu, Dec 17, 2009 at 12:42 PM, Harry (Open ERP) <email address hidden> wrote:

> this problem is fixed in my branch :
> lp:~hmo-tinyerp/openobject-addons/p_christeas_addons/
>
> --
> "Document" installation delete all previous attachments...
> https://bugs.launchpad.net/bugs/445306
> You received this bug notification because you are subscribed to
> OpenObject Addons.
>
> Status in OpenObject Addons Modules: Confirmed
>
> Bug description:
> Hi, I am using latest 5.0 (stable) version (branch)
>
> Instead of storing attachment in DB, the "document" module store them on
> disk.
> But when installing this module you will lose ALL previous attachments.
>
> Indeed, this module replace "datas" binary field, by a function field. So
> all data are deleted from DB without warning.
>
> This is a big issue with this module. The user must be warned before
> installing the module.
>
> One simple solution: change the module description with a warning.
>
>
>
>
>

[Jay Vora (Serpent Consulting Services) (jayvora)]

It has been fixed in to trunk.
Kindly check it.
Thanks.

[Ferdinand (office-chricar)]

the problem is back in 6.1

IMHO it is not sufficient to just put a warning.
stored pdf for invoices are accounting data which must never be lost.

BTW - IMHO the data are still stored in ir_attachment but the module "does not know" how to open these.