Feeling Lucky
?
[#16928] - Fix issue with "'a.asset_id' isn't in GROUP BY" when ONLY_FULL_GROUP_BY enabled
- Closed
- 6 Jul 2017
- Medium
- Build: staging
- # 16928
- Diff
- asika32764:patch-14
- Success hound No violations found. Woof! Details
User tests: Successful: Unsuccessful:
Just a simple fix for admin mod_menu gorup in ONLY_FULL_GROUP_BY mode.
Testing Instructions
Force enable ONLY_FULL_GROUP_BY mode. You can use this code in pdomysql:
$this->connection->query("SET @@SESSION.sql_mode = 'STRICT_TRANS_TABLES,ONLY_FULL_GROUP_BY';");Now admin panel will show this error, and the menu options all disappeared.
After this PR, all menutypes will back:
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Category | ⇒ | Modules Administration |
| Labels |
Added:
?
|
||
| Category | Modules Administration | ⇒ | Administration com_fields Modules |
| Category | Modules Administration com_fields | ⇒ | Modules Administration |
asika32764
- comment
- 3 Jul 2017
That will be better if we can get rid of too many groups.
alikon
- comment
- 3 Jul 2017
missed that one
asika32764
- comment
- 6 Jul 2017
:+1
| Status | Pending | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-07-06 11:31:22 |
| Closed_By | ⇒ | asika32764 |
I have tested this item✅ successfully on 32c446b
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/16928.