https://bugs.documentfoundation.org/show_bug.cgi?id=118112
--- Comment #76 from Howard Johnson <[email protected]> --- SUMMARY OF THIS BUG AND HOW TO FIX IT [CORRECTED*1] * Rev 1) you must edit the file named content.xml below, not settings.xml ! PROBLEM: Some time ago subforms linking (forms that have subforms) got broken in existing, working *.odb files when LO was revised, i.e. the newer LO version permanently broke these existing older *.odb files. Newly created LO subforms don't have this problem. Only older *.odb files run on newer LO. Newer LO versions don't fix the older subforms. So your older base subforms are forever broken unless and until you manually fix them. >>>> To fix them you have to manually edit xml in them, as described below. EXAMPLE: In my case I got this error message: Could not set parameter at position C1 (values was 7) Query - conn:73(M) - "SELECT * FROM `engine_maintenance`.`log, vehicle maintance` WHERE ( `engine_maintenance`.`log, vehicle maintance`.`Equipment ID` = :link_from_Equipment_ID ) ORDER BY `Date` ASC" at ./connectivity/source/drivers/jdbc/Object.cxx:173 The problem is in this clause: WHERE ( `engine_maintenance`.`log, vehicle maintance`.`Equipment ID` = :link_from_Equipment_ID ) And specifically, but don't quote me on this, in the ":link...". SOLUTION: You fix your .odb files one of several ways. The method I used was described above in #24 by Robert Großkopf: bugs.documentfoundation.org/show_bug.cgi?id=118112#c24 0) Made a backup copy of my broken database file, let's call it foo.odb 1) I opened this foo.odb with Archive Manager (in GUI). 2) Right clicked on content.xml and clicked Extract. Keep this screen open. 3) Opened the extracted content.xml with kate to edit it. 4) Searched for the string; db:parameter-name-substitution="false" 5) Deleted the text: db:parameter-name-substitution="false" 6) Saved content.xml, and closed kate. 7) Returned to the Archive Manager screen. 8) Dragged my updated content.xml into the still open Archive Manager screen, thus replacing settings.xml with the new one. 9) Opened foo.odb with LO and now the subform works properly again. -- You are receiving this mail because: You are the assignee for the bug.
