#3051 - Error installing
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.
Other Add-Ons of interest
Reporting
Marketing
Social
SugarCRM Customer Survey Plugin
Customer Survey Plugin
Sugarcrm Plugin
Sugar Survey Plugin
customer survey tool
suitecrm questionnaire module
survey builder
best online survey tools
customer satisfaction survey software
best survey tools for business
online survey solution
7 years ago
Hi, is this product supported in the On-Demand environment?
7 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.