Jump to content

PageViewStatistic for ProcessWire


tcnet
 Share

Recommended Posts

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

 

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

  • 4 months later...

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.

upgrade1.jpg.1647776a0528c9cb1eea5479d39f997e.jpg

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

upgrade2.jpg.23543a92db578b9373a7bc05904dcb18.jpg

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

upgrade3.jpg.39c5516b830dddb3e4a8c352579e942c.jpg

 

Link to comment
Share on other sites

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!

  • Like 1
Link to comment
Share on other sites

  • 2 months later...
8 minutes ago, eydun said:

image.thumb.png.c83337f5c82c87fe60be446ec73e133c.png

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.

Link to comment
Share on other sites

  • 1 month later...
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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 5 months later...

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?

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...