category hits stoped at 32767 ???

[HelpMeNow]

I have one category in my 4images that the hits in it has reached 32767 and stoped going up! Even regular users won't be counted. All my other categories are registering hits but has not reached this number yet.

How can this be fixed.

[V@no]

I'm not sure if this could help, but (hope u know how to work with mysql managers, i.e. phpmyadmin)
try to execute this mysql query:

ALTER TABLE `4images_categories` CHANGE `cat_hits` `cat_hits` MEDIUMINT( 10 ) DEFAULT '0' NOT NULL

by default cat_hits field set to SMALLINT( 6 ) I really dont know what's the difference bettween all those " *INT " types, but for some reason cat_id is set to MEDIUMINT ( 8 ) but hits to smaller value...that should be opposite I think

[HelpMeNow]

V@no,
Thank you for your quick reply. I ran the query and it's working now and regestering hits.
Thank you again for your help and expertise.

p.s. I noticed that the download number for the dutch version of 4images on this site has also stopped on 32767 as well.

[V@no]

V@no,
Thank you for your quick reply. I ran the query and it's working now and regestering hits.
Thank you again for your help and expertise.

p.s. I noticed that the download number for the dutch version of 4images on this site has also stopped on 32767 as well.

great, thx for the info, I'd posted database "fixer" today (it seems the few more tables needs to be updated),
but before I do that, I'd like to know for sure, what is the best type/max size for that kind of fields...is anyone out there familuar with mysql?

[babe]

So, is there anything else except for running that mysql query that needs to be done?

[www.girls-on-bikes.com]

Ahh, damn I love knowing the size of an integer