[#26791] - [com_banners] use regexp()
- Closed
- 1 Nov 2019
- Medium
- Build: staging
- # 26791
- Diff
- alikon:patch-112
- Pending Hound Hound is busy sniffing around... Details
User tests: Successful: Unsuccessful:
Pull Request for Issue #26788 .
Summary of Changes
used the query method regexp()
Testing Instructions
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 not shown.
Actual result
SQL error
Documentation Changes Required
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Category | ⇒ | Front End com_banners |
| Title |
|
||||||
i'm afraid i've missed to quote [[:<:]] .... was in hurry.....
| Labels |
Added:
?
|
||
No difference.
42601, 7, ERROR: syntax error at or near "Joomla" LINE 4: ....own_prefix=0 AND 1) AND (a.metakey ~* '[[:<:]]'Joomla'[[:... ^
I have tested this item
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/26791.
I tested with postgresql and the nightly build of j39. Following your test instructions I get the following errors:
Warning: Invalid argument supplied for foreach() in joomla39\components\com_banners\models\banners.php on line 208
Warning: Invalid argument supplied for foreach() in joomla39\modules\mod_banners\tmpl\default.php on line 19
| Status | Pending | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2019-11-01 08:46:04 |
| Closed_By | ⇒ | alikon |
Doesn't work: