[#24679] - Delete Banners Tracks raises an error [PostgreSQL]
- Closed
- 22 Apr 2019
- Medium
- Build: staging
- # 24679
Steps to reproduce the issue
Generate banner tracks with impression and click.
Go to Components -> Banners -> Tracks.
Click the Delete Tracks button.
Expected result
All tracks are deleted.
Actual result
System information (as much as possible)
php: Linux pc-salon 4.15.0-47-generic #50-Ubuntu SMP Wed Mar 13 10:44:52 UTC 2019 x86_64
dbserver: postgresql
dbversion: 9.5.6
dbcollation: C
dbconnectioncollation: UTF8
phpversion: 7.2.15-0ubuntu0.18.04.2
server: Apache/2.4.29 (Ubuntu)
sapi_name: apache2handler
version: Joomla! 3.9.5 Stable [ Amani ] 9-April-2019 15:00 GMT
platform: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
useragent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/73.0.3683.86 Chrome/73.0.3683.86 Safari/537.36
Additional comments
PostgreSQL does not accept integers for the where clause.
I suggest to replace:
by:
$where = 'true';
joomla-cms-bot
- | Labels |
Added:
?
|
||
| Labels |
Added:
J3 Issue
|
||
It's a good question if we have the same mistake elswhere in code.
It's a good question if we have the same mistake elswhere in code.
It seems those 2 are the only ones I can find, too. Question is how could we test the 2nd one?
And who will make the PR? If you want I can do it.
Good question: How to to purge all maps from the taxonomy ?
Yes, you can make the PR if you want.
Thanks.
@twister65 Please test PR #24682 .
For the other place I make other PR to be tested by code review, since where clause is not necessary there at all.
Closed as having Pull Request.
| Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2019-04-22 12:04:55 |
| Closed_By | ⇒ | franz-wohlkoenig |
@twister65 Other PR is #24683 , please test, too, if possible.
Or maybe better by
$where = '1 = 1';"1 = 1" resolves to "TRUE" in every kind of SQL database.