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 Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/953103 Title: Can't set relations, primary key spontaneously unset To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/953103/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
![http://static.fsf.org/nosvn/no-facebook-me.png"](http://static.fsf.org/nosvn/no-facebook-me.png"){kind=link}