Bug 50816 - EDITING: Pictures in forms not deleted in the *.odb-file when deleted in forms
Summary: EDITING: Pictures in forms not deleted in the *.odb-file when deleted in forms
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Forms
  Show dependency treegraph
 
Reported: 2012-06-07 01:18 UTC by Robert Großkopf
Modified: 2024-04-10 07:17 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
Only one form - you see nothing inside. File over 500kB (531.22 KB, application/vnd.sun.xml.base)
2012-06-07 01:18 UTC, Robert Großkopf
Details
Images from editing forms will all be saved, when switching from editing to input data. (515.38 KB, application/vnd.oasis.opendocument.database)
2024-04-10 07:15 UTC, Robert Großkopf
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2012-06-07 01:18:35 UTC
Created attachment 62697 [details]
Only one form - you see nothing inside. File over 500kB

Create a form in base, load a picture into this form and save the database. The database is as big as the pictures. 
Then reopen the database. Delete the picture in the form. Save the database. The picture isn't seen any longer in the form, but the file is too big for only one form without anything inside.
Have a look at the file with a packing-program. Only with a packing-program you could delete the picture.

Robert
Comment 1 Jochen 2012-08-29 18:41:03 UTC
I can confirm the bug
OS: Windows 7 pro 64 bit
LO 3.5.5
Comment 2 Julien Nabet 2014-11-30 21:35:55 UTC
On pc Debian x86-64 with master sources updated today, I could reproduce this.
(put all since Jochen confirmed on Windows)
Comment 3 Alex Thurgood 2015-01-03 17:39:08 UTC Comment hidden (no-value)
Comment 4 QA Administrators 2016-01-17 20:04:08 UTC Comment hidden (obsolete)
Comment 5 Robert Großkopf 2016-01-29 15:14:06 UTC
Bug still exists with LO 5.1.0.3, OpenSUSE 42.1 Leap, 64bit rpm Linux.
Comment 6 Robert Großkopf 2016-03-06 15:45:20 UTC
Bug appears also in the first available LO-version (LO 3.3.0.4, OpenSUSE 42.1 64bit rpm Linux). So I set this bug as "Inherited From OOo".
Comment 7 QA Administrators 2017-05-22 13:19:02 UTC Comment hidden (obsolete)
Comment 8 Robert Großkopf 2017-05-28 15:51:23 UTC
Bug still exists with LO 5.4.0.0.beta1, OpenSUSE 42.1 Leap, 64bit rpm Linux.

... but the importance is very high:
If you delete a picture, it won't be deleted in the odb-file
AND
the picture will be copied every time you open the form for editing and saving it after you have edited. The file will blow up very fast!!

Another person, who could set the importance higher, must have a look here. I am not allowed to do this. Seems I am only a simple user with 87 open bug-reports ...
Comment 9 Julien Nabet 2017-05-31 16:00:30 UTC
On pc Debian x86-64 with master sources some days ago, I could still reproduce this.

Let's increase importance since:
- it concerns all platform
- not a corner case
- insidious since no error
- data loss/corruption possible

Lionel: I don't know if the root cause is in Base part or other part dealing with image but thought you might have some opinion.

Robert: I don't know who manages rights on LO bugzilla but I suppose this page https://wiki.documentfoundation.org/QA/Team#QA_team_volunteers could help to find some useful contacts.
Comment 10 QA Administrators 2018-06-24 02:41:42 UTC Comment hidden (obsolete)
Comment 11 Drew Jensen 2018-06-24 18:40:37 UTC
Checked with 6.1 Beta 1 under Ubuntu 18.04

The problem persists.

Using the same build and opening a Writer File, add image, save it and the file is 502 K. Re-open it and delete the image, save again, the file is now 8 K.

To be clear the image(s) is(are) left in the Base Form, and ODT file, which when embedded in a Base file does not act the same as a free standing ODT file in this regard.

