? ? ? Pending
Pull Request for # 6617

User tests: Successful: Unsuccessful:

avatar wojsmol
wojsmol
2 Jan 2016

fix for #6617 (comment)

Original issue description

Okay, but what about question 2 of my post?
I'm not a Joomla expert but this seems to not be working the way the Joomla Help screen explains it should.

  1. The Banner Manager > Tracks screen keeps adding new rows of info every HOUR instead of DAILY for each Banner. Shouldn't it only list each Banner's impressions once per day instead of every hour of every day?
    The hourly impression tracking creates tons of pages in the Tracks screens over time. I would think that would be a waste of database space and unnecessary Tracks screens.

I have attached 3 screenshots of my Joomla 3.4x settings related to the Client and Banner Tracking.
I apologize if this is not a bug but let me know if I should instead post this as a question on the Joomla.org forum instead of GitHub.

banners-1
banners-2
banners-3

avatar wojsmol wojsmol - open - 2 Jan 2016
avatar wojsmol wojsmol - change - 2 Jan 2016
Status New Pending
avatar joomla-cms-bot joomla-cms-bot - change - 2 Jan 2016
Labels Added: ?
avatar brianteeman brianteeman - change - 12 Jan 2016
Category Components
avatar brianteeman brianteeman - change - 12 Jan 2016
The description was changed
avatar waader
waader - comment - 27 Jan 2016

I tested this successfully, but I would not consider this a bug. I agree that hourly records are a bit excessive but this a known behaviour for a long time, see for example here: http://www.inmotionhosting.com/support/edu/joomla-3/banners/tracking

Also on an existing installation with activated tracking you would get mixed (hourly, daily) records which isn´t desirable. A neat solution could be another parameter - there aren´t that many for this component - that let´s you switch to daily records.


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/8825.

avatar brianteeman
brianteeman - comment - 27 Jan 2016

it is a bug if we call it daily when it is in fact hourly

On 27 January 2016 at 12:19, waader notifications@github.com wrote:

I tested this successfully, but I would not consider this a bug. I agree
that hourly records are a bit excessive but this a known behaviour for a
long time, see for example here:
http://www.inmotionhosting.com/support/edu/joomla-3/banners/tracking

Also on an existing installation with activated tracking you would get
mixed (hourly, daily) records which isn´t desirable. A neat solution could
be another parameter - there aren´t that many for this component - that

let´s you switch to daily records.

This comment was created with the J!Tracker Application
https://github.com/joomla/jissues at issues.joomla.org/joomla-cms/8825
https://issues.joomla.org/tracker/joomla-cms/8825.


Reply to this email directly or view it on GitHub
#8825 (comment).

Brian Teeman
Co-founder Joomla! and OpenSourceMatters Inc.
http://brian.teeman.net/

avatar waader
waader - comment - 27 Jan 2016

You probably mean the description in the mentioned help text. As I get no help text at all I searched via google and found that this behaviour is known for a long time. So in this case I would say, correct the help text. Anyway.

avatar brianteeman
brianteeman - comment - 27 Jan 2016

To me the code is wrong not the text

On 27 January 2016 at 12:42, waader notifications@github.com wrote:

You probably mean the description in the mentioned help text. As I get no
help text at all I searched via google and found that this behaviour is
known for a long time. So in this case I would say, correct the help text.
Anyway.


Reply to this email directly or view it on GitHub
#8825 (comment).

Brian Teeman
Co-founder Joomla! and OpenSourceMatters Inc.
http://brian.teeman.net/

avatar brianteeman brianteeman - change - 18 Mar 2016
The description was changed
Rel_Number 0 6617
Relation Type Pull Request for
avatar waader waader - test_item - 15 Apr 2016 - Tested successfully
avatar waader
waader - comment - 15 Apr 2016

I have tested this item :white_check_mark: successfully on 139d644

Does what it says but I see no issue here.


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/8825.

avatar conconnl
conconnl - comment - 28 Jun 2016

It would be a nice addition if you could choose between Hourly or Daily through the settings.
If you just change the code, existing environments will start working differently.
When you create a configuration option for it and keep the default the same you won't change existing websites.


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/8825.

avatar joomla-cms-bot
joomla-cms-bot - comment - 28 Jun 2016

