# Edit lead causing error
**URL:** https://forum.mautic.org/t/edit-lead-causing-error/1999
**Category:** Product Support
**Created:** [June 23, 2015, 9:13am UTC](https://forum.mautic.org/t/edit-lead-causing-error/1999 "2015-06-23T09:13:33Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@wbuist](https://forum.mautic.org/u/wbuist)
#### Post date: [June 23, 2015, 9:13am UTC](https://forum.mautic.org/t/edit-lead-causing-error/1999/1 "2015-06-23T09:13:33Z")
I find that I can’t edit leads. The system is reporting a 500 Internal Server Error on any record which has an email address.
Any ideas what the issue is?
---
### Author:  [@wbuist](https://forum.mautic.org/u/wbuist)
#### Post date: [June 23, 2015, 9:13am UTC](https://forum.mautic.org/t/edit-lead-causing-error/1999/2 "2015-06-23T09:13:33Z")
I find that I can’t edit leads. The system is reporting a 500 Internal Server Error on any record which has an email address.
Any ideas what the issue is?
---
### Author:  [@escopecz](https://forum.mautic.org/u/escopecz)
#### Post date: [July 9, 2015, 8:07am UTC](https://forum.mautic.org/t/edit-lead-causing-error/1999/3 "2015-07-09T08:07:02Z")
Hi, could you take a look into app/logs directory and see if there are some details of the error?
---
### Author:  [@edelciomolina](https://forum.mautic.org/u/edelciomolina)
#### Post date: [October 25, 2015, 2:12pm UTC](https://forum.mautic.org/t/edit-lead-causing-error/1999/4 "2015-10-25T14:12:10Z")
Hi, I´m with the same issue.
Please, take a look on the log info:
[2015-10-25 14:02:55] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALDBALException: “An exception occurred while executing ‘SELECT p0\_.page\_id AS sclr0, p0\_.date\_hit AS date\_hit1, p0\_.date\_left AS date\_left2, p0\_.referer AS referer3, p0\_.source AS source4, p0\_.source\_id AS source\_id5, p0\_.url AS url6, p0\_.url\_title AS url\_title7, p0\_.query AS query8 FROM page\_hits p0\_ WHERE p0\_.lead\_id = 3’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘p0\_.query’ in ‘field list’” at C:Vitrineewwwdoohnow\_marketingvendordoctrinedballibDoctrineDBALDBALException.php line 91 {“exception”:"[object] (Doctrine\DBAL\DBALException(code: 0): An exception occurred while executing ‘SELECT p0\_.page\_id AS sclr0, p0\_.date\_hit AS date\_hit1, p0\_.date\_left AS date\_left2, p0\_.referer AS referer3, p0\_.source AS source4, p0\_.source\_id AS source\_id5, p0\_.url AS url6, p0\_.url\_title AS url\_title7, p0\_.query AS query8 FROM page\_hits p0\_ WHERE p0\_.lead\_id = 3’:nnSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘p0\_.query’ in ‘field list’ at C:\Vitrinee\www\doohnow\_marketing\vendor\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php:91, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘p0\_.query’ in ‘field list’ at C:\Vitrinee\www\doohnow\_marketing\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php:699)"} []
I dont have certain about, but I think it happened after the update.
Thank you.
---
### Author:  [@manageit](https://forum.mautic.org/u/manageit)
#### Post date: [October 25, 2015, 10:56pm UTC](https://forum.mautic.org/t/edit-lead-causing-error/1999/5 "2015-10-25T22:56:42Z")
I am having the same error after the update
---
### Author:  [@escopecz](https://forum.mautic.org/u/escopecz)
#### Post date: [October 26, 2015, 8:12am UTC](https://forum.mautic.org/t/edit-lead-causing-error/1999/6 "2015-10-26T08:12:45Z")
Thanks for the report. Could you try one test for me? If you have a SSH access to the server, could you run:
```auto
php /path_to_mautic/app/console doctrine:schema:update --dump-sql
```
and paste the result here?
---
### Author:  [@edelciomolina](https://forum.mautic.org/u/edelciomolina)
#### Post date: [October 26, 2015, 12:24pm UTC](https://forum.mautic.org/t/edit-lead-causing-error/1999/7 "2015-10-26T12:24:40Z")
Please, take a look.
`C:wwwmarketing> php app/console doctrine:schema:update --dump-sql
ALTER TABLE page_hits ADD query LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)';`
Thank you!
---
### Author:  [@escopecz](https://forum.mautic.org/u/escopecz)
#### Post date: [October 26, 2015, 12:28pm UTC](https://forum.mautic.org/t/edit-lead-causing-error/1999/8 "2015-10-26T12:28:23Z")
Ok, take a look at [https://github.com/mautic/mautic/issues/1051#issuecomment-151107899](https://github.com/mautic/mautic/issues/1051#issuecomment-151107899)
---
### Author:  [@edelciomolina](https://forum.mautic.org/u/edelciomolina)
#### Post date: [October 26, 2015, 12:32pm UTC](https://forum.mautic.org/t/edit-lead-causing-error/1999/9 "2015-10-26T12:32:42Z")
Thank you very much, this solved my issue.
Have a nice day!
---
### Author:  [@sandeeptxlit](https://forum.mautic.org/u/sandeeptxlit)
#### Post date: [September 8, 2016, 7:45am UTC](https://forum.mautic.org/t/edit-lead-causing-error/1999/10 "2016-09-08T07:45:14Z")
Hi, I am getting following error :
[2016-09-08 07:42:18] mautic.ERROR: SCHEMA ERROR: An exception occurred while executing ‘SELECT f.alias, f.is\_unique\_identifer as is\_unique, f.type FROM mulead\_fields f ORDER BY f.field\_order ASC’: SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected [] []
[2016-09-08 07:42:46] mautic.ERROR: Error: Maximum execution time of 30 seconds exceeded - in file C:xampphtdocsmauticwebvendordoctrinedballibDoctrineDBALDriverPDOStatement.php - at line 35 [] []
[2016-09-08 08:39:34] mautic.NOTICE: DoctrineDBALExceptionConnectionException: An exception occurred while executing ‘SHOW FULL TABLES WHERE Table\_type = ‘BASE TABLE’’: SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected (uncaught exception) at C:xampphtdocsmauticwebvendordoctrinedballibDoctrineDBALDriverAbstractMySQLDriver.php line 103 while running console command `doctrine:schema:update` [] []
How to fix these ?
---
### Author:  [@escopecz](https://forum.mautic.org/u/escopecz)
#### Post date: [September 8, 2016, 8:10am UTC](https://forum.mautic.org/t/edit-lead-causing-error/1999/11 "2016-09-08T08:10:50Z")
The database server is failing. Contact your hosting provider/system administrator to help you fix that.
---
### Author:  [@sandeeptxlit](https://forum.mautic.org/u/sandeeptxlit)
#### Post date: [September 8, 2016, 8:29am UTC](https://forum.mautic.org/t/edit-lead-causing-error/1999/12 "2016-09-08T08:29:59Z")
I am working on my localhost xampp and getting these error on my fresh installation.
how to fix “The database server is failing”
I have also increase my execution time to 60 seconds in ini.php file.
---
### Author:  [@escopecz](https://forum.mautic.org/u/escopecz)
#### Post date: [September 8, 2016, 8:43am UTC](https://forum.mautic.org/t/edit-lead-causing-error/1999/13 "2016-09-08T08:43:40Z")
Increasing a PHP limit when the database (not PHP) is failing won’t help much. Try some advice from [https://www.google.cz/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8&client=ubuntu#q=xampp+The+database+server+is+failing](https://www.google.cz/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8&client=ubuntu#q=xampp+The+database+server+is+failing)
---
### Author:  [@sandeeptxlit](https://forum.mautic.org/u/sandeeptxlit)
#### Post date: [September 8, 2016, 10:29am UTC](https://forum.mautic.org/t/edit-lead-causing-error/1999/14 "2016-09-08T10:29:13Z")
still not able to fixed the above errors.
I have another query, Do we need to install Mautic to work with Mautic Rest API?
---
### Author:  [@escopecz](https://forum.mautic.org/u/escopecz)
#### Post date: [September 8, 2016, 10:33am UTC](https://forum.mautic.org/t/edit-lead-causing-error/1999/15 "2016-09-08T10:33:37Z")
Yes, you need to install Mautic if you want to get some responses from the API requests. But you can avoid the installation and use the [mautic.net](http://mautic.net) service to host your Mautic.
---
### Author:  [@sandeeptxlit](https://forum.mautic.org/u/sandeeptxlit)
#### Post date: [September 8, 2016, 11:04am UTC](https://forum.mautic.org/t/edit-lead-causing-error/1999/16 "2016-09-08T11:04:29Z")
What I’m wondering that is it possible to get the Mautic API up running so that any application can push information into Mautic when for example a new user is created.
If yes then how?
---
### Author:  [@escopecz](https://forum.mautic.org/u/escopecz)
#### Post date: [September 8, 2016, 11:08am UTC](https://forum.mautic.org/t/edit-lead-causing-error/1999/17 "2016-09-08T11:08:53Z")
Mautic is a PHP app and it has API, yes. Here is the documentation [https://developer.mautic.org/#rest-api](https://developer.mautic.org/#rest-api)
---
### Author:  [@sandeeptxlit](https://forum.mautic.org/u/sandeeptxlit)
#### Post date: [September 9, 2016, 7:49am UTC](https://forum.mautic.org/t/edit-lead-causing-error/1999/18 "2016-09-09T07:49:23Z")
Hi,
I have created account on [mautic.net](http://mautic.net) and following the api documentation, but still getting the issues.
I have authenticated the api but when I am trying to get the contact list then by passing parameter (contacts) then my current page getting blank.
I am alos getting error while processing readme documentation:-
Fatal error: Call to undefined method MauticAuthApiAuth::validateAccessToken() in C:xampphtdocsmautictest.php on line 40.
Please advise.
Is it possible to have skype call?
---
### Author:  [@sandeeptxlit](https://forum.mautic.org/u/sandeeptxlit)
#### Post date: [September 12, 2016, 4:45am UTC](https://forum.mautic.org/t/edit-lead-causing-error/1999/19 "2016-09-12T04:45:57Z")
Hi, Please advise.
---
### Author:  [@escopecz](https://forum.mautic.org/u/escopecz)
#### Post date: [September 12, 2016, 6:21am UTC](https://forum.mautic.org/t/edit-lead-causing-error/1999/20 "2016-09-12T06:21:18Z")
Hard to tell without seeing the code.
[Next page](https://forum.mautic.org/t/edit-lead-causing-error/1999.md?page=2)