Mautic: Installation Update Upgrade Troubleshooting

von RICARDOS.COMAug 9, 2022IT, Marketing0 Kommentare

Mautic Installation

// Verzeichniswechsel in den entsprechenden vhost 
cd /var/www/vhost/mautic.testing.dev.ricardos.net/

Mautic Paket von Github laden

# Alle Releases: https://github.com/mautic/mautic/releases
# Gewünschtes Paket: https://github.com/mautic/mautic/releases/download/4.4.1/4.4.1.zip
# Mit wget Mautic-Paket von Github holen
wget  https://github.com/mautic/mautic/releases/download/4.4.1/4.4.1.zip

Mautic Paket entpacken

unzip 4.4.1.zip

Mautic Verzeichnisse und Dateien dem Webserver zuweisen

chown -R www-data:www-data .

Berechtigungen setzen

#Methode 1: relativ
chmod -R 755 .
#Methode 2: absolut
chmod -R 755 /var/www/vhost/mautic.testing.dev.ricardos.net/

Mautic in einem Unterverzeichnis installieren / Install Mautic in subfolder

Mautic in a subfolder / Mautic im Unterverzeichnis
Mautic im Unterverzeichnis Error 403
// htaccess fix for mautic in a subfolder
<If "%{REQUEST_URI} =~ m#^/map/(index|index_dev|upgrade/upgrade)\.php#">
// *replace map with your foldername

Mautic Update

// Go to Mautic Directory
cd /var/www/vhost/mautic.testing.dev.ricardos.net/
// Search for Mautic Update
/opt/plesk/php/7.4/bin/php bin/console mautic:update:find
// If new Update available
/opt/plesk/php/7.4/bin/php bin/console mautic:update:apply
// If Update done
/opt/plesk/php/7.4/bin/php bin/console mautic:update:apply --finish
// Clear Cache
/opt/plesk/php/7.4/bin/php bin/console cache:clear
// Set Cache folder permissions
chown -R www-data:www-data var/cache/*

Mautic TroubleshootingHOT

Solve the view Segments Problem

/* Ein Upgrade des DB-Schemas kann zu einem Problem mit IDX_SEARCH führen */
mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'SELECT DATE_FORMAT(t.date_added, '%Y-%m-%d') AS date, COUNT(*) AS count FROM map_lead_event_log t USE INDEX (map_IDX_SEARCH) WHERE (t.object = ?) AND (t.bundle = ?) AND (t.action = ?) AND (t.object_id = ?) AND (t.date_added BETWEEN ? AND ?) GROUP BY DATE_FORMAT(t.date_added, '%Y-%m-%d') ORDER BY DATE_FORMAT(t.date_added, '%Y-%m-%d') ASC LIMIT 32' with params ["segment", "lead", "added", "2", "2022-08-18 00:00:00", "2022-09-18 23:59:59"]:  SQLSTATE[42000]: Syntax error or access violation: 1176 Key 'map_IDX_SEARCH' doesn't exist in table 't'" at /var/www/mautic.testing.dev.ricardos.net/map/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'SELECT DATE_FORMAT(t.date_added, '%Y-%m-%d') AS date, COUNT(*) AS count FROM map_lead_event_log t USE INDEX (map_IDX_SEARCH) WHERE (t.object = ?) 

/* INDEX erstellen mit folgendem Statement (yourprefix entsprechend anpassen) */

CREATE INDEX yourprefix_IDX_SEARCH ON yourprefix_lead_event_log (object, bundle, action, object_id, date_added)

[dsm_star_rating show_number=”on” _builder_version=”4.18.0″ _module_preset=”default” global_colors_info=”{}”][/dsm_star_rating]