LibreOffice writer form for database crashes on exit

English
#1

I have a writer form document that is used to enter data into a mysql database behind a .odb file which is a registered data source on the machine. Trouble is, every time the form document is closed, it crashes. The data is still saved to the db, but I still get the pesky message that it crashed, and libreoffice doesn’t stop running. Here’s my version info:

Version: 7.0.6.2 (x64)
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

Anyone familiar with this issue and know how to get around it? I’d really like to avoid upgrading LO, because in my experience, that breaks other functionalities on my db frontend.

Edit: I’m attaching the original document, which crashes any time it’s opened and subsequently closed.(QF) Receiving & Inspection.odt (189.7 KB)

#2

Select and copy all form controls into a new Writer document.
Does it make a difference?

#3

Thanks for the response! Unfortunately, no, it does not make any difference. The new document crashes just like the original.

#5

@Villeroy,
What were you getting at when you asked about what happens when all controls are copied to a new document?

#6

I don’t understand it, even when a form is created within Base, it is stored in the .odb file, but it is still Writer that opens the form. The only thing I can think of that would make this different from the most mundane of database forms in LO is that this form has a subform.

#7

Turn of Skia under Tools>Options>View

or try menu:Help>Restart in safe mode

#8

@Villeroy Thanks for the suggestion. Even with Skia turned off, the problem persists.

#9

The issue seems to lie with that subform, because when I remove the subform, the crashing ceases. I can’t find anything wrong with how the subform is set up. It has a table control with a combobox column with a SQL[native] data source. Thinking that might be causing the issue, I created a view in the DB using the same SQL command, and swiched the data source for the CB to that. The crashing still persisted.

#10

Please tell me more about why you suggested switching to safe mode.

#11

I just tried restarting in safe mode. It crashes when I do that.

#12

Does it still crash while in safe mode?
Can you attach a demo document that crashes on your system, so we can see if it crashes on other systems too?
It is definitively not a known problem.
It may be related to the subform itself. It could be a detail of that subform.

#13

Yes, it does still crash. The document in question is attached to the original post.

#14

I don’t see anything wrong in your Writer document. Of course, I don’t have any database connected to it.

Here is a form/subform based on the Bibliography.
biblio_form_subform.odt (15.5 KB)

#15

Thanks for spending time trying to sort this out!

#16

It wasn’t a known bug, but it must have been an unknown bug. Upgrading LO to 7.4.7.2 (The latest still) from where I was (7.0.6.2) took care of it.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.