LibreOffice Base crashes when creating table relationships

English
, , , , ,
#1

I am using LibreOffice 6.1.5.2 on Mint 19.1 Cinnamon using kernel 4.15.0-47-generic to create a small HSQLDB database for my personal use. Recently I started encountering a problem in Base that is rendering it useless to me. When I attempt to create a relationship between two tables LO crashes giving me the following error message:
Screenshot of Error Message

The relationship tool works fine otherwise. It is only when I attempt to use the drop down to choose the first table with which the relationship is to be created.
I attempted deleting and recreating the tables thinking it maybe just those first few tables I was working. Then I scrubbed that entire database and started another one. Lastly, I removed and reinstalled LO. The problem still exists.

The last point, interestingly enough, the crash isn’t reported in Mint’s System’s Report tool. So ???

Please help!
Scott

As requested, here is the scrubbed database file. Of course, the database is still in development so no data has been unput. Thanks again in advance for you help.

Scott

Sales Results Alternate.odb

#2

Did you try running in Safe Mode? This will bypass the user profile which may be a source of the problem. The user profile is not touched when removing/reinstalling LO.

Haven’t see this problem through v6.2.2.2 (just re-tested on Mint 18.3). Please post a sample (scrubbed) of the Base file.

#3

Forgive me, I’m rather new to this world. What is a scrubbed base file and how do I post it? I would know what a certain log file would be, but a Base file I don’t. Thanks in advance for your patience.

#4

Hello,

Base file (your created .odb database) without any personal or confidential data. Edit you question (edit is lower right of question) . On toolbar (upper left of question) there is a paperclip icon. This allows attachments.

#5

OK, thanks for the direction. I will attempt to recreate the crash now in safe mode and let you know how that works out.

#6

@overflowscott Have deleted many tables and relations in your sample and added again. Did this after saving file, closing & re-opening. Had no problems or crashes. Very probable some problem with your User Profile (thus the running in Safe Mode). This post explains more on this → LibreOffice user profile.

#7

The problem persists even in safe mode so it is not the profile.Thanks for your help.

#8

As stated, I can’t duplicate. Best if you file bug report → Bugzilla.

#9

As for the bug report…yes, of course. Thanks for the prompting. I am working on that now.

#10

I opened your relationship window once.

image description
image description893×618 14.3 KB

That’s too demanding for me. I can not help here.
But maybe this overview can help others to help you.
I wish you success!

#11

Are you thinking that the problem is caused by the complexity of the database rather than a bug or other software issue?

#12

As already mentioned, I have not created such a construct myself yet. What struck me purely from gut feeling is the table “INT Ups VOLS” and any others, which is linked from two sides with “n”. But I can not say it because it does not know. But you can read in the documentation, if it is possible.

#13

@Hrbrgr Thank You for your help. Hopefully someone else will step up. As of right now I am considering uninstalling LO and installing a different office suite but I really don’t want to do that as I have grown to truly like LO. Be well!
Scott

#14

Maybe a little note, you use the field identifier “ID” in several tables. I would distinguish them, e.g. in ID_1, ID_2 etc. I wish you great success.

#15

Yes, this is a good suggestion. BTW, Just FYI. I uninstalled LO and installed AOO knowing that it is very similiar. Same situation - AOO crashed immediately.

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