Redmine: Installation
Posted onhttps://www.linode.com/docs/applications/project-management/how-to-install-and-configure-redmine-on-ubuntu-16-04/
Mautic: Helpful Queries to Audit your System
Posted onTo 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: PrestaShopExeption
Posted onWhen 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.
Prestashop: Limit the number of Products on Manufacturer list
Posted onWe have about 5000 products from a certain manufacturer but we only want to issue 500 per query, as the 5000 product query is hurting our server. To do this you go to ~/classes/Manufacturer.php You need to add the limit on 2 queries: The first one (line ~364) count the number of products per manufacturer […]
Apache: Memory Leak – Tweaking Prefork
Posted onOn 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.