Ricardo Malla's Blog

TRUNCATE audit_log; SET FOREIGN_KEY_CHECKS = 0; DELETE ip_addresses; SET FOREIGN_KEY_CHECKS = 1; DELETE FROM lead_points_change_log WHERE YEAR(date_added) = YEAR(NOW()) AND MONTH(date_added) < (MONTH(NOW()) – 1); DELETE FROM lead_event_log WHERE (YEAR(date_added) = YEAR(NOW()) AND WEEK(date_added) < WEEK(NOW()) – 1); TRUNCATE email_stats_devices; DELETE FROM page_hits WHERE (YEAR(date_hit) = YEAR(NOW()) AND MONTH(date_hit) < MONTH(NOW()) – 1); SET FOREIGN_KEY_CHECKS […]

SET FOREIGN_KEY_CHECKS = 0; DELETE FROM ip_addresses; SET FOREIGN_KEY_CHECKS = 1;

  The BodyParser.php did not work as AmazonSES’s bounces report the Bounces through DSN.   I had to edit the DsnParser.php and add this line: elseif (preg_match(‘/Action: Failed/i’, $dsnReport)) { #echo “\n\ntest1\n\n”; $result[‘rule_cat’] = Category::INACTIVE; $result[‘rule_no’] = ‘0106’; }

Resolution here: https://github.com/mautic/mautic/issues/7768 After update to 2.15.2 i could not change the URL of Mautic installation not to include the “index.php” in the configuration in the Backend. After manually changing the url in the app/config/local.php, the problem (GET 301 redirect) disappeared.    

Need to backup and restore Customizations. On my case on the BodyParser.php for the bounced emails.

  If there are contacts on the campaign you will not be able to delete it, so you have to do it Manually.     DELETE campaign_leads FROM campaign_leads WHERE campaign_id = “THE CAMPIGN ID YOU WANT TO DELETE”; DELETE campaign_lead_event_log FROM campaign_lead_event_log WHERE campaign_id = “THE CAMPIGN ID YOU WANT TO DELETE”;

outlook.exe /cleanclientrules

  Popular Cloud Providers: Amazon Redshift Microsoft Azure SQL Data Warehouse Snowflake Google BigQuery

    =TRIM(RIGHT(SUBSTITUTE(LEFT(B2,FIND (” “,B2&” “,FIND(“@”,B2))-1),” “, REPT(” “,LEN(B2))),LEN(B2))). =LEFT(B2,FIND (” “,B2&” “,FIND(“@”,B2))-1

Fri Oct 11 18:16:51 2019 [10594][1][ERROR] Warning: Multiple links found for relationship a26_proveedor_contacts within module Contacts Fri Oct 11 18:16:51 2019 [10594][1][ERROR] Warning: Multiple links found for relationship a26_proveedor_contacts within module Contacts Fri Oct 11 18:16:51 2019 [10594][1][ERROR] Warning: Multiple links found for relationship a26_proveedor_contacts within module Contacts Fri Oct 11 18:16:51 2019 [10594][1][ERROR] Warning: […]

It is not possible to do using Studio. You need to create an extended vardefs and modify its field type: Create the file custom/Extension/modules/<ModuleName>/Ext/Vardefs/<somescript>.php and add the code below into it: <?PHP $dictionary[‘<BeanName>’][‘fields’][‘<FieldName>’][‘type’]= ‘html’; ?> Replace the content between “<>” by the appropriate values. Go to Admin -> Repair -> Quick Repair and Rebuild.     […]

docker ps -a docker start metabase   app/run_metabase.sh   docker run -dit –restart unless-stopped 6be30353fa96 docker container ls -a docker start 6be30353fa96 docker run -dit –restart unless-stopped 6be30353fa96   docker rm -f 46d2139a3a5f 181e245d2c2c 96f3579cbf03 docker start superset_superset_1   docker start 46d2139a3a5f docker stop 46d2139a3a5f     docker-compose run –rm superset ./docker-init.sh    

https://github.com/addyosmani/critical https://jonassebastianohlsson.com/criticalpathcssgenerator/

    {if $page_name==”index”} {literal} <style> #page { background-color: #FFFFFF; border-top-style: solid; border-top-width: 0; } </style> {/literal} {/if} https://www.prestashop.com/forums/topic/171541-css-for-home-only/ Or for example, for product page I use: {if isset($product->id)} <link rel=”canonical” href=”{$link->getProductLink($product)}” /> <link rel=”stylesheet” href=”/themes/default-bootstrap/css/global_criticalpath.css” type=”text/css” media=”all” /> {* <link rel=”stylesheet” href=”/themes/default-bootstrap/css/global_criticalpath_rev1.css” type=”text/css” media=”all” />*} {/if}

UPDATE email_addresses SET email_addresses.mautic = 1 WHERE email_address IN ( SELECT email_address FROM a0_custom_mautic_emails )

pjsip dump endpt — Dump the res_pjsip endpt internals pjsip export config_wizard primitives [to] — Export config wizard primitives pjsip list aors — List PJSIP Aors pjsip list auths — List PJSIP Auths pjsip list channels — List PJSIP Channels pjsip list ciphers — List available OpenSSL cipher names pjsip list contacts — List PJSIP […]