Mautic

Mautic: Helpful Queries to Audit your System

Posted on

  To  check how many emails are triggered and sent for your campaigns Today. SELECT leads.id, leads.email, leads.company, leads.custom_mkt_drip, campaign_lead_event_log.* FROM campaign_lead_event_log left join leads on campaign_lead_event_log.lead_id = leads.id left join email_stats ON leads.email = email_stats.email_address WHERE DATE(date_triggered) = DATE(NOW()) AND campaign_lead_event_log.is_scheduled = 0 AND campaign_lead_event_log.channel = “email” AND metadata NOT LIKE “%failed%” ORDER BY […]

Prestashop

Prestashop: PrestaShopExeption

Posted on

When inputting the incorrect Product ID. Would like to have this redirected to 404, as of now getting a 500 error that damages SEO To disable this you can disable DEBUG Mode on /config/defines.inc.php   define(‘_PS_MODE_DEV_’, false);   And you will get a 500 Error. I would like to get a 404 Error Instead.  

Apache

Apache: Memory Leak – Tweaking Prefork

Posted on

On htop, got over 100 apache threads. Changed <IfModule mpm_prefork_module> StartServers 5 MinSpareServers 5 MaxSpareServers 10 MaxRequestWorkers 150 MaxConnectionsPerChild 0 </IfModule>   To <IfModule mpm_prefork_module> StartServers 5 MinSpareServers 5 MaxSpareServers 10 MaxRequestWorkers 150 MaxConnectionsPerChild 5000 </IfModule> Will test.