Description: I created a database to manage my volunteering association. I created two tables: one for "members" and one table for "courses". Base crashed multiple times when I was editing the tables, and also crashed each time I was trying to build a relationship between the two tables. Steps to Reproduce: 1. Open the "Relationships" creation window; 2. Add the tables; 3. Drag the field to be linked from a table to the other 4. Set the properties of the relationship in the pop-up window Actual Results: LO crashes. I have to reopen it, repair the file, and start again. I tried the same task on LibreOffice 7.3.4-2 on Linux 5.15, and it worked without any flaws. Expected Results: Being able to create a many-to-many relationship between two table Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: OfficeDatabaseDocument [Information guessed from browser] OS: macOS (All) OS is 64bit: yes
@Luca: - are you using the Intel x64 version or the aarch64 Arm version of LibreOffice ? - which kind of database are you using (embedded HSQLDB, Firebird, other DB engine) ?
No repro for me with an embedded HSLQBD and Version: 7.3.4.2 / LibreOffice Community Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5 CPU threads: 8; OS: Mac OS X 12.4; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded this is the Arm version of LibreOffice on macOS. Using the Relations dialog does not crash LO for me.
I am using a MacBook Pro running on a 2,5 GHz Dual-Core Intel Core i5. The database kind is Firebird.
(In reply to Alex Thurgood from comment #1) > @Luca: > > - are you using the Intel x64 version or the aarch64 Arm version of > LibreOffice? I am using a MacBook Pro running on a 2,5 GHz Dual-Core Intel Core i5. > - which kind of database are you using (embedded HSQLDB, Firebird, other DB > engine)? The database kind is Firebird. PS: Sorry for using "comment" in place of "Reply". I am new to this forum.
@Luca - thanks, unfortunately still no repro for me, even with embedded Firebird. I can click on the relations link between the two tables and when I select an existing relation, have access to the actions choices (Step 4 of your description). Does the crash depend on any specific thing, e.g. ? - number of tables added to Relations UI ? - type of relation (multiple key, single key, 1to1, 1toN, etc) ? - action associated with relation ?
(In reply to Alex Thurgood from comment #5) > @Luca - thanks, unfortunately still no repro for me, even with embedded > Firebird. > > I can click on the relations link between the two tables and when I select > an existing relation, have access to the actions choices (Step 4 of your > description). > > > Does the crash depend on any specific thing, e.g.? > - number of tables added to Relations UI? > - type of relation (multiple key, single key, 1to1, 1toN, etc)? > - action associated with relation? I was following along with this tutorial: https://youtu.be/PJQPzVvZg7I. There are three tables: - courses - students - students vs courses map The latter serves to create a many-to-many relationship between the first two tables. I was able to complete the tutorial using LibreOffice 7.3.4-2 on Linux (Manjaro, 5.15.50) running on HP Elitebook 840 (Intel Core I5-7300Ux4).
[Automated Action] NeedInfo-To-Unconfirmed
Does this still occur if you test the latest 7.5? Do you have two screens? Can you paste the version info from the About dialog?
Recently I haven't had the chance to work on the project, so I didn't test it. I guess the issue is resolved.
Let's close as "insufficient data" as it wasn't reproduced, questions were unanswered, and it doesn't look Luca will be able to test again. There's always the option to set back to "unconfirmed" again if your still experience it, Luca. (Or New if someone else reproduces.)