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

#2441 - Error after loading Syno Dashboard plug-in

Closed Bug? created by Paul Hekimian Verified Purchase 5 years ago

Wed Aug 24 20:21:36 2016 [564][1][FATAL] Error inserting into table: syno_dashboardtemplates: Query Failed: INSERT INTO syno_dashboardtemplates (id,name,date_entered,date_modified,modified_user_id,created_by,deleted,flag_data,assigned_user_id) VALUES ('5b7d5092-6a38-11e6-a9d4-027a430c0995','BEN Dashboard MGR','2016-08-24 20:21:36','2016-08-24 20:21:36','1','1',0,0,'1'): MySQL error 1146: Table 'db_ben.syno_dashboardtemplates' doesn't exist

  1. paul13 member avatar

    Paul Hekimian Verified Purchase

    5 years ago

    you can reach me at 310-344-1811

  2. paul13 member avatar

    Paul Hekimian Verified Purchase

    5 years ago

    I did a repair and rebuild and that did not work.

  3. paul13 member avatar

    Paul Hekimian Verified Purchase

    5 years ago

    I'm running Sugar 7.7.1.1

  4. jason member avatar

    jason

    5 years ago

    We were able to work this out. Once the Quick Repair & Rebuild finished loading we just needed to click on the "Execute" button.

    Cheers, Jason Eggers SugarOutfitters

  5. paul13 member avatar

    Paul Hekimian Verified Purchase

    5 years ago

    I have another issue. Can you tell what is causing this error?

    Wed Aug 24 21:21:00 2016 [20662][1][FATAL] Executing repair query: Query Failed: ALTER TABLE syno_dashboardtemplatefilters ADD CONSTRAINT PRIMARY KEY (id): MySQL error 1068: Multiple primary key defined

  6. synolia member avatar

    synolia Provider Affiliate

    5 years ago

    Hello Paul,

    We are looking into this issue and it will be fixed soon. In the mean time, to fix this, please remove all the "ALTER TABLE [...] ADD CONSTRAINT [...]" queries when proposed and it should work properly.

    Sorry for the inconvenince a new update should be released soon.

    Kind regards, Synolia Support

    • synolia member avatar

      synolia Provider Affiliate

      5 years ago

      Hi,

      The new version of our add-on is available under the download tab with the name SUGAR_SYNODASHBOARDTEMPLATES_7.2.2-to-7.7_20160916.zip

      Best regards, Synolia Support

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