Not possible to active for new blogs after update

Okay, it looks like you skipped one of the updates or are still using an older version of SlimStat. Is that correct? wp_slim_browsers should have browser_id set to smallint, not mediumint (that was a bug in an earlier version).

You will need to drop the foreign key in wp_slim_stats referencing that column, then update the type to smallint, then recreate the foreign key.

I have SlimStat 3.6 installed. And I have not skipped any updates.

Is it possible you can provide me with some TSQL code to do what you suggest?

And please explain why this results in nothing being captured on new blogs.

Is this the correct TSQL to do this?

ALTER TABLE wp_slim_stats DROP FOREIGN KEY fk_wp_browser_id;

ALTER TABLE wp_slim_browsers MODIFY browser_id SMALLINT UNSIGNED NOT NULL auto_increment;

ALTER TABLE wp_slim_stats ADD CONSTRAINT fk_wp_browser_id FOREIGN KEY (browser_id) REFERENCES wp_slim_browsers(browser_id);

yes

ALTER TABLE wp_slim_stats DROP FOREIGN KEY fk_wp_browser_id; didn’t work.

ERROR 1025 (HY000): Error on rename.

Running ALTER TABLE wp_slim_browsers MODIFY browser_id SMALLINT UNSIGNED NOT NULL auto_increment; didn?t work either.

ERROR 1062 (23000): ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry ‘65535’ for key ‘PRIMARY’

I am starting to give up on this plugin now!

What keys do you see associated to wp_slim_stats in phpmyadmin?

I have not installed phpmyadmin. I’m running in the terminal.

https://imgur.com/DWH1V5W

But the thing is, I have not touch these tables in anyway. This problem have to do something with your updates to the plugin.

SHOW CREATE TABLE wp_slim_stats;

https://imgur.com/DWH1V5W

Can I add you on facebook or chat with you over skype?

I have sent you my skype alias to your support mail.

You don’t have any foreign keys associated to that table. Delete all the records in wp_slim_browsers that have browser_id = 0

select * from wp_slim_browsers where browser_id = 0;
Empty set (0.00 sec)

Please add me on Skype and we can try and find out what the problem is.

Will it be possible for me to downgrade from 3.6 to 3.5.5 without problem by just overwriting the plugin directory?

Your tables seem to be in an inconsistent state. You can downgrade, but make sure to backup your slimstat tables first.

I’m glad we were able to figure this out! ??

Well, the problem was related to you changing MEDIUMINT to SMALLINT in the table wp_slimstat_browsers in version 3.5.6

Or only solution now is to uninstall slimstat and install it again or continuously change SMALLINT to MEDIUMINT in wp_slimstat_browsers for each and every update.

Another solution is to write a PHP-script and try and remap all integers with a value above 65535, but I do not really think I have the time to do that.

But in summary, I would say that this problem occurred because of your lack of quality assurance. This problem was not related to anything we did.

But anyway, I would like to thank you developer for taking his time trying to figure out what the problems was.