<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Parameter index out of range (1 > number of parameters, which is 0). (see comment 39 for manual fix)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=118112#c70">Comment # 70</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Parameter index out of range (1 > number of parameters, which is 0). (see comment 39 for manual fix)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=118112">bug 118112</a> from <a class="email" href="mailto:tim@tim-passingham.co.uk" title="tim@tim-passingham.co.uk">tim@tim-passingham.co.uk</a> <pre>(In reply to Julien Nabet from <a href="show_bug.cgi?id=118112#c69">comment #69</a>) > (In reply to tim from <a href="show_bug.cgi?id=118112#c68">comment #68</a>) > > ... > > 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: > <a class="bz_bug_link bz_status_VERIFIED bz_closed" title="VERIFIED FIXED - embedded firebird files created with parameter name substitution disabled" href="show_bug.cgi?id=117053#c15">https://bugs.documentfoundation.org/show_bug.cgi?id=117053#c15</a> > > > > > 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>