[Bug 557493] New: Defining relationships in OOo does not work correctly

older
[Bug 581650] New: "You can only...

bugzilla_noreply＠novell.com

21 Nov 2009 21 Nov '09

01:45

http://bugzilla.novell.com/show_bug.cgi?id=557493 http://bugzilla.novell.com/show_bug.cgi?id=557493#c0 Summary: Defining relationships in OOo does not work correctly Classification: openSUSE Product: openSUSE 11.2 Version: Final Platform: i586 OS/Version: openSUSE 11.2 Status: NEW Severity: Normal Priority: P5 - None Component: OpenOffice.org AssignedTo: bnc-team-ooo@forge.provo.novell.com ReportedBy: nicari12@yahoo.co.uk QAContact: cwei@novell.com Found By: --- Blocker: --- User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-GB; rv:1.9.1.4) Gecko/20091016 SUSE/3.5.4-1.1.2 Firefox/3.5.4 A relationship between two tables can not be properly defined. This is true both when pre-defining the relationship, and also when defining the relationship manually during the creation of a form by means of the wizzard. Reproducible: Always Steps to Reproduce: 1.Use Wizzard to create form 2.On Form Wizzard select table and columns 3.Select Add Sub-form and Sub-form based on manual selection of fields 4.Click Next and select fields for the main-form 5.Click Next -- This is the end. It hangs permanently, only the kill command can bring OOo down. Please note: Defining the relationship of two tables before creating the table does also not work. 1.Select Database-Tables 2.Tools > Relationships 3.Add the two tables 4.Click <New Relation> 5.Select the Main-Table and the Primary key 6.Select the Sub-Table and the related key column 7.A Relationship line 1:n may or may not appear, but it does not point to the selected fields. 8.Re-clicking the relationship icon shows the two tables, but the column fields are empty. i.e. no proper relationship has been defined. Actual Results: The first set: The system hangs and OOo has to be killed The second set: No correct relationship has been defined Expected Results: Relationships should have been defined properly. Computer: Toshiba Laptop Satellite A100, 32bit Operating System openSUSE 11.2 final OOo was either installed from the DVD or downloaded from the normal repository. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

Show replies by date

bugzilla_noreply＠novell.com

21 Nov 21 Nov

01:50

New subject: [Bug 557493] Defining relationships in OOo does not work correctly

http://bugzilla.novell.com/show_bug.cgi?id=557493 http://bugzilla.novell.com/show_bug.cgi?id=557493#c1 --- Comment #1 from Egbert Eissing 2009-11-21 01:50:32 UTC --- correction: the headline of the second set "before creating the table" should read "before creating the form" -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

23 Nov 23 Nov

06:27

New subject: [Bug 557493] Defining relationships in OOo does not work correctly

http://bugzilla.novell.com/show_bug.cgi?id=557493 http://bugzilla.novell.com/show_bug.cgi?id=557493#c Egbert Eissing changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|Normal |Critical -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

24 Nov 24 Nov

08:01

New subject: [Bug 557493] Defining relationships in OOo does not work correctly

http://bugzilla.novell.com/show_bug.cgi?id=557493 http://bugzilla.novell.com/show_bug.cgi?id=557493#c2 --- Comment #2 from Egbert Eissing 2009-11-24 08:01:35 UTC --- I tested this bug also with the Gnome desktop. The behaviour is exactly the same as with KDE4. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

8 Dec 8 Dec

15:38

New subject: [Bug 557493] Defining relationships in OOo does not work correctly

http://bugzilla.novell.com/show_bug.cgi?id=557493 http://bugzilla.novell.com/show_bug.cgi?id=557493#c5 Noel Power changed: What |Removed |Added ---------------------------------------------------------------------------- AssignedTo|nopower@novell.com |bnc-team-ooo@forge.provo.no | |vell.com --- Comment #5 from Noel Power 2009-12-08 15:38:42 GMT --- back to list -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

9 Dec 9 Dec

23:27

New subject: [Bug 557493] Defining relationships in OOo does not work correctly

