Hi,
Here are errors you guys might want to look at while I did an ant run-install: 2007-12-22 11:00:41,093 (main) [ DatabaseUtil.java:351:ERROR] Could not create table [public.USER_PREFERENCE]: SQL Exception while executing the following: CREATE TABLE public.USER_PREFERENCE (USER_LOGIN_ID VARCHAR(255), USER_PREF_TYPE_ID VARCHAR(20), USER_PREF_GROUP_ID VARCHAR(60), USER_PREF_VALUE VARCHAR(255), USER_PREF_DATA_TYPE VARCHAR(60), LAST_UPDATED_STAMP TIMESTAMPTZ, LAST_UPDATED_TX_STAMP TIMESTAMPTZ, CREATED_STAMP TIMESTAMPTZ, CREATED_TX_STAMP TIMESTAMPTZ, CONSTRAINT PK_USER_PREFERENCE PRIMARY KEY ()) Error was: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" 2007-12-22 11:01:41,390 (main) [ DatabaseUtil.java:2870:ERROR] Could not create foreign key indices for entity [PartyInvitationRoleAssoc]: SQL Exception while executing the following: CREATE INDEX PARTYINVITATION ON public.PARTY_INVITATION_ROLE_ASSOC (PARTY_INVITATION_ID) Error was: org.postgresql.util.PSQLException: ERROR: relation "partyinvitation" already exists Will this have any impact any where? Brendan |
I guess Adrian will look at it pretty soon (I've noticed that the
UserPreference* entity definitions are not complete: no primary key and no foreign keys); in the meantime I've added the primary key (I hope it is correct, it should be) and the error is fixed in rev. 606439. Thank you for the bug report, Jacopo Brendan Vogt wrote: > Hi, > > > > Here are errors you guys might want to look at while I did an ant > run-install: > > > > 2007-12-22 11:00:41,093 (main) [ DatabaseUtil.java:351:ERROR] Could > not create table [public.USER_PREFERENCE]: SQL Exception while executing the > following: > > CREATE TABLE public.USER_PREFERENCE (USER_LOGIN_ID VARCHAR(255), > USER_PREF_TYPE_ID VARCHAR(20), USER_PREF_GROUP_ID VARCHAR(60), > USER_PREF_VALUE VARCHAR(255), USER_PREF_DATA_TYPE VARCHAR(60), > LAST_UPDATED_STAMP TIMESTAMPTZ, LAST_UPDATED_TX_STAMP TIMESTAMPTZ, > CREATED_STAMP TIMESTAMPTZ, CREATED_TX_STAMP TIMESTAMPTZ, CONSTRAINT > PK_USER_PREFERENCE PRIMARY KEY ()) > > Error was: org.postgresql.util.PSQLException: ERROR: syntax error at or near > ")" > > > > > > 2007-12-22 11:01:41,390 (main) [ DatabaseUtil.java:2870:ERROR] Could > not create foreign key indices for entity [PartyInvitationRoleAssoc]: SQL > Exception while executing the following: > > CREATE INDEX PARTYINVITATION ON public.PARTY_INVITATION_ROLE_ASSOC > (PARTY_INVITATION_ID) > > Error was: org.postgresql.util.PSQLException: ERROR: relation > "partyinvitation" already exists > > > > Will this have any impact any where? > > > > Brendan > > |
Thanks.
If I use SVN in Eclipse to check out OFBiz, how do I check what the rev is? -----Original Message----- From: Jacopo Cappellato [mailto:[hidden email]] Sent: Saturday, December 22, 2007 11:57 AM To: [hidden email] Subject: Re: Install Errors I guess Adrian will look at it pretty soon (I've noticed that the UserPreference* entity definitions are not complete: no primary key and no foreign keys); in the meantime I've added the primary key (I hope it is correct, it should be) and the error is fixed in rev. 606439. Thank you for the bug report, Jacopo Brendan Vogt wrote: > Hi, > > > > Here are errors you guys might want to look at while I did an ant > run-install: > > > > 2007-12-22 11:00:41,093 (main) [ DatabaseUtil.java:351:ERROR] Could > not create table [public.USER_PREFERENCE]: SQL Exception while executing > following: > > CREATE TABLE public.USER_PREFERENCE (USER_LOGIN_ID VARCHAR(255), > USER_PREF_TYPE_ID VARCHAR(20), USER_PREF_GROUP_ID VARCHAR(60), > USER_PREF_VALUE VARCHAR(255), USER_PREF_DATA_TYPE VARCHAR(60), > LAST_UPDATED_STAMP TIMESTAMPTZ, LAST_UPDATED_TX_STAMP TIMESTAMPTZ, > CREATED_STAMP TIMESTAMPTZ, CREATED_TX_STAMP TIMESTAMPTZ, CONSTRAINT > PK_USER_PREFERENCE PRIMARY KEY ()) > > Error was: org.postgresql.util.PSQLException: ERROR: syntax error at or > ")" > > > > > > 2007-12-22 11:01:41,390 (main) [ DatabaseUtil.java:2870:ERROR] Could > not create foreign key indices for entity [PartyInvitationRoleAssoc]: SQL > Exception while executing the following: > > CREATE INDEX PARTYINVITATION ON public.PARTY_INVITATION_ROLE_ASSOC > (PARTY_INVITATION_ID) > > Error was: org.postgresql.util.PSQLException: ERROR: relation > "partyinvitation" already exists > > > > Will this have any impact any where? > > > > Brendan > > |
Right click on your project in the Navigator and select Properties, the
Subversion tab will display the revision number. Regards Scott On 23/12/2007, Brendan Vogt <[hidden email]> wrote: > > Thanks. > > If I use SVN in Eclipse to check out OFBiz, how do I check what the rev > is? > > > -----Original Message----- > From: Jacopo Cappellato [mailto:[hidden email]] > Sent: Saturday, December 22, 2007 11:57 AM > To: [hidden email] > Subject: Re: Install Errors > > I guess Adrian will look at it pretty soon (I've noticed that the > UserPreference* entity definitions are not complete: no primary key and > no foreign keys); in the meantime I've added the primary key (I hope it > is correct, it should be) and the error is fixed in rev. 606439. > > Thank you for the bug report, > > Jacopo > > Brendan Vogt wrote: > > Hi, > > > > > > > > Here are errors you guys might want to look at while I did an ant > > run-install: > > > > > > > > 2007-12-22 11:00:41,093 (main) [ DatabaseUtil.java:351:ERROR] > Could > > not create table [public.USER_PREFERENCE]: SQL Exception while executing > the > > following: > > > > CREATE TABLE public.USER_PREFERENCE (USER_LOGIN_ID VARCHAR(255), > > USER_PREF_TYPE_ID VARCHAR(20), USER_PREF_GROUP_ID VARCHAR(60), > > USER_PREF_VALUE VARCHAR(255), USER_PREF_DATA_TYPE VARCHAR(60), > > LAST_UPDATED_STAMP TIMESTAMPTZ, LAST_UPDATED_TX_STAMP TIMESTAMPTZ, > > CREATED_STAMP TIMESTAMPTZ, CREATED_TX_STAMP TIMESTAMPTZ, CONSTRAINT > > PK_USER_PREFERENCE PRIMARY KEY ()) > > > > Error was: org.postgresql.util.PSQLException: ERROR: syntax error at or > near > > ")" > > > > > > > > > > > > 2007-12-22 11:01:41,390 (main) [ DatabaseUtil.java:2870:ERROR] > Could > > not create foreign key indices for entity [PartyInvitationRoleAssoc]: > SQL > > Exception while executing the following: > > > > CREATE INDEX PARTYINVITATION ON public.PARTY_INVITATION_ROLE_ASSOC > > (PARTY_INVITATION_ID) > > > > Error was: org.postgresql.util.PSQLException: ERROR: relation > > "partyinvitation" already exists > > > > > > > > Will this have any impact any where? > > > > > > > > Brendan > > > > > > |
Another quick question, how do I do an update through Eclipse? Do I just
say Import then follow the normal SVN checkout process? -----Original Message----- From: Scott Gray [mailto:[hidden email]] Sent: Saturday, December 22, 2007 2:41 PM To: [hidden email] Subject: Re: Install Errors Right click on your project in the Navigator and select Properties, the Subversion tab will display the revision number. Regards Scott On 23/12/2007, Brendan Vogt <[hidden email]> wrote: > > Thanks. > > If I use SVN in Eclipse to check out OFBiz, how do I check what the rev > is? > > > -----Original Message----- > From: Jacopo Cappellato [mailto:[hidden email]] > Sent: Saturday, December 22, 2007 11:57 AM > To: [hidden email] > Subject: Re: Install Errors > > I guess Adrian will look at it pretty soon (I've noticed that the > UserPreference* entity definitions are not complete: no primary key and > no foreign keys); in the meantime I've added the primary key (I hope it > is correct, it should be) and the error is fixed in rev. 606439. > > Thank you for the bug report, > > Jacopo > > Brendan Vogt wrote: > > Hi, > > > > > > > > Here are errors you guys might want to look at while I did an ant > > run-install: > > > > > > > > 2007-12-22 11:00:41,093 (main) [ DatabaseUtil.java:351:ERROR] > Could > > not create table [public.USER_PREFERENCE]: SQL Exception while executing > the > > following: > > > > CREATE TABLE public.USER_PREFERENCE (USER_LOGIN_ID VARCHAR(255), > > USER_PREF_TYPE_ID VARCHAR(20), USER_PREF_GROUP_ID VARCHAR(60), > > USER_PREF_VALUE VARCHAR(255), USER_PREF_DATA_TYPE VARCHAR(60), > > LAST_UPDATED_STAMP TIMESTAMPTZ, LAST_UPDATED_TX_STAMP TIMESTAMPTZ, > > CREATED_STAMP TIMESTAMPTZ, CREATED_TX_STAMP TIMESTAMPTZ, CONSTRAINT > > PK_USER_PREFERENCE PRIMARY KEY ()) > > > > Error was: org.postgresql.util.PSQLException: ERROR: syntax error at or > near > > ")" > > > > > > > > > > > > 2007-12-22 11:01:41,390 (main) [ DatabaseUtil.java:2870:ERROR] > Could > > not create foreign key indices for entity [PartyInvitationRoleAssoc]: > SQL > > Exception while executing the following: > > > > CREATE INDEX PARTYINVITATION ON public.PARTY_INVITATION_ROLE_ASSOC > > (PARTY_INVITATION_ID) > > > > Error was: org.postgresql.util.PSQLException: ERROR: relation > > "partyinvitation" already exists > > > > > > > > Will this have any impact any where? > > > > > > > > Brendan > > > > > > |
if you want something for a production server use export, this removes
all the svn history. if you want to keep tabs on what has change check the trunk and make a project. I just found out about export, so I use the check of the svn, until I want a image for the server, then I use export, into a separate folder. Brendan Vogt sent the following on 12/22/2007 5:03 AM: > Another quick question, how do I do an update through Eclipse? Do I just > say Import then follow the normal SVN checkout process? > > > -----Original Message----- > From: Scott Gray [mailto:[hidden email]] > Sent: Saturday, December 22, 2007 2:41 PM > To: [hidden email] > Subject: Re: Install Errors > > Right click on your project in the Navigator and select Properties, the > Subversion tab will display the revision number. > > Regards > Scott > > On 23/12/2007, Brendan Vogt <[hidden email]> wrote: >> Thanks. >> >> If I use SVN in Eclipse to check out OFBiz, how do I check what the rev >> is? >> >> >> -----Original Message----- >> From: Jacopo Cappellato [mailto:[hidden email]] >> Sent: Saturday, December 22, 2007 11:57 AM >> To: [hidden email] >> Subject: Re: Install Errors >> >> I guess Adrian will look at it pretty soon (I've noticed that the >> UserPreference* entity definitions are not complete: no primary key and >> no foreign keys); in the meantime I've added the primary key (I hope it >> is correct, it should be) and the error is fixed in rev. 606439. >> >> Thank you for the bug report, >> >> Jacopo >> >> Brendan Vogt wrote: >>> Hi, >>> >>> >>> >>> Here are errors you guys might want to look at while I did an ant >>> run-install: >>> >>> >>> >>> 2007-12-22 11:00:41,093 (main) [ DatabaseUtil.java:351:ERROR] >> Could >>> not create table [public.USER_PREFERENCE]: SQL Exception while executing >> the >>> following: >>> >>> CREATE TABLE public.USER_PREFERENCE (USER_LOGIN_ID VARCHAR(255), >>> USER_PREF_TYPE_ID VARCHAR(20), USER_PREF_GROUP_ID VARCHAR(60), >>> USER_PREF_VALUE VARCHAR(255), USER_PREF_DATA_TYPE VARCHAR(60), >>> LAST_UPDATED_STAMP TIMESTAMPTZ, LAST_UPDATED_TX_STAMP TIMESTAMPTZ, >>> CREATED_STAMP TIMESTAMPTZ, CREATED_TX_STAMP TIMESTAMPTZ, CONSTRAINT >>> PK_USER_PREFERENCE PRIMARY KEY ()) >>> >>> Error was: org.postgresql.util.PSQLException: ERROR: syntax error at or >> near >>> ")" >>> >>> >>> >>> >>> >>> 2007-12-22 11:01:41,390 (main) [ DatabaseUtil.java:2870:ERROR] >> Could >>> not create foreign key indices for entity [PartyInvitationRoleAssoc]: >> SQL >>> Exception while executing the following: >>> >>> CREATE INDEX PARTYINVITATION ON public.PARTY_INVITATION_ROLE_ASSOC >>> (PARTY_INVITATION_ID) >>> >>> Error was: org.postgresql.util.PSQLException: ERROR: relation >>> "partyinvitation" already exists >>> >>> >>> >>> Will this have any impact any where? >>> >>> >>> >>> Brendan >>> >>> >> > > > > |
Yes but I don't want to download the whole OFBiz each time an update was
done. Normally in Windows I would right click and select Update then it does an update, but I want to be able to update it through Eclipse. -----Original Message----- From: BJ Freeman [mailto:[hidden email]] Sent: Saturday, December 22, 2007 3:17 PM To: [hidden email] Subject: Re:Eclipse-Svn check out was Install Errors if you want something for a production server use export, this removes all the svn history. if you want to keep tabs on what has change check the trunk and make a project. I just found out about export, so I use the check of the svn, until I want a image for the server, then I use export, into a separate folder. Brendan Vogt sent the following on 12/22/2007 5:03 AM: > Another quick question, how do I do an update through Eclipse? Do I just > say Import then follow the normal SVN checkout process? > > > -----Original Message----- > From: Scott Gray [mailto:[hidden email]] > Sent: Saturday, December 22, 2007 2:41 PM > To: [hidden email] > Subject: Re: Install Errors > > Right click on your project in the Navigator and select Properties, the > Subversion tab will display the revision number. > > Regards > Scott > > On 23/12/2007, Brendan Vogt <[hidden email]> wrote: >> Thanks. >> >> If I use SVN in Eclipse to check out OFBiz, how do I check what the rev >> is? >> >> >> -----Original Message----- >> From: Jacopo Cappellato [mailto:[hidden email]] >> Sent: Saturday, December 22, 2007 11:57 AM >> To: [hidden email] >> Subject: Re: Install Errors >> >> I guess Adrian will look at it pretty soon (I've noticed that the >> UserPreference* entity definitions are not complete: no primary key and >> no foreign keys); in the meantime I've added the primary key (I hope it >> is correct, it should be) and the error is fixed in rev. 606439. >> >> Thank you for the bug report, >> >> Jacopo >> >> Brendan Vogt wrote: >>> Hi, >>> >>> >>> >>> Here are errors you guys might want to look at while I did an ant >>> run-install: >>> >>> >>> >>> 2007-12-22 11:00:41,093 (main) [ DatabaseUtil.java:351:ERROR] >> Could >>> not create table [public.USER_PREFERENCE]: SQL Exception while executing >> the >>> following: >>> >>> CREATE TABLE public.USER_PREFERENCE (USER_LOGIN_ID VARCHAR(255), >>> USER_PREF_TYPE_ID VARCHAR(20), USER_PREF_GROUP_ID VARCHAR(60), >>> USER_PREF_VALUE VARCHAR(255), USER_PREF_DATA_TYPE VARCHAR(60), >>> LAST_UPDATED_STAMP TIMESTAMPTZ, LAST_UPDATED_TX_STAMP TIMESTAMPTZ, >>> CREATED_STAMP TIMESTAMPTZ, CREATED_TX_STAMP TIMESTAMPTZ, CONSTRAINT >>> PK_USER_PREFERENCE PRIMARY KEY ()) >>> >>> Error was: org.postgresql.util.PSQLException: ERROR: syntax error at or >> near >>> ")" >>> >>> >>> >>> >>> >>> 2007-12-22 11:01:41,390 (main) [ DatabaseUtil.java:2870:ERROR] >> Could >>> not create foreign key indices for entity [PartyInvitationRoleAssoc]: >> SQL >>> Exception while executing the following: >>> >>> CREATE INDEX PARTYINVITATION ON public.PARTY_INVITATION_ROLE_ASSOC >>> (PARTY_INVITATION_ID) >>> >>> Error was: org.postgresql.util.PSQLException: ERROR: relation >>> "partyinvitation" already exists >>> >>> >>> >>> Will this have any impact any where? >>> >>> >>> >>> Brendan >>> >>> >> > > > > |
In reply to this post by Brendan Vogt
Right click on the project, Team > Update...
Regards Scott ps. RTFM On 23/12/2007, Brendan Vogt <[hidden email]> wrote: > > Another quick question, how do I do an update through Eclipse? Do I just > say Import then follow the normal SVN checkout process? > > > -----Original Message----- > From: Scott Gray [mailto:[hidden email]] > Sent: Saturday, December 22, 2007 2:41 PM > To: [hidden email] > Subject: Re: Install Errors > > Right click on your project in the Navigator and select Properties, the > Subversion tab will display the revision number. > > Regards > Scott > > On 23/12/2007, Brendan Vogt <[hidden email]> wrote: > > > > Thanks. > > > > If I use SVN in Eclipse to check out OFBiz, how do I check what the rev > > is? > > > > > > -----Original Message----- > > From: Jacopo Cappellato [mailto:[hidden email]] > > Sent: Saturday, December 22, 2007 11:57 AM > > To: [hidden email] > > Subject: Re: Install Errors > > > > I guess Adrian will look at it pretty soon (I've noticed that the > > UserPreference* entity definitions are not complete: no primary key and > > no foreign keys); in the meantime I've added the primary key (I hope it > > is correct, it should be) and the error is fixed in rev. 606439. > > > > Thank you for the bug report, > > > > Jacopo > > > > Brendan Vogt wrote: > > > Hi, > > > > > > > > > > > > Here are errors you guys might want to look at while I did an ant > > > run-install: > > > > > > > > > > > > 2007-12-22 11:00:41,093 (main) [ DatabaseUtil.java:351:ERROR] > > Could > > > not create table [public.USER_PREFERENCE]: SQL Exception while > executing > > the > > > following: > > > > > > CREATE TABLE public.USER_PREFERENCE (USER_LOGIN_ID VARCHAR(255), > > > USER_PREF_TYPE_ID VARCHAR(20), USER_PREF_GROUP_ID VARCHAR(60), > > > USER_PREF_VALUE VARCHAR(255), USER_PREF_DATA_TYPE VARCHAR(60), > > > LAST_UPDATED_STAMP TIMESTAMPTZ, LAST_UPDATED_TX_STAMP TIMESTAMPTZ, > > > CREATED_STAMP TIMESTAMPTZ, CREATED_TX_STAMP TIMESTAMPTZ, CONSTRAINT > > > PK_USER_PREFERENCE PRIMARY KEY ()) > > > > > > Error was: org.postgresql.util.PSQLException: ERROR: syntax error at > or > > near > > > ")" > > > > > > > > > > > > > > > > > > 2007-12-22 11:01:41,390 (main) [ DatabaseUtil.java:2870:ERROR] > > Could > > > not create foreign key indices for entity [PartyInvitationRoleAssoc]: > > SQL > > > Exception while executing the following: > > > > > > CREATE INDEX PARTYINVITATION ON public.PARTY_INVITATION_ROLE_ASSOC > > > (PARTY_INVITATION_ID) > > > > > > Error was: org.postgresql.util.PSQLException: ERROR: relation > > > "partyinvitation" already exists > > > > > > > > > > > > Will this have any impact any where? > > > > > > > > > > > > Brendan > > > > > > > > > > > > |
In reply to this post by Brendan Vogt
then you want to check out the svn the first time.
then use team-update for what has changed. Brendan Vogt sent the following on 12/22/2007 5:21 AM: > Yes but I don't want to download the whole OFBiz each time an update was > done. Normally in Windows I would right click and select Update then it > does an update, but I want to be able to update it through Eclipse. > > > > -----Original Message----- > From: BJ Freeman [mailto:[hidden email]] > Sent: Saturday, December 22, 2007 3:17 PM > To: [hidden email] > Subject: Re:Eclipse-Svn check out was Install Errors > > if you want something for a production server use export, this removes > all the svn history. > if you want to keep tabs on what has change check the trunk and make a > project. > I just found out about export, so I use the check of the svn, until I > want a image for the server, then I use export, into a separate folder. > > Brendan Vogt sent the following on 12/22/2007 5:03 AM: >> Another quick question, how do I do an update through Eclipse? Do I just >> say Import then follow the normal SVN checkout process? >> >> >> -----Original Message----- >> From: Scott Gray [mailto:[hidden email]] >> Sent: Saturday, December 22, 2007 2:41 PM >> To: [hidden email] >> Subject: Re: Install Errors >> >> Right click on your project in the Navigator and select Properties, the >> Subversion tab will display the revision number. >> >> Regards >> Scott >> >> On 23/12/2007, Brendan Vogt <[hidden email]> wrote: >>> Thanks. >>> >>> If I use SVN in Eclipse to check out OFBiz, how do I check what the rev >>> is? >>> >>> >>> -----Original Message----- >>> From: Jacopo Cappellato [mailto:[hidden email]] >>> Sent: Saturday, December 22, 2007 11:57 AM >>> To: [hidden email] >>> Subject: Re: Install Errors >>> >>> I guess Adrian will look at it pretty soon (I've noticed that the >>> UserPreference* entity definitions are not complete: no primary key and >>> no foreign keys); in the meantime I've added the primary key (I hope it >>> is correct, it should be) and the error is fixed in rev. 606439. >>> >>> Thank you for the bug report, >>> >>> Jacopo >>> >>> Brendan Vogt wrote: >>>> Hi, >>>> >>>> >>>> >>>> Here are errors you guys might want to look at while I did an ant >>>> run-install: >>>> >>>> >>>> >>>> 2007-12-22 11:00:41,093 (main) [ DatabaseUtil.java:351:ERROR] >>> Could >>>> not create table [public.USER_PREFERENCE]: SQL Exception while executing >>> the >>>> following: >>>> >>>> CREATE TABLE public.USER_PREFERENCE (USER_LOGIN_ID VARCHAR(255), >>>> USER_PREF_TYPE_ID VARCHAR(20), USER_PREF_GROUP_ID VARCHAR(60), >>>> USER_PREF_VALUE VARCHAR(255), USER_PREF_DATA_TYPE VARCHAR(60), >>>> LAST_UPDATED_STAMP TIMESTAMPTZ, LAST_UPDATED_TX_STAMP TIMESTAMPTZ, >>>> CREATED_STAMP TIMESTAMPTZ, CREATED_TX_STAMP TIMESTAMPTZ, CONSTRAINT >>>> PK_USER_PREFERENCE PRIMARY KEY ()) >>>> >>>> Error was: org.postgresql.util.PSQLException: ERROR: syntax error at or >>> near >>>> ")" >>>> >>>> >>>> >>>> >>>> >>>> 2007-12-22 11:01:41,390 (main) [ DatabaseUtil.java:2870:ERROR] >>> Could >>>> not create foreign key indices for entity [PartyInvitationRoleAssoc]: >>> SQL >>>> Exception while executing the following: >>>> >>>> CREATE INDEX PARTYINVITATION ON public.PARTY_INVITATION_ROLE_ASSOC >>>> (PARTY_INVITATION_ID) >>>> >>>> Error was: org.postgresql.util.PSQLException: ERROR: relation >>>> "partyinvitation" already exists >>>> >>>> >>>> >>>> Will this have any impact any where? >>>> >>>> >>>> >>>> Brendan >>>> >>>> >> >> >> > > > > |
Administrator
|
In reply to this post by Scott Gray
And be curious...
Jacques From: "Scott Gray" <[hidden email]> > Right click on the project, Team > Update... > > Regards > Scott > > ps. RTFM > > On 23/12/2007, Brendan Vogt <[hidden email]> wrote: >> >> Another quick question, how do I do an update through Eclipse? Do I just >> say Import then follow the normal SVN checkout process? >> >> >> -----Original Message----- >> From: Scott Gray [mailto:[hidden email]] >> Sent: Saturday, December 22, 2007 2:41 PM >> To: [hidden email] >> Subject: Re: Install Errors >> >> Right click on your project in the Navigator and select Properties, the >> Subversion tab will display the revision number. >> >> Regards >> Scott >> >> On 23/12/2007, Brendan Vogt <[hidden email]> wrote: >> > >> > Thanks. >> > >> > If I use SVN in Eclipse to check out OFBiz, how do I check what the rev >> > is? >> > >> > >> > -----Original Message----- >> > From: Jacopo Cappellato [mailto:[hidden email]] >> > Sent: Saturday, December 22, 2007 11:57 AM >> > To: [hidden email] >> > Subject: Re: Install Errors >> > >> > I guess Adrian will look at it pretty soon (I've noticed that the >> > UserPreference* entity definitions are not complete: no primary key and >> > no foreign keys); in the meantime I've added the primary key (I hope it >> > is correct, it should be) and the error is fixed in rev. 606439. >> > >> > Thank you for the bug report, >> > >> > Jacopo >> > >> > Brendan Vogt wrote: >> > > Hi, >> > > >> > > >> > > >> > > Here are errors you guys might want to look at while I did an ant >> > > run-install: >> > > >> > > >> > > >> > > 2007-12-22 11:00:41,093 (main) [ DatabaseUtil.java:351:ERROR] >> > Could >> > > not create table [public.USER_PREFERENCE]: SQL Exception while >> executing >> > the >> > > following: >> > > >> > > CREATE TABLE public.USER_PREFERENCE (USER_LOGIN_ID VARCHAR(255), >> > > USER_PREF_TYPE_ID VARCHAR(20), USER_PREF_GROUP_ID VARCHAR(60), >> > > USER_PREF_VALUE VARCHAR(255), USER_PREF_DATA_TYPE VARCHAR(60), >> > > LAST_UPDATED_STAMP TIMESTAMPTZ, LAST_UPDATED_TX_STAMP TIMESTAMPTZ, >> > > CREATED_STAMP TIMESTAMPTZ, CREATED_TX_STAMP TIMESTAMPTZ, CONSTRAINT >> > > PK_USER_PREFERENCE PRIMARY KEY ()) >> > > >> > > Error was: org.postgresql.util.PSQLException: ERROR: syntax error at >> or >> > near >> > > ")" >> > > >> > > >> > > >> > > >> > > >> > > 2007-12-22 11:01:41,390 (main) [ DatabaseUtil.java:2870:ERROR] >> > Could >> > > not create foreign key indices for entity [PartyInvitationRoleAssoc]: >> > SQL >> > > Exception while executing the following: >> > > >> > > CREATE INDEX PARTYINVITATION ON public.PARTY_INVITATION_ROLE_ASSOC >> > > (PARTY_INVITATION_ID) >> > > >> > > Error was: org.postgresql.util.PSQLException: ERROR: relation >> > > "partyinvitation" already exists >> > > >> > > >> > > >> > > Will this have any impact any where? >> > > >> > > >> > > >> > > Brendan >> > > >> > > >> > >> > >> >> > |
Free forum by Nabble | Edit this page |