[1.7/1.7.1 (upgrade only)] Categories hits stops at 32767

[V@no]

To fix that you'll need change the type of cat_hits field in 4images_categories table from smallint(6) to int(10)

Here is MySQL query for your convinience:

Code: [Select]

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

[ascanio]

is this gonna happen to every one?

[martrix]

Yes - as long as "everybody" has the cat_hits data-type set to smallint - which length is from -32768 to 32767

I guess your counter doesn't go backwards, so you won't have any problems with the -32768 border-line

Int can hold up to 2147483647 hits and I guess that will take a while untill you'll get at this point 

[ascanio]

so what i have to do is to change the data-type of cat_hits to get more space?

[martrix]

  you have to read V@no's post 
and then run the MySQL query he wrote... not more not less...

[mantra]

when you click refresh button they  still update counter visit of the category page.
how to stop this  :

[V@no]

the hits dont count "unique" hits, the hits are how many times categories.php was requested.

[kief24]

would you like to explain where i can find the file i have to change ? can't find it....

thx !!!

[ascanio]

it is not a file what u have to change you need to go to PHPmyadmin and do this

To fix that you'll need change the type of cat_hits field in 4images_categories table from smallint(6) to int(10)

Here is MySQL query for your convinience:

Code: [Select]

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

[kief24]

maybe i am missing something here,
but how do i access phpmyadmin?

[martrix]

that depends on the configuration of your server and where it is installed...

sometimes it is

www.yourdomain.com/phpmyadmin
sometimes
mysql.yourdomaincom
and similar.
Your webspace-provider should be able to give you the needed information...

[kief24]

ok, found it , thx a lot

[Naveen]

I was going to post a thread on this, good that I checked out first.

This is what happens


Thank you V@no, I'll try out your trick

[V@no]

@RED_LINE:
continue discussion the issue you have here

[Flo2005]

I´ve done these changes from small int 6 to small int 10, but it doesn´t work