• Hello Fabrik Community

    Fabrik is now in the hands of the development team that brought you Fabrik for Joomla 4. We have recently transitioned the Fabrik site over to a new server and are busy trying to clean it up. We have upgraded the site to Joomla 4 and are running the latest version of Fabrik 4. We have also upgraded the Xenforo forum software to the latest version. Many of the widgets you might have been used to on the forum are no longer operational, many abandoned by the developers. We hope to bring back some of the important ones as we have time.

    Exciting times to be sure.

    The Fabrik 4.0 Official release is now available. In addition, the Fabrik codebase is now available in a public repository. See the notices about these in the announcements section

    We wish to shout out a very big Thank You to all of you who have made donations. They have really helped. But we can always use more...wink..wink..

    Also a big Thank You to those of you who have been assisting others in the forum. This takes a very big burden off of us as we work on bugs, the website and the future of Fabrik.

Sql conditions for email list plugin stopped working with the last official update

gnavarro

Member
Hi,

My config:
Fabrik 3.3.3
Joomla! 3.4.4
Template - Protostar
Updated from github
Access to site admin in my Fabrik account

Sql conditions for email list plugin are not working any more. I noticed this when installed the last official update from Fabrik... already updated from GitHub but problem persists.

When using any type of condition it will generate an incorrect query for the list.

Please advise. Thanks
 
Just noticed that also the option "Hide Subject" has an issue... the sow/hide is inverted... Is showing when we select "No" and hiding when we select "Yes"!!!
 
I've merged that commit - thanks Troester! I think its a recent change that Hugh added so hopefully little backwards compatibility issues
 
Hi,

I've just made a github update and the email list plugin are not working again!! Don't know why! I've tried to remove the SQL condition but problem persists.

It seams to exist a bug within the Fabrik code for this function.

Please help me.
 
Last edited:
Hi Rob,

What I've noticed is that is only sending emails when Mail Merge is set to "no". When I set it to "yes" it returns "0 emails sent"..."1 emails not sent"!

Sorry for the lack of information in the previous post :)
 
I don't think this is related to the issue above.
Was Merge=yes working before the update?
What are your plugin settings?
 
Hi Troester,

Yes before these last updates (Fabrik official and github) it was working like it is.

My Config

SQL Condition: data_liquidacao='0000-00-00 00:00:00' AND estado='Realizada'
Use WYSIWYG Editor:no
Send All:no

Send from user:no
From/Reply-to: facturacao@fisiolar.pt

Email or SMS: Email
Recipient method: Single
Get email address from: Defined in 'email to...
Email to: {fb_sessoes_fisioterapia___email_clt}
Email field display: Hidden
Hide subject: Yes

Message:
Exmo(a). Sr(a)...

Template: None
Content template: Email List Plugin (Aviso Pagamento)
Allow attachments:no

Merge emails: yes

Message preamble:
<br><br>
<table width="95%" border="0" align="center" cellspacing="5" cellpadding="0">
<tr>...

Message postamble
<br>
Relembramos que o pagamento do tratamento deve ser realizado semanalmente, ? data da ?ltima sess?o ocorrida. Assim sendo, agradecemos a r...

Update: Notifica??o de Pagamento
Update value: Pagamento
Update: Data de Notifica??o de Pagamento
Update value: now()

Hope it helps...
 
Try with
Email to: {fb_sessoes_fisioterapia___email_clt_raw}

{fb_sessoes_fisioterapia___email_clt} may contain a "mailto:..." or a link to details which are no valid email addresses
 
Hi Troester,

It worked! ;)

Now the only problem is that "Email field display: Hidden" is not hiding the email feild!!

Thanks.
 
Email field display is working on my site (hidden, readonly, editable).
The "Hide subject" option is inverted.
 
Sorry! I was editing the plugin from a copied list and not from the original one.

The only bug is the "Hide subject" option is inverted.

Thanks for all your help!
 
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top