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

#1930 - Database Failure after hitting 'Execute' button

Closed Installation created by jim58 6 years ago

Hi,

When we hit the 'Execute' button during the installation process we receive a database failure message. During further quick repairs and rebuilds still no luck.

This is the log file message:

Thu Feb 11 17:17:12 2016 [30064][d4f65209-79d7-a94a-34af-568d4d1a3375][FATAL] Query Failed: DESCRIBE syno_dashboardtemplatefilters: MySQL error 1146: Table 'db_XX.syno_dashboardtemplatefilters' doesn't exist Thu Feb 11 17:17:12 2016 [30064][d4f65209-79d7-a94a-34af-568d4d1a3375][FATAL] Query Failed: DESCRIBE syno_dashboardtemplatelines: MySQL error 1146: Table 'db_XX.syno_dashboardtemplatelines' doesn't exist Thu Feb 11 17:17:12 2016 [30064][d4f65209-79d7-a94a-34af-568d4d1a3375][FATAL] Query Failed: DESCRIBE syno_dashboardtemplatehistory: MySQL error 1146: Table 'db_XX.syno_dashboardtemplatehistory' doesn't exist Thu Feb 11 17:17:53 2016 [31756][d4f65209-79d7-a94a-34af-568d4d1a3375][FATAL] Executing repair query: Query Failed: ALTER TABLE syno_dashboardtemplatefilters ADD CONSTRAINT PRIMARY KEY (id): MySQL error 1068: Multiple primary key defined

And this is the quick repair and rebuild message we receive (executing will not fix this, it just gives us a database failure message):

/* Table : syno_dashboardtemplatelines / / MISSING TABLE: syno_dashboardtemplatelines / CREATE TABLE syno_dashboardtemplatelines (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT 0 NULL ,assigned_user_id char(36) NULL ,template_dashboard_type varchar(255) NULL ,template_name varchar(255) NULL ,template_dashboard_module varchar(255) NULL ,template_view varchar(255) NULL ,template_metadata text NULL , PRIMARY KEY (id), KEY idx_syno_dashboardtemplatelines_date_modfied (date_modified), KEY idx_syno_dashboardtemplatelines_id_del (id, deleted), KEY idx_syno_dashboardtemplatelines_date_entered (date_entered)) CHARACTER SET utf8 COLLATE utf8_general_ci; / INDEXES / /MISSING INDEX IN DATABASE - idx_syno_dashboardtemplatelines_pk - primary ROW */ ALTER TABLE syno_dashboardtemplatelines ADD CONSTRAINT PRIMARY KEY (id);;

/*MISSING INDEX IN DATABASE - idx_syno_dashboardtemplatelines_date_modfied - index ROW */ ALTER TABLE syno_dashboardtemplatelines ADD INDEX idx_syno_dashboardtemplatelines_date_modfied (date_modified);;

/*MISSING INDEX IN DATABASE - idx_syno_dashboardtemplatelines_id_del - index ROW */ ALTER TABLE syno_dashboardtemplatelines ADD INDEX idx_syno_dashboardtemplatelines_id_del (id,deleted);;

/*MISSING INDEX IN DATABASE - idx_syno_dashboardtemplatelines_date_entered - index ROW */ ALTER TABLE syno_dashboardtemplatelines ADD INDEX idx_syno_dashboardtemplatelines_date_entered (date_entered);;

/* Table : syno_dashboardtemplatehistory / / MISSING TABLE: syno_dashboardtemplatehistory / CREATE TABLE syno_dashboardtemplatehistory (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT 0 NULL ,assigned_user_id char(36) NULL , PRIMARY KEY (id), KEY idx_syno_dashboardtemplatehistory_date_modfied (date_modified), KEY idx_syno_dashboardtemplatehistory_id_del (id, deleted), KEY idx_syno_dashboardtemplatehistory_date_entered (date_entered)) CHARACTER SET utf8 COLLATE utf8_general_ci; / INDEXES / /MISSING INDEX IN DATABASE - idx_syno_dashboardtemplatehistory_pk - primary ROW */ ALTER TABLE syno_dashboardtemplatehistory ADD CONSTRAINT PRIMARY KEY (id);;

/*MISSING INDEX IN DATABASE - idx_syno_dashboardtemplatehistory_date_modfied - index ROW */ ALTER TABLE syno_dashboardtemplatehistory ADD INDEX idx_syno_dashboardtemplatehistory_date_modfied (date_modified);;

