Hi! Sorry for the delayed response, but attached please find the .odb involved as well as an .ogv video of me demonstrating the problem. While I was doing this I observed that the Relationships tool apparently does not have anything to do with the problem- it looks like the primary key just does not get set on saving the "Ppl" table for some reason. I apologize for having muddied the waters before- I should have checked that the primary key actually got set before trying to relate things.
On Thu, Mar 15, 2012 at 9:12 PM, Christopher M. Penalver < [email protected]> wrote: > koanhead, thank you for reporting this and helping make Ubuntu better. > Could you please attach an example document where this problem occurs > with? As well, could you provide a recording of this via > recordmydesktop? > > ** Changed in: libreoffice (Ubuntu) > Status: New => Incomplete > > -- > You received this bug notification because you are subscribed to the bug > report. > https://bugs.launchpad.net/bugs/953103 > > Title: > Can't set relations, primary key spontaneously unset > > Status in “libreoffice” package in Ubuntu: > Incomplete > > Bug description: > When attempting to set relations between three tables: table 3 primary > key is unset after opening Relations window (after being set in Design > View). Setting relation between tables 1 and 2 works, but yields error > message (would have pasted it here, but it was in an alert window that went > away and I can't find LibreOffice's error log if one exists) having to do > with mismatch between field types (both are SmallInt). Relation apparently > set anyway: 1:n line drawn as expected in Relations window. Relation > between tables 1 and 3 fails due to table 3's lack of primary key. > On closing the Relations window, chose "No" at prompt to save relations. > Back in Design View, reset table 3's primary key. On returning to Relations > window, table 3 primary key unset again, and relation between tables 1 and > 2 persists despite choosing "No" at the aforementioned dialog. Repeated > this process 3 times with identical result. > > ProblemType: Bug > DistroRelease: Ubuntu 11.04 > Package: libreoffice-base 1:3.3.4-0ubuntu1 > ProcVersionSignature: Ubuntu 2.6.38-13.57-generic 2.6.38.8 > Uname: Linux 2.6.38-13-generic x86_64 > NonfreeKernelModules: nvidia > Architecture: amd64 > CheckboxSubmission: 71dcdffc611aa0b506f8503de91b9e83 > CheckboxSystem: edda5d4f616ca792bf437989cb597002 > Date: Mon Mar 12 08:08:57 2012 > EcryptfsInUse: Yes > InstallationMedia: Ubuntu 10.04 LTS "Lucid Lynx" - Release amd64 > (20100429) > ProcEnviron: > LANGUAGE=en_US:en > LANG=en_US.UTF-8 > SHELL=/bin/bash > SourcePackage: libreoffice > UpgradeStatus: Upgraded to natty on 2012-02-19 (21 days ago) > > To manage notifications about this bug go to: > > https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/953103/+subscriptions > -- <a href="http://www.fsf.org/fb";><img src=" http://static.fsf.org/nosvn/no-facebook-me.png"; alt="Not f'd — you won't find me on Facebook" /></a> ** Attachment added: "CurriculumVitae.odb" https://bugs.launchpad.net/bugs/953103/+attachment/2993326/+files/CurriculumVitae.odb ** Attachment added: "primarykey.ogv" https://bugs.launchpad.net/bugs/953103/+attachment/2993327/+files/primarykey.ogv -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/953103 Title: Can't set relations, primary key spontaneously unset Status in “libreoffice” package in Ubuntu: Incomplete Bug description: When attempting to set relations between three tables: table 3 primary key is unset after opening Relations window (after being set in Design View). Setting relation between tables 1 and 2 works, but yields error message (would have pasted it here, but it was in an alert window that went away and I can't find LibreOffice's error log if one exists) having to do with mismatch between field types (both are SmallInt). Relation apparently set anyway: 1:n line drawn as expected in Relations window. Relation between tables 1 and 3 fails due to table 3's lack of primary key. On closing the Relations window, chose "No" at prompt to save relations. Back in Design View, reset table 3's primary key. On returning to Relations window, table 3 primary key unset again, and relation between tables 1 and 2 persists despite choosing "No" at the aforementioned dialog. Repeated this process 3 times with identical result. ProblemType: Bug DistroRelease: Ubuntu 11.04 Package: libreoffice-base 1:3.3.4-0ubuntu1 ProcVersionSignature: Ubuntu 2.6.38-13.57-generic 2.6.38.8 Uname: Linux 2.6.38-13-generic x86_64 NonfreeKernelModules: nvidia Architecture: amd64 CheckboxSubmission: 71dcdffc611aa0b506f8503de91b9e83 CheckboxSystem: edda5d4f616ca792bf437989cb597002 Date: Mon Mar 12 08:08:57 2012 EcryptfsInUse: Yes InstallationMedia: Ubuntu 10.04 LTS "Lucid Lynx" - Release amd64 (20100429) ProcEnviron: LANGUAGE=en_US:en LANG=en_US.UTF-8 SHELL=/bin/bash SourcePackage: libreoffice UpgradeStatus: Upgraded to natty on 2012-02-19 (21 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/953103/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
![http://static.fsf.org/nosvn/no-facebook-me.png"](http://static.fsf.org/nosvn/no-facebook-me.png"){kind=link}