How to install Acquia's Custom Objects plugin?

I’m also having trouble with it on Mautic 4.3.1.

I copied the plugin in the plugins folder and renamed the directory to CustomObjectsBundle. Before deleting the cache Mautic would not detect it. After deleting the cache it would give the mautic.leads sql error mentioned above.

I then tried upgrading the install to a Composer based install (Mautic was installed using the Bitnami Mautic package on Google Compute Engine).

Then it would throw the “site is currently offline” error when trying to install the plugin through the marketplace like @mikew was having, apparently due to a lack of memory. Increasing the PHP memory made no difference (it would just consume it all).

Then I deleted all contacts (~9k) and companies (~12k). The plugin would now install “successfully” but is nowhere to be found, even after running the plugin commands (mautic:plugin:install/reload etc) and flushing the cache.

[2022-06-01 11:28:20] mautic.ERROR: Installation of plugin through Composer has failed:  [] {"hostname":"mautic-1-vm","pid":6200}
[2022-06-01 11:28:54] mautic.ERROR: PHP Error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) - in file /opt/bitnami/mautic/vendor/twig/twig/src/Node/Expression/ConstantExpression.php - at line 21 [] {"hostname":"mautic-1-vm","pid":6200}
[2022-06-01 11:28:54] mautic.ERROR: Symfony\Component\Debug\Exception\OutOfMemoryException: Error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) - in file /opt/bitnami/mautic/vendor/twig/twig/src/Node/Expression/ConstantExpression.php - at line 21 [] {"hostname":"mautic-1-vm","pid":6200}
[2022-06-01 11:30:42] mautic.ERROR: Installation of plugin through Composer has failed:  [] {"hostname":"mautic-1-vm","pid":6221}
[2022-06-01 11:31:06] mautic.ERROR: PHP Error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 294912 bytes) - in file /opt/bitnami/mautic/vendor/symfony/translation/Translator.php - at line 404 [] {"hostname":"mautic-1-vm","pid":6221}
[2022-06-01 11:31:06] mautic.ERROR: Symfony\Component\Debug\Exception\OutOfMemoryException: Error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 294912 bytes) - in file /opt/bitnami/mautic/vendor/symfony/translation/Translator.php - at line 404 [] {"hostname":"mautic-1-vm","pid":6221}
[2022-06-01 11:48:34] mautic.ERROR: Installation of plugin through Composer has failed:  [] {"hostname":"mautic-1-vm","pid":6782}
[2022-06-01 11:48:57] mautic.ERROR: PHP Error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 495616 bytes) - in file /opt/bitnami/mautic/vendor/symfony/translation/Translator.php - at line 366 [] {"hostname":"mautic-1-vm","pid":6782}
[2022-06-01 11:48:57] mautic.ERROR: Symfony\Component\Debug\Exception\OutOfMemoryException: Error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 495616 bytes) - in file /opt/bitnami/mautic/vendor/symfony/translation/Translator.php - at line 366 [] {"hostname":"mautic-1-vm","pid":6782}
[2022-06-01 11:58:45] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\TableNotFoundException: "An exception occurred while executing 'SELECT c0_.is_published AS is_published_0, c0_.date_added AS date_added_1, c0_.created_by AS created_by_2, c0_.created_by_user AS created_by_user_3, c0_.date_modified AS date_modified_4, c0_.modified_by AS modified_by_5, c0_.modified_by_user AS modified_by_user_6, c0_.checked_out AS checked_out_7, c0_.checked_out_by AS checked_out_by_8, c0_.checked_out_by_user AS checked_out_by_user_9, c0_.id AS id_10, c0_.alias AS alias_11, c0_.name_singular AS name_singular_12, c0_.name_plural AS name_plural_13, c0_.description AS description_14, c0_.lang AS lang_15, c0_.type AS type_16, c0_.category_id AS category_id_17, c0_.relationship_object AS relationship_object_18, c0_.master_object AS master_object_19 FROM custom_object c0_ LEFT JOIN categories c1_ ON c0_.category_id = c1_.id WHERE c0_.is_published = ?' with params [1]:  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bitnami_mautic.custom_object' doesn't exist" at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 61 {"exception":"[object] (Doctrine\\DBAL\\Exception\\TableNotFoundException(code: 0): An exception occurred while executing 'SELECT c0_.is_published AS is_published_0, c0_.date_added AS date_added_1, c0_.created_by AS created_by_2, c0_.created_by_user AS created_by_user_3, c0_.date_modified AS date_modified_4, c0_.modified_by AS modified_by_5, c0_.modified_by_user AS modified_by_user_6, c0_.checked_out AS checked_out_7, c0_.checked_out_by AS checked_out_by_8, c0_.checked_out_by_user AS checked_out_by_user_9, c0_.id AS id_10, c0_.alias AS alias_11, c0_.name_singular AS name_singular_12, c0_.name_plural AS name_plural_13, c0_.description AS description_14, c0_.lang AS lang_15, c0_.type AS type_16, c0_.category_id AS category_id_17, c0_.relationship_object AS relationship_object_18, c0_.master_object AS master_object_19 FROM custom_object c0_ LEFT JOIN categories c1_ ON c0_.category_id = c1_.id WHERE c0_.is_published = ?' with params [1]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'bitnami_mautic.custom_object' doesn't exist at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:61, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bitnami_mautic.custom_object' doesn't exist at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bitnami_mautic.custom_object' doesn't exist at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} {"hostname":"mautic-1-vm","pid":6918}
[2022-06-01 10:00:01] mautic.NOTICE: Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing 'SELECT f.id, f.label, f.type, o.id as custom_object_id FROM custom_object o LEFT JOIN custom_field f ON f.custom_object_id = o.id':  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bitnami_mautic.custom_object' doesn't exist (uncaught exception) at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 61 while running console command `mautic:segments:update` [] {"hostname":"mautic-1-vm","pid":6967}
[2022-06-01 10:00:01] mautic.WARNING: Command `mautic:segments:update` exited with status code 1 [] {"hostname":"mautic-1-vm","pid":6967}
[2022-06-01 12:00:24] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\TableNotFoundException: "An exception occurred while executing 'SELECT c0_.is_published AS is_published_0, c0_.date_added AS date_added_1, c0_.created_by AS created_by_2, c0_.created_by_user AS created_by_user_3, c0_.date_modified AS date_modified_4, c0_.modified_by AS modified_by_5, c0_.modified_by_user AS modified_by_user_6, c0_.checked_out AS checked_out_7, c0_.checked_out_by AS checked_out_by_8, c0_.checked_out_by_user AS checked_out_by_user_9, c0_.id AS id_10, c0_.alias AS alias_11, c0_.name_singular AS name_singular_12, c0_.name_plural AS name_plural_13, c0_.description AS description_14, c0_.lang AS lang_15, c0_.type AS type_16, c0_.category_id AS category_id_17, c0_.relationship_object AS relationship_object_18, c0_.master_object AS master_object_19 FROM custom_object c0_ LEFT JOIN categories c1_ ON c0_.category_id = c1_.id WHERE c0_.is_published = ?' with params [1]:  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bitnami_mautic.custom_object' doesn't exist" at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 61 {"exception":"[object] (Doctrine\\DBAL\\Exception\\TableNotFoundException(code: 0): An exception occurred while executing 'SELECT c0_.is_published AS is_published_0, c0_.date_added AS date_added_1, c0_.created_by AS created_by_2, c0_.created_by_user AS created_by_user_3, c0_.date_modified AS date_modified_4, c0_.modified_by AS modified_by_5, c0_.modified_by_user AS modified_by_user_6, c0_.checked_out AS checked_out_7, c0_.checked_out_by AS checked_out_by_8, c0_.checked_out_by_user AS checked_out_by_user_9, c0_.id AS id_10, c0_.alias AS alias_11, c0_.name_singular AS name_singular_12, c0_.name_plural AS name_plural_13, c0_.description AS description_14, c0_.lang AS lang_15, c0_.type AS type_16, c0_.category_id AS category_id_17, c0_.relationship_object AS relationship_object_18, c0_.master_object AS master_object_19 FROM custom_object c0_ LEFT JOIN categories c1_ ON c0_.category_id = c1_.id WHERE c0_.is_published = ?' with params [1]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'bitnami_mautic.custom_object' doesn't exist at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:61, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bitnami_mautic.custom_object' doesn't exist at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bitnami_mautic.custom_object' doesn't exist at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} {"hostname":"mautic-1-vm","pid":6957}
[2022-06-01 12:00:30] mautic.ERROR: Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing 'SELECT c0_.is_published AS is_published_0, c0_.date_added AS date_added_1, c0_.created_by AS created_by_2, c0_.created_by_user AS created_by_user_3, c0_.date_modified AS date_modified_4, c0_.modified_by AS modified_by_5, c0_.modified_by_user AS modified_by_user_6, c0_.checked_out AS checked_out_7, c0_.checked_out_by AS checked_out_by_8, c0_.checked_out_by_user AS checked_out_by_user_9, c0_.id AS id_10, c0_.alias AS alias_11, c0_.name_singular AS name_singular_12, c0_.name_plural AS name_plural_13, c0_.description AS description_14, c0_.lang AS lang_15, c0_.type AS type_16, c0_.category_id AS category_id_17, c0_.relationship_object AS relationship_object_18, c0_.master_object AS master_object_19 FROM custom_object c0_ LEFT JOIN categories c1_ ON c0_.category_id = c1_.id WHERE c0_.is_published = ?' with params [1]:  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bitnami_mautic.custom_object' doesn't exist - in file /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php - at line 61 [] {"hostname":"mautic-1-vm","pid":6956}
[2022-06-01 12:00:30] mautic.ERROR: Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing 'SELECT c0_.is_published AS is_published_0, c0_.date_added AS date_added_1, c0_.created_by AS created_by_2, c0_.created_by_user AS created_by_user_3, c0_.date_modified AS date_modified_4, c0_.modified_by AS modified_by_5, c0_.modified_by_user AS modified_by_user_6, c0_.checked_out AS checked_out_7, c0_.checked_out_by AS checked_out_by_8, c0_.checked_out_by_user AS checked_out_by_user_9, c0_.id AS id_10, c0_.alias AS alias_11, c0_.name_singular AS name_singular_12, c0_.name_plural AS name_plural_13, c0_.description AS description_14, c0_.lang AS lang_15, c0_.type AS type_16, c0_.category_id AS category_id_17, c0_.relationship_object AS relationship_object_18, c0_.master_object AS master_object_19 FROM custom_object c0_ LEFT JOIN categories c1_ ON c0_.category_id = c1_.id WHERE c0_.is_published = ?' with params [1]:  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bitnami_mautic.custom_object' doesn't exist - in file /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php - at line 61 [] {"hostname":"mautic-1-vm","pid":6956}
[2022-06-01 12:00:35] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\TableNotFoundException: "An exception occurred while executing 'SELECT c0_.is_published AS is_published_0, c0_.date_added AS date_added_1, c0_.created_by AS created_by_2, c0_.created_by_user AS created_by_user_3, c0_.date_modified AS date_modified_4, c0_.modified_by AS modified_by_5, c0_.modified_by_user AS modified_by_user_6, c0_.checked_out AS checked_out_7, c0_.checked_out_by AS checked_out_by_8, c0_.checked_out_by_user AS checked_out_by_user_9, c0_.id AS id_10, c0_.alias AS alias_11, c0_.name_singular AS name_singular_12, c0_.name_plural AS name_plural_13, c0_.description AS description_14, c0_.lang AS lang_15, c0_.type AS type_16, c0_.category_id AS category_id_17, c0_.relationship_object AS relationship_object_18, c0_.master_object AS master_object_19 FROM custom_object c0_ LEFT JOIN categories c1_ ON c0_.category_id = c1_.id WHERE c0_.is_published = ?' with params [1]:  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bitnami_mautic.custom_object' doesn't exist" at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 61 {"exception":"[object] (Doctrine\\DBAL\\Exception\\TableNotFoundException(code: 0): An exception occurred while executing 'SELECT c0_.is_published AS is_published_0, c0_.date_added AS date_added_1, c0_.created_by AS created_by_2, c0_.created_by_user AS created_by_user_3, c0_.date_modified AS date_modified_4, c0_.modified_by AS modified_by_5, c0_.modified_by_user AS modified_by_user_6, c0_.checked_out AS checked_out_7, c0_.checked_out_by AS checked_out_by_8, c0_.checked_out_by_user AS checked_out_by_user_9, c0_.id AS id_10, c0_.alias AS alias_11, c0_.name_singular AS name_singular_12, c0_.name_plural AS name_plural_13, c0_.description AS description_14, c0_.lang AS lang_15, c0_.type AS type_16, c0_.category_id AS category_id_17, c0_.relationship_object AS relationship_object_18, c0_.master_object AS master_object_19 FROM custom_object c0_ LEFT JOIN categories c1_ ON c0_.category_id = c1_.id WHERE c0_.is_published = ?' with params [1]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'bitnami_mautic.custom_object' doesn't exist at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:61, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bitnami_mautic.custom_object' doesn't exist at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bitnami_mautic.custom_object' doesn't exist at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} {"hostname":"mautic-1-vm","pid":6930}
[2022-06-01 12:02:04] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\TableNotFoundException: "An exception occurred while executing 'SELECT c0_.is_published AS is_published_0, c0_.date_added AS date_added_1, c0_.created_by AS created_by_2, c0_.created_by_user AS created_by_user_3, c0_.date_modified AS date_modified_4, c0_.modified_by AS modified_by_5, c0_.modified_by_user AS modified_by_user_6, c0_.checked_out AS checked_out_7, c0_.checked_out_by AS checked_out_by_8, c0_.checked_out_by_user AS checked_out_by_user_9, c0_.id AS id_10, c0_.alias AS alias_11, c0_.name_singular AS name_singular_12, c0_.name_plural AS name_plural_13, c0_.description AS description_14, c0_.lang AS lang_15, c0_.type AS type_16, c0_.category_id AS category_id_17, c0_.relationship_object AS relationship_object_18, c0_.master_object AS master_object_19 FROM custom_object c0_ LEFT JOIN categories c1_ ON c0_.category_id = c1_.id WHERE c0_.is_published = ?' with params [1]:  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bitnami_mautic.custom_object' doesn't exist" at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 61 {"exception":"[object] (Doctrine\\DBAL\\Exception\\TableNotFoundException(code: 0): An exception occurred while executing 'SELECT c0_.is_published AS is_published_0, c0_.date_added AS date_added_1, c0_.created_by AS created_by_2, c0_.created_by_user AS created_by_user_3, c0_.date_modified AS date_modified_4, c0_.modified_by AS modified_by_5, c0_.modified_by_user AS modified_by_user_6, c0_.checked_out AS checked_out_7, c0_.checked_out_by AS checked_out_by_8, c0_.checked_out_by_user AS checked_out_by_user_9, c0_.id AS id_10, c0_.alias AS alias_11, c0_.name_singular AS name_singular_12, c0_.name_plural AS name_plural_13, c0_.description AS description_14, c0_.lang AS lang_15, c0_.type AS type_16, c0_.category_id AS category_id_17, c0_.relationship_object AS relationship_object_18, c0_.master_object AS master_object_19 FROM custom_object c0_ LEFT JOIN categories c1_ ON c0_.category_id = c1_.id WHERE c0_.is_published = ?' with params [1]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'bitnami_mautic.custom_object' doesn't exist at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:61, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bitnami_mautic.custom_object' doesn't exist at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bitnami_mautic.custom_object' doesn't exist at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} {"hostname":"mautic-1-vm","pid":6959}
[2022-06-01 12:59:24] mautic.ERROR: Installation of plugin through Composer has failed:  [] {"hostname":"mautic-1-vm","pid":7516}
[2022-06-01 12:59:55] mautic.ERROR: PHP Error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 327680 bytes) - in file /opt/bitnami/mautic/vendor/symfony/translation/MessageCatalogue.php - at line 173 [] {"hostname":"mautic-1-vm","pid":7516}
[2022-06-01 12:59:55] mautic.ERROR: Symfony\Component\Debug\Exception\OutOfMemoryException: Error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 327680 bytes) - in file /opt/bitnami/mautic/vendor/symfony/translation/MessageCatalogue.php - at line 173 [] {"hostname":"mautic-1-vm","pid":7516}
[2022-06-01 13:02:02] mautic.ERROR: Installation of plugin through Composer has failed:  [] {"hostname":"mautic-1-vm","pid":7548}
[2022-06-01 13:02:20] mautic.ERROR: PHP Error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 294912 bytes) - in file /opt/bitnami/mautic/vendor/symfony/translation/Translator.php - at line 404 [] {"hostname":"mautic-1-vm","pid":7548}
[2022-06-01 13:02:20] mautic.ERROR: Symfony\Component\Debug\Exception\OutOfMemoryException: Error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 294912 bytes) - in file /opt/bitnami/mautic/vendor/symfony/translation/Translator.php - at line 404 [] {"hostname":"mautic-1-vm","pid":7548}
[2022-06-01 13:11:38] mautic.ERROR: Installation of plugin through Composer has failed:  [] {"hostname":"mautic-1-vm","pid":651}
[2022-06-01 13:12:29] mautic.WARNING: PHP Warning - require(/opt/bitnami/mautic/var/cache/pro_/ContainerDkL59lj/getSwiftmailer_EmailSender_ListenerService.php): failed to open stream: No such file or directory - in file /opt/bitnami/mautic/var/cache/pro_/ContainerDkL59lj/appAppKernelProdContainer.php - at line 2333 {"file":"getSwiftmailer_EmailSender_ListenerService.php","lazyLoad":true} {"hostname":"mautic-1-vm","pid":651}
[2022-06-01 13:12:29] mautic.ERROR: PHP Notice: require(): Failed opening required '/opt/bitnami/mautic/var/cache/pro_/ContainerDkL59lj/getSwiftmailer_EmailSender_ListenerService.php' (include_path='.:/opt/bitnami/php/lib/php') - in file /opt/bitnami/mautic/var/cache/pro_/ContainerDkL59lj/appAppKernelProdContainer.php - at line 2333 [] {"hostname":"mautic-1-vm","pid":651}
[2022-06-01 13:12:29] mautic.WARNING: PHP Warning - Cannot modify header information - headers already sent by (output started at /opt/bitnami/mautic/vendor/symfony/http-foundation/Response.php:384) - in file /opt/bitnami/mautic/docroot/app/bundles/CoreBundle/ErrorHandler/ErrorHandler.php - at line 497 {"error":{"inline":null,"type":64,"message":"The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator. System administrators, check server logs for errors.","logMessage":null,"line":2333,"file":"/opt/bitnami/mautic/var/cache/pro_/ContainerDkL59lj/appAppKernelProdContainer.php","trace":[{"namespace":"","short_class":"","class":"","type":"","function":"","file":"/opt/bitnami/mautic/var/cache/pro_/ContainerDkL59lj/appAppKernelProdContainer.php","line":2333,"args":[]}],"context":[],"showExceptionMessage":false,"previous":null},"inline":false,"inTemplate":false,"isAjax":true,"dataArray":{"errors":[{"message":"The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator. System administrators, check server logs for errors.","code":500,"type":null}]}} {"hostname":"mautic-1-vm","pid":651}
[2022-06-01 13:12:29] mautic.ERROR: Symfony\Component\Debug\Exception\FatalErrorException: Notice: require(): Failed opening required '/opt/bitnami/mautic/var/cache/pro_/ContainerDkL59lj/getSwiftmailer_EmailSender_ListenerService.php' (include_path='.:/opt/bitnami/php/lib/php') - in file /opt/bitnami/mautic/var/cache/pro_/ContainerDkL59lj/appAppKernelProdContainer.php - at line 2333 [] {"hostname":"mautic-1-vm","pid":651}
[2022-06-01 13:13:46] mautic.ERROR: Installation of plugin through Composer has failed:  [] {"hostname":"mautic-1-vm","pid":650}
[2022-06-01 13:14:24] mautic.WARNING: PHP Warning - require(/opt/bitnami/mautic/var/cache/pro_/ContainerP75XwT0/getSwiftmailer_EmailSender_ListenerService.php): failed to open stream: No such file or directory - in file /opt/bitnami/mautic/var/cache/pro_/ContainerP75XwT0/appAppKernelProdContainer.php - at line 2333 {"file":"getSwiftmailer_EmailSender_ListenerService.php","lazyLoad":true} {"hostname":"mautic-1-vm","pid":650}
[2022-06-01 13:14:24] mautic.ERROR: PHP Notice: require(): Failed opening required '/opt/bitnami/mautic/var/cache/pro_/ContainerP75XwT0/getSwiftmailer_EmailSender_ListenerService.php' (include_path='.:/opt/bitnami/php/lib/php') - in file /opt/bitnami/mautic/var/cache/pro_/ContainerP75XwT0/appAppKernelProdContainer.php - at line 2333 [] {"hostname":"mautic-1-vm","pid":650}
[2022-06-01 13:14:24] mautic.WARNING: PHP Warning - Cannot modify header information - headers already sent by (output started at /opt/bitnami/mautic/vendor/symfony/http-foundation/Response.php:384) - in file /opt/bitnami/mautic/docroot/app/bundles/CoreBundle/ErrorHandler/ErrorHandler.php - at line 497 {"error":{"inline":null,"type":64,"message":"The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator. System administrators, check server logs for errors.","logMessage":null,"line":2333,"file":"/opt/bitnami/mautic/var/cache/pro_/ContainerP75XwT0/appAppKernelProdContainer.php","trace":[{"namespace":"","short_class":"","class":"","type":"","function":"","file":"/opt/bitnami/mautic/var/cache/pro_/ContainerP75XwT0/appAppKernelProdContainer.php","line":2333,"args":[]}],"context":[],"showExceptionMessage":false,"previous":null},"inline":false,"inTemplate":false,"isAjax":true,"dataArray":{"errors":[{"message":"The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator. System administrators, check server logs for errors.","code":500,"type":null}]}} {"hostname":"mautic-1-vm","pid":650}
[2022-06-01 13:14:24] mautic.ERROR: Symfony\Component\Debug\Exception\FatalErrorException: Notice: require(): Failed opening required '/opt/bitnami/mautic/var/cache/pro_/ContainerP75XwT0/getSwiftmailer_EmailSender_ListenerService.php' (include_path='.:/opt/bitnami/php/lib/php') - in file /opt/bitnami/mautic/var/cache/pro_/ContainerP75XwT0/appAppKernelProdContainer.php - at line 2333 [] {"hostname":"mautic-1-vm","pid":650}
[2022-06-01 13:21:06] mautic.ERROR: Installation of plugin through Composer has failed:  [] {"hostname":"mautic-1-vm","pid":1387}
[2022-06-01 13:21:43] mautic.WARNING: PHP Warning - require(/opt/bitnami/mautic/var/cache/pro_/ContainerXB2XxkK/getSwiftmailer_EmailSender_ListenerService.php): failed to open stream: No such file or directory - in file /opt/bitnami/mautic/var/cache/pro_/ContainerXB2XxkK/appAppKernelProdContainer.php - at line 2333 {"file":"getSwiftmailer_EmailSender_ListenerService.php","lazyLoad":true} {"hostname":"mautic-1-vm","pid":1387}
[2022-06-01 13:21:44] mautic.ERROR: PHP Notice: require(): Failed opening required '/opt/bitnami/mautic/var/cache/pro_/ContainerXB2XxkK/getSwiftmailer_EmailSender_ListenerService.php' (include_path='.:/opt/bitnami/php/lib/php') - in file /opt/bitnami/mautic/var/cache/pro_/ContainerXB2XxkK/appAppKernelProdContainer.php - at line 2333 [] {"hostname":"mautic-1-vm","pid":1387}
[2022-06-01 13:21:44] mautic.WARNING: PHP Warning - Cannot modify header information - headers already sent by (output started at /opt/bitnami/mautic/vendor/symfony/http-foundation/Response.php:384) - in file /opt/bitnami/mautic/docroot/app/bundles/CoreBundle/ErrorHandler/ErrorHandler.php - at line 497 {"error":{"inline":null,"type":64,"message":"The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator. System administrators, check server logs for errors.","logMessage":null,"line":2333,"file":"/opt/bitnami/mautic/var/cache/pro_/ContainerXB2XxkK/appAppKernelProdContainer.php","trace":[{"namespace":"","short_class":"","class":"","type":"","function":"","file":"/opt/bitnami/mautic/var/cache/pro_/ContainerXB2XxkK/appAppKernelProdContainer.php","line":2333,"args":[]}],"context":[],"showExceptionMessage":false,"previous":null},"inline":false,"inTemplate":false,"isAjax":true,"dataArray":{"errors":[{"message":"The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator. System administrators, check server logs for errors.","code":500,"type":null}]}} {"hostname":"mautic-1-vm","pid":1387}
[2022-06-01 13:21:44] mautic.ERROR: Symfony\Component\Debug\Exception\FatalErrorException: Notice: require(): Failed opening required '/opt/bitnami/mautic/var/cache/pro_/ContainerXB2XxkK/getSwiftmailer_EmailSender_ListenerService.php' (include_path='.:/opt/bitnami/php/lib/php') - in file /opt/bitnami/mautic/var/cache/pro_/ContainerXB2XxkK/appAppKernelProdContainer.php - at line 2333 [] {"hostname":"mautic-1-vm","pid":1387}

