?
avatar Erftralle
Erftralle
13 Mar 2015

Steps to reproduce the issue

Open the article manager in the backend and change the list limit (e.g. to 5, assuming you have more than 5 articles in your system)

Expected result

The list should show only 5 items.

Actual result

The list shows all items.

System information (as much as possible)

Joomla! 3.4.0
Microsoft SQL Server 2012

Additional comments

This is due to a change made in #5293.
An essential part of the query, namely

    $query = 'SELECT * FROM (' . $query . ') _myResults WHERE RowNumber BETWEEN ' . $start . ' AND ' . $end;

has been removed from the processLimit() function in libraries/joomla/database/query/sqlsrv.php (maybe by accident?).

Votes

# of Users Experiencing Issue
1/1
Average Importance Score
5.00

avatar Erftralle Erftralle - open - 13 Mar 2015
avatar joomla-cms-bot joomla-cms-bot - change - 13 Mar 2015
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - change - 13 Mar 2015
Labels Added: ?
avatar zero-24 zero-24 - change - 13 Mar 2015
Category MS SQL
avatar sovainfo
sovainfo - comment - 10 Jun 2015

Fixed by #7149

avatar zero-24
zero-24 - comment - 10 Jun 2015

Closing as we have a PR that fixes the issue thanks for checking @sovainfo and reporting @Erftralle

avatar zero-24 zero-24 - change - 10 Jun 2015
Status New Closed
Closed_Date 0000-00-00 00:00:00 2015-06-10 20:42:09
Closed_By zero-24
Build master staging
avatar zero-24 zero-24 - close - 10 Jun 2015

Add a Comment

Login with GitHub to post a comment