This PR has received new commits.

CC: @waader


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/8825.

avatar wojsmol
wojsmol - comment - 28 Jun 2016

just a rebase to current staging.

avatar joomla-cms-bot
joomla-cms-bot - comment - 28 Jun 2016

This PR has received new commits.

CC: @waader


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/8825.

avatar joomla-cms-bot joomla-cms-bot - change - 28 Jun 2016
Labels Added: ?
avatar wojsmol
wojsmol - comment - 28 Jun 2016

@brianteeman Plese check new language strings

avatar brianteeman
brianteeman - comment - 28 Jun 2016

Lol I was just commenting on the strings when I got the email :)

avatar joomla-cms-bot
joomla-cms-bot - comment - 28 Jun 2016

This PR has received new commits.

CC: @waader


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/8825.

avatar wojsmol
wojsmol - comment - 28 Jun 2016

@conconnl @waader Please test now

avatar zero-24
zero-24 - comment - 28 Jun 2016

my seccond comment still applys ;)

this can't work because we set it to 'Y-m-d H' in line 81 and override it everytime with 'Y-m-d' in line 84.

I think moving the line 84 above the if can fix the issue:

$trackDate = JFactory::getDate()->format('Y-m-d');

 if ($track_frequency == 'hourly')
 {
    $trackDate = JFactory::getDate()->format('Y-m-d H');
 }
avatar joomla-cms-bot
joomla-cms-bot - comment - 28 Jun 2016

This PR has received new commits.

CC: @waader


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/8825.

avatar joomla-cms-bot
joomla-cms-bot - comment - 28 Jun 2016

This PR has received new commits.

CC: @waader


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/8825.

avatar wojsmol
wojsmol - comment - 28 Jun 2016

@zero-24 Thans for comments, PR updated

avatar zero-24
zero-24 - comment - 28 Jun 2016

Looks better thanks ?

avatar conconnl
conconnl - comment - 29 Jun 2016

@wojsmol I Tested this correctly, but I'm seeing one inconsistency.
screen shot 2016-06-30 at 00 36 21

The text states: "These settings apply for all clients unless they are changed for a specific client. "
But the "Track Frequency" is not configurable on client level.
Maybe you can add this to the Client part and then everything is perfect.

avatar joomla-cms-bot
joomla-cms-bot - comment - 30 Jun 2016

This PR has received new commits.

CC: @waader


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/8825.

avatar joomla-cms-bot
joomla-cms-bot - comment - 30 Jun 2016

This PR has received new commits.

CC: @waader


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/8825.

avatar conconnl
conconnl - comment - 30 Jun 2016

@wojsmol The track frequency at client level does not work, it keeps jumping back to hourly.
Instead of the selected setting.


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/8825.

avatar joomla-cms-bot
joomla-cms-bot - comment - 1 Jul 2016

This PR has received new commits.

CC: @waader


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/8825.

avatar joomla-cms-bot
joomla-cms-bot - comment - 1 Jul 2016

This PR has received new commits.

CC: @waader


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/8825.

avatar wojsmol
wojsmol - comment - 1 Jul 2016

After applying the patch run the database fix in Extensions> Manage> Database.

avatar conconnl conconnl - test_item - 1 Jul 2016 - Tested successfully
avatar conconnl
conconnl - comment - 1 Jul 2016

I have tested this item successfully on ca1e68b


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/8825.

avatar conconnl
conconnl - comment - 1 Jul 2016

@wojsmol it works perfectly now


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/8825.

avatar joomla-cms-bot
joomla-cms-bot - comment - 1 Jul 2016

This PR has received new commits.

CC: @conconnl, @waader


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/8825.

avatar wojsmol
wojsmol - comment - 1 Jul 2016

@waader @alikon Plese test in postgresql and sqlazure if passible.

avatar toxic2302 toxic2302 - test_item - 1 Aug 2016 - Tested successfully
avatar toxic2302
toxic2302 - comment - 1 Aug 2016

I have tested this item successfully on ec75c7a

After I have installed the patch and fixed the database I'm able to see the track frequency option.
On the client level of the banner I checked the daily option and it doesn't switch to hourly. I have tested with a mysql database.

So in my opinion it works correctly.

