I have a CentOS 6 system running Apache and PHP and I have FreeTDS set up to facilitate connections to a MSSQL Server. I had no issues installing SugarCRM 6.5 to the MSSQL server, however, I get the following errors with SuiteCRM 7.0.0 after clicking the “Install” buttton:
...SQL Error : Invalid object name 'securitygroups_default'.SQL Error : Invalid object name 'securitygroups_default'.SQL Error : Invalid object name 'securitygroups_default'.SQL Error : Invalid object name 'securitygroups_default'.SQL Error : Invalid object name 'securitygroups_default'.SQL Error : Invalid object name 'securitygroups_default'.SQL Error : Invalid object name
'securitygroups_default'.SQL Error : Invalid object name 'securitygroups_default'..SQL Error : Incorrect syntax near the keyword 'function'.
Installation on a local MySQL database works fine, so it appears to be limited to MSSQL. Can anyone help troubleshoot? Thank you! :cheer:
No our server does not run Intellisense. It appears that the issue has something to do with the SecurityGroups extension, is there a way to prevent it from installing?
Ok so I may have found a workaround for this problem.
I have a test version of SugarCRM running so I installed the basic version of the SecurityGroups module. SQL Server Management Studio has a Create To function which will automatically create a database table creation script for any selected table. I had it create a script to create both the securitygroups_default and securitygroups.
This then revealed another error in yet another module, this time AOS_Fields. The error was " Syntax error near the keyword 'function’ ". 'function is the name of one of the columns in the AOS_Fields table.
So I had to go into the vardefs.php in the AOR_Fields module folder and add parenthesis to the column name, so it went from ‘function’ to ‘[function]’.
With these changes, the installer FINALLY completed on a MSSQL database. I’m not sure if these modules are supposed to be compatible with MSSQL, but with these problems I’m leaning towards ‘not compatible’.
Hi,
I’m also trying to get SuiteCRM running on MSSQL.Generally it seems to be fine with the exception of AOR Reports caused by the fact that there is this field named “function” which MSSQL treats as a reserved word.
I modified vardefs to add [ ] so it becomes [function] which improves things a little but AOR still kicks out database errors when I try to add fields to a report.
This will be addressed in the next release of AOR. There are no release dates confirmed. We will be, along with the community, extending and improving upon the functionality of many modules for SuiteCRM 7.1.0. The roadmap for SuiteCRM 7.1.0 can be seen in the SuiteCRM Documentation.
I am trying to install SuiteCRM 7.7.2 with connection MSSQL … During installation I do not see MSSQL option… Please assist as I get the below error:
Database unavailable
Database Support was not found. Please make sure you have the necessary drivers for one of the following supported Database Types: MySQL or MS SQLServer. You might need to uncomment the extension in the php.ini file, or recompile with the right binary file, depending on your version of PHP. Please refer to your PHP Manual for more information on how to enable Database Support.
Location of your PHP configuration file (php.ini):
/etc/php.ini