Deleting on a JModelAdmin with an SqlSrv database, the returned query fails because it tries to "limit" the delete query
DELETE FROM CommercialOffer WHERE [id] = '15'
SELECT * FROM ( DELETE , ROW_NUMBER() OVER (ORDER BY (select 0)) AS RowNumber FROM CommercialOffer WHERE [id] = '15') _myResults WHERE RowNumber BETWEEN 1 AND 0
Joomla! 3.3.3
On libraries\joomla\database\query.php I put a "return $query;" on line 411, which looks to have made the trick. But I feel the other "cases" should be looked too as by nature the update should not have a "limit". Although I have encountered no problems with updates as it is.
Category | ⇒ | MS SQL SQL |
Labels |
Added:
?
|
Labels |
Removed:
?
|
Labels |
Added:
?
|
Status | New | ⇒ | Information Required |
Status | Information Required | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2015-12-17 11:11:59 |
Closed_By | ⇒ | brianteeman |
Closed due to lack of response for further information - it can always be reopened if that is provided
Hello @toperf
Thank you for your contribution.
The last comment here was on August 14 2014. So the question is, Is this issue/pull request still valid?
If no reply is received within 4 weeks we will close this issue.
Thanks for understanding!
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4110.