# Contact Record View (500 Error)

**URL:** https://forum.mautic.org/t/contact-record-view-500-error/6283
**Category:** Product Support
**Created:** [October 19, 2016, 2:50pm UTC](https://forum.mautic.org/t/contact-record-view-500-error/6283 "2016-10-19T14:50:35Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![manageit](https://avatars.discourse-cdn.com/v4/letter/m/5daacb/32.png) [@manageit](https://forum.mautic.org/u/manageit)
#### Post date: [October 19, 2016, 2:50pm UTC](https://forum.mautic.org/t/contact-record-view-500-error/6283/1 "2016-10-19T14:50:35Z")

</div>

When trying to view any client record, I get a 500 error, and this in the log. Version: v2.2.1

Code:

[2016-10-19 08:37:30] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionInvalidFieldNameException: "An exception occurred while executing 'SELECT ls.stage\_id as reference, ls.event\_name as eventName, ls.action\_name as actionName, ls.date\_added as dateAdded FROM lead\_stages\_change\_log ls WHERE ls.lead\_id = 7 ORDER BY ls.date\_added DESC LIMIT 25': Unknown column 'ls.stage\_id' in 'field list'" at /home/engageitnotifier/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 ls.stage\_id as reference, ls.event\_name as eventName, ls.action\_name as actionName, ls.date\_added as dateAdded FROM lead\_stages\_change\_log ls WHERE ls.lead\_id = 7 ORDER BY ls.date\_added DESC LIMIT 25':nnUnknown column 'ls.stage\_id' in 'field list' at /home/engageitnotifier/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Unknown column 'ls.stage\_id' in 'field list' at /home/engageitnotifier/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:94)"} []

---

<div class="post-metadata">

### Author: ![manageit](https://avatars.discourse-cdn.com/v4/letter/m/5daacb/32.png) [@manageit](https://forum.mautic.org/u/manageit)
#### Post date: [October 19, 2016, 2:50pm UTC](https://forum.mautic.org/t/contact-record-view-500-error/6283/2 "2016-10-19T14:50:35Z")

</div>

When trying to view any client record, I get a 500 error, and this in the log. Version: v2.2.1

```auto
[2016-10-19 08:37:30] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionInvalidFieldNameException: "An exception occurred while executing 'SELECT ls.stage_id as reference, ls.event_name as eventName, ls.action_name as actionName, ls.date_added as dateAdded FROM lead_stages_change_log ls WHERE ls.lead_id = 7 ORDER BY ls.date_added DESC LIMIT 25': Unknown column 'ls.stage_id' in 'field list'" at /home/engageitnotifier/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 ls.stage_id as reference, ls.event_name as eventName, ls.action_name as actionName, ls.date_added as dateAdded FROM lead_stages_change_log ls WHERE ls.lead_id = 7 ORDER BY ls.date_added DESC LIMIT 25':nnUnknown column 'ls.stage_id' in 'field list' at /home/engageitnotifier/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Unknown column 'ls.stage_id' in 'field list' at /home/engageitnotifier/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:94)"} []
```

---

<div class="post-metadata">

### Author: ![danwaterloo](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/danwaterloo/32/77_2.png) [@danwaterloo](https://forum.mautic.org/u/danwaterloo)
#### Post date: [October 19, 2016, 10:05pm UTC](https://forum.mautic.org/t/contact-record-view-500-error/6283/3 "2016-10-19T22:05:02Z")

</div>

Hi there, the system is complaining about a missing field … (ls.stage\_id). It appears that when you upgraded, not all of the commands needed for the database update were not executed.

I wrote up a little ‘how to’ to run correct this… you can find the instructions here:

[https://www.mautic.org/community/index.php/conversation/post/16500](https://www.mautic.org/community/index.php/conversation/post/16500)

Dan

---

<div class="post-metadata">

### Author: ![manageit](https://avatars.discourse-cdn.com/v4/letter/m/5daacb/32.png) [@manageit](https://forum.mautic.org/u/manageit)
#### Post date: [October 20, 2016, 4:18am UTC](https://forum.mautic.org/t/contact-record-view-500-error/6283/4 "2016-10-20T04:18:56Z")

</div>

Thanks Dan, I will give that a try.
