Bug 163090 - No more access to HSQL Base doc DataSource from 24.8 onwards
Summary: No more access to HSQL Base doc DataSource from 24.8 onwards
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
24.8.1.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-09-22 14:14 UTC by Alain Romedenne
Modified: 2024-09-25 16:44 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
LibreOffice Base w/ Python script & BASIC macro counterpart (7.27 KB, application/vnd.oasis.opendocument.database)
2024-09-22 14:17 UTC, Alain Romedenne
Details
Tables to associate with script (3.89 KB, image/png)
2024-09-22 14:30 UTC, Alain Romedenne
Details
Tables with added relationships (31.71 KB, image/jpeg)
2024-09-22 14:36 UTC, Alain Romedenne
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Alain Romedenne 2024-09-22 14:14:30 UTC
Description:
Python macro stopped functioning while Basic counterpart still works fine

Steps to Reproduce:
1. display table relationships menu. Remove any present relations between tables, tables should exhibit no relationships.
2. run 'SetRelationships' Python script
3. check that 2 relations have been set

3.

Actual Results:
Python script fails:

com.sun.star.uno.RuntimeException: Error during invoking function SetRelationships in module vnd.sun.star.tdoc:/58078120/Scripts/python/Relationships.py (<class 'AttributeError'>: 'NoneType' object has no attribute 'DataSource'
  File "/opt/libreoffice24.8/program/pythonscript.py", line 913, in invoke
    ret = self.func( *args )
  File "vnd.sun.star.tdoc:/58078120/Scripts/python/Relationships.py", line 11, in SetRelationships


Expected Results:
cf. attached capture


Reproducible: Always


User Profile Reset: No

Additional Info:
Running equivalent Basic Standard.Module1.PysCreerRelation() works normally.
Comment 1 Alain Romedenne 2024-09-22 14:17:58 UTC
Created attachment 196608 [details]
LibreOffice Base w/ Python script & BASIC macro counterpart
Comment 2 Alain Romedenne 2024-09-22 14:30:17 UTC
Created attachment 196609 [details]
Tables to associate with script
Comment 3 Alain Romedenne 2024-09-22 14:36:03 UTC
Created attachment 196610 [details]
Tables with added relationships
Comment 4 Buovjaga 2024-09-22 14:59:57 UTC
Which operating system? Can you bibisect this?
Comment 5 John van Mersbergen 2024-09-22 17:51:27 UTC
This problem probably has the same origin as bug #162962. On Windows this is caused by a "bug" in Scriptforge. In version 24.8.1 this bug occurs for the first time when calling Python scripts.
Comment 6 John van Mersbergen 2024-09-23 09:41:56 UTC
@Alain Romedenne

Download LO(dev) version 24.8.2 from:
https://dev-builds.libreoffice.org/daily/

Try this version on your database.
Comment 7 Alain Romedenne 2024-09-25 16:32:40 UTC
(In reply to John van Mersbergen from comment #6)
> @Alain Romedenne
> 
> Download LO(dev) version 24.8.2 from:
> https://dev-builds.libreoffice.org/daily/
> 
> Try this version on your database.

I am using LMDE 6

Nothing happens with:
Version: 24.8.3.0.0+ (X86_64) / LibreOffice Community
Build ID: b9fa13e7739fa86f3043df197a1fbdd9fb5738cd
CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: en-US
Calc: threaded

It fails with 24.8.1.2

BTW can you provide uninstall instructions for the above LODev build?
Comment 8 Buovjaga 2024-09-25 16:44:12 UTC
(In reply to Alain Romedenne from comment #7)
> (In reply to John van Mersbergen from comment #6)
> > @Alain Romedenne
> > 
> > Download LO(dev) version 24.8.2 from:
> > https://dev-builds.libreoffice.org/daily/
> > 
> > Try this version on your database.
> 
> I am using LMDE 6
> 
> Nothing happens with:
> Version: 24.8.3.0.0+ (X86_64) / LibreOffice Community
> Build ID: b9fa13e7739fa86f3043df197a1fbdd9fb5738cd
> CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: gtk3
> Locale: fr-FR (fr_FR.UTF-8); UI: en-US
> Calc: threaded
> 
> It fails with 24.8.1.2
> 
> BTW can you provide uninstall instructions for the above LODev build?

I don't think there is any special uninstallation required, just remove the files.