Blesta Crashes With Sql Error Trying To Open A Ticket

[Alex Vojacek]

I updated succesfully to Blesta 3.1 following the gui method and everything appears to be working properly, but I received an error today when trying to open up a ticket to a customer.

As soons as I try to open a ticket for tech support for a customer,  it jumps into an error screen that says:

 

 

Oh noes!

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'support_departments.override_from_email' in 'field list' on line 124 in /home/web/clients/lib/model.php 

Printing Stack Trace:
#0 /home/web/clients/lib/model.php(124): PDOStatement->execute(Array)
#1 /home/web/clients/components/record/record.php(655): Model->query('SELECT `support...', Array)
#2 /home/web/clients/plugins/support_manager/models/support_manager_tickets.php(853): Record->fetch()
#3 /home/web/clients/plugins/support_manager/controllers/admin_tickets.php(240): SupportManagerTickets->sendEmail('21', Array)
#4 /home/web/clients/lib/dispatcher.php(111): AdminTickets->add()
#5 /home/web/clients/index.php(21): Dispatcher::dispatch('/admin/plugin/s...')
#6 {main}

 

Any idea what can i do?

[Alex Vojacek]

For future reference.

 

You need to upgrade each plugin inside the plugin area for it to work, otherwise, errors like this can happen.

 

After upgrading each plugin blesta works properly.

[Michael]

Glad you have managed to fix it on your own, it's always recommended to check Plugins, Modules and Gateways for upgrades after you have upgraded Blesta.

[Paul]

In a future release, we're going to have the upgrade process attempt to update any extensions that need to be also. This should cut down on this.. but for now, it's a good idea to check all plugins, gateways, and modules to see if they need to be upgraded.