I’ll try on a fresh install, but by now my days are starting to look like 90% debugging various Mautic issues and 10% actual work

edit: I noticed its looking for some file in the cache/pro_ folder instead of the cache/prod folder? The file exists in the latter, the cache/pro_ folder doesn’t exist at all.

fixed by Fixing DoctrineEventSubscriber for plugin installations by escopecz · Pull Request #11206 · mautic/mautic · GitHub

2 Likes

Wonderful, thank you!

So it looks like the fix might be rolled out in 4.3.2.

I’m not sure how, but it works fine for me without the fix…

I did simple download and zip type of install.

hi - this works for us!!! Thank you!!!

@joeyk I thought I also couldn’t reproduce it but it was only because I installed the plugin before the regression bug was merged in 4.3.0. If you had the DB schema installed before then you wouldn’t get the error.

@gary.harrison can you please comment on Fixing DoctrineEventSubscriber for plugin installations by escopecz · Pull Request #11206 · mautic/mautic · GitHub that it works for you? It needs just one more approval to get it merged.

1 Like

@joeyk the king - waiting for your tutorial :slight_smile: Did you do this on an install with composer

Great and curious to know as I also downloaded, unzip, change file permission etc but on click of install/update- no new plugin installed message. I have never seen such a scenario with Mautic

