SQL Error

Posted by Adrian Crum on
URL: http://ofbiz.116.s1.nabble.com/SQL-Error-tp145761.html

I'm trying to update my local copy of OFBiz to the latest SVN. Last version used
was back in 2005. Now I'm getting SQL exceptions:

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 PARTY_NOTE PN INNER JOIN NOTE_DATA ND ON
PN.NOTE_ID = ND.NOTE_ID WHERE (TARGET_PARTY_ID = ?) ORDER BY NOTE_DATE_TIME DESC
([Extended Systems][Advantage SQL Engine]Column not found: TARGET_PARTY_ID --
Location of error in the SQL statement is: 259)

Any idea what changed or what could be wrong?