[OGo-GNUstep-Port] postgresql adapter exception while entering a project

Sun, 03 Jun 2007 21:37:12 +0200

Hi,

found another exception when trying to enter a project from a search result 
list, OGo stops with the following exception:

2007-06-03 21:26:09.939 ogo-webui-1.1[4495] ./Source/NSDictionary.m: [result 
class] GSMutableDictionary
2007-06-03 21:26:09.957 ogo-webui-1.1[4495] NGObjWeb/WOContext.m: 
valueForKey: _key WEDropContainerScriptDone
2007-06-03 21:26:09.957 ogo-webui-1.1[4495] NGObjWeb/NSObject+WO.m: 
WOGetKVCValueUsingMethod: object: <0x0x8630a008[WOContext]: 
006466315d18630a008 app=ogo-webui-1.1 sn=118F118F01466315C3 
eid=006466315d18630a008.0.9 rqeid=(nil)>, _key: WEDropContainerScriptDone
2007-06-03 21:26:09.957 ogo-webui-1.1[4495] NGObjWeb/WOContext.m: 
valueForKey: _key WEDragContainerScriptDone
2007-06-03 21:26:09.957 ogo-webui-1.1[4495] NGObjWeb/NSObject+WO.m: 
WOGetKVCValueUsingMethod: object: <0x0x8630a008[WOContext]: 
006466315d18630a008 app=ogo-webui-1.1 sn=118F118F01466315C3 
eid=006466315d18630a008.0.11 rqeid=(nil)>, _key: WEDragContainerScriptDone

Breakpoint 2, -[NSException raise] (self=0x83eb7288, _cmd=0x26caeef0) at 
NSException.m:782
782       if (GSPrivateEnvironmentFlag("GNUSTEP_STACK_TRACE", NO) == YES
(gdb) bt
#0  -[NSException raise] (self=0x83eb7288, _cmd=0x26caeef0) at 
NSException.m:782
#1  0x06cb1d17 in -[EOAdaptorChannel 
selectAttributes:describedByQualifier:fetchOrder:lock:] (self=0x8a255108, 
_cmd=0x285bf220,
    attributes=0x889a7d28, qualifier=0x889a7d48, fetchOrder=0x0, 
lockFlag=0 '\000') at EOAdaptorChannel.m:282
#2  0x085e24f3 in -[SkyProjectFileManagerCache 
_primaryFetchAccountLogin4PersonIdCache] (self=0x7c675188, _cmd=0x285bf250)
    at SkyProjectFileManagerCache.m:736
#3  0x085e2839 in -[SkyProjectFileManagerCache accountLogin4PersonId:] 
(self=0x7c675188, _cmd=0x285bb188, _personId=0x8a079218)
    at SkyProjectFileManagerCache.m:774
#4  0x085cc6af in +[SkyProjectFileManager(FileAttributes) 
buildFileAttrsForDoc:editing:atPath:isVersion:projectId:projectName:projectNumber:fileAttrContext:]

(self=0x285bc460, _cmd=0x285bb068, _doc=0x889a7808, _editing=0x0, _path=0x0, 
_isVersion=0 '\000', _projectId=0x88acdb58, _pName=0x0,
    _pNumber=0x0, _context=0x7c675188) at 
SkyProjectFileManager+FileAttributes.m:546
#5  0x085ca7b9 in +[SkyProjectFileManager(FileAttributes) 
buildFileAttrsForDoc:editing:atPath:isVersion:projectId:fileAttrContext:] (
    self=0x285bc460, _cmd=0x285be370, _doc=0x889a7808, _editing=0x0, 
_path=0x0, _isVersion=0 '\000', _projectId=0x88acdb58, _context=0x7c675188)
    at SkyProjectFileManager+FileAttributes.m:162
#6  0x085de244 in -[SkyProjectFileManagerCache(Internals) rootFolderAttrs] 
(self=0x7c675188, _cmd=0x285be410)
    at SkyProjectFileManagerCache+Internals.m:1260
#7  0x085de2ce in -[SkyProjectFileManagerCache(Internals) 
fileAttributesAtPathCache] (self=0x7c675188, _cmd=0x285bcd30)
    at SkyProjectFileManagerCache+Internals.m:1275
#8  0x085d5cbd in -[SkyProjectFileManagerCache(Caching) 
fileAttributesAtPath:manager:] (self=0x7c675188, _cmd=0x285bc6c0, 
_path=0x285b9890,
    _manager=0x7e804888) at SkyProjectFileManagerCache+Caching.m:112
