OFBiz › OFBiz - User

Install Errors

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

10 messages Options

Brendan Vogt

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

Jacopo Cappellato

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

Brendan Vogt

RE: Install Errors

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:

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

Scott Gray

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

Brendan Vogt

RE: Install Errors

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:

BJ Freeman

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

Brendan Vogt

RE: Eclipse-Svn check out was Install Errors

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:

Scott Gray

Re: Install Errors

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

BJ Freeman

Re: Eclipse-Svn check out was Install Errors

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

Jacques Le Roux

Re: Install Errors

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