[5.x]: Craft 5 upgrade issue

[tejubhe]

What happened?

Description

When trying for Craft 4 to craft 5 upgrade.
When i disable formie plugin then only i am able to login in the backend , if i kept the formie plugin then getting continue option in the backend for DB changes.
This total migrations are need to be migrated for Formie migrations to be applied:
- m231125_000000_craft5
- m231129_000000_integrations_mapping
- m231130_000000_conditions_mapping
- m231202_000000_auth_module
- m240130_000000_permissions
- m240313_000000_subfields
- m240318_000000_fix_content_table
- m240318_000000_migrate_stencils
- m240318_000000_notification_fields
- m240325_000000_notifications_custom_settings
- m240407_000000_payment_fk
- m240507_000000_entry_integration_ids
- m240528_000000_payment_fk
- m250113_000000_calculations
- m250114_000000_email_blocked_domains
- m250711_000000_fix_element_field_source_ids
- m250806_000000_integrations_optin

Its failing from the backend PFA screenshot

When I run this via command php craft migrate/all
Getting this
*** applying m231125_000000_craft5
> dropping foreign key on {{%formie_fieldlayout_pages}} if it exists ... done (time: 0.022s)
> dropping foreign key on {{%formie_fieldlayout_rows}} if it exists ... done (time: 0.018s)
> dropping foreign key on {{%formie_fieldlayout_rows}} if it exists ... done (time: 0.039s)
> dropping foreign key on {{%formie_fields}} if it exists ... done (time: 0.018s)
> dropping foreign key on {{%formie_fields}} if it exists ... done (time: 0.051s)
> dropping foreign key on {{%formie_fields}} if it exists ... done (time: 0.102s)
> dropping foreign key on {{%formie_fields}} if it exists ... done (time: 0.099s)
> drop index idx_aoarrbxbhkjrzmkzmolhciaffmfwpujlpxkp on {{%formie_fieldlayout_pages}} ... done (time: 0.069s)
> drop index idx_fajtvrafhwnrbhvqwhdrjxnlacpommosckme on {{%formie_fieldlayout_rows}} ... done (time: 0.031s)
> drop index idx_jieazgccwpbpjhdeeyvfbgumhiluneougvne on {{%formie_fieldlayout_rows}} ... done (time: 0.032s)
> drop index idx_uexbacmuxbzoicocquztqydhebjwuhdlbypb on {{%formie_fields}} ... done (time: 0.018s)
> drop index idx_sadvafqdymahzoxncbwrjjiuqhcnjaboinej on {{%formie_fields}} ... done (time: 0.018s)
> drop index idx_nbyjuforcrfhghczlogvnormyeljdlvivhya on {{%formie_fields}} ... done (time: 0.020s)
> drop index idx_tjxwxeuuaqwfyeswagrrekdptzxazbxyivsg on {{%formie_fields}} ... done (time: 0.026s)
> drop index idx_gcgzgoqgqagevgcybwzqrarwyounkkxonsbs on {{%formie_fields}} ... done (time: 0.027s)
> dropping foreign key on {{%formie_forms}} if it exists ... done (time: 0.078s)
> dropping index on {{%formie_forms}} if it exists ... done (time: 0.060s)
> create index idx_wdqpjcjltksdklnwouhldzhqlfydqtrkzouu on {{%formie_fieldlayout_pages}} (layoutId) ... done (time: 0.043s)
> create index idx_dwyaiosyrqoeythhdhehqifnhoqqxdotsmum on {{%formie_fieldlayout_rows}} (layoutId) ... done (time: 0.039s)
> create index idx_ewfktzbssjlwcamimxowhsarngoklelwtyko on {{%formie_fieldlayout_rows}} (pageId) ... done (time: 0.031s)
> create index idx_epqwfqxvqnirqrtxhvtyblkkhyboqiyzemvz on {{%formie_fields}} (layoutId) ... done (time: 0.028s)
> create index idx_pmlmhbuedzlkogvpsgxmnnntwsdkeyambihm on {{%formie_fields}} (pageId) ... done (time: 0.051s)
> create index idx_mhjtajeisfmbsvfuykolevnqueosjpmbrjlv on {{%formie_fields}} (rowId) ... done (time: 0.136s)
> create index idx_oygsqmmlkuwosayeyjovxeykkhodslurrleb on {{%formie_fields}} (handle) ... done (time: 0.028s)
> create index idx_exnvjvpahkfcecwglzfesmacvigwnsfssphi on {{%formie_fields}} (syncId) ... done (time: 0.030s)
> add foreign key fk_seoqgoernholwfjywpntkrlmuqlnbshsmzjt: {{%formie_fieldlayout_pages}} (layoutId) references {{%formie_fieldlayouts}} (id) ... done (time: 0.160s)
> add foreign key fk_scbzafgdkrdjewuctszgrbtnrgadnvoymnft: {{%formie_fieldlayout_rows}} (layoutId) references {{%formie_fieldlayouts}} (id) ... done (time: 0.142s)
> add foreign key fk_zwxdsogemwfosqxepaorlbnkprvxxqomzkry: {{%formie_fieldlayout_rows}} (pageId) references {{%formie_fieldlayout_pages}} (id) ... done (time: 0.130s)
> add foreign key fk_gjrvmxmyhaesquatlozvwkdgzlalaeqyngvf: {{%formie_fields}} (layoutId) references {{%formie_fieldlayouts}} (id) ... done (time: 0.154s)
> add foreign key fk_krpydbohdzraewgxfvmacrvxkhrsoxwgkeiy: {{%formie_fields}} (pageId) references {{%formie_fieldlayout_pages}} (id) ... done (time: 0.156s)
> add foreign key fk_wsihysmnkqryromyietwhitbnluuijotesgm: {{%formie_fields}} (rowId) references {{%formie_fieldlayout_rows}} (id) ... done (time: 0.158s)
> add foreign key fk_jzcixawxzzvbtoxgoihrjuglyssceonvyyew: {{%formie_fields}} (syncId) references {{%formie_fields}} (id) ... done (time: 0.165s)
> create index idx_dwjoefjzgvzzsszlioszuukabipdjtczsjds on {{%formie_forms}} (layoutId) ... done (time: 0.044s)
> add foreign key fk_cxvvjpwvvduanshkesuvvqloztzgtezgebpo: {{%formie_forms}} (layoutId) references {{%formie_fieldlayouts}} (id) ... done (time: 0.177s)
> dropping foreign key on {{%formie_forms}} if it exists ... done (time: 0.012s)
> dropping index on {{%formie_forms}} if it exists ... done (time: 0.001s)
> update in {{%elements_sites}} ... done (time: 0.017s)
> Updated form #9741 title to IFA Form.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated form #24259 title to Individuals Form.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated form #31734 title to Individuals Email.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated form #31739 title to Branch & CSD Invest Form.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated form #44833 title to IFA email.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated form #44841 title to Generic.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated form #44842 title to Professional Email.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated form #44843 title to Professionals Form.
> update in {{%elements_sites}} ... done (time: 0.008s)
> Updated form #44844 title to Charities Email.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated form #44845 title to Charities Form.
> update in {{%elements_sites}} ... done (time: 0.011s)
> Updated form #44846 title to Pensions Email.
> update in {{%elements_sites}} ... done (time: 0.008s)
> Updated form #44847 title to Pensions Form.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated form #49184 title to CSD Financial Plans.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated form #164057 title to Individuals Email (Direct).
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated form #178961 title to IFA Event Form.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated form #180127 title to Professionals Event Form.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated form #186934 title to Careers form.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated form #1133546 title to Individuals Form - Plan options.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated form #2307541 title to Question form.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated form #2753082 title to FP Event form.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated form #4061549 title to OneStep.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated form #4061552 title to Coaching.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated form #6179986 title to Make Money your wealth event form.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated form #6188029 title to Partnerships form.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated form #6209917 title to IFA Roadshows form.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated form #6217286 title to IFA DDQ Form.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated form #6360277 title to Ask a question.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208828 title to 2022-05-08 00:54:50.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated submission #208829 title to 2022-05-08 00:54:50.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208830 title to 2022-05-08 00:54:50.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208831 title to 2022-05-08 00:54:50.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208832 title to 2022-05-08 00:54:51.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208833 title to 2022-05-08 00:54:51.
> update in {{%elements_sites}} ... done (time: 0.009s)
> Updated submission #208834 title to 2022-05-08 00:54:51.
> update in {{%elements_sites}} ... done (time: 0.008s)
> Updated submission #208835 title to 2022-05-08 00:55:21.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208836 title to 2022-05-08 00:55:21.
> update in {{%elements_sites}} ... done (time: 0.008s)
> Updated submission #208837 title to 2022-05-08 00:55:21.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208838 title to 2022-05-08 00:55:22.
> update in {{%elements_sites}} ... done (time: 0.008s)
> Updated submission #208839 title to 2022-05-08 00:55:22.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208840 title to 2022-05-08 00:55:23.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208841 title to 2022-05-08 00:55:23.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208842 title to 2022-05-08 00:55:24.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208843 title to 2022-05-08 00:55:24.
> update in {{%elements_sites}} ... done (time: 0.008s)
> Updated submission #208844 title to 2022-05-08 00:55:24.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated submission #208845 title to 2022-05-08 00:55:25.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208846 title to 2022-05-08 00:55:25.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated submission #208847 title to 2022-05-08 00:55:25.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208848 title to 2022-05-08 00:55:26.
> update in {{%elements_sites}} ... done (time: 0.008s)
> Updated submission #208849 title to 2022-05-08 00:55:29.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated submission #208850 title to 2022-05-08 00:55:29.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208851 title to 2022-05-08 00:55:29.
> update in {{%elements_sites}} ... done (time: 0.008s)
> Updated submission #208852 title to 2022-05-08 00:55:30.
> update in {{%elements_sites}} ... done (time: 0.008s)
> Updated submission #208853 title to 2022-05-08 00:55:31.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated submission #208854 title to 2022-05-08 00:55:31.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208855 title to 2022-05-08 00:55:31.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated submission #208856 title to 2022-05-08 00:55:32.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208857 title to 2022-05-08 00:55:33.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208858 title to 2022-05-08 00:55:33.
> update in {{%elements_sites}} ... done (time: 0.006s)
> Updated submission #208859 title to 2022-05-08 00:55:34.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208860 title to 2022-05-08 00:55:34.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208861 title to 2022-05-08 00:55:34.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208862 title to 2022-05-08 00:55:34.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208863 title to 2022-05-08 00:55:35.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208864 title to 2022-05-08 00:55:36.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208865 title to 2022-05-08 00:55:36.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208866 title to 2022-05-08 00:55:36.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208867 title to 2022-05-08 00:55:37.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208868 title to 2022-05-08 00:55:37.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208869 title to 2022-05-08 00:55:37.
> update in {{%elements_sites}} ... done (time: 0.007s)
> Updated submission #208870 title to 2022-05-08 00:55:39.
And this continues and after some time due to timeout it stopped.
I checked the elements_sites table entries count form DB its showing me as 7.3m rows.
My composer.json contains
"craftcms/cms": "5.8.18",
"verbb/formie": "3.1.4",
In the logs I am only getting below logs
5-10-16 06:26:26 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:26:31 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:26:37 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:26:47 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:26:47 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:26:47 [xxx.xx.xxx.xX][4820643][733f1d2ca5eb6af75d10f9bccc5c558e][info][application] Password Policy plugin loaded
2025-10-16 06:26:47 [xxx.xx.xxx.xX][4820643][733f1d2ca5eb6af75d10f9bccc5c558e][info][application] Password Policy plugin loaded
2025-10-16 06:26:49 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:26:53 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:26:53 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:26:58 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:26:58 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:27:03 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:27:03 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:27:08 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:27:08 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:27:13 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:27:14 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:27:14 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:27:19 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:27:19 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:27:24 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:27:25 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:27:30 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:27:30 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:27:35 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:27:35 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:27:40 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded
2025-10-16 06:27:40 [xxx.xxx.xxx.x][-][-][info][application] Password Policy plugin loaded

