I'm trying to create an sql addressbook. I think I did everything right, but I
can't see anything in the web interface when I search, and in the sogo logs I
get:
EXCEPTION: <NSException: 0xf95040> NAME:NSInvalidArgumentException
REASON:Number of objects does not match the number of keys. INFO:(nil)
And then sogo restarts.
I think I've got the view set up right. Here's the column names:
c_cn | cn | givenname | sn | title | department | homephone | mobile |
telephonenumber | fax | streetaddress | locality | st | zip | countryname |
birthdate | mail |
The relevant section in .GNUStepDaults / SOGoUserSources is:
{
type=sql;
id="SQL DIR";
viewURL =
"postgresql://sogo:passw...@localhost:5432/sogo/sogoaddress";
canAuthenticate = NO;
isAddressBook = YES;
}
I'm using the same postgres username / password to login to postgres for sogo's
contacts, calendars, etc. It is a different table, but same username/password,
etc.
As a simple test, I created this view with only one record that uses no weird
characters or anything like that.
Any ideas what is wrong? (Debian Lenny with Postgres 8.4 (backports)
Thanks,
Ben
--
[email protected]
https://inverse.ca/sogo/lists
