With the 4.1 version base no longer shows related fields of 1:n relationships in subforms of a mysql (native) db. A little experimenting showed that this happens only when the primary key is set to "bigint unsigned". "bigint" alone works, as do "int unsigned". Steps to reproduce: 1. create a simple mysql database CREATE TABLE `series` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) CREATE TABLE `episode` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `series_id` bigint unsigned DEFAULT NULL, `title` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) 2. link this db to LibreOffice base and create a simple form with the wizard Table "series", add subform, Table "episode", join "series_id" and "id" 3. you can enter data in both tables, but stored data in the "episode" table is not shown once you change the active record in the "series" table.
Could you please describe, which version of connector you are using? There is no direct LO-connector working with LO 4.1.* and Linux-rpm.
I wasn't aware of it, but it seems as if it's a version provided by the debian package manager. The package is libreoffice-mysql-connector 1.0.2+LibO4.1.0-4 (debian sid). / Knut Esztermann
Just tried with the JDBC connector, same problem there. / Knut Esztermann
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d805c470845c89a54bfc50ec7d75dfba670d8b21 fdo#67546 handle unsigned 64 bit integers The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Fixed for values of the key between 0 and 2^63-1 for 4.1.x and for values between 2^63 and 2^64-1 for 4.2.0.
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "libreoffice-4-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d1cb302bc47b553ac2f6e126f19ea75f69564f18&h=libreoffice-4-1 fdo#67546 handle unsigned 64 bit integers It will be available in LibreOffice 4.1.2. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.