Can you please provide a few things so we can look into this:

What is your C5 version?
What is your Hutman Ads version?
What is your PHP version?

What is your C5 version?
Version Installed - 8.3.2

What is your Hutman Ads version?
Hutman Ads v.1.0.0

What is your PHP version?
PHP 7.1

Please update to the newest version, this issue was fixed.

After upgrading it, I am getting following error

Call to a member function toArray() on null

This is not an error I have seen before. Can I please get access to your site so I can check to see what is going on? It would be super helpful to get C5 admin access as well as FTP or SSH access.

Also the statistic problem still persists. Unable to load the pages and once clicked on stats button, browser keeps loading and can not load site as well on same browser

Hi can you please help me out on this?

I would be happy to try to help with this, as previously asked can I please get access to your site so I can check to see what is going on?

I need C5 admin access as well as FTP or SSH access.

I have a clean C5 site running C5 8.3.2, PHP 7.1, and the latest 1.1.1 of Hutman Ads as you stated you are using and everything is working fine. So I am unable to replicate this issue.

Can you please provide me your email Id where I can provide you with all the access

Please send them to developers@hutman.net and we will take a look at your site and see what is going on.

Have emailed you the details, please check it and let me know

Hello, we got your information, thank you for providing that. Unfortunately while we were trying to add a new index to the Hutman_AdClicks on the click_date field we were given the error "SQLSTATE[HY000] [1040] Too many connections". We had 2 connections to the server so I am not sure who/what else is using this server right now but we are unable to add that index to speed up the Stats query.

We will wait and hour and see if the site comes back up, if it does not we will wait until we hear from you to proceed trying to make that change.

Also, I found that if you continue to wait for the Stats page it does load, it is just very slow. I believe this is because the query we are running was on un-indexed fields.

Is there any other way to add it like from database, or you can guide me what needs to be done and I can give it a try

After another try I was able to add the indexes by running these queries:



I also changed out our query for a better optimized one and the stats are loading significantly faster. Thank you for bringing this to our attention, the next release will address this issue.

Thanks for solving, appreciate your support

I am also seeing this problem. Any ideas on what to try?
for the heck of it I ran the 2 SQL statements you posted and it returned empty - no results.

When I click on "view Stats" it just times out.

I am using V1.1.2 of your app

# concrete5 Version
Core Version - 8.5.2
Version Installed - 8.5.2
Database Version - 20190925072210

# Database Information
Version: 5.7.30
SQL Mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

# concrete5 Packages
Background Image and Overlay (0.9.9), ExchangeCore reCAPTCHA (1.1.1), Formidable (Lite Version) (1.1.8), HTML Beautifier + Minifier (1.1.0), Hutman Ads (1.1.2), Image Optimizer (3.2.10), Info Box Grid (1.8), Lazy Menu (1.1.2), Location Map (1.0.11), Login/Logout Link (1.0), Magic Tabs (7.2.8), Quick Tabs (1.0), Responsive Embed (1.0.1), Responsive Theme (2.1.9), Site Alerts (1.0.0), Zoomer (1.0.1)

# concrete5 Overrides
css/jquery-magnific-popup.css

# concrete5 Cache Settings
Block Cache - On
Overrides Cache - Off
Full Page Caching - On - If blocks on the particular page allow it.
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache

# Server API
fpm-fcgi

# PHP Version
5.6.40