Apache OpenOffice (AOO) Bugzilla – Issue 9645
crash using database fields insertion dialog
Last modified: 2006-05-31 14:29:06 UTC
I was using OOCalc as a database by filling rows. I opened a read only letter and saved it as a new OOWriter document. I tried to insert a mailing field from my previous database. I used the menu 'insertion'->'champ'->'autres' (french) and got the frame named 'Champs'. I selected the 'Base de données' tab. I selected the 'Enregistrement suivant' as a 'type de champs'. Then I double clicked on a query of my database and OOCalc and OOWriter crashed. I reproduce it always. Sometimes the following message is logged in console: Segmentation fault sometimes nothing is dumped.
Sophia, thank you for using and supporting OOo. Please attach the files required to reproduce this issue. This is what I've translated from your instructions so far. 1. Create a Bibliography DB using Calc. 2. Insert->Field->Other 3. Go to the Database tab 4. Select Next Record in the Type field. 5. Click Insert. I tried creating a simple Calc file and used it as a data source in OOo 643c and OOo 1.0.1. I am unable to reproduce the problem. However, I'm not clear on the steps I need to take.
6. open my database tree 7. double click on a query leaf I could reproduce it.
Created attachment 3847 [details] OOCalc database
Created attachment 3848 [details] OOWriter document where I want to insert a field
Thanks for the attachments and update Sophia. I must be doing something different. Unable to duplicate on OOo 1.0.1 and OOo 643c.
Did you create a query ? I used the following query to produce the bug: SELECT "Lettre candidature", "Civilité", "DRH", "Raison sociale", "Adresse1", "Adresse2", "CP", "Ville", "Cedex" FROM "liste organismes" "liste_organismes" WHERE ( ( "DRH" <> '' ) ) Once you created this query in the database node (menu 'affichage'->'sources de données'), then you have the double click as previously described on this query in the 'Champs' frame (verify you selected at first 'next record'). I think this problem is not only for this query because I produced the bug with other queries too.
Sophia, thanks for your continued patience. I just want to make it clear, you are doing fine, I just am having issues on my side. I think I've reproduced the issue on 1.0.1. 643c does not crash. 1. Add "organismes.sxc" as a Data Source. 2. Create a query using the SQL provided by Sophia. Note I removed the double instance of "liste organismes" from the query because I think that was a typo. 3. Insert->Fields->Other 4. Go to Database tab. 5. Choose "Next Record" as Type. 6. Choose the query that was entered in step 2. 7. Double click on "Next Record" or click on Insert. OOo should crash at this point. Duplicated on RH 8.0, RH OOo 1.0.1. Unable to duplicate on Win2K server SP3, OOo 643c. Unable to duplicate on RH 8.0, OOo 643c.
procedure diff: c < 6. Choose the query that was entered in step 2. --- > 6. Double click on the query that was entered in step 2. d < Double click on "Next Record" or click on Insert. The bug appear on step 6.
Fixed in a src643C
closing
change subcomponent to 'none'