# CSV imports fail - stalling In Progress, Runtime Less than 1 second **URL:** https://forum.mautic.org/t/csv-imports-fail-stalling-in-progress-runtime-less-than-1-second/25199 **Category:** Product Support **Tags:** mautic-4 **Created:** [August 27, 2022, 4:11pm UTC](https://forum.mautic.org/t/csv-imports-fail-stalling-in-progress-runtime-less-than-1-second/25199 "2022-08-27T16:11:53Z") **Posts on this page:** 1 **Showing post:** 15
### Author: ![modifiedcontent](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/modifiedcontent/32/511_2.png) [@modifiedcontent](https://forum.mautic.org/u/modifiedcontent) #### Post date: [October 16, 2022, 2:19pm UTC](https://forum.mautic.org/t/csv-imports-fail-stalling-in-progress-runtime-less-than-1-second/25199/15 "2022-10-16T14:19:13Z")
What is the role of [lead\_event\_log](https://forum.mautic.org/t/csv-imports-fail-stalling-in-progress-runtime-less-than-1-second/25199/5) in importing via CSV? I tried to change collation of that table to utf8mb4\_general\_ci via PHPMyAdmin, but get a ‘foreign key contraint incorrectly formed’ error message. When I try to downgrade (?) that table from InnoDB to MYISAM I get this error message: ```auto Error Static analysis: 1 errors were found during analysis. Missing comma before start of a new alter operation. (near "DEFAULT CHARSET" at position 51) SQL query: Edit Edit ALTER TABLE `mtc_lead_event_log` ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE utf8_unicode_ci; MySQL said: Documentation #1071 - Specified key was too long; max key length is 1000 bytes ``` I tried ‘Optimize table’ in PHPMyAdmin, which returned this unhelpful message: ```auto username_mautic.lead_event_log optimize note Table does not support optimize, doing recreate + ... username_mautic.lead_event_log optimize status OK ``` ‘… recreate + …’ is apparently [‘… recreate + analyze instead’](https://stackoverflow.com/questions/30635603/what-does-table-does-not-support-optimize-doing-recreate-analyze-instead-me). And lo and behold, after two months without any useful help/hints from Mautic developers, it actually seems to have fixed my problem; import of the most basic CSV now results in ‘Runtime 2 seconds, Progress 100%, 2 inserted, 43 updated’. --- _[View the full topic](https://forum.mautic.org/t/csv-imports-fail-stalling-in-progress-runtime-less-than-1-second/25199)._