by AppJetty

Best SuiteCRM Mobile App
Now access all your necessary SuiteCRM data as and when required right from your mobile phone. Get everything done on the go with TapCRM, our SuiteCRM Mobile app. Now equipped with an exclusive field service feature: Live Tracking!"

Free 30 day trial
Try it Now

#1670 - install failure on windows with sql server

Closed Installation created by ionelmoisuc a year ago

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",
                                 "",
                                 "

Hello Administrator,


You are added on TapCRM mobile app.


Here is your QR code for url :

",
                                 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.

  1. Biztech member avatar

    AppJetty Provider

    a year ago

    Hi Ionel,

    Thank you for contacting us and addressing your concern.

    We troubleshot the issue with the windows and SQL server. Kindly clean install your CRM and then reinstall the provided latest package via email.

    Hope this helps! Feel free to write in case of any concern.

    Regards,
    Appjetty.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...