Thanks for that. The field I had to add c_category (not c_categories) I had to add it to the quick table which does the calendar as opposed to contacts.
The script in question (sql-update-1.3.3_to_1.3.4.sh) refers to the Contacts table. As I thought, I had already run it. When I reran it, luckily, it just said that the fieldname was already there for all my users' contact tables. loads of lines like this ..... ERROR: column "c_categories" of relation "sogohallj0900b365f7997_quick" already exists ERROR: column "c_categories" of relation "sogohomerl0900575031a7a_quick" already exists ERROR: column "c_categories" of relation "sogoscottt090025e560e92_quick" already exists ERROR: column "c_categories" of relation "sogoholdswor0067fec48aa_quick" already exists ERROR: column "c_categories" of relation "sogorobinson0031d36d832_quick" already exists ERROR: column "c_categories" of relation "sogocarveri0011244dd79a_quick" already exists ERROR: column "c_categories" of relation "sogobambridg00c355534f9_quick" already exists ERROR: column "c_categories" of relation "sogochiltone0072c2b0b70_quick" already exists ERROR: column "c_categories" of relation "sogostaplesj001238a71ea_quick" already exists ERROR: column "c_categories" of relation "sogoeglons0900a45592d61_quick" already exists ....... I updated from an earlier version than 1.33. Is there an older script that does an update to the fields in the Calendar quick tables? Brian On 26 January 2011 15:31, Francis Lachapelle <[email protected]> wrote: > > On Jan 25, 2011, at 6:28 AM, Brian Lockwood wrote: > > > Apologies for a long post. Also, [email protected] seems to be the new place > to post sogo messages as my messages to [email protected] do not > appear. > > Yes, since May 2010 .. ;) > > > I use SOGo for the school email system but wanted to expand use of the > calendar. Unfortunately it seems to have broken, probably since the 1.33 > upgrade. > > I get errors in the sogo log (placed below this message). > > > > When I upgraded, I ran a database upgrade script that came with the > upgrade. > > Mail and address books all seem fine for all users. > > I added a field into my sogobrianloc00117296d89 table of the datatype > varchar(10) called c_category and this seemed to make the problem go away. > > > > Jan 24 18:50:39 sogod [15291]: [ERROR] <0x0xaa479f8[GCSFolder]> > -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute > quick-fetch SQL 'SELECT > b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_uid,a.c_startdate,a.c_enddate > FROM sogobrianloc00117296d89_quick a, sogobrianloc00117296d89 b WHERE > ((c_component = 'vevent') AND (c_iscycle = 1)) AND a.c_name = b.c_name AND > (c_deleted != 1 OR c_deleted IS NULL)': <PostgreSQL72Exception: 0x9464da0> > NAME:PostgreSQL72FatalError REASON:fatal pgsql error > (channel=<0x0xac78c40[PostgreSQL72Channel]: > connection=<0x0x943c1a0[PGConnection]: connection=0x0xaa8efd8>>): ERROR: > column a.c_category does not exist > > You didn't executed the update script (sql-update-1.3.3_to_1.3.4.sh). It > adds the c_categories field for all the quick addressbook tables. > > > Francis > > -- > [email protected] :: +1.514.755.3640 :: http://www.inverse.ca > Inverse :: Leaders behind SOGo (http://sogo.nu) and PacketFence ( > http://packetfence.org) > > -- > [email protected] > https://inverse.ca/sogo/lists -- [email protected] https://inverse.ca/sogo/lists
