Hi @maxbyer,
Thank you for opening this thread, and I apologize for any inconvenience this may have caused.
Could you please provide more details about the issue you are experiencing?
Additionally, we would appreciate it if you could check the browser’s console for any errors. Providing screenshots/screencasts would also greatly assist us in identifying the problem and providing more accurate solutions.
Thank you for your cooperation!
Regards
I posted this in another thread.
https://ibb.co/86PdHqR
Thank you, @maxbyer!
Could you please open the Inspector of the browser, navigate to Network tab, search for name=summary, and check the response?
If there is nothing in the Network tab, kindly click on the “reload” button of the “Traffic Summary” widget. Please check this image for reference: https://i.vgy.me/RnhFQT.png.
Additionally, we would appreciate it if you could check the browser’s Console tab for any errors.
Thank you!
Regards
Thanks for your response, unfortunately I don’t have the time doing that, It was working before update, after the next update and it does not work I will have to remove it in favor of something else.
Hi @maxbyer ,
Thanks for letting us know about your experience, and I’m really sorry for the trouble caused by the update. Your satisfaction matters to us, and we’ll look into this to make sure future updates don’t disrupt important features.
If there’s anything we can do to help or if you’d like to give it another try, please reach out. We appreciate your feedback and trust.
Best,
Navid
I just did a rollback and everything works. I hope your next update fixes everything.
Dear @maxbyer,
Could you kindly let us know which version of WP Statistics you rolled back to?
Thank you!
Regards
Hi @maxbyer,
Could you please check the Main IP Detection Method by navigating to Statistics > Settings > Advanced Options? For reference, you can use this image: https://i.vgy.me/P8GWhU.png.
Please ensure “Sequential IP Detection” is selected as the Main IP Detection Method, if it isn’t already.
Afterwards, kindly update the plugin and clear the cache from both your CDN and browser.
Let us know if this resolves the issue.
Thank you!
Regards
I tried and still no luck.
Dear @maxbyer,
Could you please check the statistics_visitor table in your database (version 14.11.2) and confirm if the following columns exist in the table:
- source_channel
- source_name
Thank you for your cooperation!
Regards,
Matthew
No, neither of those exist.
Thank you, @maxbyer, for checking the database!
We introduced two new columns in version 14.11, but it seems there was an issue during the update, resulting in the columns not being created in your database.
To resolve this, please run the following SQL command to add the missing columns:
ALTER TABLE wp_statistics_visitor ADD source_channel VARCHAR(50) NULL DEFAULT NULL , ADD source_name VARCHAR(100) NULL DEFAULT NULL;
Make sure to replace wp_ with your custom database prefix if applicable.
Additionally, please verify if the visitor_id column exists in the wp_statistics_useronline table. If not, use the following command to create it:
ALTER TABLE wp_statistics_useronline ADD visitor_id BIGINT NOT NULL;
We sincerely apologize for any inconvenience this may have caused. Rest assured, we are committed to improving WP Statistics to prevent similar issues in the future.
We look forward to hearing back from you!
Regards,
Matthew
I would prefer to uninstall and reinstall, why can’t I just do that?
Dear @maxbyer,
Apologies for the delay!
You can also deactivate and then reactivate WP Statistics (version 14.11 or later) to have the aforementioned columns created automatically.
This should resolve the issue.
Thank you for your continued support!
Regards,
Matthew
