Remark: I upgraded to 2.3 from 2.17a if it makes any difference. 2015-06-05 4:22 GMT+03:00 westlake <[email protected]>:
> 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 > -- Parimatega, Raido Rinaldi hooldustehnik Mob. 510 2834 [email protected] Kuvarnet OÜ | +372 747 5542 | Riia 181C III korrus, Tartu 51014 skype: arvutihooldus | www.kuvarnet.ee | ithooldus.net -- [email protected] https://inverse.ca/sogo/lists
