TapCRM - Mobile App for SuiteCRM

Thu Jan 3 05:52:53 2019 [2752][1][FATAL] Query Failed: SELECT reminders.* , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , N'Users' modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , N'Users' created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , N'Users' assigned_user_name_mod FROM reminders LEFT JOIN users jt0 ON reminders.modified_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 LEFT JOIN users jt1 ON reminders.created_by=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 LEFT JOIN users jt2 ON reminders.assigned_user_id=jt2.id AND jt2.deleted=0

AND jt2.deleted=0 where (reminders.popup = 1 AND (reminders.date_willexecute = -1 OR reminders.date_willexecute BETWEEN AND )) AND reminders.deleted=0::: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'AND'. Thu Jan 3 05:55:37 2019 [3540][1][FATAL] Array ( [0] => This is the result : --- $enabled [1] => Array ( [0] => Accounts [1] => Contacts [2] => Opportunities [3] => Leads [4] => AOS_Quotes [5] => Documents [6] => Calls [7] => Meetings [8] => Tasks [9] => Notes [10] => AOS_Invoices [11] => AOS_Contracts [12] => Cases [13] => Prospects [14] => ProspectLists [15] => AOS_Products [16] => AOS_Product_Categories [17] => AOR_Reports [18] => AOK_KnowledgeBase [19] => AOK_Knowledge_Base_Categories [20] => Mob_followups [21] => Mob_Visit [22] => bc_sms [23] => Mob_smstemplates )

)

Thu Jan 3 05:55:37 2019 [3540][1][FATAL] Array ( [0] => This is the result : --- $RowsOfCount1 [1] => Array ( [num_rows] => 0 )

)

Thu Jan 3 05:55:37 2019 [3540][1][FATAL] Query Failed:IF NOT EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[mob_saved_search]') AND type in (N'U')) CREATE TABLE mob_saved_search ( id char(36) NOT NULL, search_name varchar(150) DEFAULT NULL, search_module varchar(150) DEFAULT NULL, deleted bit DEFAULT '0', date_entered datetime DEFAULT NULL, date_modified datetime DEFAULT NULL, assigned_user_id char(36) DEFAULT NULL, contents text, is_public tinyint(1), is_dashboard tinyint(1), my_items tinyint(1) );::: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Column, parameter, or variable #9: Cannot specify a column width on data type tinyint. Thu Jan 3 05:55:37 2019 [3540][1][FATAL] Query Failed:INSERT INTO email_templates ( id, date_entered, date_modified, modified_user_id, created_by, published, name, description, subject, body, body_html, deleted, assigned_user_id, text_only, type ) VALUES ("d41e4307-1fea-kkkk-ec9f-5931419aeae2", "2019-01-03 05:55:37", "2019-01-03 05:55:37", "1", "1", "off", "User notification for TapCRM access", "", "Welcome! You are allowed to use CRM on TapCRM App", "", "

", 0, "1", 0, "");::: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The identifier that starts with '<div class=N'mozaik-inner' style=N'font-family:Arial, Helvetica, sans-serif;font-size:14px;line-height:22.4px;color:rgb(68,68,68' is too long. Maximum length is 128. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name. Thu Jan 3 05:55:37 2019 [3540][1][FATAL] Query Failed:CREATE TABLE IF NOT EXISTS mob_favourite_modules ( id char(36) NOT NULL, module_name varchar(255) NOT NULL, date_created datetime NOT NULL ) DEFAULT CHARSET=utf8;::: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'IF'. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'mob_favourite_modules'. Thu Jan 3 05:55:41 2019 [3540][1][FATAL] Error altering column(s) active on table: mob_notification: Query Failed: ALTER TABLE mob_notification ALTER COLUMN [active] bit NULL ALTER TABLE mob_notification ADD DEFAULT '0' FOR active ::: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Column already has a DEFAULT bound to it. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Could not create constraint or index. See previous errors. Thu Jan 3 05:55:41 2019 [3540][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.