The mailing list for listmasters using Sympa

[Brian Riffle <address@concealed>]

Olivier,
   Thank you for such a quick reply.  I have re-installed sympa (since 
its just a test box right now) with the new List.pm.  Unfortunately, it 
appears that there is a problem still with List.pm.  I am getting an error:

Dec 16 10:38:55 mail2 task_manager[24391]: Unable to execute SQL 
statement "INSERT INTO admin_table (user_admin, comment_admin, 
list_admin, date_admin, update_admin, 
reception_admin,subscribed_admin,included_admin,include_sources_admin, 
role_admin, info_admin, profile_admin) VALUES ('address@concealed', 
'Brian Riffle', 'kccannouncements', 
dateadd(second,1134758335,"01/01/1970"), 
dateadd(second,1134758335,"01/01/1970"), 'mail', '1', NULL, NULL, 
'owner', NULL, 'privileged')" : Server message number=257 severity=16 
state=1 line=1 text=Implicit conversion from datatype 'VARCHAR' to 
'NUMERIC' is not allowed.  Use the CONVERT function to run this query. 

I have found this on line 5277 of List.pm.  It appears to be the same 
issue, it is treating the value as a char, not as numeric. 
It appears to be:  $dbh->quote($new_admin_user->{'subscribed'}).  It has 
been a long time since I have used Perl, and am not sure how to modify 
this to make it not do the quotes. 

Thanks,
Brian Riffle

--
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