[#19079] - Compact list of tagged items -1054 Unknown column 'Array' in 'where clause'
- Closed
- 24 Dec 2017
- Medium
- Build: staging
- # 19079
Steps to reproduce the issue
Create a menu item using a "Compact list of tagged items", set a tag and then navigate to the page.
Expected result
See the list of articles that are tagged with the selected tag.
Actual result
An SQL error, "1054 Unknown column 'Array' in 'where clause'".
System information (as much as possible)
PHP version 5.4.27
Database Version 5.5.32 MariaDB
Joomla Version 3.8.3
Additional comments
I see that the link created is -> index.php?option=com_tags&view=tag&layout=list&id[0]=20 .
If i remove the array, and try to navigate to -> index.php?option=com_tags&view=tag&layout=list&id=20, it works normally.
| Labels |
Added:
?
|
||
| Category | ⇒ | com_tags SQL |
| Status | New | ⇒ | Discussion |
Multiples are not comma separated list as seen here:
index.php?option=com_tags&view=tag&layout=list&id[0]=2&id[1]=3&id[2]=4&Itemid=474
Here it is for a single tag:
index.php?option=com_tags&view=tag&layout=list&id[0]=2
| Status | Discussion | ⇒ | Information Required |
@franz-wohlkoenig @brianteeman Can you reproduce? If not, please close. Thanks.
Can't reproduce but i'm not on MariaDB.
Can't reproduce but i'm not on MariaDB.
Shouldn't need to be. The error message looks like it would be a PHP "Array to string conversion error" type thing, so should be database platform agnostic.
@tonypartridge: Can't reproduce.
Thanks for Info, @mbabker.
System information
3.8.4-dev
Multilanguage Site (4 Lang.) & Test English (GB) Sample Data
macOS Sierra, 10.12.6
Firefox 57 (64-bit)
MAMP 4.2
- Apache-Server
- PHP 7.0.22
- MySQLi 5.6.35
| Status | Information Required | ⇒ | Closed - Unconfirmed Report |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-12-24 07:09:33 |
| Closed_By | ⇒ | franz-wohlkoenig |
| Status | Closed - Unconfirmed Report | ⇒ | Closed |
| Closed_Date | 2017-12-24 07:09:33 | ⇒ | 2017-12-24 07:09:34 |
| Closed_By | franz-wohlkoenig | ⇒ | joomla-cms-bot |
Set to "closed" on behalf of @franz-wohlkoenig by The JTracker Application at issues.joomla.org/joomla-cms/19079
closed as unconfirmed Report.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/19079.
Unable to reproduce. It should be an array since more than one tag can be selected.