Thu, 07 Aug 2008 13:30:29 +0100, Mark Rogers : Re: [dspam-users] Over 65535 dspam_virtual_uids > Bonnetot Jean-Daniel wrote: > > I thought about this but it seems DSPAM use int concerning uid. Int > > in C language is between 0 and 65535. > > So, if MySQL can change his limits (SMALLINT to INT, 65535 to > > 4294967295), DSPAM can't unless patching code... > > > > Not really, then, other than as you suggest patching the code. Seems > a bit shortsighted to be limited to 65535 these days, so I'm sure the > patch would likely be accepted. > > In the unlikely event that there are a large number of unused uid > values at the end of the range (eg if 60000 - 65535 have been used > but deleted so are spare) you could tell MySQL to change the > auto_increment value down to buy you some time. >
Yes, this is the solution for the moment. I wrote a script which takes the uid on the end of the list and moves them to the start. The script updates all tables to guarantee the consistence of data. Then auto_increment is changed to be just after the bigger uid. The url of the script : http://geekarea.fr/share/dspam_reindex_uid.pl -- .`'`. BONNETOT Jean-Daniel : ': : `. ` .` PRIVIANET `'` Sys & Net Admin !DSPAM:1011,489c3f56150921164912110!
