[#18442] - Bug: Frontend. When inserting article via the article xtd button, the Authors filter is broken
- Closed
- 30 Oct 2017
- Medium
- Build: staging
- # 18442
Steps to reproduce the issue
Edit an article in frontend. Use the Article xtd button in editor to insert an article.
Search by Author in the modal.
Expected result
Filter works.
Actual result
We get a 500
500 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND a.created_by = 789 GROUP BY a.id, l.title, l.image, uc.name, ag.title, c.tit' at line 12 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND a.created_by = 789 GROUP BY a.id, l.title, l.image, uc.name, ag.title, c.tit' at line 12
and PHP Warning in php logs
[30-Oct-2017 09:37:50 Europe/Berlin] PHP Warning: array_keys() expects parameter 1 to be array, boolean given in /Applications/MAMP/htdocs/testnew/trunkgitnew/administrator/components/com_content/models/articles.php on line 426
[30-Oct-2017 09:37:50 Europe/Berlin] PHP Warning: Invalid argument supplied for foreach() in /Applications/MAMP/htdocs/testnew/trunkgitnew/administrator/components/com_content/models/articles.php on line 426
Additional comments
Not nice.
joomla-cms-bot
- | Labels |
Added:
?
|
||
franz-wohlkoenig
- | Category | ⇒ | com_content |
| Status | New | ⇒ | Confirmed |
I think I found the solution.
| Status | Confirmed | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-10-30 09:55:23 |
| Closed_By | ⇒ | infograf768 |
Witam
Mam pytanie i jeżeli ktoś się spotkał z takim problemem proszę o info.
Po aktualizacji (chyba bo na to wygląda) systemu joomla do wersji 3.8.2 system w panelu administratora w opcji wyszukiwania artykułów wyrzuca bład 500. Problem pojawia się podczas wpisania w wyszukiwarce art. nazwy i kliknięcia ENTER (info w załącznikach). Hosting mam na HOME.pl - administratorzy w home.pl po sprawdzeniu stwierdzili że po ich stronie jest wszystko OK (PHP 5.6).
KOMUNIKAT BŁĘDU: po wpisaniu w wyszukiwarce "MOWE":
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (a.title LIKE '%MOWE%' OR a.alias LIKE '%MOWE%') ORDER BY a.id desc LIMIT 20' at line 10 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (a.title LIKE '%MOWE%' OR a.alias LIKE '%MOWE%')' at line 9
Proszę o info czym może być to spowodowane i jak to rozwiązać prawidłowo.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/18442.
confirmed