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
Update with composer from 4.4.3 -> 4.4.4 Mautic 4 Install/Upgrade Support	2	661	December 30, 2022
Updating from 5.02 to 5.03 with composer update - Doesn't update version Product Support	2	178	March 1, 2024
Mautic Update Composer 5.0.2. to 5.0.3. \| Not Updating mautic/core-lib Product Support	2	415	February 8, 2024
Installing via Composer Mautic 4 Install/Upgrade Support	4	1074	December 8, 2023
Trying to update to 5.1 from 5.0.4 Mautic 5 Install/Upgrade Support	22	1127	January 28, 2025

How to update 5 to 5.0.1 via composer?

Related topics