2010.05.25 12:32 Thomas Damgaard rašė: > 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)
Is database updated as someone said on this list about a week ago? ---------------------------- Originali žinutė ---------------------------- Tema: [SOGo] database change in nightlies Nuo: "Wolfgang Sourdeau" <[email protected]> Data: 2010.05.19 17:59 Kam: "SOGo List" <[email protected]> -------------------------------------------------------------------------- Hi everyone, We have updated the database schema yesterday, which will prevent SOGo from working properly unless you apply a script or reinitialize your tables. To do so, please execute the script named "sql-update-1.2.2_to_1.2.3.sh" in the documentation directory. Thanks -- Wolfgang Sourdeau :: +1 (514) 447-4918 ext. 125 :: [email protected] Inverse inc. Leaders behind SOGo (www.scalableogo.org) and PacketFence (www.packetfence.org)
-- [email protected] https://inverse.ca/sogo/lists
