Hi, Le 04/06/2015 18:45, ra...@kuvarnet.ee a écrit : > I uprgaded sogo to 2.3 version. Now I need to run sql update script, but I get > following error. Any help would be appreciated. > > sogo@tormsrvsogo:/usr/share/doc/sogo$ bash sql-update-2.1.17_to_2.3.0-mysql.sh > Username (sogo): root > Hostname (127.0.0.1): localhost > Database (sogo): sogo > This script will ask for the sql password twice > Converting c_partstates from VARCHAR(255) to mediumtext in calendar quick > tables > Enter password: > Enter password: > ERROR 1060 (42S21) at line 1: Duplicate column name 'c_description' >
You have to delete the c_description columns, I had the same problem during my update. I'm not versed enough in SQL to send a modified script but basically, you can replace the creation of the column by a drop command in the script. I hope someone can contribute a proper script. Fabrice -- users@sogo.nu https://inverse.ca/sogo/lists
