# Mautic hangs on contact upload wizard **URL:** \ **Category:** Product Support\ **Created:** [July 19, 2017, 6:30am UTC](https://forum.mautic.org/t/mautic-hangs-on-contact-upload-wizard/8987 "2017-07-19T06:30:24Z")\ **Posts on this page:** 14\ **Page:** 1

**Author:** ![lead2crm](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/lead2crm/32/1634_2.png) [@lead2crm](https://forum.mautic.org/u/lead2crm)\ **Post date:** [July 19, 2017, 6:30am UTC](https://forum.mautic.org/t/mautic-hangs-on-contact-upload-wizard/8987/1 "2017-07-19T06:30:24Z")

My screen is frozen when trying to upload 140 contacts with only 4 columns up update. Any ideas? I have it set at 150 Please do not leave this page until complete. Import is in progress. 0% 0 / 137 Cancel ---

**Author:** ![JoPitts](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/jopitts/32/636_2.png) [@JoPitts](https://forum.mautic.org/u/JoPitts)\ **Post date:** [July 21, 2017, 3:07am UTC](https://forum.mautic.org/t/mautic-hangs-on-contact-upload-wizard/8987/3 "2017-07-21T03:07:15Z")

@lead2crm , any thing in the error logs? What are the four columns? ---

**Author:** ![lead2crm](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/lead2crm/32/1634_2.png) [@lead2crm](https://forum.mautic.org/u/lead2crm)\ **Post date:** [July 21, 2017, 7:56pm UTC](https://forum.mautic.org/t/mautic-hangs-on-contact-upload-wizard/8987/4 "2017-07-21T19:56:54Z")

The only thing I saw in the error logs was related to a seperate issue I was shaving regarding segments. I was going to login right now, try to upload and see if I could generate a fresh error for the error log; however, now my mautic dahsboard page is loading funny as if it’s missing a css file and I cant navigate the tool. So many bugs… ![](http://www.lead2crm.com/images/mautic_error.png) ---

**Author:** ![lead2crm](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/lead2crm/32/1634_2.png) [@lead2crm](https://forum.mautic.org/u/lead2crm)\ **Post date:** [July 21, 2017, 8:29pm UTC](https://forum.mautic.org/t/mautic-hangs-on-contact-upload-wizard/8987/5 "2017-07-21T20:29:47Z")

The only thing the logs show are related to a different issue I am having in segments, even though I just tried to do list import. [2017-07-21 20:43:02] mautic.NOTICE: DoctrineDBALExceptionSyntaxErrorException: An exception occurred while executing ‘SELECT count(distinct(l.id)) as lead\_count, max(l.id) as max\_id FROM MAP2q\_leads l INNER JOIN MAP2q\_lead\_lists\_leads ll ON l.id = ll.lead\_id WHERE (ll.date\_added \<= ‘2017-07-21 20:43:02’) AND (ll.manually\_added = ?) AND (ll.leadlist\_id = 36) AND (l.id NOT IN (SELECT l.id FROM MAP2q\_leads l INNER JOIN MAP2q\_companies\_leads cl ON l.id = cl.lead\_id INNER JOIN MAP2q\_companies comp ON cl.company\_id = comp.id WHERE (comp.platform\_\_eloqua = ?) AND (()) GROUP BY l.id))’ with params [0, “Yes”]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)) GROUP BY l.id))’ at line 1 (uncaught exception) at /home/lead2crm/public\_html/map/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 90 while running console command `mautic:segments:update` [] [] ---

**Author:** ![lead2crm](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/lead2crm/32/1634_2.png) [@lead2crm](https://forum.mautic.org/u/lead2crm)\ **Post date:** [July 21, 2017, 10:38pm UTC](https://forum.mautic.org/t/mautic-hangs-on-contact-upload-wizard/8987/6 "2017-07-21T22:38:27Z")

im actually running 2.82 mautic, but when i tried to update to 2.9, the installation wasnt successful 100%. . The installer got stuck on the clearing application cache step and i checked the schema and it said there as an error and the error logs confirm the installation had issues; however, i could still browse around mautic and i saw some of the 2.9 changes in the import wizard, but when i tried my import i got a server 500 error. I have since reverted back to 2.8.2 ---

**Author:** ![JoPitts](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/jopitts/32/636_2.png) [@JoPitts](https://forum.mautic.org/u/JoPitts)\ **Post date:** [July 24, 2017, 2:03am UTC](https://forum.mautic.org/t/mautic-hangs-on-contact-upload-wizard/8987/7 "2017-07-24T02:03:05Z")

and did reverting back resolve the problem? What are the four columns you are trying to import? ---

**Author:** ![lead2crm](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/lead2crm/32/1634_2.png) [@lead2crm](https://forum.mautic.org/u/lead2crm)\ **Post date:** [July 24, 2017, 1:32pm UTC](https://forum.mautic.org/t/mautic-hangs-on-contact-upload-wizard/8987/8 "2017-07-24T13:32:14Z")

Reverting back did not solve this problem, it must have started when i updated to the previous (and now current version I’m using) 2.8.2. I hadnt done a list import in quite some time (months). The error I have above in the error log is unrelated to this and doesnt appear in my log. The error above is solved in v2.9 as a known bug. These are the fields I was trying to update:. Lead Owner, email address, company, first name, last name and a custom contact field. ---

**Author:** ![JoPitts](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/jopitts/32/636_2.png) [@JoPitts](https://forum.mautic.org/u/JoPitts)\ **Post date:** [July 24, 2017, 7:19pm UTC](https://forum.mautic.org/t/mautic-hangs-on-contact-upload-wizard/8987/9 "2017-07-24T19:19:40Z")

Then I guess you need to get a stable upgrade to 2.9 sorted out. Have you tried re-running the upgrade? I know they say that seeing as there are no schema updates, you can run it from within the UI, but maybe try from the shell instead. ---

**Author:** ![lead2crm](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/lead2crm/32/1634_2.png) [@lead2crm](https://forum.mautic.org/u/lead2crm)\ **Post date:** [July 25, 2017, 12:28am UTC](https://forum.mautic.org/t/mautic-hangs-on-contact-upload-wizard/8987/10 "2017-07-25T00:28:16Z")

I’m going to have to get someone to do that for me, i waved goodbye to web dev in 2008 ---

**Author:** ![JoPitts](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/jopitts/32/636_2.png) [@JoPitts](https://forum.mautic.org/u/JoPitts)\ **Post date:** [July 25, 2017, 12:43am UTC](https://forum.mautic.org/t/mautic-hangs-on-contact-upload-wizard/8987/11 "2017-07-25T00:43:17Z")

Don’t need any web dev skills… just a little linux/unix Follow the instructions here (but do the pre 2.6.0 method) [https://www.mautic.org/community/index.php/8022-2-9-0-released](https://www.mautic.org/community/index.php/8022-2-9-0-released) Cheers Jo ---

**Author:** ![lead2crm](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/lead2crm/32/1634_2.png) [@lead2crm](https://forum.mautic.org/u/lead2crm)\ **Post date:** [July 25, 2017, 4:23am UTC](https://forum.mautic.org/t/mautic-hangs-on-contact-upload-wizard/8987/12 "2017-07-25T04:23:55Z")

So, I loaded it from shell, here’s my new error log since that failed: [2017-07-25 01:12:22] mautic.ERROR: PHP Notice: require(): Failed opening required ‘/home/lead2crm/public\_html/map/app/cache/prod/doctrine/orm/Proxies/\_\_CG\_\_MauticPluginBundleEntityPlugin.php’ (include\_path=’.:/usr/local/php56/pear’) - in file /home/lead2crm/public\_html/map/vendor/doctrine/common/lib/Doctrine/Common/Proxy/AbstractProxyFactory.php - at line 209 [] [] [2017-07-25 01:12:22] mautic.ERROR: SymfonyComponentDebugExceptionFatalErrorException: Notice: require(): Failed opening required ‘/home/lead2crm/public\_html/map/app/cache/prod/doctrine/orm/Proxies/\_\_CG\_\_MauticPluginBundleEntityPlugin.php’ (include\_path=’.:/usr/local/php56/pear’) - in file /home/lead2crm/public\_html/map/vendor/doctrine/common/lib/Doctrine/Common/Proxy/AbstractProxyFactory.php - at line 209 [] [] [2017-07-25 05:14:02] mautic.NOTICE: DoctrineDBALExceptionSyntaxErrorException: An exception occurred while executing ‘SELECT count(distinct(l.id)) as lead\_count, max(l.id) as max\_id FROM MAP2q\_leads l INNER JOIN MAP2q\_lead\_lists\_leads ll ON l.id = ll.lead\_id WHERE (ll.date\_added \<= ‘2017-07-25 05:14:02’) AND (ll.manually\_added = ?) AND (ll.leadlist\_id = 48) AND (l.id NOT IN (SELECT l.id FROM MAP2q\_leads l INNER JOIN MAP2q\_companies\_leads cl ON l.id = cl.lead\_id INNER JOIN MAP2q\_companies comp ON cl.company\_id = comp.id WHERE (comp.temporarily\_disable\_marke = ?) AND (()) GROUP BY l.id))’ with params [0, “TRUE”]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)) GROUP BY l.id))’ at line 1 (uncaught exception) at /home/lead2crm/public\_html/map/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 90 while running console command `mautic:segments:update` [] [] [2017-07-25 05:15:02] mautic.NOTICE: DoctrineDBALExceptionSyntaxErrorException: An exception occurred while executing ‘SELECT count(distinct(l.id)) as lead\_count, max(l.id) as max\_id FROM MAP2q\_leads l INNER JOIN MAP2q\_lead\_lists\_leads ll ON l.id = ll.lead\_id WHERE (ll.date\_added \<= ‘2017-07-25 05:15:02’) AND (ll.manually\_added = ?) AND (ll.leadlist\_id = 48) AND (l.id NOT IN (SELECT l.id FROM MAP2q\_leads l INNER JOIN MAP2q\_companies\_leads cl ON l.id = cl.lead\_id INNER JOIN MAP2q\_companies comp ON cl.company\_id = comp.id WHERE (comp.temporarily\_disable\_marke = ?) AND (()) GROUP BY l.id))’ with params [0, “TRUE”]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)) GROUP BY l.id))’ at line 1 (uncaught exception) at /home/lead2crm/public\_html/map/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 90 while running console command `mautic:segments:update` [] [] [2017-07-25 05:16:02] mautic.NOTICE: DoctrineDBALExceptionSyntaxErrorException: An exception occurred while executing ‘SELECT count(distinct(l.id)) as lead\_count, max(l.id) as max\_id FROM MAP2q\_leads l INNER JOIN MAP2q\_lead\_lists\_leads ll ON l.id = ll.lead\_id WHERE (ll.date\_added \<= ‘2017-07-25 05:16:02’) AND (ll.manually\_added = ?) AND (ll.leadlist\_id = 48) AND (l.id NOT IN (SELECT l.id FROM MAP2q\_leads l INNER JOIN MAP2q\_companies\_leads cl ON l.id = cl.lead\_id INNER JOIN MAP2q\_companies comp ON cl.company\_id = comp.id WHERE (comp.temporarily\_disable\_marke = ?) AND (()) GROUP BY l.id))’ with params [0, “TRUE”]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)) GROUP BY l.id))’ at line 1 (uncaught exception) at /home/lead2crm/public\_html/map/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 90 while running console command `mautic:segments:update` [] [] [2017-07-25 05:17:01] mautic.NOTICE: DoctrineDBALExceptionSyntaxErrorException: An exception occurred while executing ‘SELECT count(distinct(l.id)) as lead\_count, max(l.id) as max\_id FROM MAP2q\_leads l INNER JOIN MAP2q\_lead\_lists\_leads ll ON l.id = ll.lead\_id WHERE (ll.date\_added \<= ‘2017-07-25 05:17:01’) AND (ll.manually\_added = ?) AND (ll.leadlist\_id = 48) AND (l.id NOT IN (SELECT l.id FROM MAP2q\_leads l INNER JOIN MAP2q\_companies\_leads cl ON l.id = cl.lead\_id INNER JOIN MAP2q\_companies comp ON cl.company\_id = comp.id WHERE (comp.temporarily\_disable\_marke = ?) AND (()) GROUP BY l.id))’ with params [0, “TRUE”]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)) GROUP BY l.id))’ at line 1 (uncaught exception) at /home/lead2crm/public\_html/map/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 90 while running console command `mautic:segments:update` [] [] [2017-07-25 05:18:02] mautic.NOTICE: DoctrineDBALExceptionSyntaxErrorException: An exception occurred while executing ‘SELECT count(distinct(l.id)) as lead\_count, max(l.id) as max\_id FROM MAP2q\_leads l INNER JOIN MAP2q\_lead\_lists\_leads ll ON l.id = ll.lead\_id WHERE (ll.date\_added \<= ‘2017-07-25 05:18:02’) AND (ll.manually\_added = ?) AND (ll.leadlist\_id = 48) AND (l.id NOT IN (SELECT l.id FROM MAP2q\_leads l INNER JOIN MAP2q\_companies\_leads cl ON l.id = cl.lead\_id INNER JOIN MAP2q\_companies comp ON cl.company\_id = comp.id WHERE (comp.temporarily\_disable\_marke = ?) AND (()) GROUP BY l.id))’ with params [0, “TRUE”]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)) GROUP BY l.id))’ at line 1 (uncaught exception) at /home/lead2crm/public\_html/map/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 90 while running console command `mautic:segments:update` [] [] [2017-07-25 05:18:55] mautic.NOTICE: DoctrineDBALExceptionDriverException: An exception occurred while executing ‘insert into MAP2q\_companies (companyname, is\_published) (SELECT DISTINCT TRIM(company), 1 from MAP2q\_leads l left join MAP2q\_companies c ON l.company = c.companyname where company IS NOT NULL and company \<\> ‘’ and c.companyname is null)’: Illegal mix of collations (utf8\_unicode\_ci,IMPLICIT) and (utf8\_general\_ci,IMPLICIT) for operation ‘=’ (uncaught exception) at /home/lead2crm/public\_html/map/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 while running console command `doctrine:migrations:migrate` ---

**Author:** ![lead2crm](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/lead2crm/32/1634_2.png) [@lead2crm](https://forum.mautic.org/u/lead2crm)\ **Post date:** [July 25, 2017, 4:48am UTC](https://forum.mautic.org/t/mautic-hangs-on-contact-upload-wizard/8987/13 "2017-07-25T04:48:54Z")

Note: While the “applying migrations failed”, mautic is running pretty well so far. The upload wizard works and did import records; however, im probably going to have to revert back to 2.8.2 because I dont want a partially working update that I cant update to 3.0 when that comes out (or other versions) because mine is so broken. ---

**Author:** ![lead2crm](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/lead2crm/32/1634_2.png) [@lead2crm](https://forum.mautic.org/u/lead2crm)\ **Post date:** [July 25, 2017, 5:54am UTC](https://forum.mautic.org/t/mautic-hangs-on-contact-upload-wizard/8987/14 "2017-07-25T05:54:52Z")

As far as the original topic, 2.9 fixes the bug with the contact wizard.