Hello again. I still don't know what it is I did wrong, but I suspect this may be an error on my part as opposed to a bug in LibreOffice. I've deleted the problem table and rebuilt it, and now things seem to be working correctly.
On Mon, Apr 2, 2012 at 8:55 PM, Andrew Kane <[email protected]> wrote: > 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> > -- <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> -- 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}