http://bugzilla.novell.com/show_bug.cgi?id=557493 http://bugzilla.novell.com/show_bug.cgi?id=557493#c6 Kohei Yoshida changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |kyoshida@novell.com --- Comment #6 from Kohei Yoshida 2009-12-09 23:27:39 UTC --- Ok. This bug report contains two separate bugs. Let's focus on the 2nd bug in this report since the 1st one is being worked on in a separate (unfortunately private) bug. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

10 Dec 10 Dec

00:09

New subject: [Bug 557493] Defining relationships in OOo does not work correctly

http://bugzilla.novell.com/show_bug.cgi?id=557493 http://bugzilla.novell.com/show_bug.cgi?id=557493#c7 Kohei Yoshida changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO Info Provider| |nicari12@yahoo.co.uk --- Comment #7 from Kohei Yoshida 2009-12-10 00:09:23 UTC --- Egbert, could you attach a test Base file that exhibits the problem? I made my own test Base file and created a new relation, but I was able to create a correct relation, and 1:n line is displayed correctly. So, I need an actual file that can reproduce the problem. Thanks. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

14 Dec 14 Dec

07:09

New subject: [Bug 557493] Defining relationships in OOo does not work correctly

http://bugzilla.novell.com/show_bug.cgi?id=557493 http://bugzilla.novell.com/show_bug.cgi?id=557493#c8 Egbert Eissing changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW CC| |nicari12@yahoo.co.uk Info Provider|nicari12@yahoo.co.uk | --- Comment #8 from Egbert Eissing 2009-12-14 07:09:42 UTC --- Sorry for the delay! I had openSUSE de-installed to test something else. Now I am back in action. The problem is obviously one that occurs only if an external database is being accessed and two or more related tables are to be referenced simultaneously in a query or form. I am attaching two base files. Base file 'Automobiles': This was created with a previous version of openSUSE, probably version 11.2-RC1. following the instructions in the tutorial. It worked then. Now, in order to test against this final release, I created two tables and a query 'CompanyContact' from them, using the QueryDesiner. It worked fine. Please note: The database is the internal database of openOffice. Base file 'hildy': Both query and form "CompanyContact' were created when running version 11.2-RC1. It worked then very well, and I can still access these without problem. To test again now, I created query "cost_con" from a single table. This worked fine. Any attempt to create a query from two related tables failed, openOffice simply crashed without leaving a trace. In this case, I am attached to a mySQL database on an external server, which runs on our company LAN. I hope this helps, though it lacks the data from the LAN server, and there is probably no trace of any of the attempts to create a query with related tables. Let me know if I can be of any additional help. Regards, Egbert -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

09:37

New subject: [Bug 557493] Defining relationships in OOo does not work correctly

http://bugzilla.novell.com/show_bug.cgi?id=557493 http://bugzilla.novell.com/show_bug.cgi?id=557493#c9 Noel Power changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO CC| |nopower@novell.com Info Provider| |nicari12@yahoo.co.uk --- Comment #9 from Noel Power 2009-12-14 09:37:33 GMT --- please try to get a) output from the soffice program ( e.g. just run soffice from a shell and redirect output to a file ) please make sure that no soffice processes are already running ( e.g. do a pkill -9 soffice ). then in a terminal soffice [options] > ~/soffice.out 2>&1 b) please try and get a stack trace after the crash for information on above please see http://en.opensuse.org/Bugs:OOo -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

15 Dec 15 Dec

07:38

New subject: [Bug 557493] Defining relationships in OOo does not work correctly

http://bugzilla.novell.com/show_bug.cgi?id=557493 http://bugzilla.novell.com/show_bug.cgi?id=557493#c10 Egbert Eissing changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW Info Provider|nicari12@yahoo.co.uk | --- Comment #10 from Egbert Eissing 2009-12-15 07:38:36 UTC --- Created an attachment (id=332594) --> (http://bugzilla.novell.com/attachment.cgi?id=332594) output file from soffice start until crash in base I also tried to make a stack trace log file, but the logfile grew bigger, yet the application oooffice never started up and therefor probably no useful information here. But if this is still useful to you, please let me know. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

07:41

New subject: [Bug 557493] Defining relationships in OOo does not work correctly

