Mautic Community Forums

Exception Error

Hi There, I have tried to upgrade my current Mautic version and now I am getting the error below when I try to login.

any idea how to resolve this issue. I tried repairing the database and rebooting the server but this error still persist



Regards



Peter



An exception occurred while executing ‘SELECT t0_.is_published AS is_published0, t0_.date_added AS date_added1, t0_.created_by AS created_by2, t0_.created_by_user AS created_by_user3, t0_.date_modified AS date_modified4, t0_.modified_by AS modified_by5, t0_.modified_by_user AS modified_by_user6, t0_.checked_out AS checked_out7, t0_.checked_out_by AS checked_out_by8, t0_.checked_out_by_user AS checked_out_by_user9, t0_.id AS id10, t0_.username AS username11, t0_.password AS password12, t0_.first_name AS first_name13, t0_.last_name AS last_name14, t0_.email AS email15, t0_.position AS position16, t0_.timezone AS timezone17, t0_.locale AS locale18, t0_.last_login AS last_login19, t0_.last_active AS last_active20, t0_.online_status AS online_status21, t0_.preferences AS preferences22, t0_.signature AS signature23, t1_.is_published AS is_published24, t1_.date_added AS date_added25, t1_.created_by AS created_by26, t1_.created_by_user AS created_by_user27, t1_.date_modified AS date_modified28, t1_.modified_by AS modified_by29, t1_.modified_by_user AS modified_by_user30, t1_.checked_out AS checked_out31, t1_.checked_out_by AS checked_out_by32, t1_.checked_out_by_user AS checked_out_by_user33, t1_.id AS id34, t1_.name AS name35, t1_.description AS description36, t1_.is_admin AS is_admin37, t1_.readable_permissions AS readable_permissions38, t0_.role_id AS role_id39 FROM tblusers t0_ LEFT JOIN tblroles t1_ ON t0_.role_id = t1_.id WHERE t0_.username = ? OR t0_.email = ?’ with params [“admin”, “admin”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0_.signature’ in ‘field list’

Hi There, I have tried to upgrade my current Mautic version and now I am getting the error below when I try to login.
any idea how to resolve this issue. I tried repairing the database and rebooting the server but this error still persist

Regards

Peter

An exception occurred while executing ‘SELECT t0_.is_published AS is_published0, t0_.date_added AS date_added1, t0_.created_by AS created_by2, t0_.created_by_user AS created_by_user3, t0_.date_modified AS date_modified4, t0_.modified_by AS modified_by5, t0_.modified_by_user AS modified_by_user6, t0_.checked_out AS checked_out7, t0_.checked_out_by AS checked_out_by8, t0_.checked_out_by_user AS checked_out_by_user9, t0_.id AS id10, t0_.username AS username11, t0_.password AS password12, t0_.first_name AS first_name13, t0_.last_name AS last_name14, t0_.email AS email15, t0_.position AS position16, t0_.timezone AS timezone17, t0_.locale AS locale18, t0_.last_login AS last_login19, t0_.last_active AS last_active20, t0_.online_status AS online_status21, t0_.preferences AS preferences22, t0_.signature AS signature23, t1_.is_published AS is_published24, t1_.date_added AS date_added25, t1_.created_by AS created_by26, t1_.created_by_user AS created_by_user27, t1_.date_modified AS date_modified28, t1_.modified_by AS modified_by29, t1_.modified_by_user AS modified_by_user30, t1_.checked_out AS checked_out31, t1_.checked_out_by AS checked_out_by32, t1_.checked_out_by_user AS checked_out_by_user33, t1_.id AS id34, t1_.name AS name35, t1_.description AS description36, t1_.is_admin AS is_admin37, t1_.readable_permissions AS readable_permissions38, t0_.role_id AS role_id39 FROM tblusers t0_ LEFT JOIN tblroles t1_ ON t0_.role_id = t1_.id WHERE t0_.username = ? OR t0_.email = ?’ with params [“admin”, “admin”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0_.signature’ in ‘field list’