SpenceDesign

Got it, thanks!

Tried that and have not received a reply. I had to delete the SlimStat excel export plugin in order to get SlimStat to not crash the entire site, so I do not have a copy to install. Hoping SlimStat support will get back to me soon. It has been about 4 days so far.

Resolved.

No worries. Thanks for a great product. It has been awhile since I donated to your efforts. Perhaps I will make another donation before the end of the year.

Please mark this thread resolved.

Thanks again.
Cheers!

Just did some additional testing and we are now getting tracking information written to table. The previous error is gone on the Settings/Maintenance but I am not getting this error, which is less concerning though. BTW, another site I run slimstat on was has this same error.

Error:
211 Bot not tracked recorded on 12-18-15 @ 05:27 pm

I am more familiar with the previous versions interface and have not spent much time in the updated SlimStat UI. Perhaps this error is simple bots being blocked?

Hi Camu,

I will do some additional checking and get back to you. I may try dumping the table completely and do a complete new install of the plugin. I will report back once I get it working again.

Hi Camu,

Working with my developer, this is what we did.

Deactivated the plugin and set up a drop table routine and dropped all the tables. Then activated the plugin and when it came up the slim_stats table was better but still missing these two columns:

| ip_num | int(10) unsigned | | 0 | |
| other_ip_num | int(10) unsigned | | 0 | |
As seen here:
mysql> desc wp_slim_stats;
+——————-+———————-+——+—–+———+—————-+
| Field | Type | Null | Key | Default | Extra |
+——————-+———————-+——+—–+———+—————-+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| ip | varchar(39) | YES | | NULL | |
| other_ip | varchar(39) | YES | | NULL | |
| username | varchar(255) | YES | | NULL | |
| country | varchar(16) | YES | | NULL | |
| referer | varchar(2048) | YES | | NULL | |
| resource | varchar(2048) | YES | | NULL | |
| searchterms | varchar(2048) | YES | | NULL | |
| plugins | varchar(255) | YES | | NULL | |
| notes | varchar(2048) | YES | | NULL | |
| visit_id | int(10) unsigned | NO | | 0 | |
| server_latency | int(10) unsigned | YES | | 0 | |
| page_performance | int(10) unsigned | YES | | 0 | |
| browser | varchar(40) | YES | | NULL | |
| browser_version | varchar(15) | YES | | NULL | |
| browser_type | tinyint(3) unsigned | YES | | 0 | |
| platform | varchar(15) | YES | | NULL | |
| language | varchar(5) | YES | | NULL | |
| user_agent | varchar(2048) | YES | | NULL | |
| resolution | varchar(12) | YES | | NULL | |
| screen_width | smallint(5) unsigned | YES | | 0 | |
| screen_height | smallint(5) unsigned | YES | | 0 | |
| content_type | varchar(64) | YES | | NULL | |
| category | varchar(256) | YES | | NULL | |
| author | varchar(64) | YES | | NULL | |
| content_id | bigint(20) unsigned | YES | | 0 | |
| outbound_resource | varchar(2048) | YES | | NULL | |
| dt_out | int(10) unsigned | YES | | 0 | |
| dt | int(10) unsigned | YES | MUL | 0 | |
+——————-+———————-+——+—–+———+—————-+
29 rows in set (0.01 sec)

I deactivated the plugin, dropped the slimstat tables again, added the two columns to their plugins/wp-slimstat/admin/wp-slimstat-admin.php and activated the plugin and the columns are there:
mysql> desc wp_slim_stats;
+——————-+———————-+——+—–+———+—————-+
| Field | Type | Null | Key | Default | Extra |
+——————-+———————-+——+—–+———+—————-+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| ip | varchar(39) | YES | | NULL | |
| other_ip | varchar(39) | YES | | NULL | |
| ip_num | int(10) unsigned | YES | | 0 | |
| other_ip_num | int(10) unsigned | YES | | 0 | |
| username | varchar(255) | YES | | NULL | |
| country | varchar(16) | YES | | NULL | |
| referer | varchar(2048) | YES | | NULL | |
| resource | varchar(2048) | YES | | NULL | |
| searchterms | varchar(2048) | YES | | NULL | |
| plugins | varchar(255) | YES | | NULL | |
| notes | varchar(2048) | YES | | NULL | |
| visit_id | int(10) unsigned | NO | | 0 | |
| server_latency | int(10) unsigned | YES | | 0 | |
| page_performance | int(10) unsigned | YES | | 0 | |
| browser | varchar(40) | YES | | NULL | |
| browser_version | varchar(15) | YES | | NULL | |
| browser_type | tinyint(3) unsigned | YES | | 0 | |
| platform | varchar(15) | YES | | NULL | |
| language | varchar(5) | YES | | NULL | |
| user_agent | varchar(2048) | YES | | NULL | |
| resolution | varchar(12) | YES | | NULL | |
| screen_width | smallint(5) unsigned | YES | | 0 | |
| screen_height | smallint(5) unsigned | YES | | 0 | |
| content_type | varchar(64) | YES | | NULL | |
| category | varchar(256) | YES | | NULL | |
| author | varchar(64) | YES | | NULL | |
| content_id | bigint(20) unsigned | YES | | 0 | |
| outbound_resource | varchar(2048) | YES | | NULL | |
| dt_out | int(10) unsigned | YES | | 0 | |
| dt | int(10) unsigned | YES | MUL | 0 | |
+——————-+———————-+——+—–+———+—————-+
31 rows in set (0.02 sec)

