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<[email protected]> 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 ([email protected]) nethesis srl - Via degli Olmi 16/4 - 61100 Pesaro (PU) tel. +39 0721 405516 - fax +39 0721 268147 www.nethesis.it - [email protected]
-- [email protected] https://inverse.ca/sogo/lists
