Uncategorized

Mautic: Understanding Database

Posted on

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 […]

Uncategorized

Mautic: Amazon SES DSN Partes

Posted on

  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’; }

Uncategorized

Mautic: Cannot Login after update

Posted on

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.    

Uncategorized

Mautic: Cannot Delete Campaign

Posted on

  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”;

Uncategorized

SugarCRM: Multiple links found for relationship

Posted on

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: […]

Uncategorized

SugarCRM: Convert Field to HTML

Posted on

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.     […]

Uncategorized

Docker Commands

Posted on

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    

Uncategorized

Prestashop: Add css to affect only one page.

Posted on

    {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}

Uncategorized

Asterisk: pjsip commands

Posted on

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 […]