Yes - works well! Spent the day playing with Custom Objects. :slight_smile:

2 Likes

Any hint/guidance to setup this plugin please

Hi - this is what we did…

  1. download the mc-cs-plugin-custom-objects-staging.zip file from github (link is around here somewhere)
  2. upload mc-cs-plugin-custom-objects-staging.zip to your plugin directory
  3. unzip the mc-cs-plugin-custom-objects-staging.zip file
  4. rename the mc-cs-plugin-custom-objects-staging to CustomObjectsBundle
  5. Run the comand to install the plugin. There are several examples here, this is what we used - php bin/console mautic:plugins:install
  6. clear the cache. There are several examples here, this is what we used - php bin/console cache:clear
  7. login to mautic, then go to the configuration on the right - Custom Objects is a new option
2 Likes

Thanks for listing the steps, I also did all the same but with no success. Let me try again!

There is no table with name ‘mautic.leads’ in the schema.though it shows Great! You are running the current version of Mautic, any hint how to fix ?

Thanks, this command helped me before reloading plugins

php bin/console doctrine:schema:update --force

For others, running this command:

php bin/console doctrine:schema:update --force

is risky and we saw it removing some contact custom fields in the past. The proper option is to wait for release of Mautic 4.3.2 with this fix:

1 Like

I have followed these directions point by point.
I even added in chown -R www-data:www-data on the new directory as well.
When I run the command to update plugin, it tells me nothing is updated