http://bugzilla.novell.com/show_bug.cgi?id=557493 http://bugzilla.novell.com/show_bug.cgi?id=557493#c11 --- Comment #11 from Egbert Eissing 2009-12-15 07:41:18 UTC --- Created an attachment (id=332595) --> (http://bugzilla.novell.com/attachment.cgi?id=332595) stack trace log file The open office never started up when trying to create this log file. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

09:15

New subject: [Bug 557493] Defining relationships in OOo does not work correctly

http://bugzilla.novell.com/show_bug.cgi?id=557493 http://bugzilla.novell.com/show_bug.cgi?id=557493#c12 Noel Power changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO Info Provider| |nicari12@yahoo.co.uk --- Comment #12 from Noel Power 2009-12-15 09:15:07 GMT --- looks like a know kde4 integration issue, to check can you see if removing the kde package OpenOffice_org-kde4-1.1.4.ixxx ( and making sure that the libvclplug_kdeli.so ( from /usr/lib[64]/ooo3/basis3.1/program directory ) ) is also removed fixes the problem ? -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

16 Dec 16 Dec

07:53

New subject: [Bug 557493] Defining relationships in OOo does not work correctly

http://bugzilla.novell.com/show_bug.cgi?id=557493 http://bugzilla.novell.com/show_bug.cgi?id=557493#c13 --- Comment #13 from Egbert Eissing 2009-12-16 07:53:09 UTC --- (In reply to comment #12)

...

looks like a know kde4 integration issue, to check can you see if removing the kde package OpenOffice_org-kde4-1.1.4.ixxx ( and making sure that the libvclplug_kdeli.so ( from /usr/lib[64]/ooo3/basis3.1/program directory ) ) is also removed fixes the problem ?

Thanks for your suggestion. I did remouve OpenOffice_org-kde4 and libvclplug_kdeli.so, but there was no change in the behaviour. When I make a query with two related mySQL tables, the application crashes. Egbert -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

09:05

New subject: [Bug 557493] Defining relationships in OOo does not work correctly

http://bugzilla.novell.com/show_bug.cgi?id=557493 http://bugzilla.novell.com/show_bug.cgi?id=557493#c14 --- Comment #14 from Noel Power 2009-12-16 09:05:56 GMT --- does /usr/lib[64]/ooo3/basis3.1/program/libvclplug_kde4lx.so still exist try removing that also and try again if it still crashes please try again to get a backtrace, if you still can't get a backtrace start gdb without the 'tee' command so at least you can see what message is emitted by the debugger to tell why 'run' fails to start the office process -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

11 Jan 11 Jan

20:49

New subject: [Bug 557493] Defining relationships in OOo does not work correctly

http://bugzilla.novell.com/show_bug.cgi?id=557493 http://bugzilla.novell.com/show_bug.cgi?id=557493#c15 Petr Mladek changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |pmladek@novell.com --- Comment #15 from Petr Mladek 2010-01-11 20:49:05 UTC --- The QT messages from the comment #10 look similar to the bug #548354 It really might help to remove the /usr/lib[64]/ooo3/basis3.1/program/libvclplug_kde4lx.so file. Please note the "kde" vs. "kde4". Noel and you mentioned the wrong "kde" in the comment #12 and comment #14 Does it help you to remove libvclplug_kde4lx.so? -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

22 Feb 22 Feb

12:49

New subject: [Bug 557493] Defining relationships in OOo does not work correctly

http://bugzilla.novell.com/show_bug.cgi?id=557493 http://bugzilla.novell.com/show_bug.cgi?id=557493#c16 Jan Holesovsky changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |RESOLVED CC| |kendy@novell.com Info Provider|nicari12@yahoo.co.uk | Resolution| |DUPLICATE --- Comment #16 from Jan Holesovsky 2010-02-22 12:49:37 UTC --- I suppose this is a duplicate, as mentioned above. If you are still seeing the problem even with the fixed version of OOo, please reopen this bug. Thank you! *** This bug has been marked as a duplicate of bug 548354 *** http://bugzilla.novell.com/show_bug.cgi?id=548354 -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

5184

Age (days ago)

5277

Last active (days ago)

List overview

Download

15 comments

1 participants

participants (1)

bugzilla_noreply＠novell.com

[Bug 557493] New: Defining relationships in OOo does not work correctly

tags

participants (1)