[Libreoffice-bugs] [Bug 118112] Parameter index out of range (1 > number of parameters, which is 0). (see comment 39 for manual fix)

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #69 from Julien Nabet <serval2412 at yahoo.fr> ---
(In reply to tim from comment #68)
> ...
> I purged my LO, renamed my profile.  Installed LO 6.4.3.
> 
> The old TestNew4.odb still returns the parameter error.
It's expected since the fix will work only for the odb files generated from LO
version which is indeed fixed and LO 6.4.3 should be ok.
For old odb, you must use the macro proposed by Lionel here:
https://bugs.documentfoundation.org/show_bug.cgi?id=117053#c15

> 
> A brand new odb (still using JDBC) to the same old mariadb test database
> does not return the error.
It's normal since the pb isn't the MariaDB or Mysql database. The new odb is
generated from a version of LO which is fixed.

> 
> It's been a while since I created any new forms, and the form design wizard
> doesn't seem to exist.  Whether that's an ubuntu version issue or more
> general I don't yet know.  I copied the old form from TestNew4.odb to the
> new file, since I couldn't remember how to set it up the same way as before.
> 
or as I said, just run the macro quoted on your odb file.

In brief, if you don't reproduce the problem with a brand new odb file, it
shows the bug is indeed fixed.

With old odb files, just run the macro once and it'll fix the odb.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200429/75620ae8/attachment.htm>