# We are getting http 500 error when adding new assets

**URL:** <https://forum.mautic.org/t/we-are-getting-http-500-error-when-adding-new-assets/19588>\
**Category:** Mautic 3 - Install/Upgrade Support\
**Created:** [May 25, 2021, 5:39am UTC](https://forum.mautic.org/t/we-are-getting-http-500-error-when-adding-new-assets/19588 "2021-05-25T05:39:31Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![wtan360](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/wtan360/32/694_2.png) [@wtan360](https://forum.mautic.org/u/wtan360)\
**Post date:** [May 25, 2021, 5:39am UTC](https://forum.mautic.org/t/we-are-getting-http-500-error-when-adding-new-assets/19588/1 "2021-05-25T05:39:31Z")

</div>

**Your software** Mautic 3.2.1 - app/prod (kernel: app, env: prod, debug: false)  
_My PHP version is_ : 7.2.34  
_My MariaDB version is_: mysql Ver 15.1 Distrib 10.2.38-MariaDB, for Linux (x86\_64) using readline 5.1

**Updating Errors**  
_I am_ Updating.  
\*Upgrading: Command Line

These errors are showing in the Mautic log\* :

**Your problem**  
_My problem is_ : We updated to 3.2.1 some time ago but we are now running into the following error when adding a new asset.

[2021-05-24 17:06:38] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\NotNullConstraintViolationException: “An exception occurred while executing ‘INSERT INTO assets (is\_published, date\_added, created\_by, created\_by\_user, date\_modified, modified\_by, modified\_by\_user, checked\_out, checked\_out\_by, checked\_out\_by\_user, title, description, alias, storage\_location, path, remote\_path, original\_file\_name, lang, publish\_up, publish\_down, download\_count, unique\_download\_count, revision, extension, mime, size, disallow, category\_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2021-05-24 17:06:38”, 2, “sara lopes”, null, null, null, null, null, null, “Schools-FeedImporters.PNG”, “This is a test…”, “schools-feedimporterspng”, “local”, “aa2aa6ffc8e3e516d74643b7db16ef5bd210c2fb.png”, null, “Schools-FeedImporters.PNG”, “en”, “2021-05-24 10:06:00”, “2021-05-24 11:00:00”, 0, 0, 1, “png”, “image/png”, 80483, 1, 13]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘date\_modified’ cannot be null” at /var/www/html/automation/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 103 {“exception”:"[object] (Doctrine\DBAL\Exception\NotNullConstraintViolationException(code: 0): An exception occurred while executing ‘INSERT INTO assets (is\_published, date\_added, created\_by, created\_by\_user, date\_modified, modified\_by, modified\_by\_user, checked\_out, checked\_out\_by, checked\_out\_by\_user, title, description, alias, storage\_location, path, remote\_path, original\_file\_name, lang, publish\_up, publish\_down, download\_count, unique\_download\_count, revision, extension, mime, size, disallow, category\_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2021-05-24 17:06:38”, 2, “sara lopes”, null, null, null, null, null, null, “Schools-FeedImporters.PNG”, “This is a test…”, “schools-feedimporterspng”, “local”, “aa2aa6ffc8e3e516d74643b7db16ef5bd210c2fb.png”, null, “Schools-FeedImporters.PNG”, “en”, “2021-05-24 10:06:00”, “2021-05-24 11:00:00”, 0, 0, 1, “png”, “image\/png”, 80483, 1, 13]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘date\_modified’ cannot be null at /var/www/html/automation/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:103, Doctrine\DBAL\Driver\PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘date\_modified’ cannot be null at /var/www/html/automation/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:123, PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘date\_modified’ cannot be null at /var/www/html/automation/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:121)"}

_Steps I have tried to fix the problem_ : I have verified the ownership and permissions on site files. We have backed up code and db and tried the recommended update which said that the db was already up to date. I have searched online and ended up here.

Note: The reason I am entering this as Update is that I don’t believe that we have tried to add new assets since the update.

---

<div class="post-metadata">

**Author:** ![wtan360](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/wtan360/32/694_2.png) [@wtan360](https://forum.mautic.org/u/wtan360)\
**Post date:** [June 3, 2021, 2:39am UTC](https://forum.mautic.org/t/we-are-getting-http-500-error-when-adding-new-assets/19588/2 "2021-06-03T02:39:09Z")

</div>

If this is in the wrong area or there is a better place to place it can you point me in the right direction?

Thank you,  
Bill