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

#2441 - Error after loading Syno Dashboard plug-in

Closed Bug? created by Paul Hekimian Verified Purchase 3 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

    3 years ago

    you can reach me at 310-344-1811

  2. paul13 member avatar

    Paul Hekimian Verified Purchase

    3 years ago

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

  3. paul13 member avatar

    Paul Hekimian Verified Purchase

    3 years ago

    I'm running Sugar 7.7.1.1

  4. jason member avatar

    jason

    3 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

    3 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

    3 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

      3 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...

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.