# Landing page 500 Internal Server error

**URL:** <https://forum.mautic.org/t/landing-page-500-internal-server-error/7152>\
**Category:** Product Support\
**Created:** [January 13, 2017, 1:09am UTC](https://forum.mautic.org/t/landing-page-500-internal-server-error/7152 "2017-01-13T01:09:55Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![prowebspot](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/prowebspot/32/22_2.png) [@prowebspot](https://forum.mautic.org/u/prowebspot)\
**Post date:** [January 13, 2017, 1:09am UTC](https://forum.mautic.org/t/landing-page-500-internal-server-error/7152/1 "2017-01-13T01:09:55Z")

</div>

Hello,  
  
  
  
Can anyone help me with this:  
  
When I’m logged-in in mautic, then I can open any mautic landing page in the same browser. But if I logout and want to access landing page as a visitor, then get a 500 Internal Server error. This is the error log:  
  
  
  
[2017-01-13 00:22:49] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionInvalidFieldNameException: “An exception occurred while executing ‘SELECT es.id as id, es.device as device, es.device\_fingerprint FROM lead\_devices es WHERE es.lead\_id = 40’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device\_fingerprint’ in ‘field list’” at /home/supporte/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT es.id as id, es.device as device, es.device\_fingerprint FROM lead\_devices es WHERE es.lead\_id = 40’:nnSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device\_fingerprint’ in ‘field list’ at /home/supporte/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device\_fingerprint’ in ‘field list’ at /home/supporte/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device\_fingerprint’ in ‘field list’ at /home/supporte/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []  
  
  
  
PHP Version 5.6.29  
  
mautic v2.5.1  
  
cPanel, shared server  
  
  
  
Thanks

---

<div class="post-metadata">

**Author:** ![prowebspot](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/prowebspot/32/22_2.png) [@prowebspot](https://forum.mautic.org/u/prowebspot)\
**Post date:** [January 13, 2017, 1:09am UTC](https://forum.mautic.org/t/landing-page-500-internal-server-error/7152/2 "2017-01-13T01:09:55Z")

</div>

Hello,

Can anyone help me with this:  
When I’m logged-in in mautic, then I can open any mautic landing page in the same browser. But if I logout and want to access landing page as a visitor, then get a 500 Internal Server error. This is the error log:

[2017-01-13 00:22:49] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionInvalidFieldNameException: “An exception occurred while executing ‘SELECT es.id as id, es.device as device, es.device\_fingerprint FROM lead\_devices es WHERE es.lead\_id = 40’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device\_fingerprint’ in ‘field list’” at /home/supporte/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT es.id as id, es.device as device, es.device\_fingerprint FROM lead\_devices es WHERE es.lead\_id = 40’:nnSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device\_fingerprint’ in ‘field list’ at /home/supporte/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device\_fingerprint’ in ‘field list’ at /home/supporte/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device\_fingerprint’ in ‘field list’ at /home/supporte/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []

PHP Version 5.6.29  
mautic v2.5.1  
cPanel, shared server

Thanks

---

<div class="post-metadata">

**Author:** ![prowebspot](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/prowebspot/32/22_2.png) [@prowebspot](https://forum.mautic.org/u/prowebspot)\
**Post date:** [January 16, 2017, 2:58pm UTC](https://forum.mautic.org/t/landing-page-500-internal-server-error/7152/3 "2017-01-16T14:58:39Z")

</div>

Thanks! It works

---

<div class="post-metadata">

**Author:** ![Dipesh\_Dhawan](https://avatars.discourse-cdn.com/v4/letter/d/c77e96/32.png) [@Dipesh\_Dhawan](https://forum.mautic.org/u/Dipesh_Dhawan)\
**Post date:** [July 28, 2017, 3:45am UTC](https://forum.mautic.org/t/landing-page-500-internal-server-error/7152/4 "2017-07-28T03:45:48Z")

</div>

I have updated the schema still getting the error in mautic log. using version 2.9.0

---

<div class="post-metadata">

**Author:** ![sonali](https://avatars.discourse-cdn.com/v4/letter/s/958977/32.png) [@sonali](https://forum.mautic.org/u/sonali)\
**Post date:** [July 28, 2017, 6:01am UTC](https://forum.mautic.org/t/landing-page-500-internal-server-error/7152/5 "2017-07-28T06:01:36Z")

</div>

I am using 2.9.1 and updated schema still getting the error in mautic log. Though error is different one but scenario is similar.

[2017-07-28 06:53:55] mautic.WARNING: PHP Warning - mysqli\_stmt::execute(): Error reading result set’s header - in file /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php - at line 164 [] []  
[2017-07-28 06:53:55] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionDriverException: "An exception occurred while executing ‘SELECT s0\_.id AS id\_0, s0\_.name AS name\_1, s0\_.description AS description\_2, s0\_.type AS type\_3, s0\_.event\_type AS event\_type\_4, s0\_.event\_order AS event\_order\_5, s0\_.properties AS properties\_6, s0\_.trigger\_date AS trigger\_date\_7, s0\_.trigger\_interval AS trigger\_interval\_8, s0\_.trigger\_interval\_unit AS trigger\_interval\_unit\_9, s0\_.trigger\_mode AS trigger\_mode\_10, s0\_.decision\_path AS decision\_path\_11, s0\_.temp\_id AS temp\_id\_12, s0\_.channel AS channel\_13, s0\_.channel\_id AS channel\_id\_14, s1\_.is\_published AS is\_published\_15, s1\_.date\_added AS date\_added\_16, s1\_.created\_by AS created\_by\_17, s1\_.created\_by\_user AS created\_by\_user\_18, s1\_.date\_modified AS date\_modified\_19, s1\_.modified\_by AS modified\_by\_20, s1\_.modified\_by\_user AS modified\_by\_user\_21, s1\_.checked\_out AS checked\_out\_22, s1\_.checked\_out\_by AS checked\_out\_by\_23, s1\_.checked\_out\_by\_user AS checked\_out\_by\_user\_24, s1\_.id AS id\_25, s1\_.name AS name\_26, s1\_.description AS description\_27, s1\_.publish\_up AS publish\_up\_28, s1\_.publish\_down AS publish\_down\_29, s1\_.canvas\_settings AS canvas\_settings\_30, s2\_.id AS id\_31, s2\_.name AS name\_32, s2\_.description AS description\_33, s2\_.type AS type\_34, s2\_.event\_type AS event\_type\_35, s2\_.event\_order AS event\_order\_36, s2\_.properties AS properties\_37, s2\_.trigger\_date AS trigger\_date\_38, s2\_.trigger\_interval AS trigger\_interval\_39, s2\_.trigger\_interval\_unit AS trigger\_interval\_unit\_40, s2\_.trigger\_mode AS trigger\_mode\_41, s2\_.decision\_path AS decision\_path\_42, s2\_.temp\_id AS temp\_id\_43, s2\_.channel AS channel\_44, s2\_.channel\_id AS channel\_id\_45, s3\_.id AS id\_46, s3\_.name AS name\_47, s3\_.description AS description\_48, s3\_.type AS type\_49, s3\_.event\_type AS event\_type\_50, s3\_.event\_order AS event\_order\_51, s3\_.properties AS properties\_52, s3\_.trigger\_date AS trigger\_date\_53, s3\_.trigger\_interval AS trigger\_interval\_54, s3\_.trigger\_interval\_unit AS trigger\_interval\_unit\_55, s3\_.trigger\_mode AS trigger\_mode\_56, s3\_.decision\_path AS decision\_path\_57, s3\_.temp\_id AS temp\_id\_58, s3\_.channel AS channel\_59, s3\_.channel\_id AS channel\_id\_60, s4\_.is\_published AS is\_published\_61, s4\_.date\_added AS date\_added\_62, s4\_.created\_by AS created\_by\_63, s4\_.created\_by\_user AS created\_by\_user\_64, s4\_.date\_modified AS date\_modified\_65, s4\_.modified\_by AS modified\_by\_66, s4\_.modified\_by\_user AS modified\_by\_user\_67, s4\_.checked\_out AS checked\_out\_68, s4\_.checked\_out\_by AS checked\_out\_by\_69, s4\_.checked\_out\_by\_user AS checked\_out\_by\_user\_70, s4\_.id AS id\_71, s4\_.name AS name\_72, s4\_.description AS description\_73, s4\_.publish\_up AS publish\_up\_74, s4\_.publish\_down AS publish\_down\_75, s4\_.canvas\_settings AS canvas\_settings\_76 FROM sdcampaign\_events s0\_ INNER JOIN sdcampaigns s1\_ ON s0\_.campaign\_id = s1\_.id LEFT JOIN sdcampaign\_events s2\_ ON s0\_.id = s2\_.parent\_id LEFT JOIN sdcampaign\_events s3\_ ON s0\_.parent\_id = s3\_.id LEFT JOIN sdcampaigns s4\_ ON s2\_.campaign\_id = s4\_.id WHERE s1\_.is\_published = ? AND (s1\_.publish\_down IS NULL OR s1\_.publish\_down \>= ?) AND (s1\_.publish\_up IS NULL OR s1\_.publish\_up \<= ?) AND s0\_.type = ? AND s1\_.id IN (?) AND (s0\_.id NOT IN (SELECT s5\_.id FROM sdcampaign\_lead\_event\_log s6\_ LEFT JOIN sdcampaign\_events s5\_ ON s6\_.event\_id = s5\_.id LEFT JOIN sdleads s7\_ ON s6\_.lead\_id = s7\_.id WHERE s5\_.id = s0\_.id AND s7\_.id = ?)) AND (s0\_.decision\_path \<\> ‘no’ OR s0\_.decision\_path IS NULL) ORDER BY s0\_.event\_order ASC, s2\_.event\_order ASC’ with params [1, “2017-07-28 06:53:55”, “2017-07-28 06:53:55”, “email.open”, 13, 22]:

Can anyone please help me?
