On 20/09/2010 09:13, Alessio Fattorini wrote:
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?
The command
ALTER TABLE sogo_folder_info CHANGE c_folder_id c_folder_id BIGINT(20)
NOT NULL AUTO_INCREMENT ;
will change the definition of c_folder_id from bigint(20) unsigned to
bigint(20), thus removing the warning in log files.
Done it, been happy since :-)
Pierre
mysql> describe sogo_folder_info;
+------------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+---------------------+------+-----+---------+----------------+
| c_folder_id | bigint(20) unsigned | NO | UNI | NULL | auto_increment |
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 ;
--
[email protected]
https://inverse.ca/sogo/lists