@icampus


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/8825.

avatar florian1995 florian1995 - test_item - 2 Aug 2016 - Tested successfully
avatar florian1995
florian1995 - comment - 2 Aug 2016

I have tested this item successfully on ec75c7a

I applied the patch and got the track frequency option which works correctly.
I had done the database fix and can change between daily and hour now.
Using MySQL.
Tested@icampus


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/8825.

avatar roland-d
roland-d - comment - 2 Aug 2016

@waader @alikon requesting if you can test in postgresql and sqlazure if possible. Thanks.


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/8825.

avatar wojsmol
wojsmol - comment - 16 Aug 2016

rebase after #11619

avatar renekreijveld
renekreijveld - comment - 4 Nov 2016

I have tested this item successfully on 7428d3b

Installed the patch and could set the Track Frequency option to Hourly or Daily. I set the option to Hourly. In the Banner edit form I can set the Track Frequency to Hourly or Daily. In the Client edit form I can also set the Track Frequency to Hourly or Daily.


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/8825.

avatar renekreijveld renekreijveld - test_item - 4 Nov 2016 - Tested successfully
avatar superknutsel superknutsel - test_item - 4 Nov 2016 - Tested successfully
avatar superknutsel
superknutsel - comment - 4 Nov 2016

I have tested this item successfully on 7428d3b

Tested both options (hourly and daily) and it works like expected after the patch.


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/8825.

avatar slibbe slibbe - test_item - 4 Nov 2016 - Tested unsuccessfully
avatar slibbe
slibbe - comment - 4 Nov 2016

I have tested this item 🔴 unsuccessfully on 7428d3b

Tested this one with PostgreSQL. Getting several errors, not only related to this issue. Needs a more thorough review.

If needed I can test more on PostgreSQL.


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/8825.

avatar wojsmol
wojsmol - comment - 5 Nov 2016

@slibbe Could I ask you to provide errors for PostgreSQL associated with this PR?

avatar alikon
alikon - comment - 6 Nov 2016

@slibbe can you report on a new issue what error you get using banner with postgresql if they are not related to this pr

avatar wojsmol
wojsmol - comment - 6 Nov 2016

@alikon Can you test this PR on postgresql?

avatar franz-wohlkoenig franz-wohlkoenig - change - 6 Apr 2017
The description was changed
Status Pending Needs Review
avatar joomla-cms-bot joomla-cms-bot - change - 6 Apr 2017
Category Components SQL Administration com_admin Postgresql MS SQL com_banners Language & Strings Front End Installation Components
avatar joomla-cms-bot joomla-cms-bot - edited - 6 Apr 2017
avatar waader
waader - comment - 7 Apr 2017

@wojsmol If you could sync this patch I will test on postgresql and mssql.

avatar wojsmol
wojsmol - comment - 8 Apr 2017

@waader PR is rebased to staging

avatar waader
waader - comment - 10 Apr 2017

With postgres I get a syntax error for type timestamp with this query:

UPDATE #__banner_tracks SET "count" = ("count" + 1) WHERE track_type=1 AND banner_id=4 AND track_date='2017-04-10 09'

avatar wojsmol
wojsmol - comment - 10 Apr 2017

@waader Do you have any idea how to solve this problem? I have no experience with postgres.

avatar wojsmol
wojsmol - comment - 30 Apr 2017

cc @alikon see error reported by @waader any idea?

avatar alikon
alikon - comment - 30 Apr 2017

...maybe you could use CAST() ...

avatar wojsmol
wojsmol - comment - 30 Apr 2017

@alikon Plese send PR with appropriate changes.

avatar rdeutz rdeutz - change - 13 Nov 2017
Status Needs Review Pending
Labels
avatar roland-d
roland-d - comment - 22 Jul 2018

@alikon Can you help here?


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/8825.

avatar franz-wohlkoenig
franz-wohlkoenig - comment - 2 Aug 2018

gently Reminder @alikon.


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/8825.

avatar wojsmol
wojsmol - comment - 2 Aug 2018

or @csthomas maybe?

avatar alikon
alikon - comment - 2 Aug 2018

