The mailing list for listmasters using Sympa

[Brian Riffle <address@concealed>]

I have been installing Sympa on our Sendmail server, using Sybase as our 
DB backend.  (11.92 and 12.5).

I had found some errors that were generated with using Sybase and the 
database structure suggested in the documentation.  Primarily:
Subscriber table:
   subscribed_subscriber  numeric          null    ,
   included_subscriber    numeric                null    ,
Admin_table:
   subscribed_admin      numeric           null,
   included_admin      numeric           null,

The problem stems from the fact that the code uses SQL that does things 
like "Where subscribed_user = '1'".  Sybase treats things in quotes as a 
character, even if it is a number (gives CONVERT error).  To rectify 
this problem, I have changed these fields to varchar(18).  This seems to 
be working fine.  My question, however, is that I have had a bit of 
testing, but not extremely thorough.  Will this cause problems for me 
down the road?  From my brief looking at the code, I cannot see any 
indication of where these numbers would be incremented or manipulated.  
ie. changed to a '2'.

Thanks,
Brian

--
Brian Riffle
System and Network Administrator

Klamath Community College
7390 South 6th St
Klamath Falls, OR 97603

Phone   541.880.2245
Fax     541.885.7758