Using the test file, adding a new image and removing it from the form leaves both images stuck in the ODT form.
Comment 12 QA Administrators 2019-06-25 02:42:29 UTC Comment hidden (obsolete)
Comment 13 Robert Großkopf 2019-06-25 05:40:47 UTC
Bug still exists in LO 6.3.0.0beta1 on OpenSUSE 15 64bit rpm Linux
Comment 14 Julien Nabet 2020-12-13 12:59:42 UTC
On pc Debian x86-64 with master sources updated today, I could still reproduce this.
But after editing and saving it, the file doesn't keep on increasing. Do you still have this too?
Comment 15 Julien Nabet 2020-12-13 13:41:57 UTC
Just for the record, I also tried on Writer:
- brand new file
- save
=> check size of file (= size1)
- enable toolbar forms control
- add an image
- save
=> check size of file (= size2 which is > size1 obviously)
- remove the image
- save
- save
=> check size of file (= size1 again)
Comment 16 Julien Nabet 2020-12-13 13:53:17 UTC
(In reply to Julien Nabet from comment #15)
> Just for the record, I also tried on Writer:
> ...

No news here considering Drew has already told about this 2 years ago with https://bugs.documentfoundation.org/show_bug.cgi?id=50816#c11...
Comment 17 ustrendingnews 2021-05-16 07:32:37 UTC Comment hidden (spam)
Comment 18 rahul kumar 2021-09-11 13:37:46 UTC Comment hidden (spam)
Comment 19 rahul kumar 2021-09-11 13:38:14 UTC Comment hidden (obsolete, spam)
Comment 20 rahul kumar 2021-09-11 13:38:52 UTC Comment hidden (obsolete, spam)
Comment 21 rahul kumar 2021-09-11 13:38:52 UTC Comment hidden (obsolete, spam)
Comment 22 rahul kumar 2021-09-11 13:39:44 UTC Comment hidden (spam)
Comment 23 rahul kumar 2021-09-11 13:40:12 UTC Comment hidden (spam)
Comment 24 rahul kumar 2021-09-11 13:40:28 UTC Comment hidden (spam)
Comment 25 rahul kumar 2021-09-11 13:40:40 UTC Comment hidden (spam)
Comment 26 rahul kumar 2021-09-11 13:40:55 UTC Comment hidden (spam)
Comment 27 rahul kumar 2021-09-11 13:41:08 UTC Comment hidden (spam)
Comment 28 rahul kumar 2021-09-11 13:41:22 UTC Comment hidden (spam)
Comment 29 rahul kumar 2021-09-11 13:41:47 UTC Comment hidden (spam)
Comment 31 Robert Großkopf 2024-04-10 07:07:38 UTC
This one isn't only a problem with images in the form. It will also happen with image controls in a form. When opening a form in design mode, not for input data, and then switch for testing to input data the last image when switching back will be shown in the image control - and will be saved in the form → Folder pictures.

I saw a database file here, which blows up to more than 50 MB, but no image saved in the database, all fields will only save a link. 
All this images could be found in the form folder of the compressed file. No chance to delete them by GUI. Have to use a zip-app to delete.

If someone designs a database for other people and test it with his own pictures all the pictures will be transported with the file - but the person doesn't realize this.
Comment 32 Robert Großkopf 2024-04-10 07:15:37 UTC
Created attachment 193593 [details]
Images from editing forms will all be saved, when switching from editing to input data.

File with more than 500kB.
Open the file.
Open the form. 
You won't see any image, because there are only saved paths.
Close the form.
Open the form for editing.
No image will be shown.
Switch for testing design view off.
Add an image to the first data row.
Switch design view on.
Image will be shown in image control.
Save form, save Base file.
Do the same with different images in first row.
Base file will get bigger and bigger.
Now try to delete the image, which has been saved in design view. 
Base file won't get smaller.
Open the Base file with a packing program: All your pictures will be saved in the form.