Description: I was updating a series of records by amending a notes field (memo) and inserting an image. After updating around 15 records by stepping through one record as a time, it threw an error S1000 General error java.util.NoSuchElementException in statement [UPDATE "Inventory" SET "Notes" = ?,"Picture" = ? WHERE "ID" = ?] I was unable to save the db (kept getting same error) and as a result lost all my edits. This is the second time this has happened. I am running OSX 10.13.6 on 6.4.7.2. Note I did start off using 7.0 but it crashed and completely wiped out my database, erased over 1500 records! Steps to Reproduce: 1. update a memo field and insert an image 2. right arrow to next record 3. repeat update of approx 15 records Actual Results: dialog with error mentioned above. Note is does not happen every time Expected Results: should have updated the record Reproducible: Sometimes User Profile Reset: No Additional Info: Version: 6.4.7.2 Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5 CPU threads: 8; OS: Mac OS X 10.13.6; UI render: default; VCL: osx; Locale: en-GB (en_GB.UTF-8); UI-Language: en-US Calc: threaded
6.4 branch is EOL, you can give a try at LO 7.0.4
I started out using 7.0 and imported 1500 records. I was adding the images from file when LO crashed and completely wiped out the entire db, zero records left. I then switched to 6.4 as I assumed it would be more stable. After doing some research online, I've actually abandoned storing the images in the db and am now linking to them on disk.
Seems for me it is a duplicate of bug 92936 . The best way to work with images and internal HSQLDB is to link the images with a varchar-field. Should we close this as a duplicate?
No response, so let's do it *** This bug has been marked as a duplicate of bug 92936 ***