Forums Forums Community Discussion Install on IIS server and SQL server

This topic contains 8 replies, has 2 voices, and was last updated by  tamilamuthan15 1 year, 11 months ago.

  • Author
    Posts
  • #2126

    itsmesri
    Participant

    I have server Windows server running with email server and website running on IIS and SQL server. Is it possible to install CandidATS on IIS and SQL server? It is OK I can install MySQL. But is it possible to install on IIS. So I can create subsite for CandidATS.

    Please provide me instructions or steps to follow.

  • #2127

    tamilamuthan15
    Keymaster

    Itsmesri,

    We not yet tested on IIS. But It has to work on IIS. You start install it. If you face any problem, let me know. I will help you.

    with regards,
    R. Tamil Amuthan
    Software Consultant
    Auieo Software Private Limited

  • #2131

    itsmesri
    Participant

    Hi Admin,

    Do you have any steps to install Apache? I have downloaded all these * Antiword * PdfToText * html2text * UnRTF.

    Where should I deploy them? Those are not installer files.

  • #2132

    itsmesri
    Participant

    I was step 3: Loading Data. Getting these errors.

    PDOException Object ( [message:protected] => SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘IGNORE TABLE email_history ADD COLUMN for_module varchar(255) default NULL’ at line 1 [string:Exception:private] => [code:protected] => 42000 [file:protected] => C:\inetpub\wwwroot\Cats\lib\ClsNaanalPDO.php [line:protected] => 124 [trace:Exception:private] => Array ( [0] => Array ( [file] => C:\inetpub\wwwroot\Cats\lib\ClsNaanalPDO.php [line] => 124 [function] => execute [class] => PDOStatement [type] => -> [args] => Array ( ) ) [1] => Array ( [file] => C:\inetpub\wwwroot\Cats\lib\ClsNaanalPDO.php [line] => 555 [function] => query [class] => ClsNaanalPDO [type] => -> [args] => Array ( [0] => ALTER IGNORE TABLE email_history ADD COLUMN for_module varchar(255) default NULL ) ) [2] => Array ( [file] => C:\inetpub\wwwroot\\Cats\lib\DatabaseConnectionPDO.php [line] => 149 [function] => setQuery [class] => ClsNaanalPDO [type] => -> [args] => Array ( [0] => ALTER IGNORE TABLE email_history ADD COLUMN for_module varchar(255) default NULL ) ) [3] => Array ( [file] => C:\inetpub\wwwroot\Cats\modules\install\ajax\ui.php [line] => 1172 [function] => query [class] => DatabaseConnection [type] => -> [args] => Array ( [0] => ALTER IGNORE TABLE email_history ADD COLUMN for_module varchar(255) default NULL ) ) [4] => Array ( [file] => C:\inetpub\wwwroot\Cats\modules\install\ajax\ui.php [line] => 1200 [function] => MySQLQuery [args] => Array ( [0] => ALTER IGNORE TABLE email_history ADD COLUMN for_module varchar(255) default NULL ) ) [5] => Array ( [file] => C:\inetpub\wwwroot\Cats\modules\install\ajax\ui.php [line] => 962 [function] => MySQLQueryMultiple [args] => Array ( [0] => ALTER IGNORE TABLE email_history ADD COLUMN for_module varchar(255) default NULL; ALTER IGNORE TABLE email_history ADD COLUMN for_id int(11) default NULL; ALTER IGNORE TABLE email_template ADD COLUMN basemodule varchar(255) default NULL; ) ) [6] => Array ( [file] => C:\inetpub\wwwroot\Cats\ajax.php [line] => 122 [args] => Array ( [0] => C:\inetpub\wwwroot\Cats\modules\install\ajax\ui.php ) [function] => include ) ) [previous:Exception:private] => [errorInfo] => Array ( [0] => 42000 [1] => 1064 [2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘IGNORE TABLE email_history ADD COLUMN for_module varchar(255) default NULL’ at line 1 ) ) ;

    Total Errors:0
    PDO Query execution failed prematurely. Error: 1

  • #2133

    tamilamuthan15
    Keymaster

    Itsmesri,

    No need to install Antiword * PdfToText * html2text * UnRTF. CandidATS has inbuilt these by default.

    I want to see the issue live in IIS. Can you give me access to your server? I will install it.

    with regards,
    R. Tamil Amuthan
    Software Consultant
    Auieo Software Private Limited

  • #2134

    itsmesri
    Participant

    Let me know where should I provide details. or email me on getur.srikanth@gmail.com

  • #2135

    itsmesri
    Participant

    Finally I am able install all steps but I don’t know all data inserted properly or not. Let me explain what I did.

    1. I found From MySQL 5.7.4 on wards MySQL removed “ALTER IGNORETABLE” option.

    2. So I uninstalled MySQL 5.7.10 and reinstalled 5.6.28 version

    3. Then started installing CATS. this time “Ignore” error gone but I got long list of Insert into Tables errors and Installed failed.

    4. After sometime I tried again installation from Step 1 this time it went smooth with all Greens and completed installation. But I DON’T KNOW DATA INSERTED PROPERLY. BECAUSE PREVIOUS ONE FAILED.

    After logging to site. I missed couple of TABS like “JOB ORDERS”,”CANDIDATES”, “COMPANIES”.

    I don’t know how to enable them and also I am unable create new roles. Please let me know full configuration.

    image

    • This reply was modified 1 year, 11 months ago by  itsmesri.
    • This reply was modified 1 year, 11 months ago by  itsmesri.
  • #2139

    itsmesri
    Participant

    You can ignore My previous post. I don’t want to remove. This may help some other users.

    OK, Now I am able resolve “JOB ORDERS”,”CANDIDATES”, “COMPANIES”. I went through all users posts and admin reply and finally found in PROFILES section we can enable those tabs.

    Still I have one issue left. I cannot create Roles. Right now I have “Administrator”. I want create Recruiter role also.

    In Your DEMO site I cannot create. But not in my site. I Don’t what I missed?

  • #2140

    tamilamuthan15
    Keymaster

    itsmesri,

    As per our live teamviewer session,

    I understand, latest mysql expects default value for datetime type in database table. If you are using the latest mysql, set default time for datetime field in the database tables.

    If not set, ajax related role, permission and group will not work.

    with regards,
    R. Tamil Amuthan
    Auieo Software Private Limited

You must be logged in to reply to this topic.