the issue is to use a date to compare a timestamp field as reported 1 year and plus ago by @waader #8825 (comment)
see here https://github.com/joomla/joomla-cms/pull/8825/files#diff-4140a4b988c67c2915e88362dd9815ceR79 , so provide the correct data type or compare the same data type before issuing a comparison, this should be a normal rule not a postgresql rule only

avatar csthomas
csthomas - comment - 6 Aug 2018

I only did a code review.

IMO all lines $trackDate = JFactory::getDate()->format('Y-m-d H'); should be replaced by something like $trackDate = JFactory::getDate()->format('Y-m-d H:00:00'); and the same for $trackDate = JFactory::getDate()->format('Y-m-d'); should be replaced by $trackDate = JFactory::getDate()->format('Y-m-d 00:00:00');.

Then all values should be OK.

Another issue is that there is no time zone and everything will be calculated in UTC.

avatar wojsmol wojsmol - change - 8 Aug 2018
Labels
avatar franz-wohlkoenig
franz-wohlkoenig - comment - 24 Aug 2018

@wojsmol should this Pull Request test again or is it waiting for something else?

avatar wojsmol
wojsmol - comment - 24 Aug 2018

@franz-wohlkoenig PR is ready for testing.
@brianteeman Please accept language strings.

avatar franz-wohlkoenig
franz-wohlkoenig - comment - 24 Aug 2018

@wojsmol will test.

avatar brianteeman
brianteeman - comment - 24 Aug 2018

@wojsmol I requested changes 16 days ago

avatar wojsmol
wojsmol - comment - 24 Aug 2018

@brianteeman Please see 5ff5f0e 😄

avatar brianteeman
brianteeman - comment - 24 Aug 2018

image

avatar wojsmol
wojsmol - comment - 24 Aug 2018

@brianteeman Fixed in latest commit.

avatar wojsmol
wojsmol - comment - 24 Aug 2018

@alikon AFTER removed in 4e3bc26

avatar alikon
alikon - comment - 24 Aug 2018

@wojsmol thanks

avatar franz-wohlkoenig
franz-wohlkoenig - comment - 25 Aug 2018

@wojsmol to be sure what to test can you give please Test Instructions?

avatar twister65
twister65 - comment - 19 Sep 2018

I have tested this item 🔴 unsuccessfully on 4e3bc26

When Track frequency is set in the banner details ("hourly" or "daily"), it always get the Track Frequency in the global configuration.


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/8825.
avatar twister65 twister65 - test_item - 19 Sep 2018 - Tested unsuccessfully
avatar franz-wohlkoenig franz-wohlkoenig - change - 11 Apr 2019
Category Components SQL Administration com_admin Postgresql MS SQL com_banners Language & Strings Front End Installation Administration com_admin com_banners Components Front End Installation MS SQL Postgresql SQL
avatar franz-wohlkoenig franz-wohlkoenig - change - 19 Apr 2019
Title
Bug in Joomla 3.4x Banner Manager > Tracks. Shows hourly counts instead of daily counts.
Banner Manager > Tracks. Shows hourly counts instead of daily counts.
avatar franz-wohlkoenig franz-wohlkoenig - edited - 19 Apr 2019
avatar joomla-cms-bot joomla-cms-bot - change - 19 Apr 2019
Category Components SQL Administration com_admin Postgresql MS SQL com_banners Front End Installation SQL Administration com_admin Postgresql MS SQL com_banners Language & Strings Front End Installation Components
avatar twister65
twister65 - comment - 24 Apr 2019

Fixes to read the track_frequency parameter of the component (banner and client):
banner_patch.txt
banners_patch.txt

avatar HLeithner
HLeithner - comment - 29 Jun 2019

This is the oldest PR we have and sadly it started with a bug fix and is now a new feature.

Our policy says no new features in patch levels and no new feature in combat version 3.10. I don't know why this PR hasn't merged before but now I would like to ask you @wojsmol to rebase this PR on J4.

This would be really great, thx. In the meantime I close this PR.

avatar HLeithner HLeithner - close - 29 Jun 2019
avatar HLeithner HLeithner - change - 29 Jun 2019
Status Pending Closed
Closed_Date 0000-00-00 00:00:00 2019-06-29 21:47:50
Closed_By HLeithner

Add a Comment

Login with GitHub to post a comment