Bug 135549 - LibreOffice Base Various versions - all 6.3 Crash on Opening Query in Designer
Summary: LibreOffice Base Various versions - all 6.3 Crash on Opening Query in Designer
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.4.5.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Crash
  Show dependency treegraph
 
Reported: 2020-08-08 07:44 UTC by M Hewson
Modified: 2020-09-14 13:35 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description M Hewson 2020-08-08 07:44:19 UTC
Description:
Base crashes whenever I open "Create Query in Design View" or I try to edit a Query (in Design View).

I CAN Edit or Create a query in SQL view.

This happens with FIREBIRD and HSQLDB.

I have tried the following.
Re-installed the software.
Uninstalled, deleted every databases, files and all temp files.
Uninstalled, deleted all database and installed older version.

Nothing works.

Steps to Reproduce:
1.Open Libre Office Base
2.Open or Create Database
3.Click Create Query in Design View OR Edit Query in Design View

Actual Results:
"Due to an error, LibreOffice crashed. All the files. . . . . . . ."

Expected Results:
Query Designer should open.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Using Lenovo 640 Laptop with 8gig memory.
Windows 10 - all updates installed.

The bug happens whether OpenGL is enable or desiabled.
Comment 1 Julien Nabet 2020-08-08 08:31:56 UTC
Coudl you give a try at https://wiki.documentfoundation.org/QA/FirstSteps#Corrupted_user_profile ?

Also, what LO version do you use? 32 or 64 bits?
If you use LO 32 bits, you must have Java 32 bits
LO 64 bits -> Java 64 bits
Comment 2 Julien Nabet 2020-08-08 09:48:39 UTC
Also, could you give a try to last 6.4.5?
Comment 3 M Hewson 2020-08-10 09:00:57 UTC
(In reply to Julien Nabet from comment #1)
> Coudl you give a try at
> https://wiki.documentfoundation.org/QA/FirstSteps#Corrupted_user_profile ?
> 
> Also, what LO version do you use? 32 or 64 bits?
> If you use LO 32 bits, you must have Java 32 bits
> LO 64 bits -> Java

Julien - Thank you for your comment.

Yes, I have removed my user profile, both by using the instructions and by deleting: C:\Users\MH\AppData\Roaming\LibreOffice.

I still have the problem - even after de-install then re-install.

I am using 64 bit with 64 bit Java.

If I set up a new user on the PC, then all is good for that new user.

So, something appears to be left behind and is causing the failure.
Comment 4 QA Administrators 2020-08-11 04:08:38 UTC Comment hidden (obsolete)
Comment 5 M Hewson 2020-09-14 13:31:34 UTC
I have completely re-installed Windows and all other software from scratch.
This seems to have cured the issue, but is a drastic thing to have to do.

Malcolm
Comment 6 BogdanB 2020-09-14 13:35:36 UTC
Maybe there was a problem on Windows, a problem that being solved resolved the LibreOffice problem.