here i updated a system from squeeze to jessie debian which I merely
just ran two alter statements for each calendar table.
if you look at the script you get the main sql select statement to
determine which tables need later updating.
first get the calendar table/s that need updating,
select SUBSTRING_INDEX(c_quick_location, '/', -1) from $indextable where
c_path3 = 'Calendar'
here I had two calendar tables so i had to apply these following two
commands for each one
ALTER TABLE $table MODIFY c_partstates mediumtext
ALTER TABLE $table ADD COLUMN c_description mediumtext
you can find out what is $indextable by seeing which table has c_path3
if you're using mysql client it should be relatively easy
eg,
\r sogo
describe tables;
and then try the first,
here for me it was
describe sogo_folder_info; // and this one showed me c_path3 ,
so to list what the calendar tables are you use the __folder_info table,
which in my case it was sogo_folder_info
select SUBSTRING_INDEX(c_quick_location, '/', -1) from sogo_folder_info
where c_path3 = 'Calendar' ;
result for me was two calendar tables
sogoadmin00000000000_quick
sogowlake11111111111_quick
the alter statements then looks something like this,
ALTER TABLE sogoadmin00000000000_quick MODIFY c_partstates mediumtext;
ALTER TABLE sogoadmin00000000000_quick ADD COLUMN c_description mediumtext;
the same two commands again but with the other calendar table
..
Hope this helps to fix the problem with updating -- I suppose you're
using a debian-based system similarly to the one I'm using.
not to be rude but is calendaring "reminders" supported on the sogo
server? I asked this on the mailinglist yesterday but got no reply. I
thought it was not so an intrusive question but of its simplicity a good
yes or no would do.
thanks
--
[email protected]
https://inverse.ca/sogo/lists
