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
Take a look at this discussion.
Regards