php console mautic:plugins:install
0 new plugins were installed and 0 updated.

Tried clearing cache both via command line and using console command, when I login to my Mautic I get the screen that says it is broken.
I am running 4.3.1

What other information could be helpful to debug this

Can you please check your logs? The Broken message usually means there has been a critical error somewhere. It should be reflected in the logs.

thanks @rcheesley can’t believe I forgot to add them

System logs:


[2022-06-08 09:42:27] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\TableNotFoundException: "An exception occurred while executing 'SELECT c0_.is_published AS is_published_0, c0_.date_added AS date_added_1, c0_.created_by AS created_by_2, c0_.created_by_user AS created_by_user_3, c0_.date_modified AS date_modified_4, c0_.modified_by AS modified_by_5, c0_.modified_by_user AS modified_by_user_6, c0_.checked_out AS checked_out_7, c0_.checked_out_by AS checked_out_by_8, c0_.checked_out_by_user AS checked_out_by_user_9, c0_.id AS id_10, c0_.alias AS alias_11, c0_.name_singular AS name_singular_12, c0_.name_plural AS name_plural_13, c0_.description AS description_14, c0_.lang AS lang_15, c0_.type AS type_16, c0_.category_id AS category_id_17, c0_.relationship_object AS relationship_object_18, c0_.master_object AS master_object_19 FROM custom_object c0_ LEFT JOIN categories c1_ ON c0_.category_id = c1_.id WHERE c0_.is_published = ?' with params [1]:  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mautic.custom_object' doesn't exist" at /var/www/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 61 {"exception":"[object] (Doctrine\\DBAL\\Exception\\TableNotFoundException(code: 0): An exception occurred while executing 'SELECT c0_.is_published AS is_published_0, c0_.date_added AS date_added_1, c0_.created_by AS created_by_2, c0_.created_by_user AS created_by_user_3, c0_.date_modified AS date_modified_4, c0_.modified_by AS modified_by_5, c0_.modified_by_user AS modified_by_user_6, c0_.checked_out AS checked_out_7, c0_.checked_out_by AS checked_out_by_8, c0_.checked_out_by_user AS checked_out_by_user_9, c0_.id AS id_10, c0_.alias AS alias_11, c0_.name_singular AS name_singular_12, c0_.name_plural AS name_plural_13, c0_.description AS description_14, c0_.lang AS lang_15, c0_.type AS type_16, c0_.category_id AS category_id_17, c0_.relationship_object AS relationship_object_18, c0_.master_object AS master_object_19 FROM custom_object c0_ LEFT JOIN categories c1_ ON c0_.category_id = c1_.id WHERE c0_.is_published = ?' with params [1]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'mautic.custom_object' doesn't exist at /var/www/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:61, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mautic.custom_object' doesn't exist at /var/www/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mautic.custom_object' doesn't exist at /var/www/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} {"hostname":"surge-ams","pid":2157093}
[2022-06-08 09:42:30] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\TableNotFoundException: "An exception occurred while executing 'SELECT c0_.is_published AS is_published_0, c0_.date_added AS date_added_1, c0_.created_by AS created_by_2, c0_.created_by_user AS created_by_user_3, c0_.date_modified AS date_modified_4, c0_.modified_by AS modified_by_5, c0_.modified_by_user AS modified_by_user_6, c0_.checked_out AS checked_out_7, c0_.checked_out_by AS checked_out_by_8, c0_.checked_out_by_user AS checked_out_by_user_9, c0_.id AS id_10, c0_.alias AS alias_11, c0_.name_singular AS name_singular_12, c0_.name_plural AS name_plural_13, c0_.description AS description_14, c0_.lang AS lang_15, c0_.type AS type_16, c0_.category_id AS category_id_17, c0_.relationship_object AS relationship_object_18, c0_.master_object AS master_object_19 FROM custom_object c0_ LEFT JOIN categories c1_ ON c0_.category_id = c1_.id WHERE c0_.is_published = ?' with params [1]:  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mautic.custom_object' doesn't exist" at /var/www/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 61 {"exception":"[object] (Doctrine\\DBAL\\Exception\\TableNotFoundException(code: 0): An exception occurred while executing 'SELECT c0_.is_published AS is_published_0, c0_.date_added AS date_added_1, c0_.created_by AS created_by_2, c0_.created_by_user AS created_by_user_3, c0_.date_modified AS date_modified_4, c0_.modified_by AS modified_by_5, c0_.modified_by_user AS modified_by_user_6, c0_.checked_out AS checked_out_7, c0_.checked_out_by AS checked_out_by_8, c0_.checked_out_by_user AS checked_out_by_user_9, c0_.id AS id_10, c0_.alias AS alias_11, c0_.name_singular AS name_singular_12, c0_.name_plural AS name_plural_13, c0_.description AS description_14, c0_.lang AS lang_15, c0_.type AS type_16, c0_.category_id AS category_id_17, c0_.relationship_object AS relationship_object_18, c0_.master_object AS master_object_19 FROM custom_object c0_ LEFT JOIN categories c1_ ON c0_.category_id = c1_.id WHERE c0_.is_published = ?' with params [1]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'mautic.custom_object' doesn't exist at /var/www/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:61, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mautic.custom_object' doesn't exist at /var/www/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mautic.custom_object' doesn't exist at /var/www/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} {"hostname":"surge-ams","pid":2631763}
[2022-06-08 09:42:33] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\TableNotFoundException: "An exception occurred while executing 'SELECT c0_.is_published AS is_published_0, c0_.date_added AS date_added_1, c0_.created_by AS created_by_2, c0_.created_by_user AS created_by_user_3, c0_.date_modified AS date_modified_4, c0_.modified_by AS modified_by_5, c0_.modified_by_user AS modified_by_user_6, c0_.checked_out AS checked_out_7, c0_.checked_out_by AS checked_out_by_8, c0_.checked_out_by_user AS checked_out_by_user_9, c0_.id AS id_10, c0_.alias AS alias_11, c0_.name_singular AS name_singular_12, c0_.name_plural AS name_plural_13, c0_.description AS description_14, c0_.lang AS lang_15, c0_.type AS type_16, c0_.category_id AS category_id_17, c0_.relationship_object AS relationship_object_18, c0_.master_object AS master_object_19 FROM custom_object c0_ LEFT JOIN categories c1_ ON c0_.category_id = c1_.id WHERE c0_.is_published = ?' with params [1]:  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mautic.custom_object' doesn't exist" at /var/www/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 61 {"exception":"[object] (Doctrine\\DBAL\\Exception\\TableNotFoundException(code: 0): An exception occurred while executing 'SELECT c0_.is_published AS is_published_0, c0_.date_added AS date_added_1, c0_.created_by AS created_by_2, c0_.created_by_user AS created_by_user_3, c0_.date_modified AS date_modified_4, c0_.modified_by AS modified_by_5, c0_.modified_by_user AS modified_by_user_6, c0_.checked_out AS checked_out_7, c0_.checked_out_by AS checked_out_by_8, c0_.checked_out_by_user AS checked_out_by_user_9, c0_.id AS id_10, c0_.alias AS alias_11, c0_.name_singular AS name_singular_12, c0_.name_plural AS name_plural_13, c0_.description AS description_14, c0_.lang AS lang_15, c0_.type AS type_16, c0_.category_id AS category_id_17, c0_.relationship_object AS relationship_object_18, c0_.master_object AS master_object_19 FROM custom_object c0_ LEFT JOIN categories c1_ ON c0_.category_id = c1_.id WHERE c0_.is_published = ?' with params [1]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'mautic.custom_object' doesn't exist at /var/www/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:61, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mautic.custom_object' doesn't exist at /var/www/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mautic.custom_object' doesn't exist at /var/www/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} {"hostname":"surge-ams","pid":2157093}
[2022-06-08 09:43:01] mautic.NOTICE: Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing 'SELECT f.id, f.label, f.type, o.id as custom_object_id FROM custom_object o LEFT JOIN custom_field f ON f.custom_object_id = o.id':  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mautic.custom_object' doesn't exist (uncaught exception) at /var/www/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 61 while running console command `mautic:segments:update` [] {"hostname":"surge-ams","pid":2932178}
[2022-06-08 09:43:01] mautic.WARNING: Command `mautic:segments:update` exited with status code 1 [] {"hostname":"surge-ams","pid":2932178}
[2022-06-08 09:44:01] mautic.NOTICE: Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing 'SELECT f.id, f.label, f.type, o.id as custom_object_id FROM custom_object o LEFT JOIN custom_field f ON f.custom_object_id = o.id':  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mautic.custom_object' doesn't exist (uncaught exception) at /var/www/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 61 while running console command `mautic:segments:update` [] {"hostname":"surge-ams","pid":2932206}
[2022-06-08 09:44:01] mautic.WARNING: Command `mautic:segments:update` exited with status code 1 [] {"hostname":"surge-ams","pid":2932206}

Are you using a DB prefix? Does the fix posted above help at all?

I have followed these directions on a fresh manual install (not composer) and got it all ‘installed’.

I ran the console command and it installed the plugin.

When I go to the plugins page I can see the plugin there

However I do not see it in the menu.

I have cleared the cache manually and with the console command.

I did have to add the patch (Fixing DoctrineEventSubscriber for plugin installations by escopecz · Pull Request #11206 · mautic/mautic · GitHub) in order to get it to install - which by the way fixed the install as the first time I did it I got the missing leads error.

These are the errors in the error log:

2022/05/11 08:45:48 [error] 391644#391644: *1196 FastCGI sent in stderr: "PHP message: Error: Class 'MauticPlugin\CustomObjectsBundle\Provider\CustomFieldRouteProvider' not found - in file /var/www/mautic/plugins/MauticCustomPluginBundle/Config/config.php - at line 19" while reading response header from upstream, client: 130.176.1.75, server: como-ams.mishloha.co.il, request: "POST /s/ajax?action=campaign:updateConnections&campaignId=mautic_4a0c401797985d05c18588350e48905bdf2dc24f&mauticUserLastActive=1549&mauticLastNotificationId= HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.4-fpm.sock:", host: "como-ams.mishloha.co.il", referrer: "https://mautic-url.com"
2022/05/11 08:46:10 [error] 391644#391644: *1198 FastCGI sent in stderr: "PHP message: Error: Class 'MauticPlugin\CustomObjectsBundle\Provider\CustomFieldRouteProvider' not found - in file /var/www/mautic/plugins/MauticCustomPluginBundle/Config/config.php - at line 19" while reading response header from upstream, client: 64.252.86.145, server: como-ams.mishloha.co.il, request: "GET /s/login HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.4-fpm.sock:", host: "como-ams.mishloha.co.il"