Receiving Error When Installing SugarCRM v 13 (Sql Server)

Hi Eric Augustus ,

It's been awhile since I've had to deal with configuring Sugar for SQL Server, but Microsoft has the following pages to provide guidance:

https://learn.microsoft.com/en-us/sql/connect/php/system-requirements-for-the-php-sql-driver?view=sql-server-ver16&redirectedfrom=MSDN#driver-versions
https://learn.microsoft.com/en-us/sql/connect/php/loading-the-php-sql-driver?view=sql-server-ver16

A few things that I notice that differ from what you list versus the above article:

• The directive pointing to the extension file should be 'extension=', not 'ext='
• The driver you reference doesn't seem to be appropriate. It should either be 'php_sqlsrv_82_ts.dll' for 32-bit or 'php_sqlsrv_82_nts.dll' for 64-bit assuming you are running on a Windows web server. I don't see any mention of 'php_sqlsrv_82_nts_x64.dll' in their configuration options.

I hope this helps!

Chris

Thank you Chris for the reply, however I am getting the same error.  I will dig deeper to figure out what is wrong.

hello Eric

On fresh install I have the same error on MYSQL connection on windows 2022 installing Apache and php 8.0.28

Also the Elasticcearch 8.4.3 connection not working ( had to bypass ) even though can connect on the port with curl. 

What a day wasted time.

Maybe this helps:

SugarCRM 12.0 fresh install --- php errors noted:

Warning: ini_set(): Session ini settings cannot be changed when a session is active in C:\A\xampp\htdocs\sugarcrm\include\utils.php on line 4009

Warning: ini_set(): Session ini settings cannot be changed when a session is active in C:\A\xampp\htdocs\sugarcrm\include\utils.php on line 4009

Fatal error: Uncaught Error: Call to undefined function mysqli_report() in C:\A\xampp\htdocs\sugarcrm\include\database\MysqliManager.php:280 Stack trace: #0 C:\A\xampp\htdocs\sugarcrm\install\checkDBSettings.php(112): MysqliManager->connect(Array, false) #1 C:\A\xampp\htdocs\sugarcrm\install\install_utils.php(1333): checkDBSettings(true) #2 C:\A\xampp\htdocs\sugarcrm\install.php(501): validate_dbConfig() #3 {main} thrown in C:\A\xampp\htdocs\sugarcrm\include\database\MysqliManager.php on line 280

Fatal error: Uncaught TypeError: SugarQuery::setDBManager(): Argument #1 ($db) must be of type DBManager, bool given, called in C:\A\xampp\htdocs\sugarcrm\include\SugarQuery\SugarQuery.php on line 160 and defined in C:\A\xampp\htdocs\sugarcrm\include\SugarQuery\SugarQuery.php:167 Stack trace: #0 C:\A\xampp\htdocs\sugarcrm\include\SugarQuery\SugarQuery.php(160): SugarQuery->setDBManager(false) #1 C:\A\xampp\htdocs\sugarcrm\modules\Administration\UpgradeHistory.php(266): SugarQuery->__construct() #2 C:\A\xampp\htdocs\sugarcrm\src\PackageManager\PackageManager.php(746): UpgradeHistory->getJustInstalled() #3 C:\A\xampp\htdocs\sugarcrm\include\utils.php(3267): Sugarcrm\Sugarcrm\PackageManager\PackageManager->handleApplicationFatalError(Object(ErrorException)) #4 [internal function]: sugar_cleanup() #5 {main} thrown in C:\A\xampp\htdocs\sugarcrm\include\SugarQuery\SugarQuery.php on line 167

Maybe this helps:

SugarCRM 12.0 fresh install --- php errors noted:

Warning: ini_set(): Session ini settings cannot be changed when a session is active in C:\A\xampp\htdocs\sugarcrm\include\utils.php on line 4009

Warning: ini_set(): Session ini settings cannot be changed when a session is active in C:\A\xampp\htdocs\sugarcrm\include\utils.php on line 4009

Fatal error: Uncaught Error: Call to undefined function mysqli_report() in C:\A\xampp\htdocs\sugarcrm\include\database\MysqliManager.php:280 Stack trace: #0 C:\A\xampp\htdocs\sugarcrm\install\checkDBSettings.php(112): MysqliManager->connect(Array, false) #1 C:\A\xampp\htdocs\sugarcrm\install\install_utils.php(1333): checkDBSettings(true) #2 C:\A\xampp\htdocs\sugarcrm\install.php(501): validate_dbConfig() #3 {main} thrown in C:\A\xampp\htdocs\sugarcrm\include\database\MysqliManager.php on line 280

Fatal error: Uncaught TypeError: SugarQuery::setDBManager(): Argument #1 ($db) must be of type DBManager, bool given, called in C:\A\xampp\htdocs\sugarcrm\include\SugarQuery\SugarQuery.php on line 160 and defined in C:\A\xampp\htdocs\sugarcrm\include\SugarQuery\SugarQuery.php:167 Stack trace: #0 C:\A\xampp\htdocs\sugarcrm\include\SugarQuery\SugarQuery.php(160): SugarQuery->setDBManager(false) #1 C:\A\xampp\htdocs\sugarcrm\modules\Administration\UpgradeHistory.php(266): SugarQuery->__construct() #2 C:\A\xampp\htdocs\sugarcrm\src\PackageManager\PackageManager.php(746): UpgradeHistory->getJustInstalled() #3 C:\A\xampp\htdocs\sugarcrm\include\utils.php(3267): Sugarcrm\Sugarcrm\PackageManager\PackageManager->handleApplicationFatalError(Object(ErrorException)) #4 [internal function]: sugar_cleanup() #5 {main} thrown in C:\A\xampp\htdocs\sugarcrm\include\SugarQuery\SugarQuery.php on line 167

Hello Andries,

I updated the drives in the php/ext folder for windows and added php_pdo_sqlsrv_7_nts.dll and php_sqlsrv_7_nts.dlland updated the php.ini file. I am past this window.  Also, I am having the same issue in sqlserver_connect() as you (Call to undefined function mysqli_report()).  I read the driver above does not support sqlserver_connect() deprecated, could be the same issue. good luck.