At first I'm using the german version off OOo.
Open the designview to build a new table or query.
After building this new new table or query OOo(german) suggests as table/query
name "Tabelle1"/"Abfrage1" even if there is a table/query with this name.
When trying to save with this existing table/query name OOo crashes.
I've verified this happens also in the english version. Just using the names
"Table1" and "Query1"
One strange thing to me is: OOo suggests twice the same name "Table1" and
"Query1" when saving.
step-by-step description:
1. Start OpenOfficeBase
2. Create new data base
3. Create Table in Design View
4. Create Field Id (Text) as PrimaryKey
5. Close Table Design View
6. Save as suggested "Table1"
7. Create Query in Design View
8. Add "Table1" as source
9. Select "Id" as Field
10. Close Query Design View
11. Save as suggested "Query1"
12. Save Database as "Issue_96798.odb"
13. Create Query in Design View
14. Add "Table1" as source
15. Select "Id" as Field
16. Close Query Design View and save as suggested "Query1"
OOo crashes immediately
17. Start OpenOfficeBase
18. Recover "Issue_96798.odb"
19. Create Table in Design View
20. Create Field Id (Text) as PrimaryKey
21. Close Table Design View
22. Save as suggested "Table1"
OpenOffice stops working, just showing the hourglass.
see also http://qa.openoffice.org/issues/show_bug.cgi?id=96798
I knew there are not so much users of Base out there. But is there someone out there to confirm my observation?
3.0 final or 2.4.1?
Paid for Software more or less?
What You need is OSS!
I'm using the OOO300m9 (Build:9358) Version. I beleave it's 3.0 final.
... but can not reproduce the issue.
If I try to save the second query as query1 8step 16) I get a hint that this query still exists and that it can not be saved with the name of an existing query.
Whats Your local Java R(untime) E(nvironment) version?
Paid for Software more or less?
What You need is OSS!
Hi Marko,
I'm using jdk 1.5_XX.
I've just tried again with a newly downloaded english version of OpenOfficePortable and the error still occurs. An example database I've stored in:
http://rapidshare.com/files/186491322/Error.odb.htm
Step by step description first Error:
1. Open Error.odb
2. Change to Queries
3. Create Query in Design View
4. Add Table1
5. Close "Add window"
6. Double click "id"
7. Close Design Window
8. Answer the question to save the changed query with "Yes"
In my version I see now as suggested name "Query1". Even though there is an existing Query with this name.
9. Click the "Ok" Button
OpenOffice crashes!
See: http://rapidshare.com/files/186498582/OpenOfficeError.jpg.html
I have the exact message as Marko which is just a warning that it already exists. I'd wager this is an issue with your using an outdated JDK. Please upgrade to 1.6 and the issue will go away. Java 1.5 was end of lifed and is no longer supported ("The products available here have completed the Sun EOL process and are no longer supported under standard support contracts.").
Sometimes, the impossible can become possible, if you're awesome!
I've just tried java 1.6_11 and it does not crash. Even though the application suggests an existing name for a query or table.