Hello all
We are using sogo to provide shared calenders and address books for a
couple of customers. Recently, we are getting some very bad database
problems when trying to create calendar events with a set category. If
we create events with no category, everything seems to work.
The error we get is MODIFICATION_FAILED if using thunderbird. If we
use the web interface, nothing happens. Our request is simply ignored.
In the log file, we see the following kind of errors:
<0x0xd0d130[GCSFolder]> ERROR(-[GCSFolder
writeContent:toName:baseVersion:]): cannot insert content :
<PostgreSQL72Exception: 0x1073ab0> NAME:PostgreSQL72FatalError
REASON:fatal pgsql error (channel=<0x0x157e400[PostgreSQL72Channel]:
connection=<0x0x13d4920[PGConnection]: connection=0x0x18defa0>>):
ERROR: column "c_category" of relation
"sogotrhsikke00333f36be0_quick" does not exist
LINE 1: ...uick (c_partstates, c_orgmail, c_uid, c_sequence, c_category...
^
Clearly, it seems that a column is missing. When we look in the
database, this column is indeed missing. When creating a new user,
their table gets the c_category column, which indicates some kind of
missing table upgrade.
As far as I understand, foo_quick is just a parsed version of foo. If
this is true, is there any way (a command perhaps?), to regenerate
*_quick?
I hope there is a simple and easy solution :)
Version info:
Sogo: 1.2.2.20100524 (running on Debian/Lenny)
Newest thunderbird 2.x
Connector: 0.9.9, 0.99 (we have also tested with 0.10 + 0.100)
Med venlig hilsen/Kind regards
Thomas Damgaard Nielsen
http://thomasdamgaard.dk
--
[email protected]
https://inverse.ca/sogo/lists
