Anyone on this?
On 14/09/2010 09:38, Alessio Fattorini wrote:
I have the same problem below, sogo.log is full of this message.
Should i run that command? this is my sogo_folder_info fields, are they wrong?
mysql> describe sogo_folder_info;
+------------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+---------------------+------+-----+---------+----------------+
| c_folder_id | bigint(20) unsigned | NO | UNI | NULL | auto_increment |
| c_path | varchar(255) | NO | PRI | NULL | |
| c_path1 | varchar(255) | NO | | NULL | |
| c_path2 | varchar(255) | YES | | NULL | |
| c_path3 | varchar(255) | YES | | NULL | |
| c_path4 | varchar(255) | YES | | NULL | |
| c_foldername | varchar(255) | NO | | NULL | |
| c_location | varchar(2048) | NO | | NULL | |
| c_quick_location | varchar(2048) | YES | | NULL | |
| c_acl_location | varchar(2048) | YES | | NULL | |
| c_folder_type | varchar(255) | NO | | NULL | |
+------------------+---------------------+------+-----+---------+----------------+
11 rows in set (0.00 sec)
On 03/02/2010 18:19, GAMBAROTTO Pierre wrote:
Le Mercredi 03 Février 2010 12:04 CET, Pierre
Gambarotto<pierre.gambaro...@enseeiht.fr> a écrit:
My configuration :
lenny with sogo 1.2.0.20100202
mysql-server-5.0
In sogo's log, I found those messages, lots of them :
2010-02-03 12:01:33.385 sogod[29653] ERROR: MySQL4 field is marked
unsigned (unsupported): {columnName = c_folder_id; name = c_folder_id; }
Thanks to xbgmsharp who gave me a pointer to the solution, already cited in the
list in
http://mail.opengroupware.org/pipermail/sogo/2009-December/004522.html
change the c_folder_id column's definition from unsigned bigint to bigint with
mysql client :
ALTER TABLE sogo_folder_info CHANGE c_folder_id c_folder_id BIGINT(20) NOT NULL
AUTO_INCREMENT ;
--
Alessio Fattorini (alessio.fattor...@nethesis.it)
nethesis srl - Via degli Olmi 16/4 - 61100 Pesaro (PU)
tel. +39 0721 405516 - fax +39 0721 268147
www.nethesis.it - i...@nethesis.it
--
users@sogo.nu
https://inverse.ca/sogo/lists