#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.
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.