Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Base crashes with macro autoexec|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||REOPENED ---||QA Contact:|
|Priority:||P5 (lowest)||CC:||damien.gerard, jean-pierre.cornille1, jim, michelwv, mjd535, mseidel, oooforum, pats, petko, wave|
|Issue Type:||DEFECT||Latest Confirmation in:||4.1.7|
Description charlie.it 2018-01-06 21:04:38 UTC
Created attachment 86312 [details] Database with macro autoexec Can anyone test this macro inserted as autoexec in a Base file? With version 4.1.5 on Mac, it crashes Base at each boot. With version 4.1.3 on Mac it works regularly. With version 4.1.5 on Windows 7 it works regularly. With version 4.1.5 for on Linux (Ubuntu 64 bit) it works regularly. REM ***** BASIC ***** Sub autoexec Dim InteractionHandler As Object InteractionHandler = createUnoService("com.sun.star.sdb.InteractionHandler") ThisDatabaseDocument.CurrentController.connect("","") ThisDatabaseDocument.FormDocuments.getByName ( "Formulario1" ).open End Sub
Comment 1 charlie.it 2018-01-08 17:49:03 UTC
I confirm the issue also on Mac 4.1.4.
Comment 2 Peter 2018-01-08 20:50:39 UTC
What is your setup? Empty file? Have you content?
Comment 3 charlie.it 2018-01-09 07:26:07 UTC
(In reply to Peter from comment #2) > What is your setup? > Empty file? Have you content? It is not a problem of database content or set up, but it happens if in Tools > Customize > Events > Open document there is an autoexec macro that opens a form automatically. It happens also with this macro (that isn't mine, I found it in AOO Italian Forum): REM ***** BASIC ***** Sub AutoExec On Error Goto HandleError Dim LastFrame As Object Dim NumFrames As Integer Static FormDocs As Object Dim DBDoc As Object Dim ImpName As String Dim DataSource As Object Dim Conn As Object Dim Args(1) As New com.sun.star.beans.PropertyValue Dim FormName As String Dim FormDoc As Object FormName="Riepilogo" REM CHANGE TO YOUR FORM NAME ImpName="com.sun.star.comp.dba.ODatabaseDocument" NumFrames=StarDesktop.Frames.Count LastFrame=StarDesktop.Frames.getByIndex(NumFrames-1) If LastFrame.Frames.Count>1 Then Exit Sub End If If Not (LastFrame.Controller.Model.ImplementationName=ImpName) Then Exit Sub REM not a db doc End If DataSource=LastFrame.Controller.DataSource DBDoc=DataSource.DatabaseDocument FormDocs=DBDoc.FormDocuments Conn=DataSource.getConnection("","") REM no user/password Args(0).Name="ActiveConnection" : Args(0).Value=Conn if FormDocs.hasByName(FormName) Then FormDoc=FormDocs.loadComponentFromURL(FormName,"_self",2,Args() ) FormDoc.CurrentController.Frame.ContainerWindow.setFocus() End If HandleError: If Err<>0 Then Exit Sub End If End Sub
Comment 4 charlie.it 2018-01-09 07:28:34 UTC
Created attachment 86314 [details] Another file with autoexec macro
Comment 5 Peter 2018-01-09 07:48:26 UTC
I don't get you. Is the form the macro is looking for available or not? I do not think it is a problem of autostart but of condition that the document does not provide the information it is looking for. However it should not crash. Please let's focus on your script first. Then we can check if the other scripts are the same issue or another one.
Comment 6 charlie.it 2018-01-09 08:13:27 UTC
(In reply to Peter from comment #5) > I don't get you. Is the form the macro is looking for available or not? > > I do not think it is a problem of autostart but of condition that the > document does not provide the information it is looking for. > However it should not crash. > > Please let's focus on your script first. Then we can check if the other > scripts are the same issue or another one. It is not a script problem (see my second attach, different from the first). The searched form is always available. I repeat that only with AOO 4.1.5 and 4.1.4 on Mac (Sierra 10.12.6 is my o.s.)an autoexec macro registered in Tools > Customize > Events > Open document causes Open Office to crash on startup. The same files with the same macros works well with Mac AOO 4.1.3 (yes 4.1.3). The same files with the same macros works well with Windows 7 AOO 4.1.5. The same files with the same macros works well with Linus AOO 4.1.5. Did you try my files on your o.s.? Which is your o.s.? Thanks.
Comment 7 Patricia Shanahan 2018-01-09 10:09:50 UTC
One of the types of change between 4.1.3 and 4.1.4 is to add throw an exception if parsing certain forms of corrupt input file that could cause access beyond allocated memory. An over-detection error in that code could cause crashes in 4.1.4 and 4.1.5 on files that are accepted in 4.1.3 and earlier. However, it is in code that is used for all operating systems, so if it were that I would expect 4.1.5 to crash on Windows and Linux as well as Mac.
Comment 8 oooforum (fr) 2018-01-09 17:29:30 UTC
Confirmed by users on french forum This regression is MacOS system only
Comment 9 charlie.it 2018-01-10 14:51:00 UTC
Information from the French AOO forum: the problem is confirmed with High Sierra 10.13.2; instead it does not happen with El Capitan 10.11.x.
Comment 10 charlie.it 2018-01-10 14:53:12 UTC
But El Capitan is an old o.s. ....
Comment 11 Dave Fisher 2018-01-10 16:16:08 UTC
Created attachment 86315 [details] Crash on macOS 10.12.6 Macro security is Medium. JRE is Oracle 1.8.0_151
Comment 12 oooforum (fr) 2018-04-09 07:29:38 UTC
Everybody that reported this issue could to test future 4.2.0 dev-build? http://home.apache.org/~jim/AOO-builds/4.3.0-dev-r1827250/ And give feedback about it.
Comment 13 tintin60 2018-04-09 08:17:58 UTC
Hi, Just tested a data base filed on the french forum : https://forum.openoffice.org/fr/forum/viewtopic.php?p=310906#p310906 After opening and macros enabling, OpenOffice 4.2 crashes. Without macros enabling : no crash. Regards
Comment 14 CrazyDams 2018-09-21 11:53:54 UTC
Is there something new about this problem ? It's a big trouble for mac users...
Comment 15 Peter 2018-09-21 20:06:30 UTC
I am sorry, not that I know of. I will have a look in the next 2 weeks. But I am learner. So don't expect to much
Comment 16 CrazyDams 2018-09-24 06:31:14 UTC
Thanks Peter, I hope you will success
Comment 17 charlie.it 2018-11-01 09:07:33 UTC
Also in development version 4.1.6 the problem remains
Comment 18 Peter 2018-11-01 09:44:48 UTC
we did not fix anything in this direction. So no surprise that there is no change. This issue needs more deeper analysis.
Comment 19 charlie.it 2018-11-11 14:28:37 UTC
Unfortunately I have to confirm this issue with v. 4.1.6 RC1 (osMac 10.12.6)
Comment 20 tintin60 2018-11-20 08:54:29 UTC
Hi, Problem remains with 4.1.6 final (MacOS 10.13.6) Rgds
Comment 21 Jim Jagielski 2019-01-31 14:29:12 UTC
Is there any other info available other than it crashes? Is there a log in ~/Library/Logs/CrashReporter or ~/Library/Logs/DiagnosticReports
Comment 22 charlie.it 2019-02-01 06:42:04 UTC
Created attachment 86631 [details] Crash automatic report
Comment 23 charlie.it 2019-02-01 06:43:01 UTC
(In reply to Jim Jagielski from comment #21) > Is there any other info available other than it crashes? Is there a log in > ~/Library/Logs/CrashReporter or ~/Library/Logs/DiagnosticReports I attached a report
Comment 24 jpc4 2019-02-03 10:47:34 UTC
Thanks for the efforts for solving this issue, preventing the update of Java software... jpc4
Comment 25 Marcus 2019-10-12 17:35:29 UTC
Closing as fixed due to ommment #24
Comment 26 jpc4 2019-10-13 19:56:32 UTC
Sorry to contradict comment#25 : to my knowledge, the problem is not fixed. My comment #24 has been misunderstood, probably due to my poor english. I wanted to say : thanks in advance to those who will solve this issue, which actually prevents to update Java :-( jpc4
Comment 27 Matthias Seidel 2019-10-13 22:49:46 UTC
Reopened according to comment #26. Can you try with AOO 4.1.7? Some code for Java detection was changed, but I doubt that it fixes the problem. In which way does this issue prevent you from updating Java?
Comment 28 jpc4 2019-10-14 12:22:14 UTC
Maybe the 2 issues are not linked. Regarding Java, there is a notification on the document attached to the release of AOO 4.1.7 informing of a well-know bug : attached screenshot. /Users/JPC/Desktop/Capture d’écran 2019-10-14 à 14.09.36.png I have downloaded AOO 4.1.7 and will try it. I'll keep you informed.
Comment 29 jpc4 2019-10-14 12:25:10 UTC
Created attachment 86749 [details] Screenshot Notification concerning a Java bug on macOS system.
Comment 30 tintin60 2019-10-14 12:53:08 UTC
Hi, Config : AOO 4.1.7 / macOS 10.15. / JDK 8-u201 + JRE 8u-221 I checked the document joined by charlie.it on 2018_01_06 21:04:38 (first post) with all AOO and OS versions since 10.13.6. 10.14.1,2,3,4,5,6 until 10.15 today. No change : No macros : no crash. With macros : crash For your information : Same results on LibO Regards
Comment 31 jpc4 2019-10-14 13:06:19 UTC
Tested with AOO 4.1.7 os 10.14.6 (Mojave) : crash confirmed with macros.
Comment 32 Matthias Seidel 2019-10-14 16:18:15 UTC
(In reply to jpc4 from comment #29) > Created attachment 86749 [details] > Screenshot > > Notification concerning a Java bug on macOS system. Thanks, but my French is not good enough to understand the translation. ;-) Looking at the English Release Notes, there is nothing that speaks against updating Java. Some people might need to install legacy Java 6 additionally, some people reported that even Java 11 was detected without a problem. BTW: AOO 4.1.7 can now use AdoptOpenJDK  It would be nice if someone could test it on macOS.  https://adoptopenjdk.net/releases.html?variant=openjdk8&jvmVariant=hotspot#x64_mac
Comment 33 jpc4 2019-10-14 16:58:15 UTC
It seems that the Java bug notified on the french release of AOO has been solved since I could install its last update (Java 8_221), while my data base on AOO 4.1.3 with macro autoexec still works. But crash with AOO 4.1.7 as mentioned earlier.
Comment 34 charlie.it 2019-10-15 09:51:43 UTC
I confirm that my attached file causes crash with macOS (Sierra 10.12.6) version AOO 4.1.7 - Java 8_221. Regards.
Comment 35 oooforum (fr) 2019-12-27 07:46:37 UTC
*** Issue 128248 has been marked as a duplicate of this issue. ***
Comment 36 tintin60 2019-12-27 10:34:44 UTC
Hi, No change with macOS 10.15.2 and Adoptopenjdk-8jre / 1.8.0_232 Rgds
Comment 37 Mikelkel 2019-12-27 11:29:22 UTC
(In reply to tintin60 from comment #36) > Hi, > > No change with macOS 10.15.2 and Adoptopenjdk-8jre / 1.8.0_232 > > Rgds Confirmed, same try, failed. Had to go back to OO 4.1.3
Comment 38 oooforum (fr) 2020-05-18 13:57:53 UTC
Confirmed with 4.2.0-DEV: still occurs.