Base - subforms Data not loading

Using LibreOffice Base - Version: 6.1.3.1 (x64) Build ID: a9670562c26181ec3afbe381c9ff499ae88c98b7 on Windows 8.1.
I am running ODB’s created in earlier versions of LO Base with HSQLDB embedded. The forms and subforms link correctly with all data being loaded and properly linked. With the installationn of Ver. 6.1 and the deprecation of HSQLDB when I accept migration to Firebird embedded I loose all linkeages with the following errors reported:

  • The data content could not be loaded.
  • Error code: 1
  • firebird_sdbc error:
  • *Dynamic SQL Error
  • *SQL error code = -206
  • *Column unknown
  • *LINK_FROM_NUMBER_ID
  • *At line 1, column 60 caused by ‘isc_dsql_prepare’

This same problem is in LibreOfficeDev Base - Version: 6.2.0.0.alpha1 (x64) Build ID: ff46ad24d1d3cbcea45895520483ed1fd4ff488b.

Any help would be appreciated.

Hello,

This is a known problem. For a fix, see my answer & associated link here - How to unzip ODB file and edit the content.xml file to fix Firebird bug?