Install Errors

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
10 messages Options
Reply | Threaded
Open this post in threaded view
|

Install Errors

Brendan Vogt
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

Reply | Threaded
Open this post in threaded view
|

Re: Install Errors

Jacopo Cappellato
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
>
>

Reply | Threaded
Open this post in threaded view
|

RE: Install Errors

Brendan Vogt
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
>
>

Reply | Threaded
Open this post in threaded view
|

Re: Install Errors

Scott Gray
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
> >
> >
>
>
Reply | Threaded
Open this post in threaded view
|

RE: Install Errors

Brendan Vogt
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
> >
> >
>
>

Reply | Threaded
Open this post in threaded view
|

Re:Eclipse-Svn check out was Install Errors

BJ Freeman
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
>>>
>>>
>>
>
>
>
>

Reply | Threaded
Open this post in threaded view
|

RE: Eclipse-Svn check out was Install Errors

Brendan Vogt
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
>>>
>>>
>>
>
>
>
>

Reply | Threaded
Open this post in threaded view
|

Re: Install Errors

Scott Gray
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
> > >
> > >
> >
> >
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Eclipse-Svn check out was Install Errors

BJ Freeman
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
>>>>
>>>>
>>
>>
>>
>
>
>
>

Reply | Threaded
Open this post in threaded view
|

Re: Install Errors

Jacques Le Roux
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
>> > >
>> > >
>> >
>> >
>>
>>
>