Steps to reproduce

Expected behavior

Actual behavior

n

Craft CMS version

Craftcms Pro 5.8.18 previous was Craft Pro 4.16.14

PHP version

8.2.29

Operating system and version

Docker Image based deployed in Azure

Database type and version

Mysql 8.0.4

Image driver and version

Imagick

Installed plugins and versions

Formie version - 3.1.4

[linear]

CMS-1640

[Thijmen]

Have you tried running craft up without any memory limit or timeout via CLI?

[tejubhe]

Yes, I tried that also.
After that php craft up its showing pending migrations.

• m231125_000000_craft5
• m231129_000000_integrations_mapping
• m231130_000000_conditions_mapping
• m231202_000000_auth_module
• m240130_000000_permissions
• m240313_000000_subfields
• m240318_000000_fix_content_table
• m240318_000000_migrate_stencils
• m240318_000000_notification_fields
• m240325_000000_notifications_custom_settings
• m240407_000000_payment_fk
• m240507_000000_entry_integration_ids
• m240528_000000_payment_fk
• m250113_000000_calculations
• m250114_000000_email_blocked_domains
• m250711_000000_fix_element_field_source_ids
• m250806_000000_integrations_optin

and causing same problem that after some time my azure cli disconnects and again it starts from start.And its not completing

[tejubhe]

Any suggestions on this please.

[timkelty]

@tejubhe in your Azure CLI environment, what do you get running this:

php -i | grep -E "memory_limit|max_execution_time"

As @Thijmen hinted, you could try forcing those values, e.g.:

php -d max_execution_time=0 -d memory_limit=2048M craft up

[tejubhe]

Hi Team , any updates Please.
I tried DELETE FROM elements WHERE type = 'verbb\formie\elements\Submission';
Now the migration was completed successfully .
But data was not available in the control panel for the Matrix field type and plain text type.

[brandonkelly]

@tejubhe Did you see @timkelty’s last comment?