Apache OpenOffice (AOO) Bugzilla – Issue 123157
CRASH when Exiting "Design mode" in form with SQL database connection
Last modified: 2014-03-25 16:14:53 UTC
Created attachment 81425 [details] Exit draft mode, OpenOffice crashes 1. Open the attached document. It is a simple form, with a drop-down list taking values in the "biblio" database (from the "author" filed). "Draft mode" is set to on. 2. Close Draft mode. 3. OpenOffice crashes. Crash: OpenOffice 4.0 Italian, Linux 64 bit RPM.
Reproducible with "AOO 4.1.0-Dev – English UI / German locale - [AOO410m1(Build:9750) - Rev. 1516435 2013-08-24]" on German WIN7 Home Premium (64bit)", own separate user profile: 1. Open attachment from AOO Start center 2. Menu 'View -> Toolbars -> Form Controls' to make toolbar visible if necessary 3. Click 'Design Mode' in Toolbar CRASH a) Already Reproducible with * server installation of " AOO 4.0.0-Dev – English UI / German locale [AOO400m1(Build:9700) - Rev. 1457992 - Rev.1457606]" on German WIN7 Home Premium (64bit)", own separate user profile * 3.4.0 b) Was still ok with 2.0.2. 3.3.0, so rather old REGRESSION c) currently I can't imagine what in the particular document causes the crash
Reason for the crash is in control field "data" SQL query: 'SELECT DISTINCT "Author" FROM "biblio"'. After deletion of that control field contents and saved, closed and reopened document no longer will crash. Copy / paste of that contents will cause the crash again.
Query string "SELECT DISTINCT "Author"" does not cause the crash in a new document, but "SELECT DISTINCT "Author" FROM "biblio"" also will cause a crash in a newly created document with list box
It is the query that crashes. Open the Bibliographic database Create the following query in SQL view: SELECT DISTINCT "Author" FROM "biblio" Execute the query Crash No Writer bug.
*** Issue 124507 has been marked as a duplicate of this issue. ***