#9  0x085ce3fc in -[SkyProjectFileManager 
fileAttributesAtPath:traverseLink:] (self=0x7e804888, _cmd=0x285bc670, 
_path=0x285b9890,
    _followLink=0 '\000') at SkyProjectFileManager.m:364
#10 0x085d4988 in -[SkyProjectFileManager fileSystemAttributesAtPath:] 
(self=0x7e804888, _cmd=0x2476b850, _path=0x285b9890)
    at SkyProjectFileManager.m:1520
#11 0x0478f126 in -[SkyProject4Viewer fileSystemAttributes] 
(self=0x801c3208, _cmd=0x2476b630) at SkyProject4Viewer.m:399
#12 0x0478db1a in -[SkyProject4Viewer label] (self=0x801c3208, 
_cmd=0x2545efa0) at SkyProject4Viewer.m:125
#13 0x036dd439 in GSObjCGetVal (self=0x801c3208, key=0xcfbbfc90 "label", 
sel=0x2545efa0, type=0x86adad30 "@8@0:4", size=5, offset=6)
    at GSObjCRuntime.m:1507
#14 0x03627699 in ValueForKey (self=0x801c3208, key=0xcfbbfc90 "label", 
size=5) at NSKeyValueCoding.m:178
#15 0x036297d5 in -[NSObject(KeyValueCoding) valueForKey:] (self=0x801c3208, 
_cmd=0x26652378, aKey=0x26652440) at NSKeyValueCoding.m:749
#16 0x066696dc in -[SkyNavigation itemLabel] (self=0x8630f988, 
_cmd=0x7c0a8080) at SkyNavigation.m:80
#17 0x026512bc in _getComponentValue (self=0x8b7f6c28, object=0x8630f988, 
info=0x8b7f6e60) at WOKeyPathAssociation.m:528
#18 0x0265152a in _getOneValue (self=0x8b7f6c28, root=0x8630f988) at 
WOKeyPathAssociation.m:723
#19 0x02651f3c in -[WOKeyPathAssociation valueInComponent:] 
(self=0x8b7f6c28, _cmd=0x2260b450, _component=0x8630f988) at 
WOKeyPathAssociation.m:945
#20 0x0264e993 in -[WOAssociation valueInContext:] (self=0x8b7f6c28, 
_cmd=0x2261af88, _ctx=0x8630a008) at WOAssociation.m:227
#21 0x02689d26 in -[_WOComplexString appendToResponse:inContext:] 
(self=0x7d0f9b08, _cmd=0x22614660, _response=0x8630b508, _ctx=0x8630a008)
    at WOString.m:566
---Type <return> to continue, or q <return> to quit---q
Quit
(gdb) c
Continuing.
Jun 03 21:26:40 ogo-webui-1.1 [4495]: |ogo-webui-1.1| 
<OpenGroupware[0x0x8737e288]: name=ogo-webui-1.1>: caught:
  <PostgreSQL72Exception: 0x83eb7288> NAME:PostgreSQL72FatalError 
REASON:fatal pgsql error (channel=<0x0x8a255108[PostgreSQL72Channel]: 
connection=<0x0x7ecb4628[PGConnection]:  connection=0x0x7e4d0800>>): ERROR:  
column "yes" does not exist
LINE 1: ...ompany_id, t1.login FROM  person t1 WHERE t1.is_person = YES
                                                                    ^

in context:
  <0x0x8630a008[WOContext]: 006466315d18630a008 app=ogo-webui-1.1 
sn=118F118F01466315C3 eid=006466315d18630a008.0.15.1.1.3.2.3.1 rqeid=(nil)>.
Jun 03 21:26:40 ogo-webui-1.1 [4495]: |ogo-webui-1.1| terminating session 
due to exception: 118F118F01466315C3
Jun 03 21:26:40 ogo-webui-1.1 [4495]: |ogo-webui-1.1| WOServerSessionStore: 
session 118F118F01466315C3 terminated.
Jun 03 21:26:40 ogo-webui-1.1 [4495]: [da-handler] application terminates 
because it refuses new sessions and the active session count (0) is below 
the minimum (1).
10.0.0.9 - - [03/Jun/2007:21:26:40 
GMT] "GET
/OpenGroupware.woa/x/activate?woinst=4495&oid=12620&wosid=118F118F01466315C3 
HTTP/1.1" 200 897/0 30.638 - - -
Jun 03 21:26:40 ogo-webui-1.1 [4495]: <0x0x87638c48[WOHttpAdaptor]> adaptor 
stops application: <OpenGroupware[0x0x8737e288]: name=ogo-webui-1.1 
terminating> ...

Program exited normally.

it should be: t1.is_person = 1 instead of: t1.is_person = YES 

Sebastian