[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 --- Comment #33 from Alex Thurgood --- (In reply to Lionel Elie Mamane from comment #32) > The slowness is the tccd process taking its sweet time, pumping CPU time. A > web search suggests this is a problem common to all / many applications > trying to access the address book, and a problem in MacOS X. What can I say, nice one Apple ! One more reason to use TB addressbook instead. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 --- Comment #32 from Lionel Elie Mamane --- The slowness is the tccd process taking its sweet time, pumping CPU time. A web search suggests this is a problem common to all / many applications trying to access the address book, and a problem in MacOS X. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 --- Comment #31 from Tony --- (In reply to Lionel Elie Mamane from comment #26) > With the kind help of a co-developer here at the hackfest, I could test on a > Mac. After applying my patch, and after correcting the field names to what > they are in the addressboox on the Mac we were testing on, it works. Closing > the bug. > > > Tony, I recommend that you use the "UID" field rather than "First" and > "Last" (name) as master/slave fields. Lionel, That would be the correct joice when starting with a new relational database, but unfortunatley there is no UID relation between the two existing ones and I alreay have hundreds of contacts, which were inherited from other sources. It would probably need some programming to get the existing UID field replaced with the MacAdressbook key or create a mapping table. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 --- Comment #30 from Alex Thurgood --- Performance is terrible on first opening of the form. >From the StartCenter, clicking on the preview of the form document to complete loading of the form takes 1 min 22s with Version: 4.5.0.0.alpha0+ Build ID: bfceafa67ed1cc3e4e03f8f214a2716f57b2d1e7 Locale: fr_ -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 Alex Thurgood changed: What|Removed |Added Blocks||89048 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 --- Comment #29 from Alex Thurgood --- Confirming that I finally got it to work too with commit. I had to change the lower grid control completely. Deleted and inserted a new one pointing to MacAddressbook.odb registered database. Altered data in TestAdressen.dob to correspond to the records in MacAb, and then it worked. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 --- Comment #28 from Commit Notification --- Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "libreoffice-4-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=81d5fd2d6556c65f1690876cc247568e2288897e&h=libreoffice-4-3 tdf#88814 parameters are kinda-partially supported, so follow the suggestion It will be available in 4.3.7. 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. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 Commit Notification changed: What|Removed |Added Whiteboard|target:4.5.0 target:4.4.1 |target:4.5.0 target:4.4.1 ||target:4.3.7 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 --- Comment #27 from Alex Thurgood --- An example of the slowness involved : Load TestAdressen.odt Switch to form design mode Click on upper grid control, right mouse button click, choose Form, and select Data tab. Then click on the ellipsis to choose the datasource. It takes LO a full minute to open the Finder dialog. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 Lionel Elie Mamane changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED Whiteboard| target:4.4.1 |target:4.5.0 target:4.4.1 --- Comment #26 from Lionel Elie Mamane --- With the kind help of a co-developer here at the hackfest, I could test on a Mac. After applying my patch, and after correcting the field names to what they are in the addressboox on the Mac we were testing on, it works. Closing the bug. Tony, I recommend that you use the "UID" field rather than "First" and "Last" (name) as master/slave fields. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 --- Comment #25 from Alex Thurgood --- Not sure whether due to change above, but the form has become approx 30 times slower to load - so much so that OSX app scheduler thinks that app has stopped responding. When the test form finally does open, no error message is displayed, but then neither is any data shown in the lower grid control, i.e. nothing is bound. Attempting to cycle through the records in upper form with the down arrow of the keyboard causes LO to SIGBART when it reaches the new record line of the grid. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 Commit Notification changed: What|Removed |Added Whiteboard|| target:4.4.1 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 --- Comment #24 from Commit Notification --- Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "libreoffice-4-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=291aa47b6039acb80472769362ce6dca14bd98cb&h=libreoffice-4-4 tdf#88814 parameters are kinda-partially supported, so follow the suggestion It will be available in 4.4.1. 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. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 --- Comment #23 from Alex Thurgood --- (In reply to Lionel Elie Mamane from comment #22) > Someone please test a recent-enough master build, and if it works I'll > backport to 4.4 and 4.3. > Will start a new build tonight and test tomorrow. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 Lionel Elie Mamane changed: What|Removed |Added Whiteboard| target:4.5.0 | --- Comment #22 from Lionel Elie Mamane --- This *may* be fixed by the commit I just made: http://cgit.freedesktop.org/libreoffice/core/commit/?id=d2a6d6a1a05337dbb733a9a3d4926a5c6d6cd8cd Someone please test a recent-enough master build, and if it works I'll backport to 4.4 and 4.3. Thanks in advance! -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 Commit Notification changed: What|Removed |Added Whiteboard|| target:4.5.0 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 --- Comment #21 from Commit Notification --- Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d2a6d6a1a05337dbb733a9a3d4926a5c6d6cd8cd tdf#88814 parameters are kinda-partially supported, so follow the suggestion It will be available in 4.5.0. 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. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 --- Comment #20 from Alex Thurgood --- (In reply to Tony from comment #19) > And why should it be possible using the Thunderbird address book but not the > Mac Contacts? I have no idea. At a guess, the drivers must behave differently - whether by design or by error. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 --- Comment #19 from Tony --- (In reply to Alex Thurgood from comment #16) > Surely this is because the subfrom references 3 data fields in the grid > control, whereas the links between the two data sources only reference 2 > fields ? If you would only be allowed to use fields, which are used for selection, what would be the added value of the subform? The idea of a subform linked to fields in a master form is to show additional information related to the selection. And why should it be possible using the Thunderbird address book but not the Mac Contacts? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 Alex Thurgood changed: What|Removed |Added Whiteboard|needsOSX| -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 --- Comment #18 from Alex Thurgood --- Created attachment 112953 --> https://bugs.documentfoundation.org/attachment.cgi?id=112953&action=edit full bt -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 --- Comment #17 from Alex Thurgood --- (lldb) c Process 14398 resuming warn:xmloff.core:14398:1:xmloff/source/core/xmlimp.cxx:932: exception caught warn:legacy.osl:14398:1:xmloff/source/core/xmlimp.cxx:933: caught an exception! in function:virtual void SvXMLImport::setTargetDocument(const uno::Reference &) type: com.sun.star.lang.NotInitializedException context: N8dbaccess17ODatabaseDocumentE warn:xmloff.core:14398:1:xmloff/source/core/xmlimp.cxx:932: exception caught warn:legacy.osl:14398:1:xmloff/source/core/xmlimp.cxx:933: caught an exception! in function:virtual void SvXMLImport::setTargetDocument(const uno::Reference &) type: com.sun.star.lang.NotInitializedException context: N8dbaccess17ODatabaseDocumentE warn:xmloff.core:14398:1:xmloff/source/core/xmlimp.cxx:932: exception caught warn:legacy.osl:14398:1:xmloff/source/core/xmlimp.cxx:933: caught an exception! in function:virtual void SvXMLImport::setTargetDocument(const uno::Reference &) type: com.sun.star.lang.NotInitializedException context: N8dbaccess17ODatabaseDocumentE warn:legacy.osl:14398:1:dbaccess/source/core/api/SingleSelectQueryComposer.cxx:846: OSingleSelectQueryComposer::getColumns: inconsistent column counts, this might result in wrong columns! warn:legacy.osl:14398:1:dbaccess/source/core/api/SingleSelectQueryComposer.cxx:846: OSingleSelectQueryComposer::getColumns: inconsistent column counts, this might result in wrong columns! warn:legacy.osl:14398:1:comphelper/source/misc/types.cxx:85: OSL_ASSERT: 0 warn:legacy.osl:14398:1:comphelper/source/misc/types.cxx:85: OSL_ASSERT: 0 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 --- Comment #16 from Alex Thurgood --- Surely this is because the subfrom references 3 data fields in the grid control, whereas the links between the two data sources only reference 2 fields ? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 Alex Thurgood changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #15 from Alex Thurgood --- Finally managed to reproduce the reported error, and can confirm the message : SQL Status: HY000 The count of the given parameter values doesn't match the parameters. on Version: 4.5.0.0.alpha0+ Build ID: c106f83da16726506962e19bcbc3d4c25415b81a Locale: fr_ -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 --- Comment #14 from Alex Thurgood --- (In reply to Lionel Elie Mamane from comment #12) > > Since you have a Mac, maybe you could check if this is specific to the MacAB > (Mac Address Book) driver or if it happens with some other address book > driver, too? Will take a look and see what I can / can't do with this on OSX. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88814] VIEWING: Subform linked to Mac Addressbook results in parameter count error
https://bugs.documentfoundation.org/show_bug.cgi?id=88814 Lionel Elie Mamane changed: What|Removed |Added Summary|VIEWING: Subform linked to |VIEWING: Subform linked to |Addressbook results in |Mac Addressbook results in |parameter count error |parameter count error -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
