Bug 144548 - Could not find Help page for "Add Table or Query"
Summary: Could not find Help page for "Add Table or Query"
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
7.1.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, regression
Depends on:
Blocks: Help-Link
  Show dependency treegraph
 
Reported: 2021-09-16 14:02 UTC by flywire
Modified: 2024-08-08 18:35 UTC (History)
4 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 flywire 2021-09-16 14:02:20 UTC
Database Wizard, Select database, Connect to existing database: odbc, Help

Error occurs
Comment 1 Julien Nabet 2021-09-18 10:00:43 UTC
On pc Debian x86-64 with master sources updated today, I don't reproduce this but help page is about "Mail Merge Wizard", so no error but is it expected?

Olivier: thought you might be interested in this one.
Comment 2 flywire 2021-09-18 10:08:08 UTC
Version: 7.2.0.3 (x64) / LibreOffice Community
Build ID: 2a7ea282da28d665a7dc086360567b4aea27bf08
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-AU (en_AU); UI: en-GB
Calc: threaded
Comment 3 Robert Großkopf 2021-10-15 15:47:45 UTC
Works here as expected: Opens Help for database connections.

System: OpenSUSE 15.2 64bit rpm Linux, LO 7.2.2.2
Comment 4 flywire 2021-10-15 22:14:15 UTC
This is a general problem, seems links in code need verification. Two more examples:

Base Query Design, Save As
https://help.libreoffice.org/7.2/en-GB/text/shared/05/err_html.html?System=WIN&DbPAR=BASE&HID=dbaccess/ui/savedialog/dialog-action_area1
Help ID: dbaccess/ui/savedialog/dialog-action_area1


Base Table Design, Indexes
https://help.libreoffice.org/7.2/en-GB/text/shared/05/err_html.html?System=WIN&DbPAR=BASE&HID=dbaccess/ui/indexdesigndialog/dialog-action_area1
Help ID: dbaccess/ui/indexdesigndialog/dialog-action_area1


Version: 7.2.1.2 (x64) / LibreOffice Community
Build ID: 87b77fad49947c1441b67c559c339af8f3517e22
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-AU (en_AU); UI: en-GB
Calc: threaded
Comment 5 Robert Großkopf 2021-10-16 07:30:53 UTC
OK, got it with a simple example:

Open a database.
Pane Queries.
Create Query in Design view.
Press "Help" on dialog "Add Table or Query".

------
Could not find Help page (404).
That is an error. Possible causes are:
    The page does not exist and must be created.
    The page exists, but the Help ID is wrong or missing.
Use the Module, Contents, Index and Search selectors to find the right page.
The following data could be helpful in locating the error:
Help ID: dbaccess/ui/tablesjoindialog/dialog-action_area1
------
There are much more places a connection to the content is impossible.

This works with LO 7.0.5.2, fails with LO 7.1.0.3 on OpenSUSE 15.2 64bit rpm Linux.

Seems someone has planned special help for every dialog, but this special held never has been written. Help in LO 7.0.5.2 will show the start of Help about Base instead.

Have changed the Component to "Documentation". Hope this is right. This isn't a special Base problem.
Comment 6 flywire 2021-10-17 07:40:28 UTC
It would be good to run a process to identify and list broken links. If it's a manageable number there's a good chance a community member would be interested in finding the links.
Comment 7 Rafael Lima 2022-01-03 14:21:19 UTC
(In reply to flywire from comment #0)
> Database Wizard, Select database, Connect to existing database: odbc, Help
> 
> Error occurs

Following the steps reported by flywire I landed in (which seems to make sense to me):
https://help.libreoffice.org/7.2/en-US/text/shared/explorer/database/dabawiz01.html?System=UNIX&DbPAR=BASE&HID=dbaccess/ui/generalpagewizard/datasourceType#bm_id763267

However, I was able to reproduce the error reported by Robert:

> Open a database.
> Pane Queries.
> Create Query in Design view.
> Press "Help" on dialog "Add Table or Query".

I could not find a Help page dedicated specifically to the "Add Table or Query" dialog. However, pressing Help could lead the user to the "Query Design" page:
https://help.libreoffice.org/7.3/en-US/text/sdatabase/02010100.html?&DbPAR=SHARED&System=UNIX

System info:
Version: 7.2.3.2 / LibreOffice Community
Build ID: 20(Build:2)
CPU threads: 16; OS: Linux 5.13; UI render: default; VCL: kf5 (cairo+xcb)
Locale: pt-BR (pt_BR.UTF-8); UI: en-US
Ubuntu package version: 1:7.2.3-0ubuntu0.21.10.1
Calc: threaded
Comment 8 Alain Romedenne 2022-12-17 16:29:32 UTC
https://wiki.documentfoundation.org/Documentation/Understanding,_Authoring_and_Editing_Openoffice.org_Help/4#Determining_A_Help_ID wiki content can help identify helpIDs in order to scrutinize help source for missing pages or missing HID links
Comment 9 Alain Romedenne 2022-12-19 12:33:29 UTC
Help page for Robert' issue:
> 
> Open a database.
> Pane Queries.
> Create Query in Design view.
> Press "Help" on dialog "Add Table or Query".
> 
exists as https://help.libreoffice.org/7.5/en-US/text/shared/02/14020100.html and is incomplete
Comment 10 Dione Maddern 2024-08-08 18:35:44 UTC
The help page was linked correctly when I tested it, but it does need some additional information about queries added.

Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 5aa386fc22bd88719216c50f65654590469b847f
CPU threads: 8; OS: Linux 6.9; UI render: default; VCL: x11
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: CL threaded