You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Brendan Vogt <br...@gmail.com> on 2007/12/22 10:38:03 UTC

Install Errors

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

Re: Install Errors

Posted by Jacques Le Roux <ja...@les7arts.com>.
And be curious...

Jacques

From: "Scott Gray" <le...@gmail.com>
> Right click on the project, Team > Update...
> 
> Regards
> Scott
> 
> ps. RTFM
> 
> On 23/12/2007, Brendan Vogt <br...@gmail.com> 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:lektran@gmail.com]
>> Sent: Saturday, December 22, 2007 2:41 PM
>> To: user@ofbiz.apache.org
>> 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 <br...@gmail.com> 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:tiz@sastau.it]
>> > Sent: Saturday, December 22, 2007 11:57 AM
>> > To: user@ofbiz.apache.org
>> > 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
>> > >
>> > >
>> >
>> >
>>
>>
>

Re: Install Errors

Posted by Scott Gray <le...@gmail.com>.
Right click on the project, Team > Update...

Regards
Scott

ps. RTFM

On 23/12/2007, Brendan Vogt <br...@gmail.com> 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:lektran@gmail.com]
> Sent: Saturday, December 22, 2007 2:41 PM
> To: user@ofbiz.apache.org
> 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 <br...@gmail.com> 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:tiz@sastau.it]
> > Sent: Saturday, December 22, 2007 11:57 AM
> > To: user@ofbiz.apache.org
> > 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
> > >
> > >
> >
> >
>
>

Re: Eclipse-Svn check out was Install Errors

Posted by BJ Freeman <bj...@free-man.net>.
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:bjfree@free-man.net] 
> Sent: Saturday, December 22, 2007 3:17 PM
> To: user@ofbiz.apache.org
> 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:lektran@gmail.com] 
>> Sent: Saturday, December 22, 2007 2:41 PM
>> To: user@ofbiz.apache.org
>> 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 <br...@gmail.com> 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:tiz@sastau.it]
>>> Sent: Saturday, December 22, 2007 11:57 AM
>>> To: user@ofbiz.apache.org
>>> 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
>>>>
>>>>
>>
>>
>>
> 
> 
> 
>

RE: Eclipse-Svn check out was Install Errors

Posted by Brendan Vogt <br...@gmail.com>.
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:bjfree@free-man.net] 
Sent: Saturday, December 22, 2007 3:17 PM
To: user@ofbiz.apache.org
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:lektran@gmail.com] 
> Sent: Saturday, December 22, 2007 2:41 PM
> To: user@ofbiz.apache.org
> 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 <br...@gmail.com> 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:tiz@sastau.it]
>> Sent: Saturday, December 22, 2007 11:57 AM
>> To: user@ofbiz.apache.org
>> 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
>>>
>>>
>>
> 
> 
> 
>

Re:Eclipse-Svn check out was Install Errors

Posted by BJ Freeman <bj...@free-man.net>.
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:lektran@gmail.com] 
> Sent: Saturday, December 22, 2007 2:41 PM
> To: user@ofbiz.apache.org
> 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 <br...@gmail.com> 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:tiz@sastau.it]
>> Sent: Saturday, December 22, 2007 11:57 AM
>> To: user@ofbiz.apache.org
>> 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
>>>
>>>
>>
> 
> 
> 
>

RE: Install Errors

Posted by Brendan Vogt <br...@gmail.com>.
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:lektran@gmail.com] 
Sent: Saturday, December 22, 2007 2:41 PM
To: user@ofbiz.apache.org
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 <br...@gmail.com> 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:tiz@sastau.it]
> Sent: Saturday, December 22, 2007 11:57 AM
> To: user@ofbiz.apache.org
> 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
> >
> >
>
>

Re: Install Errors

Posted by Scott Gray <le...@gmail.com>.
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 <br...@gmail.com> 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:tiz@sastau.it]
> Sent: Saturday, December 22, 2007 11:57 AM
> To: user@ofbiz.apache.org
> 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
> >
> >
>
>

RE: Install Errors

Posted by Brendan Vogt <br...@gmail.com>.
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:tiz@sastau.it] 
Sent: Saturday, December 22, 2007 11:57 AM
To: user@ofbiz.apache.org
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
> 
>

Re: Install Errors

Posted by Jacopo Cappellato <ti...@sastau.it>.
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
> 
>