Feeling Lucky
?
[#26788] - [PostgreSQL] Banners don't work when filtering by meta keywords
- Closed
- 24 Oct 2019
- Medium
- Build: staging
- # 26788
Steps to reproduce the issue
Enter some meta keywords in Global Configuration.
Create a banner, enter same meta keywords.
Publish a banner module and enable filtering by meta keywords.
Expected result
Banner shown.
Actual result
Banner not shown.
System information (as much as possible)
PostgreSQL 11.1
Additional comments
The error set by the model is this:
42601, 7, ERROR: syntax error at or near "REGEXP" LINE 4: ...fix=0 AND cl.own_prefix=0 AND 1) AND (a.metakey REGEXP '[[... ^
Coming from here:
| Labels |
Added:
?
|
||
| Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2019-10-24 06:54:37 |
| Closed_By | ⇒ | alikon |
| Closed_Date | 2019-10-24 06:54:37 | ⇒ | 2019-10-24 06:54:38 |
| Closed_By | alikon | ⇒ | joomla-cms-bot |
alikon
- comment
- 24 Oct 2019
please test #26791
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/26788.
SharkyKZ
- comment
- 24 Oct 2019
Closed as having Pull Request #26791.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/26788.
Set to "closed" on behalf of @alikon by The JTracker Application at issues.joomla.org/joomla-cms/26788