I’m working on my ninth decade here. I’ve been playing with computers since a class project when we wrote an assembler for the brand new IBM 1401. I learned COBOL directly from Grace Hoppe and worked in FORTRAN and the original IBM ISAM when they came out. I’m older than dirt. I’m running Windows 10 Pro Ver 20H2 build 19042.985 on a Dell 7010 with an Intel 3.4 GHz i5-3570, 16 GB RAM, an internal 2 TB drive and 6 USB drives.
I’m evaluating LO-BASE for potential use writing databases for public charities. I’m following the video tutorials provided by TheFrugalComputerGuy.com. LO BASE crashes every time at a certain point in his “Home Invoice” tutorial which begins at Video 73 where he defines three tables, Customers, Invoice, and Tasks and links them via ID fields, then in Video 74 he defines two forms, Customers and Invoice. The Customers form works. In the Invoice form he uses the form wizard to define a subform with 5 fields and a main form with 5 fields.
In the Invoice main form he defines a VARCHAR field named Status. When the form is complete he goes back and modifies the Status field making its display box wider and changing it to a List Box with bounds of “0”;“1”. Then, at 6 minutes in the video, he attempts to modify the CustomerID by changing it into a List Box, with the content type set to SQL, then he clicks on the “…” icon next to List content and attempts to link it to the Customer table on the CustomerID field.
At this point my installation of LO crashes repeatedly. I rebuild the data files then restart and it crashes again. During data rebuild it displays a blank LO WRITER box which can’t be closed with the “X”. I had to end LO in the Task Manager.
After several crashes I removed the entire LO program and re-installed it from a new download of LibreOffice_7.0.6_Win_x64.msi. The problem continues after the re-installation.
I submitted two crash reports to BugZilla.
crashreport.libreoffice.org/stats/crash_details/aeacefb6-e997-493d-9596-664a71ede7bc
and
crashreport.libreoffice.org/stats/crash_details/c921ab97-e791-425d-9433-9a6c7f8ccf10
What’s up? Is this a known issue? What is particularly disturbing is the appearance of the completely blank and unresonsive LO-WRITER screen after the rebuilding routine. When this screen is up the Start button and task bar is not visible so I can’t start Task Manager with the mouse or by typing in a Run box. I had to hit the hardware override Ctrl-Alt-Delete to bring up Task Manager and terminate LO completely. Then LO would insist on rebuilding the last know data file again which would bring up the unresponsive WRITER screen again. I found a leftover Invoice.odb.lck file in my working directory, H:!!GrInv. I found that I had to delete the .lck file after using Task Manager to terminate LO … then LO would start.
If you go through the tutorial and it works I would like to know about it.
Paul in NY