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.