The mailing list for listmasters using Sympa

[j2 <address@concealed>]

  Quoting j2 <address@concealed>:

> I just cannot get my head around this, no matter what guides i
read, i 
> still get an error about Syntax error in filter when i try to add
a 
> mySQL subscriber source to my list.
>
> Could some friendly soul point out how i should modify the below 
> config to pull all subscribers from mySQL
>
> my query is
> select distinct email from jos_events_registrations where
session_id = 
> (select session_id from jos_events_sessions where email <> '' and 
> title like 'kontinuitet%' order by session_up desc limit 1)

  Sorry, i upgraded from 5.3b1 to 5.3.4 and now i do not get a filter  
error, but it doesnt work. i still see nothing when i go to check  
subscribers.

wrong list config enclosed *ahem* Correct below. Regardless,


visibility secret

review private

reply_to_header
apply respect
value list

web_archive
access private

pictures_feature on

serial 5

subject [Info från kontinuitet!]

subscribe owner

send editorkey

status open

shared_doc
d_edit private
d_read private

user_data_source database


available_user_options
reception digest,digestplain,html,mail,nomail,not_me,notice,summary,txt,urlize

clean_delay_queuemod 15

rfc2369_header_fields archive,help,owner,post,subscribe,unsubscribe

owner
reception mail
profile privileged
email address@concealed

archive
period month
access owner

unsubscribe open_notify

include_sql_query
db_name insidan
name festinfo
db_port 3306
host localhost
passwd yesihaveapasswordwhichididntincludeinthepost
db_type mysql
user kn-utils
sql_query select distinct email from jos_events_registrations where  
session_id = (select session_id from jos_events_sessions where email  
<> ''
and title like 'kontinuitet%' order by session_up desc limit 1)

digest 5 20:56

creation
email address@concealed
date 13 feb 2008 at 19:09:00
date_epoch 1202926140

update
email address@concealed
date 13 feb 2008 at 20:55:13
date_epoch 1202932513

custom_subject festinfo