@modifiedcontent
Very sorry to hear youāre having such a hard time with the Mautic upgrade.
Based on the information youāve sent in this thread, Iād like to mention the following:
There are currently three ways to ādownloadā Mautic:
- From the official website (Download - Mautic Community)
- From the āReleasesā section on GitHub: Releases Ā· mautic/mautic Ā· GitHub ā at the bottom of every release, thereās a section called āassetsā that contains the exact same ZIP files as youād get from the official website.
- Clone from GitHub (GitHub - mautic/mautic: Mautic: Open Source Marketing Automation Software.) ā NOTE: this is only for development purposes (e.g. if you want to contribute to Mautic), not for usage in production scenarios!!!
Option 1 and 2 have the following folder structure (the screenshot below is from the Mautic 2.16.0 release, the folder structure will very slightly change with 3.0.0):
Option 3 (again, only for developers) also contains build, tests, etc. like you already mentioned above.
So, you have probably cloned from GitHub in the past and used that to install Mautic. This is not a supported scenario and thus may lead to issues in usage and upgrading.
Before we move on to troubleshooting further, Iād like to admit that thereās some things the Mautic team could improve regarding the upgrade process to make it rock-solid. Iām trying to track these things in the following GitHub issue: Make installation/upgrade scripts more robust for different environments Ā· Issue #8452 Ā· mautic/mautic Ā· GitHub. One of the things I just added based on your topic, is
Check if the user uses the official Mautic package or if they cloned from GitHub prior to upgrading and/or installing. The official package contains the right Composer dependencies out of the box, while with the GitHub source code there might be some issues when upgrading
We could e.g. show a clear warning that the user is in a non-supported upgrade scenario which might cause issues during the upgrade or even already at the installation phase.
The database error you reported above, I could indeed reproduce. Created a bug ticket for that: Function "Backup existing tables" in installation process throws error Ā· Issue #8457 Ā· mautic/mautic Ā· GitHub
Letās move on with troubleshooting now. Would you mind trying the following:
- Download the release version of Mautic 2.16.0 from Download - Mautic Community
- Extract the folder where you want to install Mautic and ensure your webserver has write permissions to all subfolders in your Mautic folder. Do NOT open the installer.
- Restore the backup of your 2.16.0 database that you made earlier
- Create the following file
app/config/local.php and add the following contents to it. Try to fill in as many values as you can (you can edit the mailer settings later through Mautic > Configuration):
<?php
$parameters = array(
'db_driver' => 'pdo_mysql',
'db_host' => 'db', // Your DB host (often this is localhost)
'db_table_prefix' => null, // Your DB prefix here (if any)
'db_port' => '3306', // Your DB port
'db_name' => 'db', // Your DB name
'db_user' => 'db', // Your DB user
'db_password' => 'db', // Your DB password
'db_backup_tables' => 0,
'db_backup_prefix' => 'bak_',
'mailer_from_name' => 'YOUR NAME',
'mailer_from_email' => 'YOUR EMAIL',
'mailer_transport' => 'mail',
'mailer_host' => null,
'mailer_port' => null,
'mailer_user' => null,
'mailer_password' => null,
'mailer_encryption' => null,
'mailer_auth_mode' => null,
'mailer_spool_type' => 'memory',
'mailer_spool_path' => '%kernel.root_dir%/spool',
'secret_key' => '038565447ad0e9c743a6e67d29c2212f39b4f73161b717f869c8de78ce61e1e4', // PLEASE REPLACE THIS WITH SOME RANDOM KEY
'site_url' => 'https://YOUR_MAUTIC_URL', // YOUR MAUTIC URL
);
This uses a fresh copy of the Mautic installation, but with your existing database. Hope this will get you up and running again!
Appreciate the quick response.
