I am at my wits end, and asking for help on behalf of a "client" who I am
essentially doing Pro Bono work for.

This is running on Lasso 8.5, OS X 10.6 (I think) on a shared hosted server
at Point in Space.

The site has an existing function to send bulk emails to its members using
pre-designed templates. The problem occurs when they try to send the bulk
emails with an attachment. Lasso will send 20 or so of the 200 emails
before timing out, and in the process completely bogging down the server.

My work around was to add the bulk email script to the Lasso Event Queue as
a Scheduled Event. This worked wonderfully when I scheduled the event
through Lasso Admin. The bulk email script fired off, all 200 emails went
out, and the system didn't spike at all.

So I setup a small script to automatically add an event to the Event Queue
with the parameters provided for the bulk email:

var: 'my_date'=(date: (date_add: date_getcurrentdate, -minute=1));
inline:
-database='site',
-table='schedule',
-keyfield='id',
'date_time_start'=(date_format: ($my_date), -format='%Q %T'),
'date_time_end'='3001-01-01 00:00:00',
'next_execute'=(date_format: ($my_date), -format='%Q %T'),

'executeAction'='http://'(server_name)'/office/email_region_event.lasso?
FN='$FN
'&LN='$LN
'®Status='$regStatus
'®ion='$reg
'&officer='$officer
'&Sender_Name='$Sender_Name
'&subject='$subject
'&cc='$cc
'&footer='$footer
'&pa='$pa
'&attach='$attach
'&att_filepath='$att_filepath
'&template='$template
'&em='$em
'&incoming_name='$incoming_name
'&message='$message,
'repeat'=0,
'restart'=1,
'delay'=0,
'user'=var('site_un'),
'pass'=var('site_pw'),
-username=var('admin_un'),
-password=var('admin_pw'),
-Add;

The event gets added to the Event Queue, but just sits there, and never gets
run. If I manually pause, and resume the queue then the event runs as
expected.
-------------------------------------------------------
Seth C Ganahl (501) 282-4867
Ganahl Consulting =AD Web Applications
http://www.ganahlconsulting.com/
seth@ganahlconsulting.com
-------------------------------------------------------



#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso
Lasso@lists.lassosoft.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>