Bonnetot Jean-Daniel wrote:
I have a problem with the number of virtual users...
My system manages lot of users, some of them are deleted, many stays
and after some times, ids of virtual users grows over 65535 because of
auto_increment in MySQL.
In sql.errors, DSPAM says:
[08/07/2008 10:41:54] 16764: Duplicate entry '65535' for key 1: insert
into dspam_virtual_uids (uid, username) values(NULL,
'[EMAIL PROTECTED]')
I already have read something about this problem but I can't find it
anymore. Someone know this problem and the solution?
I haven't tried this but it sounds as though changing the 'uid' field to
a bigger integer type in MySQL would be sufficient; the error is coming
from MySQL not dspam, and dspam is simply asking for the next UID. MySQL
should be able to do that "live" without losing data (although again I
haven't tried this).
--
Mark Rogers // More Solutions Ltd (Peterborough Office) // 0845 45 89 555
Registered in England (0456 0902) at 13 Clarke Rd, Milton Keynes, MK1 1LG
!DSPAM:1011,489abdce150924523755307!
