# mautic:campaigns:trigger throws error

**URL:** <https://forum.mautic.org/t/mautictrigger-throws-error/4943>\
**Category:** Product Support\
**Created:** [August 18, 2016, 10:32am UTC](https://forum.mautic.org/t/mautictrigger-throws-error/4943 "2016-08-18T10:32:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![petertl](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/petertl/32/511_2.png) [@petertl](https://forum.mautic.org/u/petertl)\
**Post date:** [August 18, 2016, 10:32am UTC](https://forum.mautic.org/t/mautictrigger-throws-error/4943/1 "2016-08-18T10:32:52Z")

</div>

Hi,  
  
  
  
I updated to 2.1.0 last week via Mautic console. Shortly before finishing, the updater threw the following error:

Code:

An error occurred while updating the database. Check log for more details.

  
I did not find anything in the logfiles and the application seemed to work as designed.  
  
Today I tested something. After that, I recognized I am not able to delete a contact object. After selecting "Delete", the application asks me if I am sure, but after confirming the screen stays the same - the records to be deleted stay in the list and stay selected.  
  
Then I checked tho logfile. Every time the **mautic:campaigns:trigger** is triggered, it gives me the error:

Code:

[2016-08-18 11:11:07] mautic.NOTICE: DoctrineDBALExceptionInvalidFieldNameException: An exception occurred while executing 'SELECT c0\_.date\_triggered AS date\_triggered\_0, c0\_.is\_scheduled AS is\_scheduled\_1, c0\_.trigger\_date AS trigger\_date\_2, c0\_.system\_triggered AS system\_triggered\_3, c0\_.metadata AS metadata\_4, c0\_.channel AS channel\_5, c0\_.channel\_id AS channel\_id\_6, c0\_.non\_action\_path\_taken AS non\_action\_path\_taken\_7, c0\_.event\_id AS event\_id\_8, c0\_.lead\_id AS lead\_id\_9 FROM campaign\_lead\_event\_log c0\_ WHERE c0\_.campaign\_id = 3 AND c0\_.is\_scheduled = ? AND c0\_.trigger\_date \<= ? ORDER BY c0\_.trigger\_date DESC LIMIT 100 OFFSET 0' with params [1, "2016-08-18 11:11:07"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'c0\_.channel' in 'field list' (uncaught exception) at /var/www/\*\*\*/mautic2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 while running console command `mautic:campaigns:trigger` [] []

  
It says, it is only a notice, but I suspect it has to do with several malfunctions I noticed in the meantime:  
- Contacts cannot be deleted  
- Drilldown to form details in the list view does not work (stays in the list)  
- Form is not displayed on the landing page  
- New form cannot be created ("There was an error creating the submission results table. Try a different name." - I tried different names)  
- Drilldown into contact details does not work (stays in the list)  
  
My guess: Although /update/schema says "Database schema has been updated.", something went wrong during the update to the latest version.  
  
Any help is highly appreciated. ![:-)]( ":-)")  
  
Peter

---

<div class="post-metadata">

**Author:** ![petertl](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/petertl/32/511_2.png) [@petertl](https://forum.mautic.org/u/petertl)\
**Post date:** [August 18, 2016, 10:32am UTC](https://forum.mautic.org/t/mautictrigger-throws-error/4943/2 "2016-08-18T10:32:52Z")

</div>

Hi,

I updated to 2.1.0 last week via Mautic console. Shortly before finishing, the updater threw the following error:

```auto
An error occurred while updating the database. Check log for more details.
```

I did not find anything in the logfiles and the application seemed to work as designed.

Today I tested something. After that, I recognized I am not able to delete a contact object. After selecting “Delete”, the application asks me if I am sure, but after confirming the screen stays the same - the records to be deleted stay in the list and stay selected.

Then I checked tho logfile. Every time the mautic:campaigns:trigger is triggered, it gives me the error:

```auto
[2016-08-18 11:11:07] mautic.NOTICE: DoctrineDBALExceptionInvalidFieldNameException: An exception occurred while executing 'SELECT c0_.date_triggered AS date_triggered_0, c0_.is_scheduled AS is_scheduled_1, c0_.trigger_date AS trigger_date_2, c0_.system_triggered AS system_triggered_3, c0_.metadata AS metadata_4, c0_.channel AS channel_5, c0_.channel_id AS channel_id_6, c0_.non_action_path_taken AS non_action_path_taken_7, c0_.event_id AS event_id_8, c0_.lead_id AS lead_id_9 FROM campaign_lead_event_log c0_ WHERE c0_.campaign_id = 3 AND c0_.is_scheduled = ? AND c0_.trigger_date <= ? ORDER BY c0_.trigger_date DESC LIMIT 100 OFFSET 0' with params [1, "2016-08-18 11:11:07"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'c0_.channel' in 'field list' (uncaught exception) at /var/www/***/mautic2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 while running console command `mautic:campaigns:trigger` [] []
```

It says, it is only a notice, but I suspect it has to do with several malfunctions I noticed in the meantime:

- Contacts cannot be deleted
- Drilldown to form details in the list view does not work (stays in the list)
- Form is not displayed on the landing page
- New form cannot be created (“There was an error creating the submission results table. Try a different name.” - I tried different names)
- Drilldown into contact details does not work (stays in the list)

My guess: Although /update/schema says “Database schema has been updated.”, something went wrong during the update to the latest version.

Any help is highly appreciated. 🙂

Peter

---

<div class="post-metadata">

**Author:** ![petertl](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/petertl/32/511_2.png) [@petertl](https://forum.mautic.org/u/petertl)\
**Post date:** [August 19, 2016, 10:26am UTC](https://forum.mautic.org/t/mautictrigger-throws-error/4943/3 "2016-08-19T10:26:28Z")

</div>

Sorry that I have to push it to the top, but the errors occur in one of my production environments.

Peter