This bug was filed from the crash reporting server and is br-aeacefb6-e997-493d-9596-664a71ede7bc. ========================================= I was following a tutorial by TheFrugalComputerGuy.com to create an Invoice application. In his video #74 at about 6:00 minutes the tutorial replaces a "Customer ID" Formatted Field with a List Box, then opens the properties of the new List Box, changes Value List to SQL, click on the "..." box, then selects the ClientName and ClientID from the linked Client table. Base has crashed several times when I click on the "..." box after changing the "Formatted Field" box to a "List Box" and opening the properties for the new list box. If I allow it to rebuild Invoice.odb it reports that it has rebuilt the file. After the crash if I examine my working directory, H:\!\!GrcInvoice\ I see an Invoice.odb file and an Invoice.odb.lck file both with the date and time of the crash. If I click on Invoice.odb Base does not start but Writer starts with a blank box showing file Untitled1 is being written. I can not terminate this instance of Writer by clicking on X in the box. TaskManager shows three instance of LibreOffice running and is able to end them. LibreOffice then sent an additional crash report, crashreport.libreoffice.org/stats/crash_details/c921ab97-e791-425d-9433-9a6c7f8ccf10 If I again allow it to rebuild Invoice.odb it again reports that it has rebuilt the file and automatically starts LibreOffice which causes the empty Writer box to appear which can only be terminated by TaskManager. If I open Base again click on the Invoice tile it reports that C:\Users\me\AppData\Local\Temp\Invoice.odt does not exist, and checking that directory shows that it does not exist. Earlier today I removed LibreOffice using WindowsControlPanel > Programs and reinstalled using LibreOffice7.0.6_Win_x64.msi. This bug report has probably been sent at least five times today. Paul Lepkowski
I was advised to disable Skia rendering since display artifacts were observed by others following the same tutorial. I disabled Skia and the repeated crash after setting the content type to SQL and clicking on the "..." icon persisted. I was then advised to reset my user profile and to install a newer version, perhaps 7.1.4. (I had not modified my user profile since I had re-installed version 7.0.6.) I reset the user profile anyway. I did not install a version newer than 7.0.6. Now when I change the content type to SQL and click on the "..." icon it properly displays the available tables and permits me to select the CustomerID and Name fields from the Client table returning SELECT "NAME", "CLIENTID" FROM "CLIENT" which is correct. So ... it doesn't crash and seems to be working but I haven't run the code yet, and I don't really know what I did to fix it. I guess it was something in the user profile. Paul Lepkowski
Sometimes the user profile gets corrupted and LibreOffice starts to crash for no apparent reason, which seems to be the case here, that's why resetting the profile fixed the issue for you. Thanks for reporting the issue anyway. Closing as RESOLVED WONTFIX