But I still get the Tracker Error Code 215 Unknown column ‘resolution’ in ‘field list’ recorded on 12-18-15 @ 03:03 pm

You can see resolution is in the column list and should be based on the link you sent me:
https://slimstat.freshdesk.com/solution/articles/5000650210-what-is-the-table-schema-used-to-store-all-the-information-

We think SlimStat needs to:
1. Update their table install for those two columns noted above if they still need them, or update their column list for the table in their link above.
2. Troubleshoot the issue on the resolution column Tracker Error Code.

Any additional thoughts?

Same issue here with the Math CAPTCHA not working, but I am running Contact Form 7 Version 4.0.3. I will donate to you if this issue gets fixed. Thanks for you time in addressing this problem.

Update to not showing related videos for built WordPress embed. Use this plugin, instead of having to add the ?rel=0 to every video link. The plugin I am using to post listings was striping the ?rel=0 out and thus still showing related videos.

Plugin that fixed the showing of related videos:
https://www.ads-software.com/plugins/hide-youtube-related-videos/

Cheers!

@emirpprime you saved my bacon. Thanks for the tip on removing the 2 lines of code.

The other thing that should be noted for anyone having trouble, is that this plugin only works (after above mention code is removed) with the built in video embed feature in WordPress. If you use the iFrame embed, it does not work properly (will not scale like it should).

Bummer part is that you cannot prevent other videos from showing at the end of you videos unless you use the iFrame embed. If anyone figures out a workaround to the “rel=0” option for auto video embed, let me know. I have yet to find one.

I totally agree about the many variables involved in troubleshooting the issue with so many plugins on my end.

I will do a some clean up on my end and see if I upgrading to the latest version of WP fixes it and I will keep you posted. The site is an e-commerce site and after the holidays I should have some more time to troubleshoot things.

Thanks again for your prompt replies and communication.

Deactivated Google Analytics plugin and turned on the Pop-up JS in your plugin and have the same issue.

Again, do not spend too much time on my account trying to find it. I really just wanted you to know someone else was having a similar issue to the Original poster.

Cheers

Hi Danny,

Yes, I have the Google Analytics plugin installed and active.

Only items checked in configuration are: ?
Track outbound clicks & downloads: ?
Extensions of files to track as downloads: doc,exe,js,pdf,ppt,tgz,zip,xls
Tag links in RSS feed with campaign variables: ?
Add tracking to the comment forms: ?

It really is not big a deal to me as disabling the Pop-up JS is a fine fix for now. I have many plugins (over 20) active with that site, so nailing it down may be tough. I will try disabling the Analytics plugin and let you know how that works.

No other social sharing or twitter related plugins active. Only other one still installed is Flare, which is inactive.

Same issue for me on one of the sites I just tried your most useful plugin on. Site still running WordPress 3.4.2. Only the Twitter link opens twice the other only open once.

So, I disabled the load Pop-up JS for now and the twitter feed only opens once. The others (Facebook and Google+) open new full size windows, unlike the twitter one which opens a small pop-over window. Mac Safari browser and Firefox both act the same.

Not sure if any of this helps, but saw this post and thought I would chime in. Let me know if there is any fix and I will update to get the pop-up benefit for all three.

FYI, different site running WordPress 3.8 does not have any issue with the double twitter pop-up.

Cheers.