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 30 day trial
Try it Now

#3051 - Error installing

Closed Installation created by jgaring 4 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

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.