AnsweredAssumed Answered

driverExceptionDuringQuery  - Error while logging in

Question asked by sidhu sidhu on Oct 27, 2017
Latest reply on Oct 30, 2017 by delsugar

Hi All,

 

                We have recently upgraded to sugarcrm 7.9 ondemand.

When installed backup on our local server and done qrr.

I get the following error when logging in 

 

An exception occurred while executing 'SELECT users.id, users.user_name, users.user_hash, users.system_generated_password, users.pwd_last_changed, users.authenticate_id, users.sugar_login, users.picture, users.first_name, users.last_name, users.is_admin, users.external_auth_only, users.receive_notifications, users.description, users.date_entered, users.date_modified, users.last_login, users.modified_user_id, users.created_by, users.title, users.department, users.phone_home, users.phone_mobile, users.phone_work, users.phone_other, users.phone_fax, users.status, users.address_street, users.address_city, users.address_state, users.address_country, users.address_postalcode, users.default_team, users.team_set_id, users.deleted, users.portal_only, users.show_on_employees, users.employee_status, users.messenger_id, users.messenger_type, users.reports_to_id, users.is_group, users.preferred_language, users.acl_role_set_id, users_cstm.filters_c, users_cstm.meetings_new_c, users_cstm.meetings_existing_c, users_cstm.meetings_internal_c, users_cstm.meetings_site_c, users_cstm.calls_new_c, users_cstm.calls_existing_c, users_cstm.calls_internal_c, users_cstm.calls_site_c, users_cstm.task_new_c, users_cstm.tasks_existing_c, users_cstm.tasks_internal_c, users_cstm.tasks_site_c, users_cstm.won_opportunities_c, users_cstm.created_opportunities_c, users_cstm.created_projects_c, users_cstm.duplicate_check_user_c, users_cstm.base_rate, users_cstm.currency_id FROM users WHERE (users.user_name = ?) AND (users.deleted = ?) LIMIT 1' with params ["test", 0]: Unknown column 'users_cstm.filters_c' in 'field list'

 

i am not sure how it is query users_cstm without join

 

When i debugged i have found that it is coming from this file 

vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php

function : driverExceptionDuringQuery()

 

Can any one throw light on how to fix this.

 

Regards André Lopes Francesca Shiekh hats Angel Magana

Sidhu 

 

       

Outcomes