# 500 error when opening contacts - 1.4.0 **URL:** \ **Category:** General Discussion\ **Created:** [May 13, 2016, 1:57pm UTC](https://forum.mautic.org/t/500-error-when-opening-contacts-1-4-0/3765 "2016-05-13T13:57:38Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![pfernandes](https://avatars.discourse-cdn.com/v4/letter/p/e47774/32.png) [@pfernandes](https://forum.mautic.org/u/pfernandes)\ **Post date:** [May 13, 2016, 1:57pm UTC](https://forum.mautic.org/t/500-error-when-opening-contacts-1-4-0/3765/1 "2016-05-13T13:57:38Z")
Hi there! I have updated to 1.4 and now I Can’t open any contact! 500 error!!! Can someone help me please… ![](http://postimg.org/image/r4kr5v3nl/) ---
**Author:** ![pfernandes](https://avatars.discourse-cdn.com/v4/letter/p/e47774/32.png) [@pfernandes](https://forum.mautic.org/u/pfernandes)\ **Post date:** [May 13, 2016, 1:57pm UTC](https://forum.mautic.org/t/500-error-when-opening-contacts-1-4-0/3765/2 "2016-05-13T13:57:38Z")
Hi there! I have updated to 1.4 and now I Can’t open any contact! 500 error!!! Can someone help me please… ![](http://postimg.org/image/r4kr5v3nl/) ---
**Author:** ![pfernandes](https://avatars.discourse-cdn.com/v4/letter/p/e47774/32.png) [@pfernandes](https://forum.mautic.org/u/pfernandes)\ **Post date:** [May 13, 2016, 1:58pm UTC](https://forum.mautic.org/t/500-error-when-opening-contacts-1-4-0/3765/3 "2016-05-13T13:58:05Z")
![](http://s32.postimg.org/ru3ji8479/Captura_de_ecra_2016_05_13_a_s_15_54_03.png) ---
**Author:** ![Antonio\_Lazzari](https://avatars.discourse-cdn.com/v4/letter/a/e99b99/32.png) [@Antonio\_Lazzari](https://forum.mautic.org/u/Antonio_Lazzari)\ **Post date:** [May 13, 2016, 2:07pm UTC](https://forum.mautic.org/t/500-error-when-opening-contacts-1-4-0/3765/4 "2016-05-13T14:07:21Z")
I have the same error. During the installation the “cleaning chache” process stopped working. I try to reinstall and I have the same problem: “clear cache” doesn’t stop and work for hours. I clear chache manually but some menu work some other don’t work, getting Error 500. I can’t see: dashboard and leads, all the other menu work fine ---
**Author:** ![Simon](https://avatars.discourse-cdn.com/v4/letter/s/f07891/32.png) [@Simon](https://forum.mautic.org/u/Simon)\ **Post date:** [May 18, 2016, 2:23am UTC](https://forum.mautic.org/t/500-error-when-opening-contacts-1-4-0/3765/5 "2016-05-18T02:23:55Z")
I get the same. 500 errors ---
**Author:** ![escopecz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/escopecz/32/370_2.png) [@escopecz](https://forum.mautic.org/u/escopecz)\ **Post date:** [May 19, 2016, 7:23am UTC](https://forum.mautic.org/t/500-error-when-opening-contacts-1-4-0/3765/6 "2016-05-19T07:23:46Z")
Guys, I write this for the 10th time today… Check the Mautic logs in app/logs dir and the server logs to learn more about the cause of the error. ---
**Author:** ![Antonio\_Lazzari](https://avatars.discourse-cdn.com/v4/letter/a/e99b99/32.png) [@Antonio\_Lazzari](https://forum.mautic.org/u/Antonio_Lazzari)\ **Post date:** [June 14, 2016, 12:16pm UTC](https://forum.mautic.org/t/500-error-when-opening-contacts-1-4-0/3765/7 "2016-06-14T12:16:32Z")
I Ecopecz, I was out of the office for a long time. Sorry, you are right, that’s what I have: [2016-06-14 11:44:17] mautic.WARNING: PHP Warning: require(/home/impronte/marketing/app/cache/prod/doctrine/orm/Proxies/\_\_CG\_\_MauticCategoryBundleEntityCategory.php): failed to open stream: No such file or directory - in file /home/impronte/marketing/vendor/doctrine/common/lib/Doctrine/Common/Proxy/AbstractProxyFactory.php - at line 207 [] [] [2016-06-14 11:44:17] mautic.ERROR: Fatal: require(): Failed opening required ‘/home/impronte/marketing/app/cache/prod/doctrine/orm/Proxies/\_\_CG\_\_MauticCategoryBundleEntityCategory.php’ (include\_path=’.:/usr/lib/php:/usr/local/lib/php’) - in file /home/impronte/marketing/vendor/doctrine/common/lib/Doctrine/Common/Proxy/AbstractProxyFactory.php - at line 207 [] [] Any suggestions? ---
**Author:** ![escopecz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/escopecz/32/370_2.png) [@escopecz](https://forum.mautic.org/u/escopecz)\ **Post date:** [June 14, 2016, 12:24pm UTC](https://forum.mautic.org/t/500-error-when-opening-contacts-1-4-0/3765/8 "2016-06-14T12:24:18Z")
This does seem like a cache issue. Try to delete the app/cache directory. Make sure Mautic has permission to generate the new cache files in it. If you Mautic serves many requests for example by tracking a busy website, create a temporary index.html page in the Mautic root directory, clear the cache with the `app/console cache:clear` command and then delete the index.html file again. The issue with busy websites is that the cache generation will start multiple times and causes inconsistency. ---
**Author:** ![Antonio\_Lazzari](https://avatars.discourse-cdn.com/v4/letter/a/e99b99/32.png) [@Antonio\_Lazzari](https://forum.mautic.org/u/Antonio_Lazzari)\ **Post date:** [June 15, 2016, 11:22am UTC](https://forum.mautic.org/t/500-error-when-opening-contacts-1-4-0/3765/9 "2016-06-15T11:22:46Z")
Hi @escopecz I solved, I make by hand the tables and all work fine. ---
**Author:** ![Antonio\_Lazzari](https://avatars.discourse-cdn.com/v4/letter/a/e99b99/32.png) [@Antonio\_Lazzari](https://forum.mautic.org/u/Antonio_Lazzari)\ **Post date:** [June 15, 2016, 9:54am UTC](https://forum.mautic.org/t/500-error-when-opening-contacts-1-4-0/3765/10 "2016-06-15T09:54:37Z")
I @escopecz after the procedure the log change and I had this three kind of error: [2016-06-15 08:41:49] mautic.WARNING: IP LOOKUP: Failed to connect to [freegeoip.net](http://freegeoip.net) port 80: Connection timed out [] [] [2016-06-15 09:36:00] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALDBALException: “An exception occurred while executing ‘SELECT COUNT(_) AS dctrn\_count FROM (SELECT DISTINCT id10 FROM (SELECT m0\_.is\_published AS is\_published0, m0\_.date\_added AS date\_added1, m0\_.created\_by AS created\_by2, m0\_.created\_by\_user AS created\_by\_user3, m0\_.date\_modified AS date\_modified4, m0\_.modified\_by AS modified\_by5, m0\_.modified\_by\_user AS modified\_by\_user6, m0\_.checked\_out AS checked\_out7, m0\_.checked\_out\_by AS checked\_out\_by8, m0\_.checked\_out\_by\_user AS checked\_out\_by\_user9, m0\_.id AS id10, m0\_.name AS name11, m0\_.type AS type12, m0\_.width AS width13, m0\_.height AS height14, m0\_.cache\_timeout AS cache\_timeout15, m0\_.ordering AS ordering16, m0\_.params AS params17 FROM maugl\_widgets m0\_ WHERE m0\_.created\_by = ? ORDER BY m0\_.ordering ASC) dctrn\_result) dctrn\_table’ with params [1]: Table ‘impronte\_maut413.maugl\_widgets’ doesn’t exist" at /home/impronte/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 {“exception”:"[object] (Doctrine\DBAL\DBALException(code: 0): An exception occurred while executing 'SELECT COUNT(_) AS dctrn\_count FROM (SELECT DISTINCT id10 FROM (SELECT m0\_.is\_published AS is\_published0, m0\_.date\_added AS date\_added1, m0\_.created\_by AS created\_by2, m0\_.created\_by\_user AS created\_by\_user3, m0\_.date\_modified AS date\_modified4, m0\_.modified\_by AS modified\_by5, m0\_.modified\_by\_user AS modified\_by\_user6, m0\_.checked\_out AS checked\_out7, m0\_.checked\_out\_by AS checked\_out\_by8, m0\_.checked\_out\_by\_user AS checked\_out\_by\_user9, m0\_.id AS id10, m0\_.name AS name11, m0\_.type AS type12, m0\_.width AS width13, m0\_.height AS height14, m0\_.cache\_timeout AS cache\_timeout15, m0\_.ordering AS ordering16, m0\_.params AS params17 FROM maugl\_widgets m0\_ WHERE m0\_.created\_by = ? ORDER BY m0\_.ordering ASC) dctrn\_result) dctrn\_table’ with params [1]:nnTable ‘impronte\_maut413.maugl\_widgets’ doesn’t exist at /home/impronte/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 1146): Table ‘impronte\_maut413.maugl\_widgets’ doesn’t exist at /home/impronte/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:89)”} [] [2016-06-15 10:45:43] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALDBALException: “An exception occurred while executing ‘SELECT distinct(l.email) FROM maugl\_lead\_donotcontact dnc LEFT JOIN maugl\_leads l ON l.id = dnc.lead\_id WHERE (dnc.channel = “email”) AND (l.email \<\> ‘’)’: Table ‘impronte\_maut413.maugl\_lead\_donotcontact’ doesn’t exist” at /home/impronte/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 {“exception”:"[object] (Doctrine\DBAL\DBALException(code: 0): An exception occurred while executing ‘SELECT distinct(l.email) FROM maugl\_lead\_donotcontact dnc LEFT JOIN maugl\_leads l ON l.id = dnc.lead\_id WHERE (dnc.channel = “email”) AND (l.email \<\> ‘’)’:nnTable ‘impronte\_maut413.maugl\_lead\_donotcontact’ doesn’t exist at /home/impronte/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 1146): Table ‘impronte\_maut413.maugl\_lead\_donotcontact’ doesn’t exist at /home/impronte/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:89)"} [] ---
**Author:** ![Antonio\_Lazzari](https://avatars.discourse-cdn.com/v4/letter/a/e99b99/32.png) [@Antonio\_Lazzari](https://forum.mautic.org/u/Antonio_Lazzari)\ **Post date:** [June 14, 2016, 12:53pm UTC](https://forum.mautic.org/t/500-error-when-opening-contacts-1-4-0/3765/11 "2016-06-14T12:53:23Z")
I try the procedure, but nothing change. I had the new 1.4.1 but I have the same error…