[Libreoffice-bugs] [Bug 113617] Subform Postgresql "The column index out of range: 1, number of columns: 0

[bugzilla-daemon]

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

Alex Thurgood  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |WORKSFORME

--- Comment #16 from Alex Thurgood  ---
(In reply to jeffsummer from comment #15)
> In other words, shouldn't ticking the box and hitting 'okay' be enough - why
> does one have to save the odb and quit Libreoffice?

So, as I understand it, the driver parameters for JDBC drivers (including SQL
statement parameter substitution) are generally loaded at creation of the
database connection instance. They are not automatically updated in a running
active session (I don't know why, perhaps it would render the whole thing
potentially unstable, or have some other unforeseeable consequence, like a
performance hit or threading issues).

As you have solved the problem you were experiencing, with the indication given
in bug 108105, and Comment 2 here, this can be set to resolved works for me.

-- 
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

[Libreoffice-bugs] [Bug 113617] Subform Postgresql "The column index out of range: 1, number of columns: 0

[bugzilla-daemon]

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

--- Comment #15 from jeffsum...@mail.com ---
In other words, shouldn't ticking the box and hitting 'okay' be enough - why
does one have to save the odb and quit Libreoffice?

-- 
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

[Libreoffice-bugs] [Bug 113617] Subform Postgresql "The column index out of range: 1, number of columns: 0

[bugzilla-daemon]

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

--- Comment #14 from jeffsum...@mail.com ---
Read closely 108105 

At the end it said you can't just tick the box about parameter ?, you must also
close and reopen Libreoffice.  This made it work.  I'm not sure what the bug is
here - that a database setting does not take effect or that you have to use
that setting at all?

-- 
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

[Libreoffice-bugs] [Bug 113617] Subform Postgresql "The column index out of range: 1, number of columns: 0

[bugzilla-daemon]

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

Alex Thurgood  changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

-- 
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

[Libreoffice-bugs] [Bug 113617] Subform Postgresql "The column index out of range: 1, number of columns: 0

[bugzilla-daemon]

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

--- Comment #13 from jeffsum...@mail.com ---
-- Table: public.test1

-- DROP TABLE public.test1;

CREATE TABLE public.test1
(
id1 integer NOT NULL,
text1 character varying COLLATE pg_catalog."default",
CONSTRAINT test1_pkey PRIMARY KEY (id1)
)
WITH (
OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.test1
OWNER to postgres;





-- Table: public.test2

-- DROP TABLE public.test2;

CREATE TABLE public.test2
(
id2 integer NOT NULL,
id1 integer,
text2 character varying COLLATE pg_catalog."default",
CONSTRAINT test2_pkey PRIMARY KEY (id2),
CONSTRAINT test1_fkey FOREIGN KEY (id1)
REFERENCES public.test1 (id1) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE NO ACTION
)
WITH (
OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.test2
OWNER to postgres;

-- 
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

[Libreoffice-bugs] [Bug 113617] Subform Postgresql "The column index out of range: 1, number of columns: 0

[bugzilla-daemon]

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

--- Comment #12 from jeffsum...@mail.com ---
Created attachment 137765
  --> https://bugs.documentfoundation.org/attachment.cgi?id=137765=edit
subform data tab

-- 
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

[Libreoffice-bugs] [Bug 113617] Subform Postgresql "The column index out of range: 1, number of columns: 0

[bugzilla-daemon]

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

--- Comment #11 from jeffsum...@mail.com ---
Created attachment 137764
  --> https://bugs.documentfoundation.org/attachment.cgi?id=137764=edit
subform general tab

-- 
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

[Libreoffice-bugs] [Bug 113617] Subform Postgresql "The column index out of range: 1, number of columns: 0

[bugzilla-daemon]

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

--- Comment #10 from jeffsum...@mail.com ---
Created attachment 137763
  --> https://bugs.documentfoundation.org/attachment.cgi?id=137763=edit
main form data tab

-- 
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

[Libreoffice-bugs] [Bug 113617] Subform Postgresql "The column index out of range: 1, number of columns: 0

[bugzilla-daemon]

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

--- Comment #9 from jeffsum...@mail.com ---
Created attachment 137762
  --> https://bugs.documentfoundation.org/attachment.cgi?id=137762=edit
main form general tab

-- 
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

[Libreoffice-bugs] [Bug 113617] Subform Postgresql "The column index out of range: 1, number of columns: 0

[bugzilla-daemon]

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

--- Comment #8 from Alex Thurgood  ---
See also this report, which seems similar to yours, using pg9.1 :

https://forum.openoffice.org/en/forum/viewtopic.php?f=13=47100#p288816

-- 
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

[Libreoffice-bugs] [Bug 113617] Subform Postgresql "The column index out of range: 1, number of columns: 0

[bugzilla-daemon]

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

--- Comment #7 from Alex Thurgood  ---
Currently, but without more information on the form/subform relationship and
any other linked subforms or filtering in the ODB file, it is difficult to be
able to be more precise.

However, from the brief information you have provided, this looks like a
duplicate of bug 45148, which was closed after a long while for lack of
information from the original bug poster.

-- 
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

[Libreoffice-bugs] [Bug 113617] Subform Postgresql "The column index out of range: 1, number of columns: 0

[bugzilla-daemon]

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

Alex Thurgood  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=45
   ||148

-- 
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

[Libreoffice-bugs] [Bug 113617] Subform Postgresql "The column index out of range: 1, number of columns: 0

[bugzilla-daemon]

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

Alex Thurgood  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=10
   ||8105

-- 
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

[Libreoffice-bugs] [Bug 113617] Subform Postgresql "The column index out of range: 1, number of columns: 0

[bugzilla-daemon]

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

--- Comment #6 from Alex Thurgood  ---
@Jeff : do you get the same error if you use the postgres native driver instead
of the JDBC driver ?

-- 
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

[Libreoffice-bugs] [Bug 113617] Subform Postgresql "The column index out of range: 1, number of columns: 0

[bugzilla-daemon]

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

Alex Thurgood  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 Ever confirmed|0   |1

--- Comment #5 from Alex Thurgood  ---
@Jeff : I'm afraid we're going to need more information.

Can you provide screenshots of the General Tab and Data tab of the properties
of :

1) your Form in general; and
2) each linked control ?

-- 
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

[Libreoffice-bugs] [Bug 113617] Subform Postgresql "The column index out of range: 1, number of columns: 0

[bugzilla-daemon]

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

Alex Thurgood  changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

--- Comment #4 from Alex Thurgood  ---
@Jeff : I found this thread :

https://forum.openoffice.org/en/forum/viewtopic.php?f=39=47480

that might be related to your problem.

-- 
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

[Libreoffice-bugs] [Bug 113617] Subform Postgresql "The column index out of range: 1, number of columns: 0

[bugzilla-daemon]

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

--- Comment #3 from jeffsum...@mail.com ---
(In reply to Alex Thurgood from comment #2)
> Under Advanced Database Properties, is the "Replace named parameters by '?'"
> box ticked or not ?
> 
> Does it make any difference if you tick/untick  and try your subform again ?

Was not ticked initially, ticked it and the error is the same.

-- 
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

[Libreoffice-bugs] [Bug 113617] Subform Postgresql "The column index out of range: 1, number of columns: 0

[bugzilla-daemon]

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

Alex Thurgood  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 Ever confirmed|0   |1

--- Comment #2 from Alex Thurgood  ---
Under Advanced Database Properties, is the "Replace named parameters by '?'"
box ticked or not ?

Does it make any difference if you tick/untick  and try your subform again ?

-- 
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

[Libreoffice-bugs] [Bug 113617] Subform Postgresql "The column index out of range: 1, number of columns: 0

[bugzilla-daemon]

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

--- Comment #1 from Alex Thurgood  ---
See :


https://stackoverflow.com/questions/36439305/error-the-column-index-is-out-of-range-1-number-of-columns-0

-- 
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