Apparently the tracker is failing to record the right information in the database. Do you have a mysql log file available? Also, are you using the latest version of SlimStat?
Thread Starter
infrcl
(@infrcl)
The version is 3.5.4
I had a look to the mysql binary log and surprise! The insert_id for the slim_browsers is 65534 always, so max type data reached?
Of course, the data type is smallint(5) and not mediumint for the id in the slim_browsers table. The slim_screenres table isn’t updated either.
I think that I missed some database schema update. What is your advice to update the schema safely?
Very good catch, infrcl. Excellent troubleshooting! You can safely change the type of both fields (in wp_slim_stats and wp_slim_browsers) to something bigger. However I wonder why you have 65k records in wp_slim_browsers, given that the number of browsers recognized by SlimStat is about 40k. Would you be able to contact us via our support form and send us a dump of your wp_slim_browsers table?
http://support.getused.to.it
Thank you!
Thread Starter
infrcl
(@infrcl)
In fact, I have only 902 entries in the wp_slim_browsers table. It seems that the auto_increment value had going crazy and it had started to sum too big values between two consecutive records. For instance, the last browser_id in the wp_slim_browsers is 65534 whereas the preceding has a value of 64132.
Anyway, I’ve changed the type to mediumint and it has started to register the browser_id in the wp_slim_stats.
Cheers
Interesting. Not sure why that happened in your case. You may want to try to repair your tables, or backup your data and uninstall/reinstall the plugin.
Anyway, I’m glad you were able to figure that out.
A vote for SlimStat would be a nice way to say thank you
http://wordpress.org/support/view/plugin-reviews/wp-slimstat
Thread Starter
infrcl
(@infrcl)
I had already voted indeed. I’ve marked as favorite your plugin.
Thanks man!!