by AppJetty

SugarCRM Survey Plugin With Survey Rocket, a SugarCRM survey plugin, you can build surveys that trigger automatically to get real-time feedback from customers. It gives custom survey templates, online polls and more. Moreover, you can use the CRM data using inward and outward piping mechanism.

Free Trial

By clicking you consent to be contacted by the developer

#3051 - Error installing

Closed Installation created by jgaring 5 years ago

Our config for Sugar: Operating System: Windows Sugar Edition: Enterprise PHP Version: 5.6.30 Sugar Version: 7.7.2.0 Database Version: MS SQL Server 2008 R2 Deployment Option: On-Site Web Server: Microsoft IIS 8.x

We are attempting installation, and encountering issues during module installation: Display Log Rebuilding ActionViewMap... Rebuilding ActionFileMap... Rebuilding ActionReMap... Rebuilding Administration... Rebuilding Dependencies... Rebuilding EntryPointRegistry... Rebuilding Extensions... Rebuilding FileAccessControlMap... Rebuilding Layoutdefs... Rebuilding GlobalLinks... Rebuilding LogicHooks... Rebuilding TinyMCE... Rebuilding Menus... Rebuilding Include... Rebuilding ScheduledTasks... Rebuilding ScheduledTasks... Rebuilding UserPage... Rebuilding Utils... Rebuilding Vardefs... Rebuilding JSGroupings... Rebuilding WirelessModuleRegistry... Rebuilding WirelessLayoutdefs... Rebuilding TableDictionary... Rebuilding metadata for clients... Rebuilding Console... Installing Images Installing Relationships Rebuilding Vardefs... Rebuilding Layoutdefs... Rebuilding TableDictionary... Installing Bean : bc_submission_data Installing Bean : bc_survey_submission Installing Bean : bc_survey_template Installing Bean : bc_survey Installing Bean : bc_survey_questions Installing Bean : bc_survey_pages Installing Bean : bc_survey_answers Installing Bean : bc_survey_automizer Installing Bean : bc_automizer_condition Installing Bean : bc_automizer_actions Installing Bean : bc_survey_language Database failure. Please refer to sugarcrm.log for details.

When I review the logs, I'm seeing a lot of "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax " logs (excerpts from install log): 04/19/17 22:53:08 [3628][59399022-b6cf-4291-a812-5757234a8129][FATAL] Query Failed:SHOW TABLES LIKE N'bc_survey_submit_answer_calculation'::: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near the keyword 'LIKE'. 04/19/17 22:53:08 [3628][59399022-b6cf-4291-a812-5757234a8129][FATAL] Query Failed:IF NOT EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[notification_modules]') AND type in (N'U')) CREATE TABLE IF NOT EXISTS bc_survey_submit_answer_calculation ( id char(36) NOT NULL, answer_type varchar(100) DEFAULT NULL, submit_answer_id text, sent_survey_id char(36) DEFAULT NULL, survey_receiver_id char(36) DEFAULT NULL, question_id char(36) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8::: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near the keyword 'IF'. [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near 'bc_survey_submit_answer_calculation'. 04/19/17 22:53:08 [3628][59399022-b6cf-4291-a812-5757234a8129][FATAL] Query Failed:ALTER TABLE email_templates add COLUMN survey_id char(36) NULL;::: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near the keyword 'COLUMN'. 04/19/17 22:53:18 [3628][59399022-b6cf-4291-a812-5757234a8129][FATAL] Query Failed:IF NOT EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[notification_modules]') AND type in (N'U')) CREATE TABLE IF NOT EXISTS bc_survey_answers ( id char(36) NOT NULL, name text, date_entered datetime DEFAULT NULL, date_modified datetime DEFAULT NULL, modified_user_id char(36) DEFAULT NULL, created_by char(36) DEFAULT NULL, description text, deleted tinyint(1) DEFAULT '0', assigned_user_id char(36) DEFAULT NULL, answer_sequence int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;::: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near the keyword 'IF'. [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near 'bc_survey_answers'.

Every seen this before? Suggestion on how to fix, as I don't know if it's installed completely but I do see the config section in the admin panel.

  1. Darren_Flood member avatar

    Evolution Marketing

    4 years ago

    Hi, is this product supported in the On-Demand environment?

  2. Biztech member avatar

    AppJetty Provider Affiliate

    4 years ago

    Hi Darren,

    Thanks for contacting us.

    Yes, Our Survey Rocket plugin is compatible with SugarCRM On-Demand environment.

    Hope this helps! Let us know if you need any further assistance.

    Regards, Appjetty.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "This helps me to track all my feedback in SugarCRM. I found this solution quite dynamic."

    Read More Reviews