module PageViewStatistic for ProcessWire

[Stefanowitsch]

2 hours ago, tcnet said:

There are not a single ERROR MESSAGE in your post! These are Warnings and Notices which you get when you run ProcessWire in debug mode.

And why they not appear? Because your ProcessWire DON'T run in debug mode.

Sorry about that! Yes these messages are not error messages. But when you open a page and see a few hundred warnings you can get a bit nervous ?

On my live site I don't get these messages at all, despite the debug mode set to off. So only my local environment causes the issue when there is no IP address assigned to my virtual host.
 

2 hours ago, tcnet said:

I made a change in line 389. It seems that getenv('REMOTE_ADDR') doesn't work with local IP addresses. Please upgrade to version 1.1.6.

Thanks for the fast help! I tried to upgrade via the PW upgrades module but this time I got a real error message:

Modules: Error upgrading module (ProcessPageViewStat): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS usr int(10) unsigned' at line 1

 

[tcnet]

Ok. I don't know what you doing. The upgrade shold work. I guess you changed the database manually.

[Stefanowitsch]

I read the posts on the previous pages, it seems that more people have trouble with upgrading the module.

I will stick to the module as it is now. On the live site it runs fine and that is where the statistics do matter.

[tcnet]

2 minutes ago, Stefanowitsch said:

I read the posts on the previous pages, it seems that more people have trouble with upgrading the module.

I will stick to the module as it is now. On the live site it runs fine and that is where the statistics do matter.

Which database you using?

[Stefanowitsch]

phpMyAdmin 4.9.7

It's a mySQL Database with a utf8_general_ci collation.

[tcnet]

10 minutes ago, Stefanowitsch said:

phpMyAdmin 4.9.7

It's a mySQL Database with a utf8_general_ci collation.

Can you check which mySQL version?

[Stefanowitsch]

2 minutes ago, tcnet said:

Can you check which mySQL version?

5.7.32.

My Processwire runs on PHP 7.4.12

[tcnet]

Please give me 24 hours. I have another work too.

[Stefanowitsch]

Just now, tcnet said:

Please give me 24 hours. I have another work too.

Take your time! I am nut in a hurry. The project I am using this module on is still in development. 

[tcnet]

I made changes in the upgrade function. Please upgrade to version 1.1.7.

[Arne]

@tcnet Is it possible to export to CSV not only by day but also for the views like "last 30 days" for the data it shows there?

[tcnet]

On 5/19/2022 at 1:41 PM, Arne said:

@tcnet Is it possible to export to CSV not only by day but also for the views like "last 30 days" for the data it shows there?

Maybe.

[tcnet]

It seems that the upgrade function don't get called after an upgrade. This might be a bug in ProcessWire. This can lead to an error message ("Unknown column...") if you try to open the statistic page immediately after an upgrade.

There are two ways to avoid this error message. Click the "Continue to module settings" button directly after the upgrade

or open the Modules page and click the "Refresh" button.

 

[JayGee]

2 hours ago, tcnet said:

It seems that the upgrade function don't get called after an upgrade. This might be a bug in ProcessWire.....

This is really weird - I was just about to start typing a message into the forum about this. I'm working on a module where I cannot get the upgrade method to fire. I'll post separately rather than hijack this thread but glad to see it's not just me with this problem!

[eydun]

Thanks for building this module.

I get this error. I guess it requires php 8 as minimum?

[tcnet]

5 hours ago, eydun said:

I get this error. I guess it requires php 8 as minimum?

I replaced str_starts_with() with substr() to support PHP7. Please upgrade to version 1.2.2.

[eydun]

Do you know why it logs visits to css-files?
(this entry is a real visit, and not a bot)

Thanks.

[tcnet]

8 minutes ago, eydun said:

Do you know why it logs visits to css-files?
(this entry is a real visit, and not a bot)

Thanks.

The module records requests which being processed by ProcessWire. Make sure if ".../zoomin.cur" exists. I guess not. This might be a 404. Check if you have "Record 404 pages" activated in the module settings. I guess you have.

[eydun]

Quote

Make sure if ".../zoomin.cur" exists. I guess not. This might be a 404. Check if you have "Record 404 pages" activated in the module settings. I guess you have.

Thanks, you nailed it!

[eydun]

On 1/27/2023 at 8:49 AM, tcnet said:

The module records requests which being processed by ProcessWire. Make sure if ".../zoomin.cur" exists. I guess not. This might be a 404. Check if you have "Record 404 pages" activated in the module settings. I guess you have.

It would be awesome, if you could see it the stats, when a log is created because of a 404.

[tcnet]

2 minutes ago, eydun said:

It would be awesome, if you could see it the stats, when a log is created because of a 404.

Or you could use another module... Or you can spend some money and let developed a module which fit your requirements.

[eydun]

Thanks. Is paying you to develop this feature an option?

[herr rilke]

hi there

i get a 500 server error when trying to switch to any other view ("Days of Month", "Last 30 Days" ...) than the initially displayed one.

found an entry in exceptions:

SQLSTATE[42000]: Syntax error or access violation: 
1064 You have an error in your SQL syntax; 
check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC LIMIT 1' at line 1
In /site/modules/ProcessPageViewStat/ProcessPageViewStat.module line 1693

any idea?

 

[tcnet]

It means that you deleted columns from table process_pageviewstat_cache. Reinstalling the module might help.

[tcnet]

Ok. I found the problem. You using MySQL 8?