https://bugs.documentfoundation.org/show_bug.cgi?id=119569

--- Comment #7 from Albrecht Dreß <albrecht.dr...@arcor.de> ---
(In reply to robert from comment #5)
> Could input data in form and also in subform without any problems.
> Data were saved.

Yes.  The form itself works for me, too.  It's just the initial query when
opening the form which is broken, triggering the error message in the
Postgresql server log.  The latter is monitored by Nagios, which is somewhat
annoying…

> All tests with OpenSUSE 15, 64bit rpm Linux, LO Version: 6.1.0.3, Build ID:
> efb621ed25068d70781dc026f7e9c5187a4decd1
> 
> Could be you are working with LO directly distributed by Ubuntu or Debian?
> What's the Build ID from your versions?

I installed a fresh VM with Debian Stretch/64 plus all updates, and made a full
install of the package from <https://de.libreoffice.org/download/download/>
which is actually “Version: 6.1.0.3 Build ID:
efb621ed25068d70781dc026f7e9c5187a4decd1” (i.e. the same as yours).

I /still/ get the server error message when I open the form, even when I
created a completely new LibreOffice database document (German locale of PGSql;
log file /var/log/postgresql/postgresql-9.6-main.log):

FEHLER:  Syntaxfehler bei »:« bei Zeichen 82
ANWEISUNG:  SELECT * FROM "public"."tab2" WHERE ( 0 = 1 ) AND ( (
"public"."tab2"."ref_id" = :link_from_id ) )

I have no idea why this statement is submitted at all, as it will never (due to
“0=1”) return any data.

In addition to Libreoffice, I installed openjdk-9-jre-headless:amd64 ver.
9~b181-4~bpo9+1 and postgresql ver. 9.6+181+deb9u2, if that is of any
importance.  The version on Ubuntu is “Version: 6.0.4.2 Build-ID:
1:6.0.4~rc2-0ubuntu0.16.04.1”, btw.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to