The mailing list for listmasters using Sympa

["Mark Keisler" <address@concealed>]

Make sure that the query is one a single line.  Also make sure that you
can run that query normally through the mysql command line interface.

On Wed, February 13, 2008 2:02 pm, j2 wrote:
>
>    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
>
>
>
>
>
>
>