Bug 129117 - Base 6.3.2.2 - Queries - Create Query in Design View and goes to Document Recovery window. (Windows only)
Summary: Base 6.3.2.2 - Queries - Create Query in Design View and goes to Document Rec...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.3.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-11-30 18:29 UTC by Ron
Modified: 2019-12-04 18:41 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
LO error message (14.53 KB, image/png)
2019-11-30 18:31 UTC, Ron
Details
Tiny Base database for test purposes (36.27 KB, application/vnd.sun.xml.base)
2019-12-03 21:21 UTC, Ron
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Ron 2019-11-30 18:29:54 UTC
Description:
I am working on a Base project. I have created a simple database with 4 small tables and forms. I was going to create a few queries using the option...Create Query in Design Mode. As soon as I clicked on the option it opened a the Doument recovery window. I have reinstalled LO, checked my profile and several other settings. No luck. ***NOTE the other 2 options to create queries seem to be OK, that is using the Wizard and SQL

Steps to Reproduce:
1.Open LO and Base, and create a new database
2.Select Queries
3.Select Create Query in Design View

Actual Results:
See attached

Expected Results:
See Attached


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Should have opened the Design Query window
Comment 1 Ron 2019-11-30 18:31:31 UTC
Created attachment 156204 [details]
LO error message
Comment 2 Alex Thurgood 2019-12-02 09:08:56 UTC
@Ron :

- which database engine are you using ?
- which connector and driver version (if any) ?
- it might help if you could provide us with a sample database where the problem occurs (bearing in mind that everything you post here or as an attachment is public)
Comment 3 Ron 2019-12-03 21:21:45 UTC
Created attachment 156280 [details]
Tiny Base database for test purposes

As requested
Comment 4 QA Administrators 2019-12-04 04:22:29 UTC Comment hidden (obsolete)
Comment 5 Alex Thurgood 2019-12-04 06:50:30 UTC
@Ron : thanks!

1) Opened Players_Bug01.odb in 

Version: 6.3.2.2
Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c
Threads CPU : 4; OS : Mac OS X 10.15.1; UI Render : par défaut; VCL: osx; 
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded

It is an embedded Firebird database.

2) Clicked on Query button, then Create Query in Design Mode

3) A list of tables is displayed to select and add to the query design.

No crash. Works for me.


Might this be a Windows specific bug ? If so, can't help here.
Comment 6 Roman Kuznetsov 2019-12-04 10:25:13 UTC
no problem in

Версия: 6.5.0.0.alpha0+ (x64)
ID сборки: 89f0af144c18efafe2573801641689a1432c0cae
Потоков ЦП: 4; ОС:Windows 10.0 Build 18362; Отрисовка ИП: по умолчанию; VCL: win; 
Локаль: ru-RU (ru_RU); Язык интерфейса: ru-RU
Calc: threaded
Comment 7 Alex Thurgood 2019-12-04 10:53:41 UTC
@Ron : I'm guessing that either there is something else happening with your installation, or else this was a bug that has been fixed.
You might want to try a current daily release build to see if that has fixed your problem.

If not, then there is some other issue of which we are not aware.
Comment 8 Ron 2019-12-04 17:44:05 UTC
(In reply to Alex Thurgood from comment #7)
> @Ron : I'm guessing that either there is something else happening with your
> installation, or else this was a bug that has been fixed.
> You might want to try a current daily release build to see if that has fixed
> your problem.
> 
> If not, then there is some other issue of which we are not aware.

Thanks Alex...you are correct, there was something going on with Win 10 and Ease of Access. I would not have connected the 2. Turns out I was using Ease of Access->Windows Speech Recognition and this was causing the problem with LO. Your guess is as good as mine as to why. Anyway once I closed Speech Recognition the problem was gone. I have been fixing Windows problems for 40+ years and I'm still amazed at what I find. Have a great day.

Case closed...Ron(In reply to Alex Thurgood from comment #7)
Comment 9 Roman Kuznetsov 2019-12-04 18:41:16 UTC
So closed as WFM by Comment 8