You are here

OOo crashes when trying to save a query or table with existing name

8 posts / 0 new
Last post
Parmenion
Offline
Last seen: 6 years 7 months ago
Joined: 2008-05-06 16:07
OOo crashes when trying to save a query or table with existing name

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

Parmenion
Offline
Last seen: 6 years 7 months ago
Joined: 2008-05-06 16:07
Does anyone except me uses OpenOffice Base?

I knew there are not so much users of Base out there. But is there someone out there to confirm my observation?

MarkoMLM
MarkoMLM's picture
Offline
Last seen: 5 years 11 months ago
DeveloperTranslator
Joined: 2006-01-16 04:08
Wich version did You use?

3.0 final or 2.4.1?

Paid for Software more or less?
What You need is OSS!

Parmenion
Offline
Last seen: 6 years 7 months ago
Joined: 2008-05-06 16:07
OOO300m9 (Build:9358)

I'm using the OOO300m9 (Build:9358) Version. I beleave it's 3.0 final.

MarkoMLM
MarkoMLM's picture
Offline
Last seen: 5 years 11 months ago
DeveloperTranslator
Joined: 2006-01-16 04:08
I've followed Your step by step description ...

... 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!

Parmenion
Offline
Last seen: 6 years 7 months ago
Joined: 2008-05-06 16:07
Tyred ones again.

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

John T. Haller
John T. Haller's picture
Online
Last seen: 55 min 30 sec ago
AdminDeveloperModerator
Joined: 2005-11-28 22:21
Java Issue

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!

Parmenion
Offline
Last seen: 6 years 7 months ago
Joined: 2008-05-06 16:07
Your right!!

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.

Log in or register to post comments