Tracker Error Code

Hi,

in phpMyAdmin please make sure your table schema matches the one in the documentation:

https://slimstat.freshdesk.com/solution/articles/5000650210-what-is-the-table-schema-used-to-store-all-the-information-

Best,
Camu

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?

Hi,

I apologize for the confusion regarding ip_num and other_ip_num. Those two columns were kept in version 4.0 and 4.1 for backward compatibility, but they were not being used anymore, so we removed them completely in version 4.2 (and added code to drop them, if they still exist in your table). I updated the documentation to not have them listed anymore.

As for the error code, I am not clear on why you get that error code, as the field ‘resolution’ is now there. Not sure why that is happening.

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.

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?

Yes, we are working on renaming those “errors” into “notices”, as they just describe why a given pageview was not tracked. They are not related to a malfunction or problem. Sorry for the confusion.

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!

Resolved.

Thank you!