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.