[
https://issues.apache.org/jira/browse/OFBIZ-1321?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12533525
]
BJ Freeman commented on OFBIZ-1321:
-----------------------------------
I do not modify svn Code.
I have other modules where I pull everything I need and do it there.
this error:
I used the svn partymgr to find list of parties
then I selected one.
Note, the is a production system, as of (svn550867) and the DB is postgresql.
part of the test is to create a party id with svn550867 (6/26/07)
then
update to svn577416 (9/19/07), which I did yesterday.
click on any partyID
Note: I have a standard batch that moves from this SVN folder where I have the
ver 4.0 checked out to the clients folder.
this is then compiled
everything but source code that is required to run ofbiz is then zipped and
uploaded to the server.
This has been my standard procedure for two years.
I use the restart script to restart ofbiz on a Linux box.
> SQL creation has changed format in ver 4.0
> ------------------------------------------
>
> Key: OFBIZ-1321
> URL: https://issues.apache.org/jira/browse/OFBIZ-1321
> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Affects Versions: Release Branch 4.0
> Reporter: BJ Freeman
> Assignee: David E. Jones
> Fix For: Release Branch 4.0
>
>
> I update from the latest 4.0 release
> all of a suddent the SQL has under scores where it did not before.
> example
> viewprofile.bsh
> Method Invocation delegator.findByAnd : at Line: 86 : in file:
> component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh :
> delegator .findByAnd ( "PartyNoteView" , UtilMisc .toMap ( "targetPartyId" ,
> partyId ) , UtilMisc .toList ( "-noteDateTime" ) )
> now produces
> Target exception: org.ofbiz.entity.GenericDataSourceException: SQL Exception
> while executing the following:SELECT PN.PARTY_ID AS TARGET_PARTY_ID,
> ND.NOTE_ID AS NOTE_ID, ND.NOTE_NAME AS NOTE_NAME, ND.NOTE_INFO AS NOTE_INFO,
> ND.NOTE_DATE_TIME AS NOTE_DATE_TIME, ND.NOTE_PARTY AS NOTE_PARTY FROM
> public.PARTY_NOTE PN INNER JOIN public.NOTE_DATA ND ON PN.NOTE_ID =
> ND.NOTE_ID WHERE (TARGET_PARTY_ID = ?) ORDER BY NOTE_DATE_TIME DESC (ERROR:
> column "target_party_id" does not exist)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
