Issue 58624 - 2.0.1RC1 fails on file saved by 2.0.0
Summary: 2.0.1RC1 fails on file saved by 2.0.0
Status: CLOSED DUPLICATE of issue 58370
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.1
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: dbaneedsconfirm
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-11-29 14:32 UTC by dridgway
Modified: 2006-06-12 15:18 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
buggy database (36.85 KB, application/vnd.sun.xml.base)
2005-11-29 14:33 UTC, dridgway
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description dridgway 2005-11-29 14:32:04 UTC
With difficulty, I created small test db using 2.0.0, then installed 2.0.1RC1,
and now I can't open it.

To reproduce,
1. Open attached db.
2. Click "Reports", then double-click "Committees".
Message appears: "The connection to the data source "membership41" could not be
established. error in script file line: 9 Unexpected token , requires AS in
statement [CREATE VIEW "CmteeMemView" (ID,PERSONID,ROLE,COMMITTEENAME) AS SELECT
"CommitteeMembers"."ID", "CommitteeMembers"."PersonID",
"CommitteeMembers"."Role", "Committees"."CommitteeName" FROM "CommitteeMembers"
"CommitteeMembers", "Committees" "Committees" WHERE (
"CommitteeMembers"."CommitteeID" = "Committees"."ID" )]"

On 2.0.0/Windows, the desired report would appear. I could also use the forms,
etc., though I had to be very careful after editing a form. Likely there's
something wrong with the document, but I did create it on 2.0.0. I also tried
document on 2.0.0/Linux, and it crashes at the point where 2.0.1RC1 brings up
the error message.
Comment 1 dridgway 2005-11-29 14:33:46 UTC
Created attachment 31897 [details]
buggy database
Comment 2 Frank Schönheit 2005-12-01 11:57:17 UTC
right, unfortunately ... :(

*** This issue has been marked as a duplicate of 58370 ***
Comment 3 christoph.lukasiak 2006-06-12 15:18:37 UTC
close duplicate

do not hestitate to reopen this issue if still occurs in current version after
duplicate to issue is fixed and integrated

thx