How to update 5 to 5.0.1 via composer?

escopecz · January 10, 2024, 4:27pm

There is an open GH issue for this:

Unable to pass DB migrations: Table 'point_groups' already exists

opened 12:03AM - 06 Dec 23 UTC

bug db-migrations

### Mautic Version 5.0.x series ### PHP version 8.1.26 ### What browsers are… you seeing the problem on? Not relevant ### What happened? Unable to pass DB migrations ### How can we reproduce this issue? Step 1: php bin/console doctrine:migration:migrate ### Relevant log output ```shell root@ma:/var/www/html/mautic# php bin/console doctrine:migration:migrate WARNING! You are about to execute a migration in database "uhlmautic" that could result in schema changes and data loss. Are you sure you wish to continue? (yes/no) [yes]: > yes [notice] Migrating up to Mautic\Migrations\Version20230627140512 [notice] Table contact_export_scheduler already exists [notice] Migration Mautic\Migrations\Version20220429091934 skipped during Pre-Checks. Reason: "Schema includes this migration" [notice] Migration Mautic\Migrations\Version20220722074516 skipped during Pre-Checks. Reason: "The deduplicate column has already been added to the notifications table." [notice] Migration Mautic\Migrations\Version20221014061125 skipped during Pre-Checks. Reason: "Index webhook_id_date_added already exists" [notice] Migration Mautic\Migrations\Version20221014081742 skipped during Pre-Checks. Reason: "Schema includes this migration" [notice] Migration Mautic\Migrations\Version20221128145933 skipped during Pre-Checks. Reason: "Schema includes this migration" [notice] Migration Mautic\Migrations\Version20230131133732 skipped during Pre-Checks. Reason: "The last_built_time column has already been added to the lead_lists table." [notice] Column asset_downloads.utm_campaign already exists [notice] Column asset_downloads.utm_content already exists [notice] Column asset_downloads.utm_medium already exists [notice] Column asset_downloads.utm_source already exists [notice] Column asset_downloads.utm_term already exists [notice] Migration Mautic\Migrations\Version20230321133733 skipped during Pre-Checks. Reason: "Schema includes this migration" [notice] Table plugin_crm_pipedrive_owners was already removed [notice] Migration Mautic\Migrations\Version20230519154448 skipped during Pre-Checks. Reason: "Schema includes this migration" [notice] Migration is not required. [notice] Migration Mautic\Migrations\Version20230606111852 skipped during Pre-Checks. Reason: "Schema includes this migration" [notice] Table point_groups already exists [notice] Table point_group_contact_score already exists [notice] Column points.group_id already exists [notice] Column point_triggers.group_id already exists [notice] Column lead_points_change_log.group_id already exists [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" In ExceptionConverter.php line 45: An exception occurred while executing a query: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'point_groups' already exists In Exception.php line 28: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'point_groups' already exists In Connection.php line 71: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'point_groups' already exists doctrine: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>] root@ma:/var/www/html/mautic# ``` ### Code of Conduct - [X] I confirm that I have read and agree to follow this project's Code of Conduct

Please follow the discussion and join in with new inputs.

Topic		Replies	Views
Trying to update to 5.1 from 5.0.4 Mautic 5 Install/Upgrade Support	22	1390	January 28, 2025
Error after update to Mautic5 Mautic 5 Install/Upgrade Support	10	1906	May 15, 2024
4.4.10 → 5.0.1 fails because Symfony Path is not fount in ParameterLoader.php Mautic 5 Install/Upgrade Support	11	1693	January 16, 2024
How's the outlook on updating from 4.1.2 to 4.4.3/4.4.4? Mautic 4 Install/Upgrade Support	33	1817	November 4, 2022
Upgrading with composer Product Support	10	1173	August 24, 2022

How to update 5 to 5.0.1 via composer?

Related topics