[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 #70 from tim at tim-passingham.co.uk ---
(In reply to Julien Nabet from comment #69)
> (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.
Julian, 

Yes, it's as expected.  I was just running the test as you requested to confirm
that it works as you expect.

Having run the macro on my old databases quite a long time ago, all still works
normally.

-- 
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/21ee4d75/attachment.htm>