[dba-issues] [Issue 114665] Occasional hang and crash when editing text data in Base forms
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114665 Issue #|114665 Summary|Occasional hang and crash when editing text data in Ba |se forms Component|Database access Version|OOo 3.2.1 Platform|Macintosh URL| OS/Version|Mac OS X, 10.5 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ameliab --- Additional comments from amel...@openoffice.org Wed Sep 22 00:51:16 + 2010 --- On at least three occasions now, OpenOffice has crashed after an extended hang (presumably an infinite loop type issue) while I have been editing text data in a Base form. The Base file uses an embedded HSQL DB. I can't reliably recreate the issue, but when it has occurred it happens after copying text into the form from another document or application, then trying to edit the copied text in the form. The data being copied is plain text and is not of unusual size. In today's case it was being copied from a Writer file. I know that's a horrendously vague description, but it is particularly annoying since it generally results in significant loss of data because of not having any easy way to backup or ability to recover the embedded DB. (I know -- it's easy to say don't use the embedded DB; but a major reason I chose OO for this project was the ability to easily transfer the work between different computers and users in one convenient file. I have warned the other users to manually back up the file (using Save As) frequently, but apparently forgot to take my own advice!) I am attaching the stack trace from Mac OS's crash report just in case an ambitious developer wants to investigate. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 114665] Occasional hang and crash when editing text data in Base forms
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114665 --- Additional comments from amel...@openoffice.org Wed Sep 22 00:57:23 + 2010 --- Created an attachment (id=71797) Crash report / stack trace, as generated by Mac OS - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 111775] [MAC OSX] Can't paste to Base form text field via menu
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111775 --- Additional comments from amel...@openoffice.org Tue Sep 14 14:57:26 + 2010 --- re: fs's comment The problem seems to be specific to Base forms, and as msc comments above, controls that are tied to a database field. I was also able to paste (using Command-V) into a textbox created in Writer, but not in Base forms. (Using OO 3.2.1 on Mac OSX 10.5.8) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 114333] Data source as Table fu nction in Base forms causes form to refresh, d iscarding data
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114333 Issue #|114333 Summary|Data source as Table function in Base forms causes f |orm to refresh, discarding data Component|Database access Version|OOo 3.2.1 Platform|Macintosh URL| OS/Version|Mac OS X, 10.5 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ameliab --- Additional comments from amel...@openoffice.org Mon Sep 6 02:04:35 + 2010 --- This is a minor defect that's tripped me up enough times in the past few days to warrant a post. When using a form in Base to input data, if you click on the Data source as Table button when the form is half-filled out, all data entered into the form since the record was last saved is discarded. This button adds some very nice functionality -- shame that a minor problem is detracting from it! - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 114187] Cannot see/remove query s orts from order by statement in query view
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114187 --- Additional comments from amel...@openoffice.org Thu Sep 2 17:26:28 + 2010 --- quote: Do you say that the filter/sort buttons are enabled when viewing the *_DirectSQL queries? Or are those two paragraphs unrelated? As atjensen noted in a comment that unfortunately got appended to the wrong issue, the buttons are disabled if you run the query while in edit mode, but not if you just open the saved query. In that case, the buttons and dialogs can be used, they just don't have any effect. Although it would be ideal in the long wrong to enable sorts and filters on these results, in the short term at least it would be expected to have these buttons disabled if they aren't going to do anything. Similarly, in the case of queries run through the OO SQL parser, I would suggest that even if the user cannot *change* the original sort or filter stored in the query, they should be able to at least have some feedback to know what is going on. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 114187] Cannot see/remove query s orts from order by statement in query view
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114187 --- Additional comments from amel...@openoffice.org Thu Sep 2 17:35:21 + 2010 --- in the long *term* that should read. Not sure how Freud would interpret that slip! As for the long term, my first instinct is that it shouldn't be too complicated to implement it. Instead of sending a revised version of the original query (which OO wouldn't be able to do, since it isn't parsing the original query), OO could create a new query that selected from the original as a subquery -- SELECT * FROM (original query) WHERE (new filter conditions) ORDER BY (new sort order). You wouldn't be able to remove existing filter conditions, only filter amongst the results you have, but I think that is a reasonably intuitive behaviour. There's just one difficulty -- issue 114188 , at least when dealing with the embedded DB. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 114189] Base crashes when using f ilters / sorts on some query results with calc ulated boolean fields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114189 User ameliab changed the following: What|Old value |New value Status|RESOLVED |UNCONFIRMED Resolution|WORKSFORME| Summary|Base crashes when using qu|Base crashes when using fi |ery filters / sorts on col|lters / sorts on some quer |umns created by correlated|y results with calculated | subqueries |boolean fields --- Additional comments from amel...@openoffice.org Mon Aug 30 18:31:30 + 2010 --- The file I'd posted is definitely still crashing and/or hanging on Mac OSX for me. I re-downloaded to make sure the version saved on my computer wasn't corrupted, and got the exact same behaviour as yesterday. So... maybe an operating system-unique problem? Any other Mac users want to give it a try? *However*, I appear to have been wrong about what caused the crash. I tried reproducing it in another test database, and very similar queries work fine -- but then others crashed. After experimentation, I think I've narrowed it down to the boolean field that is causing crashes, rather than the correlated subqueries. Which is strange because I used two completely different ways of generating the boolean field (one using a boolean expression, the other casting from a number). The casting method (e.g., CAST(CAST(Random*2 AS Integer) AS Boolean) ), run through OO's SQL parser, results in crashes when I apply a filter to the boolean field (sorts are okay), but *only* if I also have the primary key in the query. (Note: these are neat crashes, where OO recovers itself without having to be relaunched from the operating system) The same query sent directly to the embedded HSQL DB, does not cause any crashing when I try to sort/filter the results, although sorts and filters have no effect (as noted in issue 114187). The alternate method, using a boolean expression as a column definition (e.g. SELECT Random = 0.5 as MoreThanHalf), is not acceptable to OpenOffice's SQL parser. When the query is sent directly to the HSQL DB, any attempt to apply a filter or sort on the results either causes a complete crash of OpenOffice or (in one case that I then couldn't reproduce) an indefinite hang. I've changed the title of this issue to correspond to this new understanding, and I'll attach my new file. In the file, I've again got one table with just a list of random numbers and an auto-generated primary key for each. All the queries are based directly on this table. Each query name clearly indicates: (1) whether it is sent directly to the embedded database (DirectQuery) or through the OpenOffice parser (Query); (2) What values it selects: PK -- the primary key from the original table Num -- a number value from the original table Boolean -- a boolean value created by performing arithmetic and cast() function on the number BooleanExp -- a boolean value defined as a boolean expression (I've gotten rid of the subquery-based fields, since they didn't affect the outcome and were just complicating matters.) (3) the behaviour (e.g., complete or neat crash, or hang) that happens on my Mac. --- Anyway, this has now become a very obscure problem, but at least I know which particular conditions to avoid in my original database! - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 114189] Base crashes when using f ilters / sorts on some query results with calc ulated boolean fields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114189 --- Additional comments from amel...@openoffice.org Mon Aug 30 18:33:12 + 2010 --- Created an attachment (id=71486) New Test Database - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 114188] Base query that reference s another query fails if subquery has order by statement
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114188 --- Additional comments from amel...@openoffice.org Mon Aug 30 18:39:48 + 2010 --- I disagree with the classification of this as an enhancement, but I will leave it up to an independent observer to make a final judgement. This isn't a case of wanting some extra SQL behaviour that OO doesn't currently support. When creating queries using the wizard or design GUI, there is always an option to sort the query, and there is always the option to base one query on another query. However, when you do both there is an error. I'd call that a defect. In particular, for someone who is unfamiliar with SQL and just using the GUI, the final error message would be quite incomprehensible, because it complains about an order by clause and the query they are trying to run might not have a sort order of its own. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 114187] Cannot see/remove query s orts from order by statement in query view
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114187 Issue #|114187 Summary|Cannot see/remove query sorts from order by statemen |t in query view Component|Database access Version|OOo 3.2.1 Platform|Macintosh URL| OS/Version|Mac OS X, 10.5 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ameliab --- Additional comments from amel...@openoffice.org Sun Aug 29 21:36:24 + 2010 --- When viewing the results of a query, any sort order created in the query definition is applied invisibly -- it does not show up in the sort order dialog, you cannot remove it, and if you sort by any other column the new sort is added as a secondary sort (i.e., it often doesn't appear to do anything). The only sort that actually works as expected is if you reverse the original sort. Otherwise, it just appears to a user that the sort function doesn't work. It doesn't matter whether the order by function was added through the OpenOffice query design or by direct SQL to the underlying database (embedded HSQL in my case). The same problem does not exist with table views that contain order by statements -- you can sort the results normally when viewing data. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 114188] Base query that reference s another query fails if subquery has order by statement
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114188 Issue #|114188 Summary|Base query that references another query fails if subq |uery has order by statement Component|Database access Version|OOo 3.2.1 Platform|Macintosh URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ameliab --- Additional comments from amel...@openoffice.org Sun Aug 29 21:58:10 + 2010 --- Base's query designer allows you to reference another saved query, which is then substituted in as a sub-query in the statement sent to the database. However, if the sub-query contains an order by statement, this causes an SQL error (at least with the embedded HSQL database, other RDBMS may tolerate this syntax). I've also had problems if the subquery is something I've created in SQL mode and I've included a semi-colon at the end (again, this causes syntax errors when it is nested as a sub-query). The OpenOffice query parser needs to strip Order by clauses and terminal semi-colons when nesting queries. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 114187] Cannot see/remove query s orts from order by statement in query view
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114187 --- Additional comments from amel...@openoffice.org Sun Aug 29 22:29:20 + 2010 --- Clarification: When viewing the results of a query that uses direct SQL (i.e., the run SQL command directly button is checked), neither sort *nor* filter commands work. This is true even if there is no order by clause or conditions on the query. Again, there is no feedback to the user that these options aren't available -- you can press the buttons and fill in the dialog boxes, but nothing happens. This may be a separate issue from the above issue with order by, but it seems related. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 114187] Cannot see/remove query s orts from order by statement in query view
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114187 --- Additional comments from amel...@openoffice.org Sun Aug 29 22:47:30 + 2010 --- Created an attachment (id=71467) Test DB created when exploring this issue and issue 114188 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 114189] Base crashes when using q uery filters / sorts on columns created by cor related subqueries
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114189 Issue #|114189 Summary|Base crashes when using query filters / sorts on colum |ns created by correlated subqueries Component|Database access Version|OOo 3.2.1 Platform|Macintosh URL| OS/Version|Mac OS X, 10.5 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ameliab --- Additional comments from amel...@openoffice.org Sun Aug 29 23:31:38 + 2010 --- When using Base with an SQL query in which one of the column definitions uses a correlated subquery, trying to filter the query results in the display causes OpenOffice to crash. Furthermore, if the query was created using the run SQL command directly option, then tryint to sort the results will either cause OpenOffice to crash or to go into an indefinite loop (and may eventually crash, although I gave up waiting and used a force quit). However, if the query was run through the OpenOffice SQL parser, sorting does not appear to cause any crashes (although see issue 114187 and issue 114188 for other problems with sorting queries that I discovered while trying to isolate what was causing the crash). Filtering still causes a crash. However, this crash is more contained -- I get OpenOffice's sorry but the program crashed your file will be recovered message, instead of Mac's OpenOffice crashed do you want to relaunch message. The test database and an explanation of it are attached to issue 114187. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 114187] Cannot see/remove query s orts from order by statement in query view
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114187 --- Additional comments from amel...@openoffice.org Sun Aug 29 23:57:50 + 2010 --- Explanation of the test database: The same test database is relevant for issue 114187 (re-sorting sorted queries), issue 114188 (syntax errors in queries that reference a sorted query) and issue 114189 (Base crashes when using filters on columns created by correlated subqueries). (A) There is one original table, named Numbers. It consists of: PrimaryKey, an auto-generated primary key, and RandNumber, a series of random numbers 0 = RandNumber 1 (B) There are three different versions of queries that operate directly on this table: Query_OOSQL runs through the OpenOffice SQL parser Query_DirectSQL has the run SQL command directly button selected View is a table view copy of Query_DirectSQL All three create three columns: ID, the primary key repeated, MoreThanHalf, a boolean based on whether or not RandNumber is greater than 0.5 (Side note -- I had to use some math and data type casting to recreate this result with the OpenOffice SQL parser, which doesn't accept a simple boolean statement as a column definition. Annoying.) and ThrownNum which uses a correlated subquery to determine the rank of this record when the records are sorted by primary key (i.e., counts the number of records with a smaller or equal primary key). These are the queries that are relevant to issue 114189 -- arguably the most important issue, since its the one that results in crashes (although probably fewer people are using correlated subqueries than are sorting queries!) Applying a filter to the results of Query_OOSQL causes a crash. Applying a filter or sort to the results of Query_DirectSQL causes a crash or hang. No problems when using the view. (C) Then, there are a series of queries and one view named HeadsOrTails etc., which basically regenerate the above results with different column alias, and various sort options. These are the queries that are relevant to (this) issue 114187, about being unable to sort already sorted results. Note that sorting/filtering these queries doesn't cause crashing, even though they are actually submitting a query with a subquery with a nested correlated subquery to the database. (The exception is the DirectSQL query, which of course can't reference another query, and so is based on the View defined above.) HeadsOrTails-HeadsSort is a query ordered by the boolean column Heads. When viewing the results, sorting by the count column ThrowNum adds a secondary sort. Filtering works properly. HeadsOrTails-ThrowSort is a query ordered by the count column ThrowNum. Trying to sort the results based on Heads appears to have no effect, since ThrowNum values are all unique. Again, filtering works properly. HeadsOrTails-NoSort is the same query without an ordered by clause. It can be sorted and filtered no problem. HeadsOrTails-NoSort-DirectSQL is an unsorted query, but run directly by the embedded database instead of using the OpenOffice SQL parser. Results cannot be sorted or filtered. View_HeadsOrTails is a sorted table view. Data can be re-sorted and filtered no problem. (D) The final set of queries filter the HeadsOrTails queries to only list those where Heads is true. These are the queries relevant to issue 114188 -- syntax errors when OpenOffice tries to use a sorted query as a subquery. HeadsOnly-UsingUnsortedQuery is defined based on the HeadsOrTails-NoSort query. It works fine. HeadsOnly-UsingSortedQuery is the same, but it is based on the HeadsOrTails-HeadsSort query. OpenOffice parses the query no problem, you can edit it in design mode, but when you actually try to view data the embedded database issues an error. HeadsOnly-UsingView is again the same idea, but based on the (sorted) View_HeadsOrTails. It works fine. All in all, a couple examples of unexpected behaviour and one dangerous crash when using queries. I think I'll be using mostly views from now on, but that's not always an option when using an external database! - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 114187] Cannot see/remove query s orts from order by statement in query view
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114187 --- Additional comments from amel...@openoffice.org Mon Aug 30 00:07:23 + 2010 --- Re-reading this sentence I realize it isn't very clear without actually opening the database: Then, there are a series of queries and one view named HeadsOrTails etc., which basically regenerate the above results with different column alias, and various sort options. What I meant is that the HeadsOrTails queries are created in design view by selecting the columns from the first set of queries / views. ThrowNum is selected and MoreThanHalf is selected and aliased as Heads. No functions or new subqueries are defined, although OpenOffice of course creates a nested sub-query by substituting one query into the FROM clause of the other. But that doesn't seem to cause problems. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 114188] Base query that reference s another query fails if subquery has order by statement
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114188 --- Additional comments from amel...@openoffice.org Mon Aug 30 00:08:46 + 2010 --- For examples, see the test database attached to issue 114187. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113970] OO Base 3.2.1 cannot conn ect with embedded DB it created -- says was cr eated by newer version
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113970 --- Additional comments from amel...@openoffice.org Thu Aug 19 18:21:27 + 2010 --- Created an attachment (id=71204) Contents/_CodeSignature/CodeResources file from possibly corrupted version of OO - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113970] OO Base 3.2.1 cannot conn ect with embedded DB it created -- says was cr eated by newer version
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113970 --- Additional comments from amel...@openoffice.org Thu Aug 19 18:20:03 + 2010 --- @r4zoli I'm afraid it can't be anything to do with Arch Linux -- I have not accessed these files on anything but this one MacBook running 3.2.1! Also, the properties file is already set to 1.8.0: #HSQL Database Engine 1.8.0.10 #Tue Aug 17 15:29:52 PDT 2010 hsqldb.script_format=0 runtime.gc_interval=0 sql.enforce_strict_size=true hsqldb.cache_size_scale=8 readonly=false hsqldb.nio_data_file=false hsqldb.cache_scale=13 version=1.8.0 hsqldb.default_table_type=cached hsqldb.cache_file_scale=1 hsqldb.lock_file=true hsqldb.log_size=10 modified=no hsqldb.cache_version=1.7.0 hsqldb.original_version=1.8.0 hsqldb.compatible_version=1.8.0 I was experimenting with a stand-alone HSQLDB system, version 1.8.1.3, and created a copy of one of my databases on it. But I don't see how that would have affected the files with the embedded databases -- the copy was one-way from embedded to stand-alone, and I used OO to copy the individual tables over. Regardless, I seem to have determined that the problem was a corrupted OpenOffice program file, because (a) any file that got resaved yesterday (while I was opening files to see if they were corrupted), is now corrupted (b) that behaviour stopped once I completely removed my old OO program files and reinstalled a fresh version. I still can't access the databases in the corrupted files (get the same newer version message as above), but new files I open and save don't get corrupted. (Note: When I said yesterday that I had re-installed OO, what I had done was copy the original app package overtop of my existing app, same as I would do when updating OO. But then I remembered that updates are supposed to preserve custom settings files, so this wouldn't completely wipe clean changes to the program.) I used the Mac Terminal to do a diff comparison of the contents of the old and new OpenOffice.org.app packages, and got the following differences: The old (corrupted) version had the extra folder Contents/_CodeSignature containing file CodeResources. The file Contents/MacOS/soffice was different between the two versions. In addition, there was an extra alias file in the Contents folder, which just referenced the CodeResources file, and the difference in the soffice file also showed up in the Contents/program folder, which is just an alias for the MacOS folder. I don't know enough about the inner workings of OO to know if either of those differences might be significant, but just in case I'll attach copies of the two files from the (apparently) corrupted version. In the meantime, I'm just making sure I backup any file before I open it, and being glad that I had duplicate backups from two days ago! - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113970] OO Base 3.2.1 cannot conn ect with embedded DB it created -- says was cr eated by newer version
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113970 --- Additional comments from amel...@openoffice.org Thu Aug 19 18:22:35 + 2010 --- Created an attachment (id=71205) Contents/MacOS/soffice file from possibly corrupted version of OO - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113970] OO Base 3.2.1 cannot conn ect with embedded DB it created -- says was cr eated by newer version
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113970 --- Additional comments from amel...@openoffice.org Thu Aug 19 18:59:39 + 2010 --- That might be it -- I added the link to the hsqldb.jar file in the downloaded hsqldb package. This would then override the jar file from the embedded database, is that the problem? If that makes sense then you can close the issue. Wonder why the properties file still says 1.8.0, though? These questions are more for a support forum than an issues tracker, but if you know the answers quickly: *If OO has its own hsqldb.jar file that it uses for the embedded database, do I need to add a class path to it in the java settings at all? I had been following instructions on a tutorial in one of the forums about how to set up a stand-alone HSQL DB. *Any ideas of how to regain access to the files that were saved while OO was using the wrong jar file? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113970] OO Base 3.2.1 cannot conn ect with embedded DB it created -- says was cr eated by newer version
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113970 --- Additional comments from amel...@openoffice.org Thu Aug 19 19:36:30 + 2010 --- Yes, you were right -- the properties file I copied above was from a version I had unzipped earlier (from trying to recover data after a crash). Thanks very much for all your help! --AB - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113970] OO Base 3.2.1 cannot conn ect with embedded DB it created -- says was cr eated by newer version
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113970 Issue #|113970 Summary|OO Base 3.2.1 cannot connect with embedded DB it creat |ed -- says was created by newer version Component|Database access Version|OOo 3.2.1 Platform|Macintosh URL| OS/Version|Mac OS X, 10.5 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ameliab --- Additional comments from amel...@openoffice.org Wed Aug 18 23:41:50 + 2010 --- Working with Base on files with an embedded database, I suddenly cannot access the data on files I was using this morning. The odb file opens correctly, but when I try to view tables, open a form, or use SQL, I get the error: The connection to the data source [filename] could not be established. The database was created by a newer version of OpenOffice.org. However, these files were both created on the exact same OO version on the exact same computer, and were last accessed without problem earlier today. OpenOffice was closed normally at lunch; there was no crash that could explain corrupted files today, although I did have a crash yesterday (unexplained, not sure what happened -- copying data [text] into a form and OO hung as if it got stuck in a loop until it eventually crashed). Neither restarting the computer, nor reinstalling OpenOffice from the original disk image, fix the problem. Access to other database files (including my backup file from yesterday's crash) don't have problems. I've copied the odb files and unzipped them to look at the database scripts and cannot find any obvious discrepancies. I'll attach the smaller database file ... and then start re-doing my work from this morning, which in turn was a re-do of work that I'd lost yesterday! And then will remind myself not to design any projects around OO Base until it is up to the reliability standards of the rest of the program. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113970] OO Base 3.2.1 cannot conn ect with embedded DB it created -- says was cr eated by newer version
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113970 --- Additional comments from amel...@openoffice.org Wed Aug 18 23:44:16 + 2010 --- Created an attachment (id=71174) One of the two files that became inaccessible - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113970] OO Base 3.2.1 cannot conn ect with embedded DB it created -- says was cr eated by newer version
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113970 --- Additional comments from amel...@openoffice.org Thu Aug 19 00:17:45 + 2010 --- I remembered one more thing that connects these two databases: I had created a saved SQL query in each that queried the system table information (SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLES) (That was the only reason I had opened up the attached Test database: I was looking at the cached versus memory properties of tables, and wanted to see if it was possible to create a memory table in an embedded database -- and I didn't want to play around with anything like that on my main database, for fear of messing up my data!) However, I've used this query before without problem. And nothing else I did while working with the test database was duplicated on the main database, except for the fact that both files were open at the same time. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113554] Base crashes after SQL in sert error from a subform when using button ac tions to navigate through parent form records
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113554 --- Additional comments from amel...@openoffice.org Sun Aug 1 19:40:37 + 2010 --- For what it's worth, I've discovered that simply cancelling the record change using a macro is not always enough to stop the crash. However, having the macro pause for user input, then cancelling the record change, does seem to protect against crashing. So, my guess is the crash has something to do with synchronization of multiple processes? Why else would pausing until someone says OK be the key to the solution? For the (rather crude) macro I'm using, see http://user.services.openoffice.org/en/forum/viewtopic.php?f=39t=32890p=150893#p150893 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113554] Base crashes after SQL in sert error from a subform when using button ac tions to navigate through parent form records
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113554 --- Additional comments from amel...@openoffice.org Sat Jul 31 16:38:47 + 2010 --- @atjensen Thanks for confirming that the problem isn't exclusive to my system. And good to know that the crashing, at least, seems to be fixed in the latest development builds. I have been trying to figure out a work-around, but it's a little complicated since the macro has to be attached to an event on the mainform to trigger action on the subform -- and since I don't have any experience with the OpenOffice API. See: http://user.services.openoffice.org/en/forum/viewtopic.php?f=39t=32890p=150797 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113554] Base crashes after SQL in sert error from a subform when using button ac tions to navigate through parent form records
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113554 Issue #|113554 Summary|Base crashes after SQL insert error from a subform whe |n using button actions to navigate through parent form | records Component|Database access Version|OOO320m18 Platform|Macintosh URL| OS/Version|Mac OS X Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ameliab --- Additional comments from amel...@openoffice.org Sat Jul 31 01:00:05 + 2010 --- In a Base form with a subform, I have added buttons to trigger the next record / previous record functions. These aren't custom macros, just the default action options in the button control's properties. The subform has some required fields (i.e., with non-null constraints on the database table). If you try to navigate away from a half-completed subform, therefore, you sometimes get SQL insert errors. When using the main form's buttons to do the navigation, OpenOffice OFTEN BUT NOT ALWAYS crashes a few moments after you have clicked OK to the error warning. In the cases where the button method doesn't crash, the subform data is lost and the main record is still changed. I haven't figured out any differences between when it crashes and when it doesn't. It doesn't crash if you use buttons associated with the subform -- instead, the form goes straight to the problem field on the subform, cancelling the navigation request. This feature also happens you try to transfer focus from the subform to any non-button features of the main form. I have re-created the problem in a much simpler sample database, which I will attach in a moment. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113554] Base crashes after SQL in sert error from a subform when using button ac tions to navigate through parent form records
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113554 --- Additional comments from amel...@openoffice.org Sat Jul 31 01:04:12 + 2010 --- Created an attachment (id=70896) Simple Test Database -- use the LibraryCheckOutForm, leaving either sub-form field empty to trigger crash - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org