Skip to Content.
Sympa Menu

en - [sympa-users] Subscribers from mySQL?

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: j2 <address@concealed>
  • To: address@concealed
  • Subject: [sympa-users] Subscribers from mySQL?
  • Date: Wed, 13 Feb 2008 20:45:13 +0100

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)



visibility secret
reply_to_header
apply respect
value list
web_archive
access private

pictures_feature on
serial 1

subject [Info från kontinuitet!]

subscribe owner

shared_doc
d_edit private
d_read private
clean_delay_queuemod 15

unsubscribe open_notify
update
email address@concealed
date 13 feb 2008 at 19:16:54date_epoch 1202926614

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

review private
send privateoreditorkey

status open

ownerreception mail
profile privileged
email address@concealed
archive
period month
access owner

digest 5 20:56
custom_subject Info




----- Slut på vidarebefordrat meddelande -----


Archive powered by MHonArc 2.6.19+.

Top of Page