/*MISSING INDEX IN DATABASE - idx_syno_dashboardtemplatehistory_id_del - index ROW */ ALTER TABLE syno_dashboardtemplatehistory ADD INDEX idx_syno_dashboardtemplatehistory_id_del (id,deleted);;

/*MISSING INDEX IN DATABASE - idx_syno_dashboardtemplatehistory_date_entered - index ROW */ ALTER TABLE syno_dashboardtemplatehistory ADD INDEX idx_syno_dashboardtemplatehistory_date_entered (date_entered);;

/* Table : syno_dashboardtemplatehistory_syno_dashboardtemplates_c / / MISSING TABLE: syno_dashboardtemplatehistory_syno_dashboardtemplates_c / CREATE TABLE syno_dashboardtemplatehistory_syno_dashboardtemplates_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT 0 NULL ,syno_dashb4d41mplates_ida varchar(36) NULL ,syno_dashb25f5history_idb varchar(36) NULL , PRIMARY KEY (id), KEY syno_dashboardtemplatehistory_syno_dashboardtemplates_ida1 (syno_dashb4d41mplates_ida), KEY syno_dashboardtemplatehistory_syno_dashboardtemplates_alt (syno_dashb25f5history_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci; / Table : syno_dashboardtemplatelines_syno_dashboardtemplates_c / / MISSING TABLE: syno_dashboardtemplatelines_syno_dashboardtemplates_c / CREATE TABLE syno_dashboardtemplatelines_syno_dashboardtemplates_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT 0 NULL ,syno_dashbb94dmplates_ida varchar(36) NULL ,syno_dashb419atelines_idb varchar(36) NULL , PRIMARY KEY (id), KEY syno_dashboardtemplatelines_syno_dashboardtemplates_ida1 (syno_dashbb94dmplates_ida), KEY syno_dashboardtemplatelines_syno_dashboardtemplates_alt (syno_dashb419atelines_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci; / Table : syno_dashboardtemplatehistory_users_c / / MISSING TABLE: syno_dashboardtemplatehistory_users_c */ CREATE TABLE syno_dashboardtemplatehistory_users_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT 0 NULL ,syno_dashboardtemplatehistory_usersusers_ida varchar(36) NULL ,syno_dashb8a60history_idb varchar(36) NULL , PRIMARY KEY (id), KEY syno_dashboardtemplatehistory_users_ida1 (syno_dashboardtemplatehistory_usersusers_ida), KEY syno_dashboardtemplatehistory_users_alt (syno_dashb8a60history_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;

We can see that the plug-in panel is available in the 'Admin' area, but quick repairs are always flagged with errors. Any ideas?

Thank you very much.

  1. sugabyte member avatar

    Sugabyte Verified Purchase

    6 years ago

    ....This is in a Enterprise 7.6 system On-Demand. Also, unable to uninstall.

  2. synolia member avatar

    synolia Provider Affiliate

    6 years ago

    Hello,

    Could you confirm that you are in 7.6.2.0 version of Sugar? A problem appears in this version and was introduce by the code of Sugar. If you want to go ahead quickly you can remove all parts which mention to repair the index before to validation the bloc of queries like :

    /*MISSING INDEX IN DATABASE - idx_syno_dashboardtemplatehistory_id_del - index ROW */ ALTER TABLE syno_dashboardtemplatehistory ADD INDEX idx_syno_dashboardtemplatehistory_id_del (id,deleted);

    We will try to discuss with sugar about this problem as soon as possible.

    Best regards, Synolia Support

  3. sugabyte member avatar

    Sugabyte Verified Purchase

    6 years ago

    Hi Synolia,

    The version is: SugarCRM Enterprise, Version 7.6.2.0 (Build 1292) On-Demand.

    We will try your fix shortly, do you have an update with regards to getting this to work with an 'out-of-the-box' 7.6.2.0 system?

    Thanks, Sugabyte

  4. synolia member avatar

    synolia Provider Affiliate

    6 years ago

    Hello Sugabyte,

    We plan to release a new version adressing this issue by the end of the week.

    Kind regards, Synolia Support

  5. synolia member avatar

    synolia Provider Affiliate

    6 years ago

    Hello Sugarbyte,

    We made the release, you can try with the latest version.

    Kind regards, Synolia Support

  6. jim58 member avatar

    jim58

    6 years ago

    Hi Synolia,

    Thanks for fixing this. The dashboard version is working.

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