# 500 Internal Server Error

**URL:** <https://forum.mautic.org/t/500-internal-server-error/6946>\
**Category:** Product Support\
**Created:** [December 22, 2016, 2:13pm UTC](https://forum.mautic.org/t/500-internal-server-error/6946 "2016-12-22T14:13:15Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gabriel\_Pardini](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Gabriel\_Pardini](https://forum.mautic.org/u/Gabriel_Pardini)\
**Post date:** [December 22, 2016, 2:13pm UTC](https://forum.mautic.org/t/500-internal-server-error/6946/1 "2016-12-22T14:13:15Z")

</div>

Hi.  
  
  
  
I tried to update Mautic from 1.4 to 2.2 a while back.I used the Frontend notification in the dashboard to start the process.  
  
But i got an error when migrating the database. Then my mautic stopped working completely.  
  
Then I rolled back to my previous mautic and restored the database from the backup.  
  
But since then, although all my data is there, i cant create new contacts or emails. Always get the Uh-oh i broke it error.  
  
I tryed following every step in this guide: [https://johnlinhart.com/blog/uh-oh-mautic-upgrade-was-not-successful](https://johnlinhart.com/blog/uh-oh-mautic-upgrade-was-not-successful)  
  
But i get the following error when i try to force the update of my database:  
  
An exception occurred while executing ‘ALTER TABLE mautic\_categories CHANGE id id INT AUTO\_INCREMENT NOT NULL’:  
  
SQLSTATE[HY000]: General Error: 1833 Cannot change colmn ‘id’ : used in a foreign key constraint ‘FK\_25CCA0112469DE2’ of table ‘academiadelide03.mautic\_campaigns’  
  
  
  
Any suggestions on how to proceed?  
  
  
  
  
  
Here´s the Log:  
  
[2016-12-22 14:06:37] mautic.NOTICE: DoctrineDBALExceptionDriverException: An exception occurred while executing ‘ALTER TABLE mautic\_categories CHANGE id id INT AUTO\_INCREMENT NOT NULL’: SQLSTATE[HY000]: General error: 1833 Cannot change column ‘id’: used in a foreign key constraint ‘FK\_25CCA0112469DE2’ of table ‘academiadelide03.mautic\_campaigns’ (uncaught exception) at /home/academiadelideres/www/mkt/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 while running console command `doctrine:schema:update` [] []

---

<div class="post-metadata">

**Author:** ![Gabriel\_Pardini](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Gabriel\_Pardini](https://forum.mautic.org/u/Gabriel_Pardini)\
**Post date:** [December 22, 2016, 2:13pm UTC](https://forum.mautic.org/t/500-internal-server-error/6946/2 "2016-12-22T14:13:15Z")

</div>

Hi.

I tried to update Mautic from 1.4 to 2.2 a while back.I used the Frontend notification in the dashboard to start the process.  
But i got an error when migrating the database. Then my mautic stopped working completely.  
Then I rolled back to my previous mautic and restored the database from the backup.  
But since then, although all my data is there, i cant create new contacts or emails. Always get the Uh-oh i broke it error.  
I tryed following every step in this guide: [https://johnlinhart.com/blog/uh-oh-mautic-upgrade-was-not-successful](https://johnlinhart.com/blog/uh-oh-mautic-upgrade-was-not-successful)  
But i get the following error when i try to force the update of my database:  
An exception occurred while executing ‘ALTER TABLE mautic\_categories CHANGE id id INT AUTO\_INCREMENT NOT NULL’:  
SQLSTATE[HY000]: General Error: 1833 Cannot change colmn ‘id’ : used in a foreign key constraint ‘FK\_25CCA0112469DE2’ of table ‘academiadelide03.mautic\_campaigns’

Any suggestions on how to proceed?

Here´s the Log:  
[2016-12-22 14:06:37] mautic.NOTICE: DoctrineDBALExceptionDriverException: An exception occurred while executing ‘ALTER TABLE mautic\_categories CHANGE id id INT AUTO\_INCREMENT NOT NULL’: SQLSTATE[HY000]: General error: 1833 Cannot change column ‘id’: used in a foreign key constraint ‘FK\_25CCA0112469DE2’ of table ‘academiadelide03.mautic\_campaigns’ (uncaught exception) at /home/academiadelideres/www/mkt/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 while running console command `doctrine:schema:update` [] []