by synolia

Create standardized dashboards for your users. No more having confused users missing out on what they could be doing with Sugar. This add-on gives Sugar administrators the ability to easily and quickly deploy dashboard templates to one or multiple users.

Includes a 30 day guarantee
Try it Now

By clicking you consent to share your profile with the developer

#2724 - upgrade error

Closed General Question created by ckorson Verified Purchase 5 years ago

We are in the process of upgrading from to of Sugar. We have upgraded our test instance and when testing the dashboard deployer we received the following error:

Screen Shot 2016-11-28 at 4.53.00 PM.png


Query Failed: SELECT users.is_admin is_admin, users.status status, users.show_on_employees show_on_employees, users.employee_status employee_status, users.messenger_type messenger_type, jt0_reports_to_link.first_name rel_reports_to_name_first_name, jt0_reports_to_link.last_name rel_reports_to_name_last_name, jt0_reports_to_link.created_by reports_to_name_owner, users.preferred_language preferred_language, users_cstm.synodt_block_dashboards_c synodt_block_dashboards_c, users.reports_to_id reports_to_id, users.first_name rel_name_first_name, users.last_name rel_name_last_name, users.user_name user_name, users_cstm.portal_id_c portal_id_c, users_cstm.rvpid_c rvpid_c, users.title title, users.department department, users.phone_work phone_work, users.last_login last_login, users.is_group is_group, users.first_name first_name, users.last_name last_name, id, users.date_modified date_modified, users.created_by created_by FROM users LEFT JOIN users jt0_reports_to_link ON (users.reports_to_id = AND jt0_reports_to_link.deleted = 0) WHERE users.deleted = 0 AND users.status = 'Active' AND users.portal_only = 0 ORDER BY users.date_modified DESC, DESC LIMIT 0,51: MySQL error 1054: Unknown column 'users_cstm.synodt_block_dashboards_c' in 'field list'

  1. synolia member avatar

    synolia Provider Affiliate

    5 years ago


    From the logs you sent i would say the module has not been installed sucesfully. To be more precise, 2 custom fields have not been deployed on the Users module which in turn fails the jobs in the job queue.

    I would recommend to either update to the latest version (over the old one so that you keep your templates) , or if you already have the latest version (or prefer a clean install), uninstalling the module and reinstalling it.

    If you still have the same errors after trying this, we willl require the php log files as well, from the time of the module installation to try and figure out why the installation fails.

    If you need any more info, dont hesitate to contact us.

    Kind regards, Synolia Support

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...