Bug 161849 - PostgreSQL, direct connection: Data base properties repeat 'port' many times
Summary: PostgreSQL, direct connection: Data base properties repeat 'port' many times
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.6.2.1 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-06-30 16:33 UTC by intmail01
Modified: 2024-07-01 03:14 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
these are screenshot (57.92 KB, application/x-compressed-tar)
2024-06-30 16:37 UTC, intmail01 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description intmail01 2024-06-30 16:33:38 UTC 
Description:
The 'port' parameter is repeated several times in the Edit > Database > properties > General

Steps to Reproduce:
1. Change the Tools > TAble filter > Ok
2. Check  Edit > Database > properties > General. The port variable is repetead several times

Actual Results:
port='5432' port='5432' port='5432' port='5432' port='5432' port='5432' port='5432' port='5432' port='5432' port='5432'

Expected Results:
port='5432'


Reproducible: Always


User Profile Reset: Yes

Additional Info:
no information
Comment 1 intmail01 2024-06-30 16:37:11 UTC 
Created attachment 195058 [details]
these are screenshot
Comment 2 Robert Großkopf 2024-06-30 17:33:09 UTC 
Have tested with
Version: 24.2.4.2 (X86_64) / LibreOffice Community
Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded

and a direct connection to PostgreSQL. Couldn't confirm the buggy behavior.
Here appears:
dbname=libretest host=localhost port='5432'
Don't know why the dbname and host are also masked in your example.

Tested also with older versions of LO on OpenSUSE 15.6 64bit rpm Linux and couldn't find such a buggy behavior.

Please report the version of LO you are using (Version from your Linux distribution?)
Aren't you able to delete all the entries, which aren't needed (incl. masking of dbname and host), in
Edit > Database > properties > General ?
Comment 3 intmail01 2024-06-30 17:54:01 UTC 
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fr-FR (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 4 intmail01 2024-06-30 17:54:23 UTC Comment hidden (obsolete)
Comment 5 intmail01 2024-06-30 18:03:23 UTC 
I use slackware 15.
I can delete the long unwanted string "port='5432'" but when I modify the Table Filter one string is added to the Data base Properties.
Comment 6 Robert Großkopf 2024-06-30 18:31:29 UTC 
(In reply to intmail01 from comment #5)
> I use slackware 15.
> I can delete the long unwanted string "port='5432'" but when I modify the
> Table Filter one string is added to the Data base Properties.

Could modify table filter without any new appearing "port='5432'" here.
Did you change  
host='localhost' dbname='stockmgm'
to
dbname=stockmgm host=localhost
(without masking)?
Comment 7 intmail01 2024-06-30 18:57:46 UTC 
I set dbname=stockmgm host=localhost but no change.
Each time I push 'Test Connection' then save the database by Ctrl+S then a string "port='5432'" is added.
Comment 8 QA Administrators 2024-07-01 03:14:31 UTC Comment hidden (obsolete)