Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[4.0] Remove quoting from ordering columns #30312

Merged
merged 3 commits into from Aug 7, 2020
Merged

[4.0] Remove quoting from ordering columns #30312

merged 3 commits into from Aug 7, 2020

Conversation

SharkyKZ
Copy link
Contributor

@SharkyKZ SharkyKZ commented Aug 7, 2020

Fixes #30309.

Summary of Changes

Removes quoting from ordering columns since there could be multiple columns.
Remove unneeded escaped used on hardcoded values.
Fixes ambiguous column names.

Testing Instructions

Create Articles - Latest in administrator.
Set Order to Recently Modified First.
View the module in control panel.

Actual result BEFORE applying this Pull Request

Error:

Unknown column 'modified DESC, created' in 'order clause'

Expected result AFTER applying this Pull Request

Works.

Documentation Changes Required

No.

@ChristineWk
Copy link

I have tested this item ✅ successfully on ecd5605


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

1 similar comment
@richard67
Copy link
Member

I have tested this item ✅ successfully on ecd5605


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

@richard67
Copy link
Member

RTC


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

@joomla-cms-bot joomla-cms-bot added the RTC This Pull Request is Ready To Commit label Aug 7, 2020
@Quy Quy added this to the Joomla 4.0 milestone Aug 7, 2020
@Quy Quy merged commit e5db439 into joomla:4.0-dev Aug 7, 2020
@joomla-cms-bot joomla-cms-bot removed the RTC This Pull Request is Ready To Commit label Aug 7, 2020
@SharkyKZ SharkyKZ deleted the j4/query/ordering branch August 7, 2020 18:50
sakiss pushed a commit to sakiss/joomla-cms that referenced this pull request Oct 16, 2020
* Remove quoting from ordering columns

* Remove redundant escaping

* Fix ambiguous column names
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

None yet

5 participants