OK, we shouldn't just have asked within a slack channel for participation 😕

Thats the issue, I cant replicate it with a fresh install.

@micmc I suggest to join the Mautic forums for the upgrading issues, if you havn't tried it yet: https://forum.mautic.org/

I know that a migration from a version 4 - especially if its been a version 3 or 2 before, can be quite challenging. Database tables have updated charsets nower days and it looks there were some migrations missing in the earlier updates of Mautic. Also it depends if you used the composer method for updating... Lets see continue in the mautic forum.

(I'm talking about non cloudron installations. I have not a lot of experiences of updates via cloudron so far, the ones I did went quite well.)

Here is the tweak, to use composer with NPM in the LAMP stack (@girish might be interesting for other apps in the LAMP stack as well, if someone with knowledge can confirm this approach):

export NPM_CONFIG_CACHE=/tmp/npm_cache export NPM_CONFIG_USERCONFIG=/tmp/.npmrc

then

mkdir -p /tmp/npm_cache touch /tmp/.npmrc npm ci --prefer-offline --no-audit

probably better prefix it with

sudo -E -u www-data ...

otherwise new created directories have the wrong ownership and need to be adjusted with

chown www-data:www-data MailjetBundle/ -R

"MailjetBundle" was the example I used it for.

changed now. Makes much more sense. I had used https://en.wikipedia.org/wiki/Mauve !

As in, the email server has to call some webhook for bounces? We don't have such a mechanism. I guess you have to write some script that runs in a cronjob that monitors an inbox for bounces and then calls webook in the format required by the app.

I did a quick test and things to seem a bit faster. Mautic seems to make a lot of php requests, so I have made this configurable in any case.

👍 ♥

@dsp76 ha ha , no worries 🙂

and 4. are not installable via composer in my trials at cloudron. throws an error: Your requirements could not be resolved to an installable set of packages. Problem 1 - mautic/core-lib[5.0.0, ..., 5.0.4] require friendsofsymfony/oauth-server-bundle dev-upgrade-2 -> found friendsofsymfony/oauth-server-bundle[dev-master, 1.0.0, ..., 1.7.x-dev, 2.0.0-alpha.0, 2.0.x-dev (alias of dev-master)] but it does not match the constraint. - pabloveintimilla/mautic-amazon-ses[v1.0.0, ..., v1.0.2] require mautic/core-lib ^5.0 -> satisfiable by mautic/core-lib[5.0.0, ..., 5.0.4]. - Root composer.json requires pabloveintimilla/mautic-amazon-ses ^1.0 -> satisfiable by pabloveintimilla/mautic-amazon-ses[v1.0.0, v1.0.1, v1.0.2]. You can also try re-running composer require with an explicit version constraint, e.g. "composer require pabloveintimilla/mautic-amazon-ses:*" to figure out if any version is installable, or "composer require pabloveintimilla/mautic-amazon-ses:^2.1" if you know which you need. Installation failed, deleting ./composer.json.

Not sure if this is related to the Cloudron environment. I also wonder if this has a chance to succeed at all as the code path is read only by design?

Would a necessary plugin needed to be added to the cloudron mautic package?

... but you are welcome to the Mautic Community as well: https://forum.mautic.org/

Ah thanks, I get many errors in that UI, like

image.png

@luckow guess we have to report this upstream. It works sometimes with a lot of clicking around and trial/error.

@girish
Thanks! I see it now.
Appreciate the help.

@ekevu123 are you on package version 4.1.0 ? I think I fixed this exact issue . Can you check if your /app/data/config/local.php has mailer_dsn set? Also, have you disabled Cloudron email in the app's Email section by any chance?

@girish
All good now! Thanks!

updates are always only tested in sqeuence. But for testing I guess you can clone the app and manually update through the next package versions till 4.0.3. Basically update to 4.0.0 then check for updates and update again until 4.0.3

Anything in the logs? Which mautic package are you on?

@girish said in Mautic 5 Upgrades Failing:

@Dave-Swift The second error is open upstream at https://github.com/mautic/mautic/issues/12993 . The first one probably needs to be reported upstream as well. Do you have a complete log of the first error?

Experiencing the same thing, yeah there might be a need for a few adjustment with a major update as such.

So here's essentially what shows up in the log and Mautic is actually not responding, and trying to restart it will respond the same as this in the log:

Jan 18 10:26:07doctrine:migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--allow-no-migration] [--all-or-nothing [ALL-OR-NOTHING]] [--configuration CONFIGURATION] [--em EM] [--conn CONN] [--] [<version>] Jan 18 10:26:07In Connection.php line 70: Jan 18 10:26:07In Exception.php line 28: Jan 18 10:26:07In ExceptionConverter.php line 45: Jan 18 10:26:07 An exception occurred while executing a query: SQLSTATE[42S01]: Base table Jan 18 10:26:07 SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'point_group Jan 18 10:26:07 SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'point_group Jan 18 10:26:07 or view already exists: 1050 Table 'point_groups' already exists Jan 18 10:26:07 s' already exists Jan 18 10:26:07 s' already exists Jan 18 10:26:07[error] Migration Mautic\Migrations\Version20230621074925 failed during Execution. Error: "An exception occurred while executing a query: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'point_groups' already exists" Jan 18 10:26:07[2024-01-18 16:26:07] [notice] Column lead_points_change_log.group_id already exists Jan 18 10:26:07[2024-01-18 16:26:07] [notice] Column point_triggers.group_id already exists Jan 18 10:26:07[2024-01-18 16:26:07] [notice] Column points.group_id already exists Jan 18 10:26:07[2024-01-18 16:26:07] [notice] Table plugin_citrix_events already exists Jan 18 10:26:07[2024-01-18 16:26:07] [notice] Table point_group_contact_score already exists Jan 18 10:26:07[2024-01-18 16:26:07] [notice] Table point_groups already exists Jan 18 10:26:07[2024-01-18 16:26:07] [notice] Migrating up to Mautic\Migrations\Versionzz20230929183000 Jan 18 10:26:07[2024-01-18 16:26:07] [notice] Migration Mautic\Migrations\Version20221128145933 skipped during Pre-Checks. Reason: "Schema includes this migration" Jan 18 10:27:10=> Healtheck error: Error: connect ECONNREFUSED 172.18.18.22:8000 Jan 18 10:27:12[2024-01-18 16:27:12] Jan 18 10:27:12[2024-01-18 16:27:12] Jan 18 10:27:12[2024-01-18 16:27:12] [WARNING] You have 183 previously executed migrations in the database that are Jan 18 10:27:12[2024-01-18 16:27:12] not registered migrations.

It seems like the installation process attempts to create new tables and columns several times... 🤕

@girish said in PHP8.0 is supported for Mautic 4.4.10:

I have managed to update the package to Mautic 5 but the LDAP plugin needs to be updated because of upstream changes. Looking into this.

Any update on that one pal?
Looking forward for that update, with Composer and access to the marketplace etc. Take care.
Thanks.