Joomla! Issue Tracker - CMS

Download
Launch
Feeling Lucky

[#11278] - Warning: Invalid argument supplied for foreach() using SQL Server db

?
avatar rudisten1
rudisten1
23 Jul 2016

Steps to reproduce the issue

set php ini error_reporting = E_ALL
install joomla using a SQL Server db as the main database
go to "users - manage"

Expected result

users managment console

Actual result

php warning as follow:

Warning: Invalid argument supplied for foreach() in C:\inetpub\wwwroot\joomla7sqlsrv\libraries\joomla\database\query\sqlsrv.php on line 394

System information (as much as possible)

php 7
sqlsrv extension 4.0 non thread safe
IIS 7
joomla 3.6
SQL Server 2014

Additional comments

avatar rudisten1 rudisten1 - open - 23 Jul 2016
avatar rudisten1 rudisten1 - change - 23 Jul 2016
The description was changed
avatar rudisten1 rudisten1 - change - 23 Jul 2016
The description was changed
avatar williamsandy
williamsandy - comment - 25 Jul 2016

This is because the JDatabaseQuerySqlsrv group function does not test if the $this->join array is empty before trying to use it.

avatar rudisten1
rudisten1 - comment - 25 Jul 2016

And now? should we expect this to be fixed ?

This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/11278.

avatar pocketpc
pocketpc - comment - 25 Jul 2016

Similar to #11279, same mitigation, will probably fix at the same time. SQL Server is kind of a second-class citizen here since most Joomla installs are on MySQL, so it probably won't get fixed until I find some time to make a pull request.

avatar brianteeman
brianteeman - comment - 5 Sep 2016

Closed as we have a PR for testing #11938

avatar brianteeman brianteeman - change - 5 Sep 2016
Status New ⇒ Closed
Closed_Date 0000-00-00 00:00:00 ⇒ 2016-09-05 14:44:02
Closed_By ⇒ brianteeman
avatar brianteeman brianteeman - close - 5 Sep 2016

Add a Comment

Login with GitHub to post a comment