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 be contacted by the developer

#2243 - Database Failure When Installing

Closed Installation created by seanharris 5 years ago

Hi,

When i try and execute the SQL i get a database failure message, This prevents the module from working when I try and save a template.

  1. synolia member avatar

    synolia Provider Affiliate

    5 years ago

    Hello,

    When you recieve a message that states a database failure there usually is a trace in the log file.

    Can you please provide us with the sugarcrm.log file (you can get that from the diagnostics in the administration ) or if you have acces to the logs, can you provide us with the query that fails?

    Once we have either the log or the query we can investigate further.

    Kind regards, Synolia Support

  2. seanharris member avatar

    seanharris

    5 years ago

    Hi,

    below is what the Logfile is showing

    Thu Jun 23 13:20:43 2016 [11467][e0c1c159-6c03-4f3e-6529-51ece75651ed][FATAL] Query Failed: ALTER TABLE users_cstm drop COLUMN synodt_block_dashboards_c: MySQL error 1091: Can't DROP 'synodt_block_dashboards_c'; check that column/key exists Thu Jun 23 13:20:43 2016 [11467][e0c1c159-6c03-4f3e-6529-51ece75651ed][FATAL] Query Failed: ALTER TABLE users_cstm drop COLUMN synodt_roles_c: MySQL error 1091: Can't DROP 'synodt_roles_c'; check that column/key exists Thu Jun 23 13:23:27 2016 [11557][e0c1c159-6c03-4f3e-6529-51ece75651ed][FATAL] Query Failed: DESCRIBE syno_dashboardtemplatelines: MySQL error 1146: Table 'sandbox_portlandbrown.syno_dashboardtemplatelines' doesn't exist Thu Jun 23 13:23:27 2016 [11557][e0c1c159-6c03-4f3e-6529-51ece75651ed][FATAL] Query Failed: DESCRIBE syno_dashboardtemplates: MySQL error 1146: Table 'sandbox_portlandbrown.syno_dashboardtemplates' doesn't exist Thu Jun 23 13:27:13 2016 [11784][e0c1c159-6c03-4f3e-6529-51ece75651ed][FATAL] Executing repair query: Query Failed: ALTER TABLE syno_dashboardtemplatelines ADD CONSTRAINT PRIMARY KEY (id): MySQL error 1068: Multiple primary key defined

  3. seanharris member avatar

    seanharris

    5 years ago

    Hi,

    Could you please respond or provide a refund.

    sean

  4. synolia member avatar

    synolia Provider Affiliate

    5 years ago

    Hello Sean,

    We are loonking into the logs that you sent. And we'll get back to you soon. Is your Sugar hosted on SugarCRM On-Demand?

    If you want a refund please contact SugarOufitters directly.

    Kind regards, Synolia Support

  5. synolia member avatar

    synolia Provider Affiliate

    5 years ago

    Hello,

    My team analysed the logs and it seems there is a critical error with the installed module. This is probably due to an error when the module has been installed or updated.

    I recommend that you try to isolate your sugar instance (make a backup first) and try to update the module with the latest version availabe on SugarOutfitters. If that still fails; restore the backup and uninstall the module and delete all linked tables (when asked when uninstalling) and reinstall from scratch the module.

    Hope this helps, if you still encounter dificulties, dont hesitate to contact us.

    Kind regards, Synolia Support

  6. seanharris member avatar

    seanharris

    5 years ago

    Hi,

    I have tried this already and it still fails unfortunately.

    Sean

  7. synolia member avatar

    synolia Provider Affiliate

    5 years ago

    Hello,

    Can you please tell us your Sugar version and edition and if you are hosted on Sugar On-Demand?

    Thanks, Synolia Support

    • seanharris member avatar

      seanharris

      5 years ago

      Hi,

      We are on enterprise Sugar (version 7.6.2.1) and we are on a hosted system.

      Sean

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • "This is a must have plugin for Sugar. We have bought it for several of our customers!"

    Read More Reviews